Electronic Proceedings of the Twentyfifth Annual International Conference on Technology in Collegiate MathematicsBoston, Massachusetts, March 2124, 2013Paper C030
This is an electronic reprint, reproduced by permission of Pearson Education Inc. Originally appeared in the Proceedings of the Twentyfifth Annual International Conference on Technology in Collegiate Mathematics, ISBN10: 0133866726, Copyright (C) 2014 by Pearson Education, Inc. 
Simulating ChiSquare Test Using Excel 
Click to access this paper:

Students in introductory statistics classes struggle to grasp the basic concepts. We illustrate the use of Excel's Data Table function and standard formulas to perform the Chisquare test for independence. The Chisquare test is an integral part in introductory statistics. Simulation using Excel is used to generate many random samples and calculate the pvalue of the test. The empirical distribution of the statistic is also tabulated. This approach will improve the students' ability to understand the meaning of the pvalue to interpret the results of hypothesis testing.
Keyword(s): statistics, spreadsheets