For the latest version of JMP Help, visit JMP.com/help.


Consumer Research > MaxDiff > Examples of the MaxDiff Platform > Example of a Multiple Table Format
Publication date: 04/21/2023

Example of a Multiple Table Format

Use the MaxDiff platform to analyze a MaxDiff experiment where the data are in multiple data tables. You should have a profile table, a subject table, and a response table.

Complete the Launch Window

1. Select Help > Sample Data Folder and open the Potato Chip Responses.jmp sample data table.

Note: If you prefer not to follow the steps for completing the launch window, click the green triangle next to the MaxDiff for Flavor script. Then proceed to Explore the Model.

2. Click the green triangle next to the Open Profile and Subject Tables script.

The profile data table, Potato Chip Profiles.jmp, lists all the potato chip types in the study (Flavor) along with information about the country of origin (Product Of). Each choice has a Profile ID.

The subjects data table, Potato Chip Subjects.jmp, lists the respondents. It also gives additional information about each respondent: Citizenship and Gender.

The responses data table, Potato Chip Responses.jmp, lists the respondents. For each respondent, the Survey ID and Choice Set ID for each set of profiles is listed, along with the Profile ID values for each choice set. The table also contains response data in the Best Profile and Worst Profile columns.

3. From any of the three data tables, select Analyze > Consumer Research > MaxDiff.

4. From the Data Format list, select Multiple Tables, Cross-Referenced.

There are three separate outlines, one for each of the data sources.

5. Click Select Data Table under Profile Data.

A Profile Data Table window appears, which prompts you to specify the data table for the profile data.

6. Select Potato Chip Profiles and click OK.

The columns from this table appear in the Select Columns.

7. Select Profile ID from the Select Columns list and click Profile ID under Pick Role Variables.

8. Select Flavor and click Add under Construct Model Effects.

Note that Product Of is another profile effect that you could add to the effects list.

Figure 5.5 Complete Profile Data Outline 

Complete Profile Data Outline

9. Open the Response Data outline. Click Select Data Table.

10. Select Potato Chip Responses and click OK.

11. Assign roles to columns to complete the launch dialog:

Select Best Profile and click Best Choice.

Select Worst Profile and click Worst Choice.

Select Choice 1, Choice 2, and Choice 3 and click Profile ID Choices.

Select Respondent and click Subject ID.

Figure 5.6 Completed Response Data Outline 

Completed Response Data Outline

12. Open the Subject Data outline. Click Select Data Table.

13. Select Potato Chip Subjects and click OK.

14. Select Respondent and click Subject ID.

15. Select Citizenship and Gender and click Add under Construct Model Effects.

Figure 5.7 Completed Subject Data Outline 

Completed Subject Data Outline

Explore the Model

1. Click Run Model.

Figure 5.8 MaxDiff Model Report 

MaxDiff Model Report

The Effect Summary report shows the terms in the model and gives p-values for their significance. Notice that Flavor is a profile effect, and that each of Citizenship*Flavor and Gender*Flavor is an interaction of a subject and a profile effect.

The Likelihood Ratio Tests report indicates that Flavor is significant.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).