General information
Category:
Coding, syntax & commands
Title:
Calculate STD() vs. Excel STDEV() function
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only