>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)