6 Contingency Tables Using Excel Just like with summary tables, to make a contingency table in Excel, it is often useful to use a Pivot Table to count the frequencies of the different categories, especially for large datasets.
{}