Probability function for specified number of standard deviations.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,318
Office Version
  1. 365
Platform
  1. Windows
Can someone please help me?

I wish to calculate the proportion of values that fall between a certain number of standard deviations in a normal distribution.

So if I have a cell with 1 as the number of st.devs, I want the function to report 68.2689492%. If I put in 2 for st.devs, it should report 95.4499736%. And entering 1.644854 for std.devs should report 90.0000000%. Like this wikepedia article.

Which functions or formulas do that?
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
3,945
Office Version
  1. 365
Platform
  1. Windows
Excel Formula:
=2*NORM.DIST(N,0,1,1)-1
 
Last edited by a moderator:
Solution

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,318
Office Version
  1. 365
Platform
  1. Windows
Jeepers! I thrashed away for too long on this one. I'm glad I sought help. Thanks tons, Stephen!!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,788
Messages
5,574,280
Members
412,584
Latest member
Leow
Top