Question

Create a crosstab table of frequencies from the data containing case id, age, sex, and marital status, using an Excel pivot table. A crosstab is a table showing the relationship between two or more variables. When the table shows the relationship between two categorical variables, a crosstab is also known as a contingency table or a two-way table. Format the data as number with 1000 separator.

Please outline step by step how to create the pivot table in Microsoft Excel following the criteria above.

Answer 1

Open Microsoft Excel.

Go to Insert.

Find this option called Pivot table.

A new dialog box will appear when you click on the Pivot table which is as follows:

Enter the data into the Table/Range box(which in your data is case id, age, sex, and marital status) and click OK.

That's how you create the pivot table in Microsoft Excel.