Subscribe Bookmark RSS Feed

Is there a way to represent how a row changes across columns?

hollyg

Community Member

Joined:

Sep 20, 2013

I am looking at how survey responses change over time. Each participant is entered as a row. Is there a way to see how each participant's anwers vary over time? For example, we have a survey that was given annually for 3 years. For yes or no questions (answers coded 1 or 0), I would like know how many people answered 1 the first year, then 0 for the two subsequent years etc.

Thank you. 

2 REPLIES
ms

Super User

Joined:

Jun 23, 2011

To get a row count of each combination you can use Summary in the Tables menu. Enter the three year-columns as grouping variables. That will give you a table with a column "N Rows" that represent the number of rows for each 1-0-0, 1-1-0 etc.

The parallel plot is a way to visualize data across rows. But otherwise JMP provides more options with data arranged in columns. The Stack command (Tables menu) is an easy way to stack a horizontal data set that automatically creates a grouping columns based on the names of stacked columns.

Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

MS gives some good options.

Here's another...the Categorical platform will handle these three responses as "Repeated Measures". In this way you'll get a transition report showing the changes from one period to the next.

4205_JMPScreenSnapz001.png

-Jeff

-Jeff