Adding percentages using Tabulate in JMP

[#1]

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

[#2 · Accepted 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 )

  )

  )

);

[#3]

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