Difference between revisions of "Manuals/calci/CHIDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 7: Line 7:
 
*This function gives the one_tailed probability of the chi-squared distribution.  
 
*This function gives the one_tailed probability of the chi-squared distribution.  
 
*It is denoted by  <math>\chi^2</math> distribution.Normally categorical data's may displayed in tables.  
 
*It is denoted by  <math>\chi^2</math> distribution.Normally categorical data's may displayed in tables.  
*The <math>\chi^2</math> static used to compare the observed value in each table to the value  
+
*The <math>\chi^2</math> static used to compare the observed value in each table to the value which would be the expected  under the assumption.  
*which would be the expected  under the assumption. The conditions of <math>\chi^2</math> test is  
+
*The conditions of <math>\chi^2</math> test is  
  
#The table should be 2x2 or more than 2x2
+
**The table should be 2x2 or more than 2x2
#Each observations should not be dependent
+
**Each observations should not be dependent
#All expected values should be 10 or greater. 
+
**All expected values should be 10 or greater. 
The test statistic is:  
+
**The test statistic is:  
 
<math>\chi^2=\sum\frac{(Oi-Ei)^2}{Ei}</math>
 
<math>\chi^2=\sum\frac{(Oi-Ei)^2}{Ei}</math>
 
The degrees of freedom are: (r–1)(c–1)
 
The degrees of freedom are: (r–1)(c–1)

Revision as of 07:01, 12 November 2013

CHIDIST(x,df)


  • 'x' is the value for which distribution is evaluated.
  • 'df' is the number of degrees of freedom.

Description

  • This function gives the one_tailed probability of the chi-squared distribution.
  • It is denoted by distribution.Normally categorical data's may displayed in tables.
  • The static used to compare the observed value in each table to the value which would be the expected under the assumption.
  • The conditions of test is
    • The table should be 2x2 or more than 2x2
    • Each observations should not be dependent
    • All expected values should be 10 or greater. 
    • The test statistic is:

The degrees of freedom are: (r–1)(c–1)

  • r = No. of rows
  • c = No. of columns

Where:

  • Oi-the observed value in the ith cell
  • Ei- the expected value in the ith cell

Also this function will the result as Error when

  1. The x & df values are non-numeric
  2. The x value is negative or df value is not an integer
  3. The df <1 or df>10^10
  4. Here CHIDIST=P(X>x),where X is a random variable.
  • CHIDIST(-2,1)=Error, because x is negative.
  • CHIDIST(2,-1)=Error, because df<1

Examples

CHIDIST(x,df) x df RESULT
CHIDIST(18,2) 18 2 0.0001234098
CHIDIST(15,1) 15 1 0.0001075112
CHIDIST(2,1) 2 1 0.157299207050
CHIDIST(-2,1) (-)2 1 error
CHIDIST(2,-1) 2 (-)1 error

See Also

References

Complex Numbers