turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Survey data

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 6, 2014 5:42 PM
(2162 views)

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

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 7, 2014 8:18 AM
(3012 views)

Solution

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

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Aug 7, 2014 8:18 AM
(3013 views)

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