Changes between Version 11 and Version 12 of WiMAX/30/05

Timestamp:

Feb 9, 2012, 7:19:17 PM (12 years ago)

Author:

Nilanjan Paul

Comment:

—

WiMAX/30/05

@@ -16 +16 @@
 3. ''sqlite3'': command line interface for accessing the contents in a database file.[[BR]]
 4. ''wimax-iperf-attn.rb'': the experiment script
+5. ''R'': a statistic analysis tool.
 
 == Set up ==
@@ -165 +166 @@
 }}}
 
-We can use R studio to analyze the data. So first dump the contents out to a file.
+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]]
+So first dump the contents out to a file: '''sqlite3 -header values.db "select * from t1" > data.tmp'''
 {{{
 nilanjan@console.sb4:~/exp/dl-iperf/5.2$ sqlite3 -header values.db "select * from t1" > data.tmp
@@ -192 +194 @@
 }}}
 
+Next in another window run R from the prompt. From inside the R command prompt, read ''data.tmp'' file:
+{{{
+R> data<-read.table("data.tmp",header=TRUE,sep="|")
+}}} 
+
+Check the data that was read:
+{{{
+R> data
+   t1key atten   nBytes     time    kBperS
+1      1     0 10878976 10.09524 8419.0148
+2      2     5 11141120 10.22524 8512.2730
+3      3    10 11010048 10.12555 8494.9451
+4      4    15 11010048 10.13542 8486.6710
+5      5    20  2097152 12.67509 1292.6145
+6      6     0  2097152 12.67509 1292.6145
+7      7     5  2097152 12.67509 1292.6145
+8      8    10  2097152 12.67509 1292.6145
+9      9    15  2097152 12.67509 1292.6145
+10    10    20  2097152 12.67509 1292.6145
+11    11     0 11010048 10.10008 8516.3640
+12    12     0 11010048 10.12322 8496.9003
+13    13     0 11141120 10.23023 8508.1184
+14    14     0 11141120 10.29482 8454.7366
+15    15     5 11010048 10.14977 8474.6765
+16    16    10 11141120 10.22505 8512.4303
+17    17    15 10878976 10.13488 8386.0884
+18    18    20  1179648 10.50950  876.9205
+19    19     0 11010048 10.12539 8495.0810
+20    20     5  9043968 10.28979 6866.6111
+}}}
 
 == Trouble shooting & miscellaneous info ==