Manuals/calci/CHIDIST

Revision as of 07:29, 19 November 2013 by Abin (talk | contribs) (→‎Description)
CHIDIST(x,df)


  • is the value for which distribution is evaluated.
  • 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 assumed value.
  • The conditions of   test is
  1. The table should be 2x2 or more than 2x2
  2. Each observations should not be dependent
  3. All expected values should be 10 or greater. 
  4. The test statistic is:

 

The degrees of freedom are: Failed to parse (syntax error): {\displaystyle (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   &   values are non-numeric
  2. The   value is negative or   value is not an integer
  3. The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle df < 1<math> or <math>df > 10^10<math> #Here CHIDIST=P(X>x),where X is a <math>\chi^2} 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

CHI-SQUARE Distribution