Skip to main content

Conjoint Analysis and Experimental Data

  • Chapter
  • First Online:
Business Statistics for Competitive Advantage with Excel and JMP
  • 76 Accesses

Abstract

This chapter introduces ANOVA, (Analysis of Variance) to analyze data from conjoint analysis experiments. Conjoint analysis is used in experiments to quantify customer preferences for better design of new products and services.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 89.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 119.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Author information

Authors and Affiliations

Authors

9.1 Electronic Supplementary Material(s)

Appendices

JMP 9.1: Run ANOVA and Pairwise Comparisons of Factor Levels

Fit Model in JMP is a General Linear Model. If potential drivers are categorical, output will be ANOVA with paired comparisons.

In beer taste.xlsx, copy and paste columns A through D into a new JMP data file.

A spreadsheet includes a table with 4 columns and 12 rows on the right. The column headers are brewery, alcohol, flavor, and rating. The drop-down options labeled untitled and columns are on the left.

Analyze, Fit Model.

Drag rating to Pick Role Variables Y.

Drag the three factors, brewery, alcohol and flavor to Construct Model Effects.

Set Emphasis to Minimal Report.

Run.

A window titled Fit model J M P Pro indicates the drop-down options of model specification. The options to select columns are on the left. The options to pick role variables and construct model effects are on the right. It also includes the help, run, recall, and remove.

Summary of fit contains multiple regression results with indicators set up by JMP. (JMP will do this if drivers are recognized as ordinal or nominal and not continuous.)

Effect Tests presents the factor F tests and pvalues.

Four tables of response rating indicate the summary of fit, analysis of variance with 5 columns and 3 rows, parameter estimates with 5 columns and 7 rows, and effect tests with 6 columns and 3 rows. The summary indicates R square adjacent, root mean square error, mean of response, and observations.

All three factors make a significant difference in ratings.

Click on the triangle next to Effect Details to see the factor level means.

For each factor, click on the red triangle next to the factor, such as brewery, and choose LSMeans Student’s t to see pairwise comparisons with t tests and pvalues.

A box indicates the drop-down options of effect details. The options L S means table and L S means student's t are selected.
A box titled response rating has two tables. The least squares mean table at the top has 4 columns and 3 rows. The column headers are level, least square mean, standard error, and mean. The table of L S means differences student's t has 4 columns and 3 rows.
A box of response rating has a table with 2 columns and 3 rows. The column headers are level and least square mean. The drop-down option above the table is L S means differences student's t.

Significant differences are shown in red. All brewery pairs are significantly different. Below the table, the part worths are sorted in descending order. Equivalent part worths share the same letter. CA micro is preferred to the other brewery levels, and VA micro is also preferred to US name brand.

A box titled response rating has two tables. The least squares mean table at the top has 4 columns and 3 rows. The column headers are level, least square mean, standard error, and mean. The table of L S means differences student's t has 4 columns and 3 rows.
A box of response rating has a table with 2 columns and 3 rows. The column headers are level and least square mean. The drop-down option above the table is L S means differences student's t.

6% and 4% differ from 8%, but not from each other. Either 6% or 4% are preferred to 8%.

A box titled response rating has two tables. The least squares mean table at the top has 4 columns and 3 rows. The column headers are level, least square mean, standard error, and mean. The table of L S means differences student's t has 4 columns and 3 rows.
A table has 2 columns and 3 rows. The column headers are level and least square mean. The row-wise entries are as follows. Row 1. Lime A, 6.1111111. Row 2. Neither B, 5.3888889. Row 3. Coffee C, 3.7222222.

All pairwise comparisons of flavor options differ significantly. Lime is preferred to the two alternate flavors, and neither is preferred to coffee flavor.

For each factor, click on the red triangle next to the factor, such as brewery, and choose LSMeans plot to see a plot of the factor level means.

A drop-down box of response rating includes a table of effect tests with 4 columns and 3 rows. The column headers are source, N p a r m, D F, and sum of squares. A list of options of effect details is at the bottom. L S means plot is selected.
A drop-down box of response rating includes a line graph of rating L S means versus brewery. The V-shaped line indicates the highest values for C A micro and V A micro and the least value for U S name brand.

To export a copy of your output, under File, choose Export:

A screenshot of a window highlights the file menu. The export option is selected from the list of options.

Then, choose Microsoft Word or PowerPoint, Next, and enter the file location:

A screenshot of a window indicates the export options with 8 circular checkboxes. The last checkbox labeled Microsoft Word is enabled. The next and cancel buttons are at the bottom right.

In the Word or PowerPoint file, resize the plots to display side by side and add stand alone titles:

