Posted Monday April 12 2010

Hi,
Right now the StdDevQueue.StdDev member calculates the standard deviation for the population. How can I get the standard deviation for the sample as calculated in Excel by STDEV() instead of STDEVP() function?
Thanks

Posted Tuesday April 13 2010

What makes you think it's giving the standard deviation of the population and not the sample? It divides by n, not (n  1) before taking the square root (where n is the sample size).
Thanks, Daniel

Posted Tuesday April 13 2010

Hi Daniel, I was comparing the results to Excel's STDEV function and didn't match. As soon as I change the function in Excel to STDEVP then it matches to what was produced in RE. Maybe another bug in Excel Thanks, Nick

Posted Thursday May 11 2017

I am running into this now.
In Excel, we are using STDDEV.S specifically to calculate a value.
If I change it to STDDEV.P, it matches my result in RightEdge using the StdDevQueue with the same inputs.
Is there any way to get the StdDevQueue to calculate the same as STDDEV.S in Excel?
Or for me to change how I am using the StdDevQueue?

Posted Saturday September 16 2017

This is basic stats has nothing to do with Excel or RE. If you want to convert a population standard deviation to a sample standard deviation you simply multiply the population stat by Sqrt(n / (n 1)).
