Subscribe Bookmark RSS Feed

Inputing a data containing sums for x by y

oedann

New Contributor

Joined:

Apr 26, 2017

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

 

Rank842357159763
Like Extremely5554
Like Very Much157913
Like Moderately10131810
Like Slightly6215
Neither Like nor Dislike2442
Dislike Slightly2413
Dislike Moderately0211
Dislike Very Much0201
Dislike Extremely0111

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

RankSampleCount
Like Extremely8425
Like Very Much84215
Like Moderately84210
Like Slightly8426
Neither Like nor Dislike8422
Dislike Slightly8422
Dislike Moderately8420
Dislike Very Much8420
Dislike Extremely8420

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.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Simple table manipulation will transform the table into what you want

1. Create 4 new columns

transform 1.PNG

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

transform 3.PNG

3. Delete the first row in the table

transform 4.PNG

4. Go to 

     Tables==Stack

transform 5.PNG

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

transform 6.PNG

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

Jim
2 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Simple table manipulation will transform the table into what you want

1. Create 4 new columns

transform 1.PNG

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

transform 3.PNG

3. Delete the first row in the table

transform 4.PNG

4. Go to 

     Tables==Stack

transform 5.PNG

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

transform 6.PNG

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

Jim
oedann

New Contributor

Joined:

Apr 26, 2017

Thank you so much. I knew there was a way. I've done it in SAS, but am a new user to JMP. I really appreciate your help.