Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How many std deviations is Excel function "STDEVP"
How many std deviations is Excel function "STDEVP"
|
#2
|
|||
|
|||
One population std dev.
In article , "mchsr" wrote: How many std deviations is Excel function "STDEVP" |
#3
|
|||
|
|||
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" |
#4
|
|||
|
|||
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" |
#5
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling a new function Excel gives me #NAME? | Excel Worksheet Functions | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |