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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
3,940
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,295
Messages
5,571,390
Members
412,386
Latest member
Yasaman
Top