How many std deviations is Excel function "STDEVP"

D

David Billigmeier

What do you mean how many std dev's?? That function calculates *The*
standard deviation of the population.
 
M

Myrna Larson

I don't understand your question. The function returns the standard deviation
of the population, in the same units as the data. There is only 1 value
returned.
 
J

Jerry W. Lewis

As others have noted, your question is predicated on a misunderstanding.
Look at Help for STDEV and STDEVP to see the formulas that each uses.

STDEV is the square root of the unbiased estimate of the population
variance if your data is a sample of independant observations. STDEVP
is the population standard deviation if your data is a complete
enumeration of the population.

Jerry
 
Top