B D D E F G H 1 j L . N O Fiber Fat Sugars 8.1 5.5 0 9.6 9.9 16.8 0 7.3 Calories 66 66 66 110 132 110 143 88 99 132 132 HINT: 9.5 16.9 10.3 5.1 5.5 14.7 1.1 9.9 7.7 12.8 4.8 143 132 YOU MAY NOT HAVE TO RUN THE REGRESSION TOOL TO ANSWER ANY QUESTIONS RELATED TO THIS WORKSHEET. 1 Cereal Data 2 3 Product Cereal Name 4 1 100% Bran 5 2 All-Bran 6 3 All-Bran w/Extra Fiber w 7 7 4 Almond Delight 8 5 Apple Cinn Cheerios 9 6 Apple Jacks 10 7 Basic 4 11 8 8 Bran Chex 12 9 Bran Flakes 13 10 Cap'n'Crunch 14 11 Cheerios 15 12 Cinnamon Toast Crunch 16 13 Clusters 17 14 Cocoa Puffs 18 15 Corn Chex 19 16 Corn Flakes 20 17 Corn Pops 21 18 Count Chocula 22 19 Cracklin' Oat Bran 23 20 Cream of Wheat 24 21 Crispix 25 22 Crispy Wheat & Raisins 26 23 Double Chex 27 24 Froot Loops 28 25 Frosted Flakes 29 26 Frosted Mini-Whests 30 27 Fruit & Fibre 31 28 Fruitful Bran 32 29 Fruity Pebbles 33 30 Golden Grahams 34 31 Grape Nuts Flakes 35 32 Grape-Nuts 36 33 Great Grains Pecan Manufacturer Nabisco Kellogg Kellogg Ralston Purina General Mills Kellogg General Mills Ralston Purina Post Quaker General Mills General Mills General Mills General Mills Ralston Purina Kellogg Kellogg General Mills Kellogg Nabisco Kellogg General Mills Ralston Purina Kellogg Kellogg Kellogg Post Kellogg Post General Mills Post Post Post 110 132 99 121 132 121 110 132 99 121 132 121 99 121 143 121 132 121 132 Carbs 3.7 9.5 7 17.2 13.35 10.3 18 16.5 14.3 15 16.9 16.1 14.3 11.4 24.2 24.9 12.5 15 12.8 23.1 23.1 10.3 18 13.9 15.4 17.2 15 13.6 14.3 18.3 14.7 18.7 14.3 3.7 11.7 12.8 9.2 1.5 3.3 12.5 7 14.3 10.6 9.2 12.5 14.7 14.7 8.4 4 4 4.8 2.9 1.65 0 2.2 3 4.1 1.4 0.8 0 3.6 1.4 0 1.1 2.5 0 0 3 2.5 0 2.2 0 0 2.5 1.9 4.1 4.1 0 0 4.7 3.3 1.9 5.94 7.26 5.28 9.9 14.52 13.2 14.3 7.04 7.92 15.84 13.2 11.44 15.84 9.9 10.56 9.9 13.31 15.84 10.89 12.1 15.84 8.91 13.31 13.2 10.89 9.9 12.1 17.16 12.1 13.2 9.68 15.84 14.52 Vitamins Sodium 0.00 111 0.23 254 0.00 186 0.00 252 0.00 198 0.00 105.5 0.00 231 0.00 252 0.51 263 0.00 210 0.00 351 0.00 263 0.00 122 0.23 230 0.24 308 0.00 351 0.67 67 0.16 230 0.21 186 0.99 56 0.00 242 1.48 122 0.00 177 0.00 169.5 0.00 188 0.00 32 0.00 144 0.00 296 0.00 116.5 0.00 308 0.32 122 0.00 187 0.41 82.5 132 0 110 121 121 110 154 9.9 13.31 14.52 11 2.5 0.25 1.1 3.6 1.4 3.6 110 10.6 13.6 12.5 6.6 8.4 3.3 5.1 11.7 14.3 5.1 8.4 0 4.7 230 210 243 187 155 286 197 230 133 274 241 155 188 352 Post Quaker General Mills Kellogg Kellogg General Mills Quaker General Mills Kellogg General Mills Kellogg General Mills Post Kellogg Quaker Quaker Quaker Kellogg Kellogg Ralston Purina Kellogg Nabisco Nabisco Nabisco Kellogg 17.2 15 14.45 16.9 20.2 21.3 11.4 15 16.9 18.3 14.7 16.65 13.9 23.8 12.5 11 13.6 13.6 18.3 27.1 24.2 0.8 0 1.65 6.6 15.4 12.1 12.1 14.52 19.36 14.52 14.52 15.4 11.88 8.91 5.94 11 121 132 176 121 132 154 132 99 66 44 99 121 110 132 132 13.9 4.8 1.1 0 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 0 Honey Comb Honey Graham Ohs Honey Nut Cheerios Just Right Crunchy Nugget Just Right Fruit &Nut Kix Life Lucky Charms Mueslix Crispy Blend Multi-Grain Cheerios Nut & Honey Crunch Oatmeal Raisin Crisp Post Nat. Raisin Bran Product 19 Puffed Rice Puffed Wheat Quaker Oat Squares Raisin Bran Raisin Squares Rice Chex Rice Krispies Shrdded Wht Spn Size Shredded Wheat Shredded Wheat n Bran Smacks Special K Strawberry Fruit Wheels Total Corn Flakes Total Raisin Bran Total Whole Grain Trix Wheat Chex Wheaties Wheaties Honey Gold 0 0 0 2.5 0.8 5.5 0.8 0.00 0.00 0.00 0.00 0.00 0.00 0.67 0.00 0.00 0.00 0.00 0.00 0.22 0.00 0.00 1.17 0.00 0.00 0.00 0.26 0.00 0.57 0.00 0.00 0.62 0.00 0.00 0.00 0.00 0.00 0.00 0.04 0.00 0.00 116.5 231 0 296 351 0 0 5.28 10.89 14.52 13.2 13.2 14.52 9.9 7.92 12.1 10.56 12.1 0 5.1 13.2 5.1 3.7 3.3 1.5 1.5 1.5 18 4.8 5.5 1.8 99 88 32 4.7 1.9 4.4 1.1 2.5 0 110 132 121 99 132 Kellogg 22 17.6 22.7 9.9 15.8 16.5 24.9 16.5 17.6 12.5 18.7 1.9 0 8.91 11.88 16.5 165 3 15.4 1.8 Nabisco General Mills General Mills General Mills General Mills Ralston Purina General Mills General Mills 45 221 16.5 220 209 220 122 253 220 220 9.9 14.7 110 110 99 121 121 4.7 1.4 1.9 1.9 3.3 8.8 8.91 9.68 9.68 20.5 4.8 19.8 7.3 0 (a) Though the calorie content of the cereal is definitely NOT dependent on the Cereal Name or Manufacturer columns, it is necessary to INCLUDE these columns in our Multiple Regression procedure so that the BEST model will have the names of the BEST cereals. True False (b) Using the Excel Data Analysis --> Regression tool, for the first time, on the data, we get the following result. Which variable is NOT a significant factor in the calculation of Calories, and should be eliminated first? Confidence Interval 95% Standardized Coefficient Standard Error t-Value p-Value Regression Table Lower Upper Constant 117.2238806 1.294880201 90.52874583 (d) After running the regression tool several times, you ended up with the best Regression Model: Calories = 22.50 + 1.38Carbs + 1.42Sugars + 5.17Fat Now, a Syracuse cereal company is manufacturing a new cereal. You want to compute the calories in the cereal, knowing that: Carbs=16, Sugars=11.7, Fiber= 2.5, Fat=13.31, Vitamins=0.67 and Sodium=67 Hmm, should I be using my first equation: Calories = 19.95 + 1.33Carbs + 1.42Sugars + 0.19Fiber + 5.13Fat + 0.49Vitamins + 0.02Sodium, which has all the variables mentioned? Use your best judgement and compute the calories in the cereal. Give your answer correct to ONE place of decimal. So, if your answer is 1.2345, you will type in 1.2 (e) The Regression Results Summary, for the best regression model, is shown here: Multiple Regression for Calories Multiple R R-Square Adjusted R-square Std. Err, of Estimate Rows Ignored Outliers Summary 0.8978 0.8061 0.7968 10.48446 0 0 What is the meaning of R-Square? R-Square is the amount of variability in the dependent variable, Calories, that can be explained by the variability in the independent variables, Carbs, Sugars and Fat R-Square is the amount of variability in the independent variable, Calories, that can be explained by the variability in the dependent variables, Carbs, Sugars and Fat. B D D E F G H 1 j L . N O Fiber Fat Sugars 8.1 5.5 0 9.6 9.9 16.8 0 7.3 Calories 66 66 66 110 132 110 143 88 99 132 132 HINT: 9.5 16.9 10.3 5.1 5.5 14.7 1.1 9.9 7.7 12.8 4.8 143 132 YOU MAY NOT HAVE TO RUN THE REGRESSION TOOL TO ANSWER ANY QUESTIONS RELATED TO THIS WORKSHEET. 1 Cereal Data 2 3 Product Cereal Name 4 1 100% Bran 5 2 All-Bran 6 3 All-Bran w/Extra Fiber w 7 7 4 Almond Delight 8 5 Apple Cinn Cheerios 9 6 Apple Jacks 10 7 Basic 4 11 8 8 Bran Chex 12 9 Bran Flakes 13 10 Cap'n'Crunch 14 11 Cheerios 15 12 Cinnamon Toast Crunch 16 13 Clusters 17 14 Cocoa Puffs 18 15 Corn Chex 19 16 Corn Flakes 20 17 Corn Pops 21 18 Count Chocula 22 19 Cracklin' Oat Bran 23 20 Cream of Wheat 24 21 Crispix 25 22 Crispy Wheat & Raisins 26 23 Double Chex 27 24 Froot Loops 28 25 Frosted Flakes 29 26 Frosted Mini-Whests 30 27 Fruit & Fibre 31 28 Fruitful Bran 32 29 Fruity Pebbles 33 30 Golden Grahams 34 31 Grape Nuts Flakes 35 32 Grape-Nuts 36 33 Great Grains Pecan Manufacturer Nabisco Kellogg Kellogg Ralston Purina General Mills Kellogg General Mills Ralston Purina Post Quaker General Mills General Mills General Mills General Mills Ralston Purina Kellogg Kellogg General Mills Kellogg Nabisco Kellogg General Mills Ralston Purina Kellogg Kellogg Kellogg Post Kellogg Post General Mills Post Post Post 110 132 99 121 132 121 110 132 99 121 132 121 99 121 143 121 132 121 132 Carbs 3.7 9.5 7 17.2 13.35 10.3 18 16.5 14.3 15 16.9 16.1 14.3 11.4 24.2 24.9 12.5 15 12.8 23.1 23.1 10.3 18 13.9 15.4 17.2 15 13.6 14.3 18.3 14.7 18.7 14.3 3.7 11.7 12.8 9.2 1.5 3.3 12.5 7 14.3 10.6 9.2 12.5 14.7 14.7 8.4 4 4 4.8 2.9 1.65 0 2.2 3 4.1 1.4 0.8 0 3.6 1.4 0 1.1 2.5 0 0 3 2.5 0 2.2 0 0 2.5 1.9 4.1 4.1 0 0 4.7 3.3 1.9 5.94 7.26 5.28 9.9 14.52 13.2 14.3 7.04 7.92 15.84 13.2 11.44 15.84 9.9 10.56 9.9 13.31 15.84 10.89 12.1 15.84 8.91 13.31 13.2 10.89 9.9 12.1 17.16 12.1 13.2 9.68 15.84 14.52 Vitamins Sodium 0.00 111 0.23 254 0.00 186 0.00 252 0.00 198 0.00 105.5 0.00 231 0.00 252 0.51 263 0.00 210 0.00 351 0.00 263 0.00 122 0.23 230 0.24 308 0.00 351 0.67 67 0.16 230 0.21 186 0.99 56 0.00 242 1.48 122 0.00 177 0.00 169.5 0.00 188 0.00 32 0.00 144 0.00 296 0.00 116.5 0.00 308 0.32 122 0.00 187 0.41 82.5 132 0 110 121 121 110 154 9.9 13.31 14.52 11 2.5 0.25 1.1 3.6 1.4 3.6 110 10.6 13.6 12.5 6.6 8.4 3.3 5.1 11.7 14.3 5.1 8.4 0 4.7 230 210 243 187 155 286 197 230 133 274 241 155 188 352 Post Quaker General Mills Kellogg Kellogg General Mills Quaker General Mills Kellogg General Mills Kellogg General Mills Post Kellogg Quaker Quaker Quaker Kellogg Kellogg Ralston Purina Kellogg Nabisco Nabisco Nabisco Kellogg 17.2 15 14.45 16.9 20.2 21.3 11.4 15 16.9 18.3 14.7 16.65 13.9 23.8 12.5 11 13.6 13.6 18.3 27.1 24.2 0.8 0 1.65 6.6 15.4 12.1 12.1 14.52 19.36 14.52 14.52 15.4 11.88 8.91 5.94 11 121 132 176 121 132 154 132 99 66 44 99 121 110 132 132 13.9 4.8 1.1 0 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 0 Honey Comb Honey Graham Ohs Honey Nut Cheerios Just Right Crunchy Nugget Just Right Fruit &Nut Kix Life Lucky Charms Mueslix Crispy Blend Multi-Grain Cheerios Nut & Honey Crunch Oatmeal Raisin Crisp Post Nat. Raisin Bran Product 19 Puffed Rice Puffed Wheat Quaker Oat Squares Raisin Bran Raisin Squares Rice Chex Rice Krispies Shrdded Wht Spn Size Shredded Wheat Shredded Wheat n Bran Smacks Special K Strawberry Fruit Wheels Total Corn Flakes Total Raisin Bran Total Whole Grain Trix Wheat Chex Wheaties Wheaties Honey Gold 0 0 0 2.5 0.8 5.5 0.8 0.00 0.00 0.00 0.00 0.00 0.00 0.67 0.00 0.00 0.00 0.00 0.00 0.22 0.00 0.00 1.17 0.00 0.00 0.00 0.26 0.00 0.57 0.00 0.00 0.62 0.00 0.00 0.00 0.00 0.00 0.00 0.04 0.00 0.00 116.5 231 0 296 351 0 0 5.28 10.89 14.52 13.2 13.2 14.52 9.9 7.92 12.1 10.56 12.1 0 5.1 13.2 5.1 3.7 3.3 1.5 1.5 1.5 18 4.8 5.5 1.8 99 88 32 4.7 1.9 4.4 1.1 2.5 0 110 132 121 99 132 Kellogg 22 17.6 22.7 9.9 15.8 16.5 24.9 16.5 17.6 12.5 18.7 1.9 0 8.91 11.88 16.5 165 3 15.4 1.8 Nabisco General Mills General Mills General Mills General Mills Ralston Purina General Mills General Mills 45 221 16.5 220 209 220 122 253 220 220 9.9 14.7 110 110 99 121 121 4.7 1.4 1.9 1.9 3.3 8.8 8.91 9.68 9.68 20.5 4.8 19.8 7.3 0 (a) Though the calorie content of the cereal is definitely NOT dependent on the Cereal Name or Manufacturer columns, it is necessary to INCLUDE these columns in our Multiple Regression procedure so that the BEST model will have the names of the BEST cereals. True False (b) Using the Excel Data Analysis --> Regression tool, for the first time, on the data, we get the following result. Which variable is NOT a significant factor in the calculation of Calories, and should be eliminated first? Confidence Interval 95% Standardized Coefficient Standard Error t-Value p-Value Regression Table Lower Upper Constant 117.2238806 1.294880201 90.52874583 (d) After running the regression tool several times, you ended up with the best Regression Model: Calories = 22.50 + 1.38Carbs + 1.42Sugars + 5.17Fat Now, a Syracuse cereal company is manufacturing a new cereal. You want to compute the calories in the cereal, knowing that: Carbs=16, Sugars=11.7, Fiber= 2.5, Fat=13.31, Vitamins=0.67 and Sodium=67 Hmm, should I be using my first equation: Calories = 19.95 + 1.33Carbs + 1.42Sugars + 0.19Fiber + 5.13Fat + 0.49Vitamins + 0.02Sodium, which has all the variables mentioned? Use your best judgement and compute the calories in the cereal. Give your answer correct to ONE place of decimal. So, if your answer is 1.2345, you will type in 1.2 (e) The Regression Results Summary, for the best regression model, is shown here: Multiple Regression for Calories Multiple R R-Square Adjusted R-square Std. Err, of Estimate Rows Ignored Outliers Summary 0.8978 0.8061 0.7968 10.48446 0 0 What is the meaning of R-Square? R-Square is the amount of variability in the dependent variable, Calories, that can be explained by the variability in the independent variables, Carbs, Sugars and Fat R-Square is the amount of variability in the independent variable, Calories, that can be explained by the variability in the dependent variables, Carbs, Sugars and Fat