Difference between revisions of "Manuals/calci/CHIDIST"
Jump to navigation
Jump to search
Line 26: | Line 26: | ||
#The <math>x</math> & <math>df</math> values are non-numeric | #The <math>x</math> & <math>df</math> values are non-numeric | ||
#The <math>x</math> value is negative or <math>df</math> value is not an integer | #The <math>x</math> value is negative or <math>df</math> value is not an integer | ||
− | #The <math>df < 1<math> or <math>df > 10^10<math> | + | #The <math>df < 1</math> or <math>df > 10^10</math> |
#Here CHIDIST=P(X>x),where X is a <math>\chi^2</math> random variable. | #Here CHIDIST=P(X>x),where X is a <math>\chi^2</math> random variable. | ||
Revision as of 06:30, 19 November 2013
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
- 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: 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
- The & values are non-numeric
- The value is negative or value is not an integer
- The or
- 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 |