Calculate Contingency Table and Expected Values for Chi-squared Test with Excel HD

This is part 1 of "Chi-Squared Test of Independence." In this part, I use Excel to organize the frequencies of two nominal variables into a contingency table. Next, the marginal totals are used to calculate the expected values in case that there is no association between the two variables. In my example, the two categorical variables are Gender and Satisfaction.