Creating Contingency Table in Excel

This tutorial provides step-by-step instructions on creating a contingency table in Excel using the Pivot Table menu. It covers the creation of a contingency table for count data as well as a 2 by 2 table for means.

▬ Chapters ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00 - Introduction of data for contingency table and research question
0:51 - Steps of creating a contingency table for count data in Excel
2:10 - Interpretation of contingency table (calculating ratio of cells)
2:50 - Steps of creating a contingency table (2 by 2 table) for cell means in Excel (using Pivot table)
▬ Links ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Excel file used in the tutorial:

Web page version of tutorial (How to Create Contingency Table in Excel):

Disclaimer:
The accuracy and comprehensiveness of this tutorial are not assured. It is advisable to verify independently or seek advice from professionals. The author of this tutorial bears no responsibility or liability for its accuracy and completeness.

[jet]

hey I wanted to make a contingency table of a set of data that I have but im really confused about the variable. Do you have an insta or some account where I can dm or a mail perhaps ?