Conjoint Analysis
Conjoint Analysis
Conjoint Analysis
Li Yang
Dec 2019
Measure Consumer Preferences
• Why do conjoint?
• How to do conjoint?
llu
r.
la
ce
llu
t
ou
ce
ith
ith
w
w
,
s,
e)
w
pl
do
Ap
in
S(
W
iO
Measuring Preferences for Tablets
Price: Screen:
• $100 • 7 inches
• $300 • 10 inches
• $500
Battery life: Cellular network access:
• 4 hours • No
• 8 hours • Yes
• 12 hours
OS: What do you want to know?
• iOS (Apple)
• Windows
• Android
Questions We Want to Answer
• What are the attributes most important to consumers?
it
n
it
..
io
.
of
al
l..
ed
ss
re
rd
ly
us
se
er
al
ea
is
re
ev
an
h
th
er
tn
er
it
h
ev
ev
bu
ac
ed
tn
In
te
rn
it
bu
ld
ed
ea
ou
Il
it
rn
Ic
d
ea
se
Il
Iu
What is Conjoint Analysis
• Multivariate technique used to understand how consumers
make tradeoffs among attributes or characteristics of
products or services
• Based on the premise that consumers evaluate the utility of a
product by combining the separate amount of utility provided
by each attribute
• Respondents perform a realistic task – provide overall
evaluations of products
• Attributes are considered jointly
• Less accurate
– People tend to rate all attributes as (equally) important
30%
Actual
25%
response data
20% from CKMBA13
15% survey
10%
5%
0%
Screen size Cell network OS Battery life Price
4. Collect data
4. Collect data
4. Collect data
4. Collect data
Apple + 7” Screen:
Screen + Cell YES + 4 hour
Price: battery + $100
Apple + 7” Screen + Cell YES + 4 hour battery + $300
• $100 • 7 inches
Apple + 7” Screen + Cell YES + 4 hour battery + $500
• $300 • 10 inches
Apple + 7”• Screen
$500 + Cell YES + 8 hour battery + $100
Apple + 7” Screen + Cell YES + 8 hour battery + $300
Apple + 7”
Battery
Screen +life: Cellular
Cell YES + 8 hour batterynetwork
+ $500 access:
• 4 hours • No,
Apple + 7”• Screen
8 hours+ Cell YES + 12 hour battery + $100
• Yes
Apple + 7” Screen + Cell YES + 12 hour battery + $300
• 12 hours
Apple + 7” Screen + Cell YES + 12 hour battery + $500
OS:
…..
• iOS (Apple),
…..
….. • Windows,
• Android
Android +10” Screen + Cell YES + 12 hour battery + $500
Stage 3: Design study
• How many combinations?
– 3 OS X 2 screens X 2 cell connectivity X 3 batteries X 3 prices
– Totally 108 combinations!!
4. Collect data
4. Collect data
Regression X Regression Y
matrix matrix
Preparing Data for Regression
Dummy variable coding
Scr: Cell: Px: Px: Batt: Batt: OS: OS: Subject
Profile # Profile desc
10" Y $300 $500 8h 12h Win And ratings
1 7,Y,300,12,Windows 0 1 1 0 0 1 1 0 3
2 7,Y,100,8,Windows 0 1 0 0 1 0 1 0 4
3 10,Y,500,12,Android 1 1 0 1 0 1 0 1 4
4 7,Y,300,4,Android 0 1 1 0 0 0 0 1 2
5 7,N,300,8,iOS 0 0 1 0 1 0 0 0 4
6 10,N,300,12,Windows 1 0 1 0 0 1 1 0 4
7 7,N,500,12,Android 0 0 0 1 0 1 0 1 3
8 10,N,300,8,Android 1 0 1 0 1 0 0 1 4
9 7,N,500,4,Windows 0 1 0 1 0 0 1 0 1
10 10,Y,100,12,iOS 1 1 0 0 0 1 0 0 7
11 10,Y,300,4,iOS 1 1 1 0 0 0 0 0 4
12 7,N,100,12,iOS 0 0 0 0 0 1 0 0 6
13 10,Y,500,8,Windows 1 1 0 1 1 0 1 0 2
14 10,N,500,4,iOS 1 0 0 1 0 0 0 0 3
15 10,N,100,4,Windows 1 0 0 0 0 0 1 0 4
16 10,N,100,8,Android 1 0 0 0 1 0 0 1 6
17 7,Y,500,8,iOS 0 1 0 1 1 0 0 0 4
18 7,Y,100,4,Android 0 1 0 0 0 0 0 1 5
Regression
Regression X matrix
Y matrix
Regression Output
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.98
R Square 0.95
Adjusted R Square 0.91
Standard Error 0.44
Observations 18
ANOVA
df SS MS F Significance F
Regression 8 36.05 4.51 23.48 0.00
Residual 9 1.73 0.19
Total 17 37.78
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 4.98 0.33 15.21 0.00 4.24 5.72 4.24 5.72
Scr: 10" 0.69 0.21 3.26 0.01 0.21 1.17 0.21 1.17
Cell: Y 0.11 0.22 0.51 0.62 -0.39 0.62 -0.39 0.62
Px: $300 -1.83 0.25 -7.25 0.00 -2.41 -1.26 -2.41 -1.26
Px: $500 -2.52 0.26 -9.86 0.00 -3.10 -1.94 -3.10 -1.94
Batt: 8h 0.85 0.26 3.33 0.01 0.27 1.43 0.27 1.43
Batt: 12h 1.35 0.26 5.29 0.00 0.77 1.93 0.77 1.93
OS: Win -1.69 0.26 -6.60 0.00 -2.26 -1.11 -2.26 -1.11
OS: And -0.67 0.25 -2.64 0.03 -1.24 -0.09 -1.24 -0.09
Part-worth
0
-0.5 7" 10" -0.5 N Y
-1 -1
-1.5 -1.5
-2 -2
-2.5 -2.5
-3
Price -3
1.5
1
0.5
Part-worth
0
-0.5 $100 $300 $500
-1
-1.5
-2
-2.5
OS -3
Ba ery
1.5 1.5
1 1
0.5 0.5
Part-worth
Part-worth
0 0
-0.5 iOS Windows Android -0.5 4 hours 8 hours 12 hours
-1 -1
-1.5 -1.5
-2 -2
-2.5 -2.5
-3 -3
Calculating Attribute Importances
• An attribute’s importance is proportional to the range (taken
over levels) of its part-worths
4. Collect data
• Quatrics
Attributes Levels
Attributes Levels
An 18M Camera
Brand Name Sony, Canon
Price ¥1269, ¥1369, ¥1469
Color Black, White, Pink, Red
Style Lovely, Fashionable
Function Scenic, Portrait
Type Travel, Home-use
Conjoint: Step Three
Code Dummy Variables
Attributes Levels
An 18M Camera
Brand Name Sony, Canon
Price ¥1269, ¥1369, ¥1469
Color Black, White, Pink, Red
Style Lovely, Fashionable
Function Scenic, Portrait
Type Travel, Home-use
Attributes Levels
An 18M Camera
Brand Name Sony, Canon
Price ¥1269, ¥1369, ¥1469
Color Black, White, Pink, Red
Style Lovely, Fashionable
Function Scenic, Portrait
Type Travel, Home-use
Orthogonal Profile Design
Translate the 0/1 dummies into actual levels of each attribute
Canon, ¥1369,
white, fashionable,
portrait, home-use
Sony, ¥1269,
white, lovely,
portrait, travel
Attributes Levels
An 18M Camera
Brand Name Sony, Canon
Price ¥1269, ¥1369, ¥1469
Color Black, White, Pink, Red
Style Lovely, Fashionable
Function Scenic, Portrait
Type Travel, Home-use
Conjoint: Step 5
Collect data from respondents
Attributes Levels
An 18M Camera
Brand Name Sony, Canon
Price ¥1269, ¥1369, ¥1469
Color Black, White, Pink, Red
Style Lovely, Fashionable
Function Scenic, Portrait
Type Travel, Home-use
Example: Digital Camera
Estimation Results from Sophia
Attributes Part-worth Values Range Importance Weights
Brand
Sony -2.0 2.0 39%
Canon 0
=2.0/(5.125)
Price
¥1269 0.375 0.375 7.3%
¥1369 0.25
¥1469 0
Color
Black -0.5 1.0 19.5%
White 0.25
Pink -0.75 =0.25-(-0.75)
Red 0
Style
Lovely -0.5 0.5 9.8%
Fashionable 0
Function
Scenic -1 1.0 19.5%
Portrait 0
Type
Travel -0.25 0.25 sum 4.9%
Home-use 0 5.125
Understanding Sophia
• She likes Canon better
• White is her favorite color
Did we ask her
• She’s no fan of lovely camera direct questions?
• Method
– Calculate the expected utility of each product for each
respondent
• First choice rule: assume highest utility profile is chosen by each
respondent
Camera Preference Study
Would shares change if Canon pink raises its price to ¥1469 ? 25%, 50%, 25%
Would shares change if Sony black switches to pink? 0%, 37.5%, 62.5%