# What is the formula behind NORM.S.DIST(x,TRUE) function?

1. ## What is the formula behind NORM.S.DIST(x,TRUE) function?

Hi,

what is the 'real' formula of norm.s.dist(x,TRUE) ?

on the microsoft help page I can only find the formula for norm.s.dist(WRONG)
The given example there: =NORM.S.DIST(1.333333,TRUE) Example: 0.908788726 (description: Normal cumulative distribution function at 1.333333)

Could someone please let me know how I can calculate the 0,908.. on my own?  Register To Reply

2. ## Re: What is the formula behind NORM.S.DIST(x,TRUE) function?

Wikipedia has a better discussion than Microsoft: https://en.wikipedia.org/wiki/Normal...ution_function

Basically, the cumulative distribution function (CDF) is the definite integral of the probability density function (PDF) from negative infinity to x. Wikipedia talks about some of the ways this integral can be calculated, or you can use your favorite algorithm for numerical integration on the PDF.  Register To Reply

3. ## Re: What is the formula behind NORM.S.DIST(x,TRUE) function?

mrshorty

This dont answer the question what exactly is the calculating path or the formula for the true value in his example!!!

So do you know the answer or not?  Register To Reply

4. ## Re: What is the formula behind NORM.S.DIST(x,TRUE) function?

so how do you calculate the given example The given example there: = NORM.S.DIST 1.333333,TRUE Example: 0.908788726 (description: Normal cumulative distribution function at 1.333333  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 