General information
Category:
Coding, syntax & commands
>>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
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