Subscribe Bookmark



Jun 23, 2011

Tabulate Totals

What statistics does the keyword “all” compute ?

Well, any statistics that you ask for.

For example, I have a table of  min, mean, and max age of car buyers, grouped by country, size, and sex.

8748_mean age.png

I would like to have the 3 statistics aggregated by the grouping column “sex”,

i.e., I want to have the min,  mean,  and max age for all the car buyers, irrespective of sex, in the same table.

To get that, drag and drop the keyword “All”  onto the grouping column “sex”.

You are in effect, asking tabulate to make an extra group, “all”, for the grouping column “sex”.


If you don't like the word "All" for your report, you can change it.

Double click in the box for  "All" in the table, and enter the word of your choice.

In this example, I have changed the word "All" to "Total".


Dropping the keyword “All” on a grouping column tells tabulate to compute the aggregate statistics for that grouping column.

You can do the same for all the other grouping columns in the table.

There is a checkbox in the Control Panel, “Add Aggregate Statistics”.

Checking that will give you the aggregate statistics for all the grouping columns in the table.

1 Comment
Community Trekker

Tabulate is great but could be better. For example the aggregate stats could be bolded, and could have ability of conditional formatting or just carrying over the conditional formatting of the data table it was derivated from. Moving from SPSS to JMP I miss these 2 features most.

Article Tags