Difference between revisions of "Manuals/calci/CHIDIST"
Jump to navigation
Jump to search
| Line 56: | Line 56: | ||
|- class="even" | |- class="even" | ||
| − | | CHIDIST(-2,1) | + | |CHIDIST(-2,1) |
|-2 | |-2 | ||
|1 | |1 | ||
|error | |error | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | |CHIDIST( | + | |CHIDIST(2,-1) |
| − | | | + | |2 |
| − | |1 | + | |-1 |
| − | | | + | |error |
|} | |} | ||
Revision as of 05:08, 12 November 2013
CHIDIST(x,df)
- 'X' is the value for which distribution is evaluated and df is the number of degrees of freedem.
Description
- This function gives the one_tailed probability of the chi-squared distribution.
- It is denoted by X^2 distribution.Normally categorical datas may displayed in tables.
- The X^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 X^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: X^2=summation(Oi-Ei)^2/Ei The degrees of freedom are: (r–1)(c–1) r =No. of rows and 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 nonnumeric 2.The x value is negative or df value is not an integer 3. The df <1or df>10^10 4.Here CHIDIST=P(X>x),where X is a X^2 random variable.
- gives
- Failed to parse (syntax error): {\displaystyle =COMPLEX(5,2,"j")} gives
gives 
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) | |||
| 1 | error | ||
| CHIDIST(2,-1) | 2 | ||
| error |