Generating a % of distribution curve using standard deviations

[mlarson]

Hi all, I am looking for the formula to generate the % of the distribution curve that would fall below a certain number of standard deviation(s). For example, +1 standard deviation would have 84.1% of the curve below it, and -1 standard deviation would have 15.9% of the curve below it.

My question is, given a certain standard deviation (say, 0.258), what formula would generate the % of the curve beneath that given standard deviation?

Thanks in advance for your help!
Mark

 

[shg]

      A- --B-- ----------------C----------------
  1   sd 0.248                                  
  2      84.1% B2: =NORMDIST(1*sd, 0, sd, TRUE) 
  3      15.9% B3: =NORMDIST(-1*sd, 0, sd, TRUE)

 

[shg]

You can instead use =NORMSDIST(1), where the 1 represents 1 standard deviation above the mean.

 

[mlarson]

Excellent, thank you!

 

[shg]

You're welcome, glad it helped.