The Soda_Raw Data.elsx gives a consumer’s ranking on 12 product profiles with different combinations of attributes involving a comparison of Coke and Pepsi.

The attributes and levels are as follows:

• Brand: Coke or Pepsi
• Packaging: 12 oz. can or 16 oz. bottle
• Price per ounce: 8 cents, 10 cents, 12 cents
• Calories per ounce: 0 or 15

• Profile	Brand	Packaging	Calories	Price	Rank
  1	coke	can	0	8	4
  2	coke	bottle	0	8	2
  3	pepsi	can	15	8	6
  4	pepsi	bottle	15	8	5
  5	coke	can	15	10	11
  6	coke	bottle	15	10	9
  7	pepsi	can	0	10	3
  8	pepsi	bottle	0	10	1
  9	coke	can	15	12	12
  10	coke	bottle	0	12	8
  11	pepsi	can	0	12	7
  12	pepsi	bottle	15	12	10

• Question 4: Complete the Conjoint Analysis Reporting. Need the excel sheet used for the regression analysis also.

Customer Preferences on Attributes

Attribute name

Lowest coefficient

Highest coefficient

The spread

Ranking of the attribute

Answer rating: 100% (QA)

1 Brand Coke or Pepsi Coke 78 Pepsi 78 156 1 2 Pack... View the full answer