Name
CHIDIST
Synopsis
Use CHIDIST to find the probability of a chi-squared variable with the specified degrees of freedom.
To Calculate
=CHIDIST(X
,Degrees_Freedom
)
Both arguments are required for this function.
-
X
Indicates a positive numeric value that you want to use to evaluate the distribution.
Example
Figure 15-4 illustrates how CHIDIST is used to
determine the probability value for a chi-squared variable. You will
notice that the value returned by CHIINV is fairly close to the
initial X
value of CHIDIST.
Figure 15-4. The CHIINV function returns a value that matches the X value specified for the CHIDIST function
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.