Three graphs of rating L S means. The left graph with a V-shaped line indicates C A Micro Brewery preferred. The graph at the center with an inverted L-shaped line indicates that 4% or 6% alcohol is preferred. The right graph with an inverted V-shaped line indicates lime flavor is preferred.

Copy and paste the Analysis of Variance and Effect Tests from the word document into the excel document.

2 tables. First, analysis of variance has 5 columns and 3 rows. The column headers are source, D F, sum of squares, mean square, and F ratio. Second, effect tests has 6 columns and 3 rows. The column headers are source, N p a r m, D F, sum of squares, F ratio, and probability greater than F.

Create a pie graph to illustrate factor contributions to explanation of preference variation (RSquare) from the Sums of Squares, shown in Fig. 9.3:

Fig. 9.3
A pie chart titled sum of squares has 4 segments. The brewery covers more than 50%. It is followed by decreasing values of alcohol, flavor, and error in a clockwise direction.

Percents of variation explained by the factors

Right click inside a slice to select Add Data Labels. Then right click on a data label to Format Data Labels, choosing Category Name, Percentage, and unchecking Value.

A pie chart titled sum of squares indicates 57% of the brewery, 23% of alcohol, 13% of flavor, and 7% of error. The label options to format data labels are on the right. Category name, percentage, and show leader lines options are enabled.

Delete the legend and make the title stand alone, shown in Fig. 9.4. Click a slice twice to change the fill color in Format, if you choose.

Fig. 9.4
A pie chart titled indicates 57% of the brewery, 23% of alcohol, 13% of flavor, and 7% of error. The text above reads Brewery explains more of preference variation than other factors.

Caption

Case 9.1: Background Music to Enhance Ad Message Recall

A brand manager suspects that the background music featured in a brand’s advertising may affect consumers’ recall of information presented in ads. Some music backgrounds are more distracting than others, and may compete with audience attention to the advertising message. Several background options are being considered, and those options differ along three categories, or factors.

  • Three vocals options are: backgrounds which feature vocals, backgrounds with brand related vocals substituted for original vocals, and backgrounds with vocals removed.

  • Three orchestration options are: saxophone, saxophone and percussion, and saxophone and piano.

  • Three tempo options are: slow tempo, moderate tempo, and fast tempo

It has been established that multiple timbres (from multiple instruments) distract more. It is also known that changes in the music background distract, and the rate of distraction is lower for slower tempos; yet, faster tempos allow streaming – music changes heard before become less surprising and distracting at faster tempos.

To determine whether vocals, orchestration and tempo of backgrounds affect brand message recall, the ad agency creative team designed nine backgrounds for a brand ad using conjoint analysis. Since the ad message, visuals, and length of ad could also influence message recall, the agency creatives were careful to make those ad features identical across the nine versions. By using ads that were identical, except for their musical backgrounds, any difference in resulting brand message recall could be attributed to the difference in backgrounds. The conjoint analysis design is shown below:

Orchestration

None

Original

Brand specific

Sax

Slow

Moderate

Fast

Sax & percussion

Moderate

Fast

Slow

Sax & piano

Fast

Slow

Moderate

Eighteen consumers were randomly selected and then randomly assigned to one of the nine background treatments, or combination of vocals, orchestration and tempo. Each viewed the brand advertisement with one of the nine backgrounds, and then message elements in the ad, which could be six, if all elements were recalled, or as low as zero, if no elements were recalled.

The data are in music backgrounds.xlsx.

Test hypotheses regarding factor effects on message recall

  1. 1.

    State the null hypotheses for the three factors. Indicate which you can reject, specifying the appropriate statistic, degrees of freedom and pvalues for all three.

  2. 2.

    Assess pairwise differences between factor levels

    Which vocal(s) lead to higher recall?

    ___ none ___ original ___ brand specific

    Which orchestration(s) lead to higher recall?

    ___ sax ___ sax and percussion ___ sax and piano

    Which tempo(s) lead to higher recall?

    ___ slow ___ moderate ___ fast

  3. 3.

    Plot the part worth recall scores by factor level for each of the three factors with a line graph.

  4. 4.

    Plot the sums of variance explained by each factor in a pie chart.

Summarize what you learned from your analysis:

Rights and permissions

Reprints and permissions

Copyright information

© 2024 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Fraser, C. (2024). Conjoint Analysis and Experimental Data. In: Business Statistics for Competitive Advantage with Excel and JMP . Springer, Cham. https://doi.org/10.1007/978-3-031-42555-4_9

Download citation

Publish with us

Policies and ethics