close
Warning:
Can't synchronize with repository "(default)" (/common/SVN/wimax does not appear to be a Subversion repository.). Look in the Trac log for more information.
- Timestamp:
-
Feb 9, 2012, 7:19:17 PM (12 years ago)
- Author:
-
Nilanjan Paul
- Comment:
-
—
Legend:
- Unmodified
- Added
- Removed
- Modified
-
v11
|
v12
|
|
16 | 16 | 3. ''sqlite3'': command line interface for accessing the contents in a database file.[[BR]] |
17 | 17 | 4. ''wimax-iperf-attn.rb'': the experiment script |
| 18 | 5. ''R'': a statistic analysis tool. |
18 | 19 | |
19 | 20 | == Set up == |
… |
… |
|
165 | 166 | }}} |
166 | 167 | |
167 | | We can use R studio to analyze the data. So first dump the contents out to a file. |
| 168 | In this example we can use R (statistical analysis tool) to analyze the data. If this tool can be easily installed: '''apt-get install r-base'''[[BR]] |
| 169 | So first dump the contents out to a file: '''sqlite3 -header values.db "select * from t1" > data.tmp''' |
168 | 170 | {{{ |
169 | 171 | nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 -header values.db "select * from t1" > data.tmp |
… |
… |
|
192 | 194 | }}} |
193 | 195 | |
| 196 | Next in another window run R from the prompt. From inside the R command prompt, read ''data.tmp'' file: |
| 197 | {{{ |
| 198 | R> data<-read.table("data.tmp",header=TRUE,sep="|") |
| 199 | }}} |
| 200 | |
| 201 | Check the data that was read: |
| 202 | {{{ |
| 203 | R> data |
| 204 | t1key atten nBytes time kBperS |
| 205 | 1 1 0 10878976 10.09524 8419.0148 |
| 206 | 2 2 5 11141120 10.22524 8512.2730 |
| 207 | 3 3 10 11010048 10.12555 8494.9451 |
| 208 | 4 4 15 11010048 10.13542 8486.6710 |
| 209 | 5 5 20 2097152 12.67509 1292.6145 |
| 210 | 6 6 0 2097152 12.67509 1292.6145 |
| 211 | 7 7 5 2097152 12.67509 1292.6145 |
| 212 | 8 8 10 2097152 12.67509 1292.6145 |
| 213 | 9 9 15 2097152 12.67509 1292.6145 |
| 214 | 10 10 20 2097152 12.67509 1292.6145 |
| 215 | 11 11 0 11010048 10.10008 8516.3640 |
| 216 | 12 12 0 11010048 10.12322 8496.9003 |
| 217 | 13 13 0 11141120 10.23023 8508.1184 |
| 218 | 14 14 0 11141120 10.29482 8454.7366 |
| 219 | 15 15 5 11010048 10.14977 8474.6765 |
| 220 | 16 16 10 11141120 10.22505 8512.4303 |
| 221 | 17 17 15 10878976 10.13488 8386.0884 |
| 222 | 18 18 20 1179648 10.50950 876.9205 |
| 223 | 19 19 0 11010048 10.12539 8495.0810 |
| 224 | 20 20 5 9043968 10.28979 6866.6111 |
| 225 | }}} |
194 | 226 | |
195 | 227 | == Trouble shooting & miscellaneous info == |