See the question below

Question 2. The soda.x/sx file gives a consumer's ranking on an orthogonal design with 12 product profiles 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 Determine the ranking of the attributes' importance and the ranking of all attribute levels. Show your work with regression result and calculation for spread to determine the importance ranking. (5 points) F G H J K L per oz per oz 3 Profile Brand Packaging Calories Price Rank 4 1 coke can 8 O 5 2 coke bottle 0 6 3 pepsi can 15 7 4 pepsi bottle 15 8 5 coke can 15 10 11 9 6 coke bottle 15 10 10 7 pepsi can 0 10 11 8 pepsi bottle 0 10 12 9 coke can 15 12 12 13 10 coke bottle 0 12 14 11 pepsi can 12 15 12 pepsi bottle 15 12 10 16 17