Wiki Page, Math 13 - Perez Sandbox : Directions: Descriptive Statistics Across Multiple Categories

Wiki Page
2026-01-17T21:14:57-08:00

These directions are typically used very early in the course when we have not yet discussed how data is formatted in a spreadsheet. If this example seems inappropriate, please see the other Descriptive Statistics instructions.

Please note - the variables and data presented in this example may not match the file you are working with.

To compare the descriptive statistics (including frequencies) of a single quantitative variable across multiple categories of a categorical variable:

1. Select Stat Summary Stats Columns

2. Under the Select column(s): heading, click on the appropriate quantitative variable to move it from the gray box on the left to the white box on the right. (Note: if all you need are the frequencies for each category of a categorical variable, just select any quantitative variable.)

Open the Group by: drop-down menu and select the appropriate categorical variable.

3. Scroll to the bottom of the page and click Compute. (Note: if you all you need are the frequencies for each category of the categorical variable, the n counts are listed in the second column.)