Programming and Application(编程与应用)


Content(目录)




Linux


MySQL
Office















 
PCNow 30-Day Free Trial, Remote PC Access
 
Logo_234x60

Chi Sqaure test in Excel


Chi Sqaure test in Excel

Zhanshan Dong


It is pretty easy to do Chi Square Test in Excel. First you need arrange your dat in table with one or two categories, then calculate the theretical value for each interactions (cells). Then just put the actual data and theoretical data into CHITEST worksheet function.

Sometimes that you need deal with your raw data first, such as counting a given value appearing in a specific categories and so on. You can use COUNT, COUNTA, COUNTIF, and so on to count the frequency of a given value.

The following is an example that I did for Peter Palencher in NYU when I was there for an interview. There are several steps to do CHITEST and also it is pretty easy.

  1. Calculate the probability or frequency for theoretical distribution (the total distribution);
  2. Calculate the theoretical number or count for each class in given a category (like metabolism);
  3. Calculate the theoretical and actual number that does not belong to a given class in a category;
  4. Use ChiTest function to calculate the probability for each cell.
I link an Excel worksheet to this page.

Download EXCEL Worksheet
©董占山Zhanshan Dong

Post comments(留言)

Name(名字)：

Comment(内容):


由Google提供

SunfineData Products|U's Bargain Network|Contact Me(与我联系)
© 1998-, 董占山, 版权所有, 欢迎转载文章链接。
转载文章和软件请注明出处(http://articles.sunfinedata.com/)。