Probability function for specified number of standard deviations.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,309
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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,309
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,113,909
Messages
5,544,999
Members
410,647
Latest member
LegenDSlayeR
Top