Standard Deviation

[magnys]

I'm trying to use the stdev tool for multiple fields in multiple records. I've got 5 data points per record, and multiple instances when these data points have been checked. I want to get a standard deviation for all of the captured test data. Here is an example of the data for just 1 of the processes.

Process DATA1 DATA2 DATA3 DATA4 DATA5 ROTATION
170-190 98.3 90.3 96.3 84.1 84.7 6825
170-190 81.4 78.9 76.6 77 85.4 6895
170-190 92.8 90.9 92.4 100.7 94.8 6937
170-190 81.4 78.9 76.6 77 85.4 6895
170-190 92.8 90.9 92.4 100.7 94.8 6937
170-190 80.9 85.8 78 85 88.9 6995
170-190 95.2 91.4 90.9 87.3 77.2 704
170-190 81.6 79.6 77.5 77.8 76.5 7173
170-190 81.6 79.6 77.5 77.8 76.5 7173
170-190 79.6 84.1 90.2 89.4 95 5433
170-190 84 83 81.3 80.8 85.3 5500
170-190 89.8 81.3 82.8 80.4 83.1 7254
170-190 81.5 96.4 94.2 97.2 88.7 7313
170-190 102 93.9 99.9 97.3 99.1 7365
170-190 94.5 94.9 90.5 91.2 95.8 7420
170-190 84.5 97.2 95.7 97.3 100.2 7465
170-190 76.9 78.6 79.8 78.7 80.8 7509


Please help!!!
Thanks

Magnys

 

[MichaelRed]

Std. Dev. has been discussed in these fora (tek-Tips) on several or more occassions. Specific threads exist in VB(A) under VB and/or MS Access and are included in the Excel Lib, accessible to any program supporting references. Do a Search using some keywords and you should find sufficient resources to resolve the issue.





MichaelRed

 

[herd]

((([DATA1]^2+[DATA2]^2+[DATA]^2+[DATA4]^2+[DATA5]^2)-(5*((([DATA1]+ [DATA2]+[DATA3]+[DATA4]+[DATA5])/5)^2)))/4)^0.5