cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
markkompas
Level I

Survey data

I am not sure if JMP can help me. I have two consecutive years of survey data with 5000 respondents each year. The question is a single, multiple choice question but they can choose as many responses as they like.  I am trying to compare frequency data on each choice year on year (2013 vs. 2014). I do not have the actual data set, just a data table with frequency counts. I need to determine which differences between years are significant.

Please help!

Mark

1 ACCEPTED SOLUTION

Accepted Solutions
melinda_thielba
Staff (Retired)

Re: Survey data

Hi, Mark!

JMP 11.0 and higher has many options for analyzing multiple response (i.e. "Check all that apply" questions) in the Categorical platform.

For your data, you will want a column that specifies how many people responded to your survey. We call that a "sample size" column. If you don't have a column like that, you can create it using a formula or by just typing the appropriate sample size (number of survey respondents) for each year into the data table.

Once you have sample size, you can bring up the Categorical platform by selecting Analyze-> Consumer Research -> Categorical.

If I understand how your data is organized correctly, you'll want to follow these steps:

Once you are in the Categorical platform, select the "Multiple Response" tab.

1) Shift-select to select all of the columns that have your counts.

2) Click the "Response Frequencies" button.

3) Assign the "Year" column (2013 vs 2014) to the X role (bottom center). 

4) Assign your Sample Size column (described above) to the Sample Size role.

4) Click "OK"

The resulting report should compare the response frequencies for each column, treating them all as one variable.

There's additional documentation on Response Frequencies (with an example) here: Additional Examples of the Categorical Platform.

That page also contains more information about Multiple Response columns in JMP.

Please respond if you have more questions!

Best,

Melinda

View solution in original post

1 REPLY 1
melinda_thielba
Staff (Retired)

Re: Survey data

Hi, Mark!

JMP 11.0 and higher has many options for analyzing multiple response (i.e. "Check all that apply" questions) in the Categorical platform.

For your data, you will want a column that specifies how many people responded to your survey. We call that a "sample size" column. If you don't have a column like that, you can create it using a formula or by just typing the appropriate sample size (number of survey respondents) for each year into the data table.

Once you have sample size, you can bring up the Categorical platform by selecting Analyze-> Consumer Research -> Categorical.

If I understand how your data is organized correctly, you'll want to follow these steps:

Once you are in the Categorical platform, select the "Multiple Response" tab.

1) Shift-select to select all of the columns that have your counts.

2) Click the "Response Frequencies" button.

3) Assign the "Year" column (2013 vs 2014) to the X role (bottom center). 

4) Assign your Sample Size column (described above) to the Sample Size role.

4) Click "OK"

The resulting report should compare the response frequencies for each column, treating them all as one variable.

There's additional documentation on Response Frequencies (with an example) here: Additional Examples of the Categorical Platform.

That page also contains more information about Multiple Response columns in JMP.

Please respond if you have more questions!

Best,

Melinda