# Probability function for specified number of standard deviations.

#### DRSteele

##### Well-known Member

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?

### 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
Excel Formula:
``=2*NORM.DIST(N,0,1,1)-1``

Last edited by a moderator:

#### DRSteele

##### Well-known Member
Jeepers! I thrashed away for too long on this one. I'm glad I sought help. Thanks tons, Stephen!!

Replies
1
Views
89
Replies
2
Views
418
Replies
2
Views
584
Replies
3
Views
276
Replies
4
Views
309