Hello,
I wish to calculate averages and standard deviation using a set of data saved in excel file.
Part of the data looks like this:
bench mach1 mach2 line
0.80 2.34 3.21 0.065
0.76 2.53 3.87 0.102
1.01 2.51 3.54 0.091
0.78 2.49 3.62 0.100
0.82 2.38 3.56 0.088
0.89 2.47 3.58 0.092
0.92 2.50 3.33 0.102
1.02 2.39 3.81 0.071
0.83 2.45 3.74 0.070
0.94 2.36 3.69 0.083
0.80 2.34 3.21 0.065
0.76 2.53 3.87 0.102
1.01 2.51 3.54 0.091
0.78 2.49 3.62 0.100
0.82 2.38 3.56 0.088
0.89 2.47 3.58 0.092
0.92 2.50 3.33 0.102
1.02 2.39 3.81 0.071
0.83 2.45 3.74 0.070
0.94 2.36 3.69 0.083
I wish to generate values of average and S.D. for each column and use these values for other functions. How should I write the deffunction (or rule) to read the data on file?
Thank you.
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
