Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement