The file "Cereals.xls" contains data on the cost, calories, fibre and sugar of cereals. Use Data Analysis in Excel to run a multiple regression, using cost as the dependent variable. 1) What is coefficent on the sugar variable (4 dec. places)? 2) What is the Adjusted R-squared value (4 dec. places)? 3) What is the value of the intercept (4 dec. places)? 4) Predict the cost of a new cereal with 500 calories, 9g fibre, and 20g sugar (4 dec. pl). Product Cost (per ounce) Calories Fiber (grams) Sugar (grams) Kellogg's Sam's Choice Extra raisin (Wal-Mart) Kountry Fresh (Winn-Dixie) Post Premium 0.13 200 8 18 0.10 210 23 0.10 170 7 17 0.14 190 8 20 American Fare (kmart) America's Choice (A&P) Safeway Kroger 0.11 170 7 17 0.12 200 8. 18 0.15 200 8 18 0.11 200 8 18 General Mills Total 0.19 180 5 19 Post The Original Shredded Wheat 'N Bran 2 Post The Original Shredded Wheat, Spoon Size Kellogg's Raisin Squares Mini-Wheats Healthy Choice Toasted Brown Sugar Squares 5 Kountry Fresh Frosted Bite Size (Winn-Dixie) S Post Frosted Bite Size Kroger Frosted Bite Size B Kellogg's Frosted Mini-Wheats Safeway Frosted Bite Size America's Choice Frosted Bite Size (A&P) General Mills Multi-Bran Chex Kellogg's Raisin Bran Crunch General Mills Wheat Chex 0.17 200 8. 1 0.17 170 0.22 180 12 0.22 190 0.15 200 11 0.15 190 12 0.12 190 6. 11 0.15 200 6. 12 0.16 190 11 0.13 190 11 0.20 200 7 12 0.17 210 5 23 0.19 180 5 Kellogg's Complete Wheat Bran Flakes 0.20 90 Post Premium Bran Flakes 0.18 100 S Post Grape-Nuts Familia original Recipe Swiss Muesli Kellogg's All-Bran Original 9Kashi Seven Whole Grains and Sesame Kellogg's All-Bran Bran Oats 0.12 210 7 0.25 210 16 0.17 80 10 0.27 90 6. 0.22 80 13 8 Post 100% Bran 0.18 80 7 210 Post Fruit & Fibre Dates, Raisins, Walnuts Kellogg's All-Bran Extra Fiber 0.20 17 0.27 50 13 General Mills Fiber One Bran Cereal 0.22 60 13