Subscribe Bookmark
stan_koprowski

Community Manager

Joined:

Aug 8, 2012

Marketing in the winter sports season

Understanding your customers has always been important, but it's even more so when marketing products and services related to winter snow sports. Winter sports can have a short season and a limited number of consumers. How do you find them, identify their needs, create new promotions and assess whether the promotions are having an impact? With JMP 11 and the new consumer research platform, you can easily handle these types of questions and tasks.

In this post, we will import survey data and explore the relationships among the categorical variables using the new Categorical platform.

The data was originally stored in the Triple-S format. According to the Triple-S.org website, Triple-S is a language used for describing survey metadata. The add-in for importing from Triple-S version 2 is posted on the JMP File Exchange, which is part of the JMP User Community.

JMP now includes a full suite of tools for performing customer and consumer research. In the past, you might have had to use one product for consumer research work and JMP for design of experiments (DOE). Now for the first time, you can do both types of analyses using a single product, for a more efficient use of your most precious resource: your time. Tools for performing these statistical analyses are now located in one convenient place under the Consumer Research menu.

Consumer Research Menu

You already collect information about how customers use merchandise or services or how satisfied they are with your offerings. The subsequent insight lets you generate better products and services, happier customers and more revenue for your organization.

We prepared a hypothetical survey to understand the winter sports buying preferences of consumers; the survey had 448 respondents. The survey asked about Winter Olympics watching preferences, skiing and snowboarding frequencies, whether or not they take family ski vacations, and more.

After importing the survey data using the Triple-S XML add-in, we analyzed the data using the new categorical platform. The new categorical platform in JMP Pro enables you to discover the needs of your customers by performing categorical response analysis. The Categorical platform tabulates and summarizes categorical response data, including multiple response data, and calculates test statistics. The strength of the Categorical platform is that it can handle responses in a wide variety of formats without needing to reshape the data.

Structured Tab

The Structured tab enables us to construct complex tables of descriptive statistics simply by dragging and dropping column names into green icon drop zones to create side-by-side and nested results. We have chosen to include responses not in data by checking the option in the bottom left under the Grouping options. This displays rows and columns for all data values, even those with zero cell counts.

The platform allowed us to determine whether families with school-age children are planning to watch the 2014 Winter Olympics. Of the 448 respondents, 64.1% were planning to watch. Of those responding positively, the viewers with school-age children were more likely to watch, with 69.2% versus 60.5% with no school-age children. We quickly were able to create reports based on respondent’s age group, preferences for skiing, snowboarding and winter sports.

Structured Report

Different survey tools report responses in different formats. The Categorical platform supports many common formats without requiring the user to reshape the data. Multiple-response questions, for example, instruct you to “select all that apply.” In JMP, the columns that store these data are called “Multiple Response” questions, as they may store multiple answers per respondent.

One of our "select all that apply" questions asked respondents when they liked to ski: On Vacation, On Business Trips, On Weekends, or On Weekdays. The responses were stored as a comma-delimited string in the data table.

Olympic Survey Data with multiple delimited responses

Using the Multiple Response Delimited response type on the Multiple tab, we were able to output the results into crosstab report tables and display frequency charts.

 

Multiple Response Delimited

The completed analysis tables can be output and shared with others on our team.

Multiple Delimited Response Crosstab Report

JMP produces a great many default statistics for the resulting crosstabs, including mean scores and chi-squared tests for association. These statistics can be accessed using the Categorical platform’s red triangle menu.

Available options accessible from Red Triangle Menu

Different survey tools can use different formats to store multiple responses, and JMP can handle many of these through selections on the Multiple Response tab. See the Additional Examples of the Categorical Platform in the JMP Consumer Research reference for more examples of multiple response columns.

Free text responses are used for respondent comment fields and were analyzed for frequency counts of each word used. We then used a tree map to visually explore the most frequent word counts collected in the comments.

Free Text Statistics and resulting tree map

In future blog posts, we will use the other analysis platforms used for Consumer Research, including Factor Analysis, Choice, and Uplift platforms to discover simple arrangements in the pattern of relationships among variables, discover the preference structure of consumers, and maximize the impact of our marketing budget by sending offers only to individuals who are likely to respond favorably, even when we have large data sets and many possible behavioral or demographic predictors.

Do you analyze consumer research data currently? Leave us a comment and let us know what types of analyses you routinely do with your survey data or other categorical response data such as defect records or side effects?


Note: Melinda Thielbar, Research Statistician Developer for JMP, co-wrote this blog post with Stan Koprowski.

3 Comments
Community Member

Dr Rob Hall wrote:

In the marketing and social research industry, a lot of survey data are delivered from the data collection process in SPSS format. Multiple response items therefore appear as separate columns in the data table. What is the most efficient way to move them from this format to the JMP multiple response column format?

Community Manager

Stan Koprowski wrote:

Hi Rob,

Thank you for the question. With aligned responses -- that is, where multiple responses are entered across several columns but treated as one grouped response --

JMP can handle multiple responses as individual columns without any additional data cleaning.

Select Analyze--> Consumer Research--Categorical.

On the right-hand side under the Response Roles, click on the Multiple tab.

This will present you with a several options for handling multiple response data, including Multiple Responses, Multiple Response by ID, Multiple Delimited, Indicator Group, etc.

For the situation you described, do a multiple select on all of the multiple response columns to be analyzed and click on the "Multiple Response" button. Select OK to complete the analysis.

Note: To select multiple columns:

For continuous selection:

1) Click and drag the cursor over the column name.

2) Hold down the SHIFT key and click the first and last columns of the desired range.

3) Hold down the SHIFT key and press the left or right arrow key.

For columns that are not next to each other:

Hold down the CTRL key and click on each column.

Good luck with your analyses.

Community Member

Walter Paczkowski wrote:

Rob,

I run into this problem all the time with survey data I receive. The "Check All that Apply" responses are typically in separate consecutive columns and are coded as 0 = Not Checked (or No) and 1 = Checked (or Yes). I start my analysis by using the Multiple Response tab and selecting Indicator Group. This gives a good summary of all the "Check All that Apply" responses.

Hope this helps.

Walt