Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate STD() vs. Excel STDEV() function
Message
From
02/09/2002 07:55:06
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Calculate STD() vs. Excel STDEV() function
Miscellaneous
Thread ID:
00695910
Message ID:
00695910
Views:
67
Dear All,

My client wants to have a standard deviation calculated on his report.
The problem is that CALCULATE STD() gives different result with FoxPro than the equivalent STDEV() in Excel.

For example: group of 10 numbers 1345,1301,1368,1322,1310,1370,1318,1350,1303,1299 listed in a table gives 26.05456 in FoxPro and 27.46 in Excel.

I think I need to go back to school, or maybe I am missing something, because the AVG() FoxPro function and AVERAGE() Excel function are giving me exactly the same result.

Any miracles?

Thanks

Jonathan
Next
Reply
Map
View

Click here to load this message in the networking platform