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.
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.
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.
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.
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.
The completed analysis tables can be output and shared with others on our team.
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.
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.
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.
Dr. Rob Hall schrieb:
In der Marketing- und Sozialforschungsbranche werden viele Erhebungsdaten aus dem Datenerfassungsprozess im SPSS-Format geliefert. Mehrere Antwortelemente erscheinen daher als separate Spalten in der Datentabelle. Was ist der effizienteste Weg, um sie von diesem Format in das JMP-Format mit mehreren Antwortspalten zu verschieben?
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.
Walter Paczkowski schrieb:
Rauben,
Ich stelle dieses Problem ständig mit Umfragedaten auf, die ich erhalte. Die Antworten "Alle zutreffenden Antworten" befinden sich normalerweise in separaten aufeinander folgenden Spalten und werden als 0 = Nicht geprüft (oder Nein) und 1 = Überprüft (oder Ja) codiert. Ich starte meine Analyse über die Registerkarte Multiple Response und wähle Indikatorgruppe aus. Dies gibt eine gute Zusammenfassung aller Antworten "Alle zutreffenden Antworten".
Hoffe das hilft.
Walt
