Example of the Tabulate Platform

Learn how to summarize data in a tabular format. In this example, you have data containing height measurements for male and female students. You want to create a table that shows the mean height for males and females and the aggregate mean for all students.

Figure 9.2 Table Showing Mean Height 

1. Select Help > Sample Data Folder and open Big Class.jmp.

2. Select Analyze > Tabulate.

Since height is the variable that you are examining, you want it to appear at the top of the table.

3. Click height and drag it into the drop zone for columns.

Figure 9.3 Height Variable Added 

You want the statistics by sex, and you want sex to appear on the side.

4. Click sex and drag it into the blank cell next to the number 2502.

Figure 9.4 Sex Variable Added 

Instead of the sum, you want it to show the mean with two decimal places. You also want the overall mean.

5. Click Mean and drag it on top of Sum.

Figure 9.5 Mean Statistic Added 

6. Click All and drag it on top of sex. Or, you can simply select the Add Aggregate Statistics check box.

7. Click the Change Format button.

8. Select Fixed Dec from the menu and enter 2 for Dec.

9. Click Done.

The completed table shows the mean height for females, males, and the combined mean height for both. The mean is reported to two decimal places.

Figure 9.6 Completed Tabulate