Manuals/calci/CHIDIST

From ZCubes Wiki
Revision as of 06:58, 12 November 2013 by Abin (talk | contribs) (→‎Description)
Jump to navigation Jump to search
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 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 \chi^2} distribution.Normally categorical data's may displayed in tables.
  • 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 \chi^2} static used to compare the observed value in each table to the value
  • which would be the expected under the assumption. The conditions of 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 \chi^2} 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.  The test statistic is: 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 \chi^2=\sum\frac{(Oi-Ei)^2}{Ei}} 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 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 \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

Complex Numbers