编程技术、软件应用与系统模拟

(Programming, Applicaiton and Simulation)


		本站目录
		首页 ASP/Access/IIS DELPHI/PASCAL PASCAL高级编程 C语言编程实例 WORD Excel MATLAB MINITAB讲座 Windows DOS SAS 生物系统模拟土壤水分剖析器其他


		镜像站点
		主站北美镜象站欧洲镜象站(1) 欧洲镜象站(2)

座右铭:
只做有益人类的事
不做有害人类的事

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.

Calculate the probability or frequency for theoretical distribution (the total distribution);
Calculate the theoretical number or count for each class in given a category (like metabolism);
Calculate the theoretical and actual number that does not belong to a given class in a category;
Use ChiTest function to calculate the probability for each cell.

I link an Excel worksheet to this page.

Download EXCEL Worksheet