Difference between revisions of "Manuals/calci/CHIDIST"
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''CHIDIST(Number, | + | <div style="font-size:30px">'''CHIDIST (Number,DegreeOfFreedom)'''</div><br/> |
*<math>Number</math> is the value for which distribution is evaluated. | *<math>Number</math> is the value for which distribution is evaluated. | ||
*<math>Degreeoffreedom</math> is the number of degrees of freedom. | *<math>Degreeoffreedom</math> is the number of degrees of freedom. | ||
| + | **CHIDIST(), returns the one-tailed probability of the chi-squared distribution. | ||
==Description== | ==Description== | ||
| Line 15: | Line 16: | ||
*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 is | + | The degrees of freedom is: (r–1)(c–1) |
*r = No. of rows | *r = No. of rows | ||
*c = No. of columns | *c = No. of columns | ||
| Line 65: | Line 66: | ||
| -2 | | -2 | ||
|1 | |1 | ||
| − | | | + | |#N/A (NUMBER > 0) |
|- class="odd" | |- class="odd" | ||
|CHIDIST(2,-1) | |CHIDIST(2,-1) | ||
|2 | |2 | ||
| -1 | | -1 | ||
| − | | | + | |null |
|} | |} | ||
Latest revision as of 08:50, 2 June 2020
CHIDIST (Number,DegreeOfFreedom)
- 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 Number} is the value for which distribution is evaluated.
- 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 Degreeoffreedom}
is the number of degrees of freedom.
- CHIDIST(), returns the one-tailed probability of the chi-squared distribution.
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 assumed value.
- 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
- 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:
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 is: (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
- 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 Number} & 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 Degreeoffreedom} values are non-numeric
- 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 Number} value is negative or 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 Degreeoffreedom} value is not an integer
- 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 Degreeoffreedom < 1} or 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 Degreeoffreedom > 10^{10}}
- 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 Number is negative.
- CHIDIST(2,-1)=Error, because Degreeoffreedom<1
ZOS
- The syntax is to calculate CHIDIST in ZOS is CHIDIST(Number,Degreeoffreedom).
- 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 Number} is the value for which distribution is evaluated.
- 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 Degreeoffreedom} is the number of degrees of freedom.
- For e.g.,CHIDIST(10..12,5.1..7.1..0.6)
Examples
| CHIDIST(Number,Degreeoffreedom) | 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 | #N/A (NUMBER > 0) |
| CHIDIST(2,-1) | 2 | -1 | null |
Related Videos
See Also
References