Question
The excel File Cereal data provides a variety of nutritional information about 67 cereals and their shelf location in a supermarket. Using the correlation and
The excel File Cereal data provides a variety of nutritional information about 67 cereals and their shelf location in a supermarket. Using the correlation and regression analysis tools in Excel, answers the following questions.
QUESTIONS:
a) Construct and examine the correlation matrix. Using correlation analysis, explain whether multicollinearity a potential problem.
b) Suggest an appropriate set of independent variables that predict the level of calories by examining the correlation matrix above.
c) Find the best multiple regression model for predicting the level of calories. Keep in mind the principle of parsimony.How good is your model? Does it use the same variables you thought in part (b)
d) State the best model equation that predicting the Calories as a function of other variables as you reach in part (c)
e) Based from your regression model, list any three types of foods that a person need to avoid to keep his/her level of calories minimum.
Cereal Data Product Cereal Name Manufacturer Calories Sodium Fiber Carb Sugars 100% Bran Nabisco 70 130 10 5 6 2 All-Bran Kellogg 70 260 9 7 5 3 All-Bran w/Extra Fiber Kellogg 50 140 14 8 0 4 Almond Delight Ralston Purina 110 200 1 14 8 5 Apple Cinn Cheerios General Mills 110 180 1.50 10.50 10 1 00 6 Apple Jacks Kellogg 110 125 1 11 14 10 7 Basic 4 General Mills 130 210 2 18 8 11 8 |Bran Chex Ralston Purina 90 200 4 15 6 12 9 Bran Flakes Post 90 210 5 13 5 10 Cap'n'Crunch Quaker 120 220 0 12 12 14 11 Cheerios General Mills 110 290 2 17 15 12 Cinnamon Toast Crunch General Mills 120 210 0 13 9 16 13 Clusters General Mills 110 140 IN 13 17 14 Cocoa Puffs General Mills 110 180 0 12 13 18 15 Corn Chex Ralston Purina 110 280 0 22 19 16 Corn Flakes Kellogg 100 290 - 21 20 17 Corn Pops Kellogg 110 90 - 13 21 18 chocula General Mills 110 180 0 12 22 19 Cracklin' Oat Bran Kellogg 110 140 4 23 20 Cream of Wheat Nabisco 10 80 24 21 Crispix Kellogg 110 220 1 25 22 Crispy Wheat & Raisins General Mills 100 140 N - 26 23 Double Chex Ralston Purina 10 190 1 24 Froot Loops Kellogg 110 125 11 28 25 Frosted Flakes Kellogg 110 200 29 26 Frosted Mini-Whests Kellogg 100 0 30 27 Fruit & Fibre Post 120 160 28 Fruitful Bran Kellogg 120 240 29 ty Pebbles Post 110 135 0 30 Golden Grahams General Mills 110 280 15 34 31 Grape Nuts Flakes Post 100 140 15 35 32 Grape-Nuts Post 110 170 17 - O W W W O 36 33 Great Grains Pecan Post 120 75 13 34 Honey Comb Post 110 180 14 35 Honey Graham Ohs Quaker 120 220 12 36 Honey Nut Cheerios General Mills 110 250 1.50 11.50 37 Just Right Crunchy Nugget Kellogg 110 170 17 IN - 38 Just Right Fruit & Nut Kellogg 140 170 20 39 Kix General Mills 110 260 0 21 40 Life Quaker 100 150 2 12 41 Lucky Charms General Mills 10 180 0 12 42 Mueslix Crispy Blend Kellogg 160 150 17 43 Multi-Grain Cheerios General Mills 100 220 44 Nut & Honey Crunch Kellogg 120 190 0 45 Oatmeal Raisin Crisp General Mills 130 170 1.50 13.50 46 Post Nat. Raisin Bran Post 120 200 11 47 Product 19 Kellogg 100 320 20 48 Puffed Rice Quaker 50 0 13 49 Puffed Wheat Quaker 50 0 1 10 Quaker Oat Squares Quaker 100 135 14 Raisin Bran Kellogg 120 210 14 Raisin Squares Kellogg 90 0 15 Rice Chex Ralston Purina 110 240 WOONU I 54 DO W W N W J W UT W T O O O W N O N O O O W J DOWN Rice Krispies Kellogg 110 290 55 Shrdded Wht Spn Size Nabisco 90 0 56 Shredded Wheat Nabisco 80 0 57 Shredded Wheat n Bran Nabisco 90 0 4 58 Smacks Kellogg 110 70 1 59 Special K Kellogg 110 230 1 60 Strawberry Fruit Wheels Nabisco 90 15 61 Total Corn Flakes General Mills 110 200 0 62 Total Raisin Bran General Mills 140 190 63 Total Whole Grain General Mills 100 200 64 Trix General Mills 110 140 W W O W AC 65 Wheat Chex Ralston Purina 100 230 66 Wheaties General Mills 100 200 67 Wheaties Honey Gold General Mills 110 200Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started