writer
1,835
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + Line 6:
Line 6: − Line 12:
Line 11: −
Manuals/calci/CHITEST (view source)
Revision as of 10:07, 12 February 2018
, 10:07, 12 February 2018no edit summary
<div style="font-size:25px">'''CHITEST(actualrange,expectedrange)'''</div><br/>
<div style="font-size:30px">'''CHITEST(actualrange,expectedrange)'''</div><br/>
*<math>actualrange</math> is the array of observed values.
*<math>actualrange</math> is the array of observed values.
*<math>expectedrange</math> is the array of expected values.
*<math>expectedrange</math> is the array of expected values.
* It is a test for independence.
* It is a test for independence.
* This function gives the value from the chi-squared distribution and the appropriate degrees of freedom i.e it calculates <math>\chi^2</math> statistic and degrees of freedom, then calls CHIDIST.
* This function gives the value from the chi-squared distribution and the appropriate degrees of freedom i.e it calculates <math>\chi^2</math> statistic and degrees of freedom, then calls CHIDIST.
The conditions of <math>\chi^2</math> test is
The conditions of <math>\chi^2</math> test is
The table should be 2x2 or more than 2x2
The table should be 2x2 or more than 2x2
All expected values should be 10 or greater.
All expected values should be 10 or greater.
Each cell has an expected frequency of at least five.
Each cell has an expected frequency of at least five.
*The <math>\chi^2</math> test first calculates a <math>\chi^2</math> statistic using the formula:
*The <math>\chi^2</math> test first calculates a <math>\chi^2</math> statistic using the formula:
<math>\chi^2 = \sum_{i=1}^{columns} \sum_{j=1}^{rows} \frac{(observed _{ij}-expected _{ij})^{2}}{grand total}</math>
<math>\chi^2 = \sum_{i=1}^{columns} \sum_{j=1}^{rows} \frac{(observed _{ij}-expected _{ij})^{2}}{grand total}</math>