turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Adding percentages using Tabulate in JMP

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 15, 2012 6:53 AM
(2501 views)

Hi,

I want to create a table using Tabulate in JMP 10. The table has three grouping variables: Product (at two levels), Test Code (at 7 levels), and Rating Category for each code (at 3 levels). Rating Category is nested under Test Code which is nested under Product. The analysis column is an Overall Liking rating for the products. The table I want has the three grouping variables, the mean for Overall Liking, and the percent of people in each Product/Code/Category group. How do I get the percent in each group? To illustrate, I may have something like:

Product | Code | Rating | Overall Mean |
---|---|---|---|

P1 | A1 | T2B | 3.2 |

Neutral | 4.3 | ||

B2B | 2.3 | ||

All | 4.0 | ||

A2 | T2B | 3.0 | |

Neutral | 2.5 | ||

B2B | 3.5 | ||

All | 3.7 |

I want to add a column that shows the percent of people responding for each level of Rating for Code A1, Product P1. The percents should sum to 100. Then have this repeat for the next combination of Product/Code and Ratings. So the first two sets should be:

Product | Group | Rating | Overall Mean | Percent Respondents |
---|---|---|---|---|

P1 | A1 | T2B | 3.2 | 25% |

Neutral | 4.3 | 35% | ||

B2B | 2.3 | 45% | ||

All | 4.0 | 100% | ||

A2 | T2B | 3.0 | 25% | |

Neutral | 2.5 | 25% | ||

B2B | 3.5 | 50% | ||

All | 3.7 | 100% |

How can I do this either using Tabulate or in a script (the script is preferable)?

Any help is appreciated.

Walt Paczkowski

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Sep 5, 2014 7:55 AM
(4358 views)

Solution

Tabulate**(**

Change Item Label**(** Statistics**(** Mean, "Overall Mean" **)** **)**,

Set Format**(** Name**(** "% of Total" **)(****9**, **2****)** **)**,

Add Table**(**

Column Table**(** Statistics**(** Name**(** "% of Total" **)(**:Rating**)** **)** **)**,

Column Table**(** Analysis Columns**(** :X **)**, Statistics**(** Mean **)** **)**,

Row Table**(**

Grouping Columns**(** :Product, :Group, :Rating **)**,

Add Aggregate Statistics**(** :Rating **)**

**)**

**)**

**)**;

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Sep 5, 2014 7:55 AM
(4359 views)

Tabulate**(**

Change Item Label**(** Statistics**(** Mean, "Overall Mean" **)** **)**,

Set Format**(** Name**(** "% of Total" **)(****9**, **2****)** **)**,

Add Table**(**

Column Table**(** Statistics**(** Name**(** "% of Total" **)(**:Rating**)** **)** **)**,

Column Table**(** Analysis Columns**(** :X **)**, Statistics**(** Mean **)** **)**,

Row Table**(**

Grouping Columns**(** :Product, :Group, :Rating **)**,

Add Aggregate Statistics**(** :Rating **)**

**)**

**)**

**)**;

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Sep 5, 2014 8:06 AM
(2179 views)

I meant to add this to the script I added in my previous reply,

To get the specific percentage you want, you need to tell Tabulate the denominator. You do that by qualifying the statistics key word "% of Total" with the grouping column(s).