How many std deviations is Excel function "STDEVP"
 

How many std deviations is Excel function "STDEVP"

One population std dev.

In article ,
"mchsr" wrote:

How many std deviations is Excel function "STDEVP"

What do you mean how many std dev's?? That function calculates *The*
standard deviation of the population.
--
Regards,
Dave
<!--


"mchsr" wrote:

How many std deviations is Excel function "STDEVP"

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.

On Mon, 12 Sep 2005 11:00:02 -0700, "mchsr"
wrote:

How many std deviations is Excel function "STDEVP"

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

mchsr wrote:

How many std deviations is Excel function "STDEVP"