Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculate STD() vs. Excel STDEV() function
Message
De
02/09/2002 09:31:51
 
 
À
02/09/2002 09:22:59
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00695910
Message ID:
00695926
Vues:
15
>>The formula in excel is STDEVPA(). Foxpro is assuming the data supplied is the universe, as opposed to the standard function in Excel which assumes that the data is just a sample. I think this is because, unlike fox, excel can only perform stdev on 30 values.
>>
>>Mace
>
>Not quite. In Excel, formulae like stdev(), sum() or product() work on up to 30 ranges, but each range can have thousands of numbers.
>
>For instances, try stdev(a1:a1000).
>
>Hilmar.

You're right again, I was entering the numbers as arguements.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform