Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > CHITEST
 

CHITEST(actual_range, expected_range)

 
 Returns the value from the chi-squared distribution ??

 actual_rangeThe data containing observations to test against expected values.
 expected_rangeThe data containing the ratio of the product of row totals and column totals to the grand total.

 REMARKS
 
  		• Returns the test for independence. This function returns the value from the chi-squared (?2) distribution for the statistic and the appropriate degrees of freedom. You can use ?2 tests to determine whether hypothesized results are verified by an experiment.
     
  		• If "actual_range" and "expected_range" have a different number of data points, then #N/A is returned.

     EXAMPLES
     
     AB
    1=CHITEST({2,3,4,5,6},{1,2,3,4,5}) = 0.6810
    2=CHITEST(B1:B2,B1:B2) = 120
    3=CHITEST(B1:B2,B3) = #N/A30
    4=CHITEST(1,"some text") = #VALUE! 
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top