K
Kevin
Should I be concerned that NORMDIST(4.92, 4.94, 0.08, FALSE) returns
4.83? This should be the noncumulative (density, mass) function
associated with the normal distribution. Surely it cannot exceed 1
because the entire area under the curve cannot exceed 1, by definition
of probability distribution. The related NORMSDIST problem:
NORMSDIST(-0.25, 0, 1, FALSE) returns 0.3866, which seems reasonable.
Can someone please reconcile the answers, or explain why Excel allows
probability distributions to have values greater than one?
Thank you.
4.83? This should be the noncumulative (density, mass) function
associated with the normal distribution. Surely it cannot exceed 1
because the entire area under the curve cannot exceed 1, by definition
of probability distribution. The related NORMSDIST problem:
NORMSDIST(-0.25, 0, 1, FALSE) returns 0.3866, which seems reasonable.
Can someone please reconcile the answers, or explain why Excel allows
probability distributions to have values greater than one?
Thank you.