Mastering Excel Through Projects: A Learn-by-Doing Approach from Payroll to Crypto to Data Analysis

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

H. ZhouMastering Excel Through Projectshttps://doi.org/10.1007/978-1-4842-7842-0_5

5. Two-Way Table and Chi-Square Test

Hong Zhou¹  

(1)

University of Saint Joseph, West Hartford, CT, USA

 

Please download the sample Excel files from https://github.com/hhohho/master-Excel-through-projects for this chapter’s exercises.

In statistics, a two-way table describes the relationship between two categorical variables. Here is a scenario. A medical study compared the assessment of emotional control of patients from two regions A and B to examine if there is any significant regional difference. These patients once had issues with emotional control and have gone through certain ...