Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Standard Variance
Message
From
03/02/2003 19:29:24
 
 
To
03/02/2003 18:56:17
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00748661
Message ID:
00748702
Views:
22
When I tried this in Fox, I got .99 which is the correct standard deviation.
So what is wrong with Excel? The STDEV function is actually an approximation of standard deviation which is designed for speed. For a "precise" version use STDEVP.

If you have some free time here is the math:

First calculate the average:
=4.625

Then for each value subtract the average and square it:
0.390625 = (4-4.625)^2
0.140625
0.390625
1.890625
2.640625
0.140625
1.890625
0.390625

Finally total these values and square root them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform