How many std deviations is Excel function "STDEVP"

  • Thread starter Thread starter Guest
  • Start date Start date
What do you mean how many std dev's?? That function calculates *The*
standard deviation of the population.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

STDEVP Function - help 1
Should I use STDEVP 2
Standard Deviation do I use 520 (20x26) inputs or avg of each 4
Display formula Excel uses for internal functions (STDEV...) 1
How do I estimate STDEVP for values in multiple fields 2
How do I find the distribution of a sample mean???? 1
Outlier analysis in excel - trimming means 2
STDEVP function with an array 2

Back
Top