Chi square test

Here is the help file for the built in =CHITEST() function http://office.microsoft.com/en-us/ex...in=HP005203066 that should explain how to use the function.

If you need instructions (from a statistical science viewpoint) about how to structure and perform and interpret the results of the chi square test, I might suggest you refer to an introductory statistics text or any of the online tutorials for this test.

Wikipedia http://en.wikipedia.org/wiki/Pearson...i-squared_test
http://www.radford.edu/rsheehy/Gen_f...ial/x2-tut.htm
http://www.uni.edu/~maclino/as/tutor...e_tutorial.pdf

I'm sure there are many others.