Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
The following are a few of generally accepted values:
% of Population Number of Standard Deviations away from Mean 50.0% 0.674 68.3% 1.000 90.0% 1.645 95.0% 1.960 95.4% 2.000 99.7% 3.000 Given the % of Population, is there an Excel formula that can be used to determine the number of Standard Deviations away from the Mean? Thus, entering 90% in A1, the formula in B1 would result in 1.645 as shown above. I'd be using this to expand the table above to include additional percentages (e.g., 75%, 85%, or whatever number I needed at the time). Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Evaluating Rank to determine formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
PivotTables in Excel 2004 calculate incorrect standard deviations | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |