Thread
:
NOSMSDIST Limit
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
crapatmath
Posts: n/a
NOSMSDIST Limit
Hi All,
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
Reply With Quote