Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate STD() vs. Excel STDEV() function
Message
From
02/09/2002 09:31:51
 
 
To
02/09/2002 09:22:59
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00695910
Message ID:
00695926
Views:
14
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform