sorry but what info did you need?

ASSIGNMENT 3: CONJOINT ANALYSIS FOR CEREALS You are a mid-level manager for a major cereal manufacturer. Top management has tasked you with designing a new brand of cereal. Not only do you have to come up with an optimal cereal product, but you also have to prove to your bosses why the product is a good design. Your past experience has told you to that four attributes drive cereal sales: the flavor of the cereal, the shape of the cereal, price and add-ins. From your experience, you further sub-divide these attributes into sublevels. There are three levels of the flavor: corn, chocolate and fruit. There are four basic shapes: puffs, hoops, crispies and flakes. There are three price points: $2.99, $3.99, and $4.99. And there are three types of add-ins: none, marshmallows and dried fruit. These attributes and levels of the attributes are represented in the table below: TABLE 1. Factorial Design FLAVORS SHAPES PRICES ADD-INS Puffs $2.99 None Chocolate Hoops $3.99 Marshmallows Fruit Crispies $4.99 Dried Fruits Flakes Com To assess the optimal product design, you decide to do a conjoint analysis. But before you do a conjoint, you have to do some prep work. PART 1. Conjoint Analysis: Prep Work QUESTION 1 (3 POINTS) How many possible combinations of cereal are represented in your factorial design? Show your work QUESTION 2 (3 POINTS) Based on the number of attributes and levels in Table 1, what is the minimum number of parameters (eg cards) each respondent in your conjoint analysis should evaluate? Show your work. 1 PART 2. Conjoint Analysis: the Regression You performed a conjoint analysis for cereals, and your results are organized in the spreadsheet named "Conjoint Analysis Data (Cereals)." The data represents 225 observations from 15 individuals. To access this file go to Blackboard>Mktg 370>Assignments>Assignment 4. Run a regression on the data (see Lecture 11 Slides for proper procedures). QUESTION 3 (5 POINTS) Using the spreadsheet, analyze the preference ratings from User 2. What can you say about User 2's taste in cereals based on User 2's preference ratings? QUESTION 4(5 POINTS) Using the output from the regression analysis, what are the partworths for each level of the attributes? Enter the partworth values in the table below. **PLEASE ATTACH REGRESSION OUTPUT FROM EXCEL FOR FULL CREDIT** FLAVORS SHAPES PRICES ADD-INS Cor: Puffs: $2.99 None: Chocolate: Hoops: $3.99: Marshmallows: Dried Fruits: Fruit: Crispies: $4.99 Flakes: QUESTION 5 (2 POINTS) Using the intercept and partworths from the output, write out the linear equation of the regression. QUESTION 6 (5 POINTS) Based on your analysis, what is the optimal product design (optimal combination of attribute levels)? What cereal brand in the real world does the optimal product design resemble? QUESTION 7 (2 POINTS) You decide to refine your conjoint analysis by adding three more cards, #16, #17, and #18. #16. Flavor: Corn, Shape: Hoops, Price: $2.99, Add-In: Dried Fruit #17. Flavor: Chocolate, Shape: Hoops, Price: $4.99, Add-In: None #18. Flavor: Fruit, Shape: Puffs, Price: $4.99, Add-In: Marshmallows How would you code the cards in Excel? Please use the provided table: Card Choco Com Marsh Fruit Putts Hoops Crispies Flakes 1994 None Dried Fruit 16 17 18 User Puffs Crispies Flakes 0 0 0 Hoops 1 0 0 0 1 Chocolate Fruit 1 0 1 0 1 0 1 0 1 0 0 1 Corn 1 2 3 4 5 6 7 8 0 0 0 0 $2.99 1 0 0 1 53.99 0 1 0 0 0 0 1 0 0 0 0 1 0 O 0 0 1 0 0 OOOOOOOO 0 1 O 0 1 0 0 0 O 1 1 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 T 1 0 0 0 1 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 9 0 0 9 10 11 12 13 14 15 1 2 3 4 5 0 0 1 0 1 0 Card 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 0 0 1 0 1 0 0 1 0 0 0 0 1 0 D 1 0 1 0 0 0 O 0 0 0 O 0 0 0 1 0 0 0 0 1 0 $4.99 Nane Marshmell Dried Fruit Preference 0 1 10 0 0 1 4 1 0 0 1 1 0 1 0 0 10 O 0 1 5 0 1 0 8 0 . 0 1 0 4 1 0 1 1 0 1 0 2 1 O 1 1 0 1 0 0 5 0 0 1 0 1 0 0 1 3 1 0 2 1 0 O 1 1 0 1 0 0 0 0 1 0 1 0 0 1 7 0 1 0 0 8 0 1 0 10 0 1 0 0 8 0 0 1 0 9 1 0 0 1 6 O 0 1 0 1 0 0 1 1 0 0 2 0 1 0 1 1 0 0 1 1 0 1 D 1 1 0 1 2 0 1 0 0 0 0 1 0 1 1 8 1 1 1 1 1 o 1 0 0 0 0 O 0 0 0 0 1 1 0 1 0 0 1 0 1 o 0 0 6 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 0 0 1 0 1 0 0 0 0 0 6 9 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 D 1 1 1 1 1 1 0 0 0 1 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 8 1 0 1 0 0 1 O 0 0 1 0 0 1 0 0 0 E E 0 1 1 1 1 0 0 0 1 0 0 0 1 0 0 0 t 0 0 0 0 3 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 0 1 0 0 1 0 1 0 1 OOO 0 0 0 0 OOO 0 0 0 0 0 OOOOO 0 0 0 1 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 1 0 1 0 0 0 1 0 1 1 0 1 1 0 2 4 6 10 0 0 0 0 0 0 1 1 0 0 0 3 3 3 3 3 3 3 3 3 3 4 4 1 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 1 0 0 0 0 1 0 1 0 1 1 0 0 1 0 0 0 0 0 0 0 1 1 O 0 0 0 D 0 0 OOOOOOOO 1 0 0 3 7 6 10 4 1 10 1 0 0 1 0 1 0 0 1 1 1 1 0 0 0 0 0 1 0 0 0 0 OOOO 1 0 1 OOOOO 0 4 1 1 0 0 0 0 4 0 0 0 0 0 0 0 1 1 O 0 1 1 0 0 0 0 0 O 0 0 a 0 0 0 1 0 0 0 1 1 1 1 1 1 0 0 0 1 1 0 0 1 0 0 1 0 0 1 0 6 10 4 1 10 5 1 0 1 0 0 1 O 0 1 0 1 0 O 1 0 0 1 0 1 0 0 0 0 0 0 0 0 0 1 0 O 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 1 1 1 0 2 0 0 1 1 0 0 0 0 1 0 1 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 0 1 O 0 D 1 0 0 0 0 1 1 2 1 0 1 0 1 0 1 O 0 1 0 0 0 5 0 0 0 O 0 0 0 0 1 1 0 1 1 0 1 0 0 0 1 0 1 0 0 1 O 1 0 0 1 0 0 0 O 1 0 0 1 0 1 1 0 0 0 - a 1 0 0 0 0 1 0 0 1 o 1 0 0 1 0 0 0 0 1 1 1 1 1 0 0 Q 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 6 1 D 1 0 0 1 0 0 0 0 0 O 0 0 0 0 0 O O 1 0 10 0 0 0 0 0 1 O 0 0 0 0 0 0 O O 0 1 0 0 0 1 1 0 0 0 0 1 0 0 0 o 1 1 0 0 1 0 1 0 1 0 0 1 1 O 0 0 0 1 0 0 0 0 1 0 0 1 O 0 0 0 1 0 1 0 0 1 1 1 1 1 0 0 1 15 1 2 3 4 5 6 > 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 6 9 6 9 O 1 0 1 0 0 0 0 0 1 0 O 0 0 3 1 1 0 O 1 O 0 0 0 1 0 0 1 0 1 0 0 1 0 0 O 0 1 0 0 D 0 O O 1 1 1 1 0 0 0 1 1 0 O 0 0 1 1 D 0 1 1 0 0 0 0 1 0 O 1 0 0 0 O 1 0 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 O 0 . 3 0 0 1 0 0 1 0 0 9 9 9 9 1 0 0 O 0 0 1 1 1 1 1 0 0 0 0 1 0 0 0 0 0 D 1 1 1 1 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 D 1 0 1 1 0 1 D 1 0 1 0 0 1 0 1 1 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 0 1 0 0 1 0 0 0 0 0 0 1 9 6 2 1 2 4 6 10 6 6 6 6 6 6 6 0 o 0 1 0 1 0 0 1 1 0 0 O 0 1 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 1 0 1 0 1 0 7 9 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 0 0 1 0 0 0 0 1 1 1 1 0 0 0 0 0 0 1 0 1 0 0 1 1 0 0 0 1 0 6 6 7 7 7 7 7 7 0 0 0 1 0 0 1 0 1 0 10 4 1 10 $ 8 1 1 1 1 1 1 0 0 0 0 1 1 O 0 0 0 0 1 0 0 0 0 0 0 OOOO 1 1 0 0 1 0 0 0 1 D A 0 0 U 0 1 0 0 0 0 1 0 7 2 7 7 0 1 0 0 0 1 0 0 0 0 0 1 0 1 0 0 0 0 1 1 0 0 OOO 0 0 1 0 2 0 1 0 1 0 0 1 0 11 12 13 14 15 1 2 3 4 5 0 1 0 0 1 0 0 D 1 1 1 1 1 0 0 1 0 1 D 0 1 0 0 0 O 0 O 1 8 8 8 8 8 8 8 0 0 0 1 0 O 0 0 1 1 0 0 1 0 0 0 0 0 1 0 1 0 0 1 0 0 0 0 1 0 1 2 1 5 9 1 0 10 1 0 0 1 0 1 0 0 0 0 1 O 0 1 1 0 0 1 D 1 O 0 0 1 0 9 0 0 0 0 1 1 0 0 0 0 0 9 1 0 1 0 1 9 8 8 0 0 0 0 1 9 9 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 0 D 0 O 0 1 0 0 0 0 O 8 B 8 8 B 1 0 1 0 0 0 0 1 0 1 0 2 1 0 1 0 1 0 g 1 0 1 1 0 0 1 0 1 0 1 0 0 1 0 1 0 0 0 0 0 0 0 1 31 1 1 1 0 O 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 O 0 a 1 0 1 0 0 0 0 1 0 0 0 1 0 0 0 1 2 0 0 0 B 0 0 1 0 O 0 0 1 0 0 1 0 1 1 0 1 0 0 1 6 1 0 1 0 0 0 0 1 0 0 9 9 0 0 0 1 1 1 1 1 1 0 0 0 1 0 0 0 0 1 0 O 0 0 0 5 6 O 0 0 0 0 0 0 D 0 O 9 9 0 0 1 1 0 1 0 0 0 1 0 0 0 0 1 1 0 0 1 2 6 6 0 0 1 0 1 0 1 0 0 1 1 0 1 0 1 0 0 1 O 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 9 9 10 0 1 0 0 1 0 0 O O 0 0 0 1 0 0 0 0 1 0 0 0 6 6 6 1 0 0 1 1 1 1 1 0 8 7 O 0 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 3 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 0 0 1 0 1 0 1 0 0 1 0 1 0 0 0 0 0 9 0 O 0 10 6 0 1 0 0 1 0 0 0 1 I 0 0 1 0 0 1 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 1 0 0 1 0 1 0 0 0 0 0 1 1 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 1 0 0 1 10 10 10 10 10 10 10 10 10 10 10 10 0 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 1 1 1 1 1 1 0 0 0 1 0 1 0 0 1 0 1 D 1 0 0 1 1 0 1 0 1 0 0 1 0 0 O 0 0 0 0 10 5 8 4 1 2 1 5 6 3 2 1 5 0 0 0 0 0 0 Q 1 0 1 0 0 1 0 1 0 0 0 1 0 1 0 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 1 0 1 0 0 1 0 1 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 1 0 0 999 0 0 1 0 1 0 0 1 1 1 0 0 0 0 0 0 1 0 D 0 9 0 0 D 0 1 0 0 1 0 I 0 1 O 11 11 11 0 0 0 0 0 0 0 1 1 OOO 1 0 O D 1 1 0 0 0 0 O O 0 0 FOO 0 1 0 0 1 0 1 0 Oo 0 1 1 0 0 1 0 0 1 1 1 0 0 0 0 0 0 7 1 1 1 2 8 8 0 0 D 0 0 0 0 1 D 1 0 0 1 0 0 1 0 0 1 1 1 1 1 0 0 0 1 1 0 0 1 0 1 0 1 0 0 1 0 0 0 0 1 0 0 0 1 1 0 O 0 0 O 1 0 0 1 0 0 0 0 0 1 0 0 0 0 6 9 0 0 0 0 0 0 0 0 1 0 1 0 0 1 0 1 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 0 0 1 0 O 0 0 1 0 0 0 0 0 1 0 0 1 1 1 1 1 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 0 1 0 1 1 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 0 0 1 O 1 0 0 2 1 2 4 6 10 8 8 7 0 1 0 0 0 1 1 1 1 1 O 1 0 1 D 0 0 0 1 0 0 1 0 1 0 D 0 0 1 0 0 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 1 0 0 0 0 0 0 9 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 O 0 0 0 1 0 0 1 0 0 0 1 1 0 o 1 0 0 1 0 1 O 0 0 0 o 0 1 1 1 0 1 0 0 0 0 9 11 11 11 11 11 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 15 15 15 0 1 0 1 0 1 0 0 4 1 10 5 8 4 1 2 1 0 0 O 0 0 1 1 1 1 1 0 0 0 1 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 0 1 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 O O 0 0 0 0 0 0 1 0 O 1 0 0 0 0 1 0 1 0 0 1 0 1 0 0 1 0 0 0 1 0 1 0 0 1 7 8 9 10 11 12 13 14 15 1 2 0 0 0 0 1 0 1 0 0 1 0 1 O 0 0 0 D 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 1 0 O 0 1 0 0 0 D 0 1 0 O 1 1 5 1 0 0 0 0 1 0 0 1 1 0 0 0 0 0 0 6 1 0 0 1 1 1 1 1 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 O 0 10 3 1 0 1 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 1 0 1 0 0 1 0 0 0 0 1 1 0 6 0 0 1 1 1 0 0 0 0 0 0 0 6 1 0 0 0 1 0 0 1 O 0 1 0 0 1 0 1 1 0 0 0 0 9 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 1 0 0 0 1 1 0 0 0 0 0 1 0 1 0 0 0 1 0 0 1 1 0 1 1 1 1 1 0 0 0 1 0 1 0 0 0 0 0 0 0 0 2 1 0 1 0 1 0 1 0 0 0 0 1 D 0 0 0 0 0 1 1 1 0 0 1 0 0 0 0 1 0 0 1 0 0 1 0 0 1 9 8 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 2. 3 4 5 1 0 1 0 0 0 0 1 0 13 13 13 13 0 0 1 0 1 0 1 0 1 1 0 0 0 0 9 0 0 1 1 1 1 0 0 0 0 0 0 0 1 0 O 0 0 1 0 7 1 0 0 1 0 1 0 1 1 1 1 1 0 0 0 0 1 0 OOOOOOOO 0 1 0 1 o 1 0 EL ET ET ET EL 8 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 O 0 0 1 1 0 10 4 1 10 5 8 4 1 2 1 5 6 3 2 1 5 9 7 0 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 0 0 1 0 0 0 O 0 0 0 0 0 0 1 D 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 0 1 0 1 0 1 1 1 1 1 0 0 0 0 0 1 0 0 1 0 1 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 1 O 1 0 0 1 O 0 0 0 1 0 0 0 1 O 1 1 1 1 1 0 0 0 0 0 0 0 0 1 0 O 0 0 0 O 0 0 0 0 1 0 1 1 0 0 0 OOO 10 O 0 0 1 0 0 0 0 1 0 1 1 1 1 1 0 0 0 0 0 1 0 0 1 0 1 0 1 0 0 1 0 0 1 OO 0 1 0 1 6 9 6 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 0 0 13 13 13 13 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 0 0 1 0 0 1 0 1 0 1 1 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 1 1 O 1 0 0 1 0 1 0 0 1 0 0 1 0 0 O 1 0 0 1 0 1 0 0 1 0 2 8 O 0 0 0 1 0 0 O 0 0 1 0 0 1 0 1 0 0 1 0 1 0 0 0 1 1 1 1 0 0 0 0 0 1 0 0 1 0 1 0 0 OOOOOOOOOOOOOOO 0 0 1 0 0 0 1 0 1 0 0 0 1 1 1 1 0 1 0 0 1 1 0 0 0 0 1 0 t 0 1 0 0 0 0 0 1 o 0 1 0 1 0 1 0 0 0 0 1 0 0 0 0 1 OOOO 1 2 4 6 10 0 0 0 0 0 OO-OOOHO 1 OOOOOOOO 0 1 0 0 OOOOO HOOOOO 1 OOOO 1 0 0 1 0 OOOO 1 1 1 1 1 0 0 0 0 0 1 0 1 9 1 0 ASSIGNMENT 3: CONJOINT ANALYSIS FOR CEREALS You are a mid-level manager for a major cereal manufacturer. Top management has tasked you with designing a new brand of cereal. Not only do you have to come up with an optimal cereal product, but you also have to prove to your bosses why the product is a good design. Your past experience has told you to that four attributes drive cereal sales: the flavor of the cereal, the shape of the cereal, price and add-ins. From your experience, you further sub-divide these attributes into sublevels. There are three levels of the flavor: corn, chocolate and fruit. There are four basic shapes: puffs, hoops, crispies and flakes. There are three price points: $2.99, $3.99, and $4.99. And there are three types of add-ins: none, marshmallows and dried fruit. These attributes and levels of the attributes are represented in the table below: TABLE 1. Factorial Design FLAVORS SHAPES PRICES ADD-INS Puffs $2.99 None Chocolate Hoops $3.99 Marshmallows Fruit Crispies $4.99 Dried Fruits Flakes Com To assess the optimal product design, you decide to do a conjoint analysis. But before you do a conjoint, you have to do some prep work. PART 1. Conjoint Analysis: Prep Work QUESTION 1 (3 POINTS) How many possible combinations of cereal are represented in your factorial design? Show your work QUESTION 2 (3 POINTS) Based on the number of attributes and levels in Table 1, what is the minimum number of parameters (eg cards) each respondent in your conjoint analysis should evaluate? Show your work. 1 PART 2. Conjoint Analysis: the Regression You performed a conjoint analysis for cereals, and your results are organized in the spreadsheet named "Conjoint Analysis Data (Cereals)." The data represents 225 observations from 15 individuals. To access this file go to Blackboard>Mktg 370>Assignments>Assignment 4. Run a regression on the data (see Lecture 11 Slides for proper procedures). QUESTION 3 (5 POINTS) Using the spreadsheet, analyze the preference ratings from User 2. What can you say about User 2's taste in cereals based on User 2's preference ratings? QUESTION 4(5 POINTS) Using the output from the regression analysis, what are the partworths for each level of the attributes? Enter the partworth values in the table below. **PLEASE ATTACH REGRESSION OUTPUT FROM EXCEL FOR FULL CREDIT** FLAVORS SHAPES PRICES ADD-INS Cor: Puffs: $2.99 None: Chocolate: Hoops: $3.99: Marshmallows: Dried Fruits: Fruit: Crispies: $4.99 Flakes: QUESTION 5 (2 POINTS) Using the intercept and partworths from the output, write out the linear equation of the regression. QUESTION 6 (5 POINTS) Based on your analysis, what is the optimal product design (optimal combination of attribute levels)? What cereal brand in the real world does the optimal product design resemble? QUESTION 7 (2 POINTS) You decide to refine your conjoint analysis by adding three more cards, #16, #17, and #18. #16. Flavor: Corn, Shape: Hoops, Price: $2.99, Add-In: Dried Fruit #17. Flavor: Chocolate, Shape: Hoops, Price: $4.99, Add-In: None #18. Flavor: Fruit, Shape: Puffs, Price: $4.99, Add-In: Marshmallows How would you code the cards in Excel? Please use the provided table: Card Choco Com Marsh Fruit Putts Hoops Crispies Flakes 1994 None Dried Fruit 16 17 18 User Puffs Crispies Flakes 0 0 0 Hoops 1 0 0 0 1 Chocolate Fruit 1 0 1 0 1 0 1 0 1 0 0 1 Corn 1 2 3 4 5 6 7 8 0 0 0 0 $2.99 1 0 0 1 53.99 0 1 0 0 0 0 1 0 0 0 0 1 0 O 0 0 1 0 0 OOOOOOOO 0 1 O 0 1 0 0 0 O 1 1 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 T 1 0 0 0 1 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 0 1 0 0 1 0 0 1 0 0 9 0 0 9 10 11 12 13 14 15 1 2 3 4 5 0 0 1 0 1 0 Card 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 0 0 1 0 1 0 0 1 0 0 0 0 1 0 D 1 0 1 0 0 0 O 0 0 0 O 0 0 0 1 0 0 0 0 1 0 $4.99 Nane Marshmell Dried Fruit Preference 0 1 10 0 0 1 4 1 0 0 1 1 0 1 0 0 10 O 0 1 5 0 1 0 8 0 . 0 1 0 4 1 0 1 1 0 1 0 2 1 O 1 1 0 1 0 0 5 0 0 1 0 1 0 0 1 3 1 0 2 1 0 O 1 1 0 1 0 0 0 0 1 0 1 0 0 1 7 0 1 0 0 8 0 1 0 10 0 1 0 0 8 0 0 1 0 9 1 0 0 1 6 O 0 1 0 1 0 0 1 1 0 0 2 0 1 0 1 1 0 0 1 1 0 1 D 1 1 0 1 2 0 1 0 0 0 0 1 0 1 1 8 1 1 1 1 1 o 1 0 0 0 0 O 0 0 0 0 1 1 0 1 0 0 1 0 1 o 0 0 6 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 0 0 1 0 1 0 0 0 0 0 6 9 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 D 1 1 1 1 1 1 0 0 0 1 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 8 1 0 1 0 0 1 O 0 0 1 0 0 1 0 0 0 E E 0 1 1 1 1 0 0 0 1 0 0 0 1 0 0 0 t 0 0 0 0 3 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 0 1 0 0 1 0 1 0 1 OOO 0 0 0 0 OOO 0 0 0 0 0 OOOOO 0 0 0 1 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 1 0 1 0 0 0 1 0 1 1 0 1 1 0 2 4 6 10 0 0 0 0 0 0 1 1 0 0 0 3 3 3 3 3 3 3 3 3 3 4 4 1 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 1 0 0 0 0 1 0 1 0 1 1 0 0 1 0 0 0 0 0 0 0 1 1 O 0 0 0 D 0 0 OOOOOOOO 1 0 0 3 7 6 10 4 1 10 1 0 0 1 0 1 0 0 1 1 1 1 0 0 0 0 0 1 0 0 0 0 OOOO 1 0 1 OOOOO 0 4 1 1 0 0 0 0 4 0 0 0 0 0 0 0 1 1 O 0 1 1 0 0 0 0 0 O 0 0 a 0 0 0 1 0 0 0 1 1 1 1 1 1 0 0 0 1 1 0 0 1 0 0 1 0 0 1 0 6 10 4 1 10 5 1 0 1 0 0 1 O 0 1 0 1 0 O 1 0 0 1 0 1 0 0 0 0 0 0 0 0 0 1 0 O 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 1 1 1 0 2 0 0 1 1 0 0 0 0 1 0 1 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 0 1 O 0 D 1 0 0 0 0 1 1 2 1 0 1 0 1 0 1 O 0 1 0 0 0 5 0 0 0 O 0 0 0 0 1 1 0 1 1 0 1 0 0 0 1 0 1 0 0 1 O 1 0 0 1 0 0 0 O 1 0 0 1 0 1 1 0 0 0 - a 1 0 0 0 0 1 0 0 1 o 1 0 0 1 0 0 0 0 1 1 1 1 1 0 0 Q 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 6 1 D 1 0 0 1 0 0 0 0 0 O 0 0 0 0 0 O O 1 0 10 0 0 0 0 0 1 O 0 0 0 0 0 0 O O 0 1 0 0 0 1 1 0 0 0 0 1 0 0 0 o 1 1 0 0 1 0 1 0 1 0 0 1 1 O 0 0 0 1 0 0 0 0 1 0 0 1 O 0 0 0 1 0 1 0 0 1 1 1 1 1 0 0 1 15 1 2 3 4 5 6 > 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 6 9 6 9 O 1 0 1 0 0 0 0 0 1 0 O 0 0 3 1 1 0 O 1 O 0 0 0 1 0 0 1 0 1 0 0 1 0 0 O 0 1 0 0 D 0 O O 1 1 1 1 0 0 0 1 1 0 O 0 0 1 1 D 0 1 1 0 0 0 0 1 0 O 1 0 0 0 O 1 0 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 O 0 . 3 0 0 1 0 0 1 0 0 9 9 9 9 1 0 0 O 0 0 1 1 1 1 1 0 0 0 0 1 0 0 0 0 0 D 1 1 1 1 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 D 1 0 1 1 0 1 D 1 0 1 0 0 1 0 1 1 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 0 1 0 0 1 0 0 0 0 0 0 1 9 6 2 1 2 4 6 10 6 6 6 6 6 6 6 0 o 0 1 0 1 0 0 1 1 0 0 O 0 1 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 1 0 1 0 1 0 7 9 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 0 0 1 0 0 0 0 1 1 1 1 0 0 0 0 0 0 1 0 1 0 0 1 1 0 0 0 1 0 6 6 7 7 7 7 7 7 0 0 0 1 0 0 1 0 1 0 10 4 1 10 $ 8 1 1 1 1 1 1 0 0 0 0 1 1 O 0 0 0 0 1 0 0 0 0 0 0 OOOO 1 1 0 0 1 0 0 0 1 D A 0 0 U 0 1 0 0 0 0 1 0 7 2 7 7 0 1 0 0 0 1 0 0 0 0 0 1 0 1 0 0 0 0 1 1 0 0 OOO 0 0 1 0 2 0 1 0 1 0 0 1 0 11 12 13 14 15 1 2 3 4 5 0 1 0 0 1 0 0 D 1 1 1 1 1 0 0 1 0 1 D 0 1 0 0 0 O 0 O 1 8 8 8 8 8 8 8 0 0 0 1 0 O 0 0 1 1 0 0 1 0 0 0 0 0 1 0 1 0 0 1 0 0 0 0 1 0 1 2 1 5 9 1 0 10 1 0 0 1 0 1 0 0 0 0 1 O 0 1 1 0 0 1 D 1 O 0 0 1 0 9 0 0 0 0 1 1 0 0 0 0 0 9 1 0 1 0 1 9 8 8 0 0 0 0 1 9 9 0 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 0 0 0 0 D 0 O 0 1 0 0 0 0 O 8 B 8 8 B 1 0 1 0 0 0 0 1 0 1 0 2 1 0 1 0 1 0 g 1 0 1 1 0 0 1 0 1 0 1 0 0 1 0 1 0 0 0 0 0 0 0 1 31 1 1 1 0 O 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 O 0 a 1 0 1 0 0 0 0 1 0 0 0 1 0 0 0 1 2 0 0 0 B 0 0 1 0 O 0 0 1 0 0 1 0 1 1 0 1 0 0 1 6 1 0 1 0 0 0 0 1 0 0 9 9 0 0 0 1 1 1 1 1 1 0 0 0 1 0 0 0 0 1 0 O 0 0 0 5 6 O 0 0 0 0 0 0 D 0 O 9 9 0 0 1 1 0 1 0 0 0 1 0 0 0 0 1 1 0 0 1 2 6 6 0 0 1 0 1 0 1 0 0 1 1 0 1 0 1 0 0 1 O 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 9 9 10 0 1 0 0 1 0 0 O O 0 0 0 1 0 0 0 0 1 0 0 0 6 6 6 1 0 0 1 1 1 1 1 0 8 7 O 0 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 3 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 0 0 1 0 1 0 1 0 0 1 0 1 0 0 0 0 0 9 0 O 0 10 6 0 1 0 0 1 0 0 0 1 I 0 0 1 0 0 1 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 0 1 0 0 1 0 1 0 0 0 0 0 1 1 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 1 0 0 1 10 10 10 10 10 10 10 10 10 10 10 10 0 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 1 1 1 1 1 1 0 0 0 1 0 1 0 0 1 0 1 D 1 0 0 1 1 0 1 0 1 0 0 1 0 0 O 0 0 0 0 10 5 8 4 1 2 1 5 6 3 2 1 5 0 0 0 0 0 0 Q 1 0 1 0 0 1 0 1 0 0 0 1 0 1 0 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 1 0 1 0 0 1 0 1 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 1 0 0 999 0 0 1 0 1 0 0 1 1 1 0 0 0 0 0 0 1 0 D 0 9 0 0 D 0 1 0 0 1 0 I 0 1 O 11 11 11 0 0 0 0 0 0 0 1 1 OOO 1 0 O D 1 1 0 0 0 0 O O 0 0 FOO 0 1 0 0 1 0 1 0 Oo 0 1 1 0 0 1 0 0 1 1 1 0 0 0 0 0 0 7 1 1 1 2 8 8 0 0 D 0 0 0 0 1 D 1 0 0 1 0 0 1 0 0 1 1 1 1 1 0 0 0 1 1 0 0 1 0 1 0 1 0 0 1 0 0 0 0 1 0 0 0 1 1 0 O 0 0 O 1 0 0 1 0 0 0 0 0 1 0 0 0 0 6 9 0 0 0 0 0 0 0 0 1 0 1 0 0 1 0 1 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 0 0 1 0 O 0 0 1 0 0 0 0 0 1 0 0 1 1 1 1 1 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 0 1 0 1 1 0 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 1 0 0 1 O 1 0 0 2 1 2 4 6 10 8 8 7 0 1 0 0 0 1 1 1 1 1 O 1 0 1 D 0 0 0 1 0 0 1 0 1 0 D 0 0 1 0 0 0 0 1 0 0 1 0 0 0 1 0 1 0 0 1 1 0 0 0 0 0 0 9 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 0 0 0 0 1 0 0 0 0 0 O 0 0 0 1 0 0 1 0 0 0 1 1 0 o 1 0 0 1 0 1 O 0 0 0 o 0 1 1 1 0 1 0 0 0 0 9 11 11 11 11 11 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 15 15 15 0 1 0 1 0 1 0 0 4 1 10 5 8 4 1 2 1 0 0 O 0 0 1 1 1 1 1 0 0 0 1 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 0 1 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 O O 0 0 0 0 0 0 1 0 O 1 0 0 0 0 1 0 1 0 0 1 0 1 0 0 1 0 0 0 1 0 1 0 0 1 7 8 9 10 11 12 13 14 15 1 2 0 0 0 0 1 0 1 0 0 1 0 1 O 0 0 0 D 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 1 0 O 0 1 0 0 0 D 0 1 0 O 1 1 5 1 0 0 0 0 1 0 0 1 1 0 0 0 0 0 0 6 1 0 0 1 1 1 1 1 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 O 0 10 3 1 0 1 0 0 0 0 0 0 0 0 1 1 1 1 1 0 0 1 0 0 1 0 1 0 1 0 0 1 0 0 0 0 1 1 0 6 0 0 1 1 1 0 0 0 0 0 0 0 6 1 0 0 0 1 0 0 1 O 0 1 0 0 1 0 1 1 0 0 0 0 9 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 1 0 0 0 1 1 0 0 0 0 0 1 0 1 0 0 0 1 0 0 1 1 0 1 1 1 1 1 0 0 0 1 0 1 0 0 0 0 0 0 0 0 2 1 0 1 0 1 0 1 0 0 0 0 1 D 0 0 0 0 0 1 1 1 0 0 1 0 0 0 0 1 0 0 1 0 0 1 0 0 1 9 8 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 2. 3 4 5 1 0 1 0 0 0 0 1 0 13 13 13 13 0 0 1 0 1 0 1 0 1 1 0 0 0 0 9 0 0 1 1 1 1 0 0 0 0 0 0 0 1 0 O 0 0 1 0 7 1 0 0 1 0 1 0 1 1 1 1 1 0 0 0 0 1 0 OOOOOOOO 0 1 0 1 o 1 0 EL ET ET ET EL 8 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 O 0 0 1 1 0 10 4 1 10 5 8 4 1 2 1 5 6 3 2 1 5 9 7 0 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 0 0 1 0 0 0 O 0 0 0 0 0 0 1 D 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 0 1 0 1 0 1 1 1 1 1 0 0 0 0 0 1 0 0 1 0 1 0 0 1 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 1 O 1 0 0 1 O 0 0 0 1 0 0 0 1 O 1 1 1 1 1 0 0 0 0 0 0 0 0 1 0 O 0 0 0 O 0 0 0 0 1 0 1 1 0 0 0 OOO 10 O 0 0 1 0 0 0 0 1 0 1 1 1 1 1 0 0 0 0 0 1 0 0 1 0 1 0 1 0 0 1 0 0 1 OO 0 1 0 1 6 9 6 0 0 0 1 0 0 1 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 0 0 13 13 13 13 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 0 0 1 0 0 1 0 1 0 1 1 1 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 1 1 O 1 0 0 1 0 1 0 0 1 0 0 1 0 0 O 1 0 0 1 0 1 0 0 1 0 2 8 O 0 0 0 1 0 0 O 0 0 1 0 0 1 0 1 0 0 1 0 1 0 0 0 1 1 1 1 0 0 0 0 0 1 0 0 1 0 1 0 0 OOOOOOOOOOOOOOO 0 0 1 0 0 0 1 0 1 0 0 0 1 1 1 1 0 1 0 0 1 1 0 0 0 0 1 0 t 0 1 0 0 0 0 0 1 o 0 1 0 1 0 1 0 0 0 0 1 0 0 0 0 1 OOOO 1 2 4 6 10 0 0 0 0 0 OO-OOOHO 1 OOOOOOOO 0 1 0 0 OOOOO HOOOOO 1 OOOO 1 0 0 1 0 OOOO 1 1 1 1 1 0 0 0 0 0 1 0 1 9 1 0