Definition

Returns the right-tailed probability of the chi-squared distribution. The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation of plants will exhibit a certain set of colors. By comparing the observed results with the expected ones, you can decide whether your original hypothesis is valid.

Sample Usage


Syntax
CHIDIST(x,deg_freedom)
The CHIDIST function syntax has the following arguments:
  • X     Required. The value at which you want to evaluate the distribution.
  • Deg_freedom     Required. The number of degrees of freedom.
Remarks
  • If either argument is nonnumeric, CHIDIST returns the #VALUE! error value.
  • If x is negative, CHIDIST returns the #NUM! error value.
  • If deg_freedom is not an integer, it is truncated.
  • If deg_freedom < 1 or deg_freedom > 10^10, CHIDIST returns the #NUM! error value.
  • CHIDIST is calculated as CHIDIST = P(X>x), where X is a χ2 random variable.
In order to use the CHIDIST formula, start with your edited Excellentable:
 
 
Then type in the CHIDIST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the CHIDIST formula for, Excellentable will generate the outcome:






  
    
      



    

        
        Error.
    

    
User does not have sufficient privileges to access this Content 
Learn More