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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
3,950
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,971
Messages
5,575,295
Members
412,653
Latest member
JyothiGrace
Top