ExcelBanter - NORMSDIST

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - NORMSDIST (https://www.excelbanter.com/excel-discussion-misc-queries/63380-normsdist.html)

Hi All,
I already posted this in the Worksheet Functions thread but I'm not sure if
that was the right place?

Anyway here is my question......
Why is
1-NORMSDIST(7.8) = 3.10862e-15
while
1-NORMSDIST(7.9) = 0

Is there a limit to how far out the Gaussian PDF curve you can go before
Excel rounds to zero?

Thanks

Barry

Hi,

=1-NORMSDIST(7.8600) = 1.887e-15
=1-NORMSDIST(7.8800) = 1.776e-15
=1-NORMSDIST(7.874962586) = 1.776e-15
=1-NORMSDIST(7.874962587) = 0

Regards,
B. R. Ramachandran

"crapatmath" wrote:

Hi All,
I already posted this in the Worksheet Functions thread but I'm not sure if
that was the right place?

Anyway here is my question......
Why is
1-NORMSDIST(7.8) = 3.10862e-15
while
1-NORMSDIST(7.9) = 0

Is there a limit to how far out the Gaussian PDF curve you can go before
Excel rounds to zero?

Thanks

Barry

Hi,

I am sorry, there was a typo in the second equation in my previsous response
(the value in the NORMDIST function should have read "7.8680" and not
"7.8800").

=1-NORMSDIST(7.8600) = 1.887e-15
=1-NORMSDIST(7.8680) = 1.776e-15 (corrected)
=1-NORMSDIST(7.874962586) = 1.776e-15
=1-NORMSDIST(7.874962587) = 0

Regards,
B. R. Ramachandran

"crapatmath" wrote:

Hi All,
I already posted this in the Worksheet Functions thread but I'm not sure if
that was the right place?

Anyway here is my question......
Why is
1-NORMSDIST(7.8) = 3.10862e-15
while
1-NORMSDIST(7.9) = 0

Is there a limit to how far out the Gaussian PDF curve you can go before
Excel rounds to zero?

Thanks

Barry