LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Paul D. Simon
 
Posts: n/a
Default Formula to determine number of Standard Deviations based on % of population

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Evaluating Rank to determine formula Mary Excel Worksheet Functions 5 September 10th 05 05:33 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
PivotTables in Excel 2004 calculate incorrect standard deviations lvphj Excel Worksheet Functions 0 May 12th 05 05:30 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 12:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"