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

Question 1: Complete the codebook with the template.

Question 2: How many product attributes are included in the dataset? How many levels does each variable has?

Question 3: What is the R-squared for the conjoint analysis? What does R-squared tell us?

Question 4: What is the significance level of the F-test? What does the significance F tell us?

\f\f