How to Do a Contingency Table in Excel?

How to Create a Contingency Table in Excel

A contingency table is a table that is used to summarize the relationships between two categorical variables. The table lists the number of times each combination of the two variables occurs. Excel is a spreadsheet application that is widely used for data analysis. Excel has a built-in feature that allows you to create contingency tables.