| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard deviation calculation
If I have the mean and a 95% probability value for a distribution, is there a
function that will calculate the standard deviation? I currently use norminv with a guess for the standard deviation and then goal seek to get the implied standard deviation. I was wondering if there is a more straightforward way to calculate the implied standard deviation if I know the mean and the 95% probability value. Thanks, Anand |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Standard deviation calculation
Use NORMSINV() and some algebra...
=(X-mean)/NORMSINV(your_probability) Where X is the value you calculated the 95% probability for (normal notation when calculating a Z score) -- Regards, Dave "Anand" wrote: If I have the mean and a 95% probability value for a distribution, is there a function that will calculate the standard deviation? I currently use norminv with a guess for the standard deviation and then goal seek to get the implied standard deviation. I was wondering if there is a more straightforward way to calculate the implied standard deviation if I know the mean and the 95% probability value. Thanks, Anand |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculation of standard deviation is not as help document says | Excel Discussion (Misc queries) | |||
| Standard deviation - confidence intervals | Excel Worksheet Functions | |||
| A question about Standard Deviation | Excel Discussion (Misc queries) | |||
| feel that the STANDARD DEVIATION formula on Excel is incorrect !! | Excel Worksheet Functions | |||
| Is there a standard deviation calculation in Excel? | Excel Worksheet Functions | |||
Linear Mode
