Name
NORMDIST
Synopsis
Use NORMDIST to find the normal cumulative probability for a value with the specified mean and standard deviation. This function is frequently used in hypothesis testing.
To Calculate
=NORMDIST(X
,Mean
,Standard_Dev
,Cumulative
)
All arguments are required for this function.
-
X
Indicates a numeric value for which you want to find the distribution.
-
Mean
Indicates a numeric value that specifies the mean of the distribution.
-
Standard_Dev
Indicates a positive numeric value that specifies the standard deviation of the distribution.
Example
Figure 15-32 illustrates how NORMDIST is used to find
the normal cumulative distribution. The figure shows how the function
returns a different value based upon the logical value specified for
the Cumulative
argument. You will also
notice in this example that NORMINV returns a value that matches the
initial X
value specified for NORMDIST.
Figure 15-32. Use NORMDIST and NORMINV when working with normal cumulative distribution
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.