Excel NORM.DIST function gives results greater than 1 with probability mass function. How
NormDist.PNG
In the table above B5 = NORM.DIST(A5, $C$5, $D$5, FALSE) and B6...B25 is this formula dragged down. Since the last parameter is set to FALSE the function should use the probability mass function which according to what I've read can't be greater than 1, but the function still returns values greater than 1.
How is this possible? A mathematical or logical explanation would be appreciated.
Thank you in advance!
The PDF is just the slope of the CDF. It can certainly be greater than one.
EDIT: See http://www.excelforum.com/excel-gene...-than-1-a.html
Last edited by shg; 03-21-2012 at 11:29 AM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks