Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Normdist Problem | Excel Worksheet Functions | |||
Gaussian Curve using Normdist? | Excel Worksheet Functions | |||
NORMDIST | Excel Worksheet Functions | |||
NORMDIST function | Excel Worksheet Functions | |||
NORMDIST(x,mean, stdev,false) vs f(x) | Excel Worksheet Functions |