cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
chungwei
Staff (Retired)
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”.

8749_minMeanMax1.png

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".

8750_total.png

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.

Last Modified: Oct 18, 2016 7:15 PM
Comments