Inputing a data containing sums for x by y

oedann

Is there anyway I can input a data table containing count sums into JMP and have the software recognize it as such. For example, here is my data table, showing that 5 people ranked sample 842 as 'Like Extremely', 15 people ranked 842 'Like Very Much', etc.:

 

Rank	842	357	159	763
Like Extremely	5	5	5	4
Like Very Much	15	7	9	13
Like Moderately	10	13	18	10
Like Slightly	6	2	1	5
Neither Like nor Dislike	2	4	4	2
Dislike Slightly	2	4	1	3
Dislike Moderately	0	2	1	1
Dislike Very Much	0	2	0	1
Dislike Extremely	0	1	1	1

 Can I code or specify in JMP that these are sums for rank by sample number to run ANOVA on the data or do I need to rewrite all the data as follows to run ANOVA (The example below is just for sample 842, just tried to keep it short for the discussion)?

Rank	Sample	Count
Like Extremely	842	5
Like Very Much	842	15
Like Moderately	842	10
Like Slightly	842	6
Neither Like nor Dislike	842	2
Dislike Slightly	842	2
Dislike Moderately	842	0
Dislike Very Much	842	0
Dislike Extremely	842	0

It seems like there would be an easy solution, but I haven't found any solution on JMP Help. Anyone know the solution or if there is one? Thanks.

txnelson

Simple table manipulation will transform the table into what you want

1. Create 4 new columns

2. Copy the 4 data values in row 1 and paste them into the 4 new columns

3. Delete the first row in the table

4. Go to 

     Tables==Stack

Select columns 2 thru 9 to be stacked

Specify Multiple series stack with the Number of Series = 2

Select the columns to be "Contiguous"

Click on OK

The new data table will have the data arranged the way you want.  Columns Data and Data2 contain your "Sample" and "Count" data.  Just click on the header for the column and changes the names