Counterintuitive results
I have a conjoint exercise with 9 attributes. The importance of each attribute is listed below:
Importance
Att1 14%
Att2 7%
Att3 8%
Att4 5%
Att5 6%
Att6 5%
Att7 11%
Att8 7%
Att9 38%
The average utilities for the last attribute (Att9) are:
Average utilities (diff)
Level 1 83
Level 2 160
Level 3 172
Level 4 239
The current market is:
Att1 Att2 Att3 Att4 Att5 Att6 Att7 Att8 Att9
Product 01 3 2 4.5 1 1 20 7 1.5 4
Product 02 4 2 2 1 1 20 7 1.5 4
Product 03 3 2 1 2 2 N/A N/A 3 4
Product 04 4 2 1 2 2 N/A N/A 3 4
Product 05 4 2 2 1 2 N/A N/A 3 4
Product 06 3 2 4.5 1 2 N/A N/A 3 4
Product 07 1 2 2 1 2 N/A N/A 3 4
Product 08 1 2 4.5 1 2 N/A N/A 3 4
Product 09 3 2 4.5 1 1 20 7 3 4
Product 10 4 2 2 1 1 20 7 3 4
Product 11 1 2 2 1 2 N/A N/A 1.5 4
Product 12 1 2 4.5 1 2 N/A N/A 1.5 4
The sensitivity shares for the first product, for the last attribute are:
Level 1 Level 2 Level 3 Level 4
Product 01 19 28 32 13
Question:
How comes that on average the utilities show that the last level of the Att9 is the most important and should gather the most share, but when I run the sensitivity analysis on this attribute the worst product is the one with level 4 on attribute 9?