The file Cereals.xls contains data on the cost, calories, fibre and sugar of cereals. Use Data...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Solution From the given data We have to run the Multiple linear regression model with cost as a dependent variable and CalariesFiber suger as a independent variable run these regression model using th... View the full answer
Related Book For
Basic Business Statistics
ISBN: 978-0321870025
13th edition
Authors: Mark L. Berenson, David M. Levine, Kathryn A. Szabat
Posted Date:
Students also viewed these mathematics questions
-
Justin Bieber stars in an ad which features a medication that treats acne (pimples), which type of ad are the marketers using to appeal to consumers? Select one: a. Social anxiety ad b. Humor ad c....
-
Trial Balance as of December 31, 2019 - Draft Dr. Account Description Debits Credits Cr. Cash 62,000 - Accounts receivable 10,000 - Short-term investments - Nestle Foods Inc. 30,000 - #2 - PP&E -...
-
a.-d. Repeat Problem 3, using REACTIM2 as the dependent variable and referring to the accompanying computer output. In problem 3 a. Observe the cross-tabulation of AGEGROUP and PPM_CO in the...
-
In Exercises find the given higher-order derivative. 2 "(x) = 2 / f(x) X
-
The quality control manager at a light bulb factory needs to estimate the mean life of a large shipment of light bulbs. The standard deviation is 100 hours. A random sample of 64 light bulbs...
-
Find the acute angle for each of the given trigonometric functions. Round off results according to Table 4.1. csc = 8.26 Data from Table 4.1 Angles and Accuracy of Trigonometric Functions...
-
The thrust developed to propel the jet ski shown in Video V9.18 and Fig. P5.71 is a result of water pumped through the vehicle and exiting as a high-speed water jet. For the conditions shown in the...
-
Allred Shipping Co. acquired land, buildings, and equipment at a lump-sum price of $920,000. An appraisal of the assets at the time of acquisition disclosed the following values. Land . . . . . . . ....
-
Use the information below and prepare the Multi-Step Income Statement for Hot Place on August 31. Sales $1,250,000 Interest Revenue 25 Sales Discounts 15,000 Sales Returns and Allowances 30,000 Cost...
-
Our client, Mathew Banks, was arrested last night by the Phoenix Police Department. The police found Mr. Banks' car pulled over on the side of the highway with him asleep or passed out inside. The...
-
Carrie needs to purchase Olive oil to make homemade salad dressings. She needs 1,300 kgs of Olive oil per day on average. The supplier charges a $80 delivery fee per order (which is independent of...
-
A time-series process of the form \(y_{t}=\alpha+y_{t-1}+v_{t}, v_{t} \sim N\left(0, \sigma^{2} ight)\) can be rearranged as \(y_{t}-y_{t-1}=\) \(\Delta y_{t}=\alpha+v_{t}\). This shows that...
-
In a study of casino size (square feet) and revenue, the value of r = 0.445 is obtained. Find the value of r2. What does that value tell us?
-
Consider the \(\operatorname{AR}(2)\) model \(y_{t}=\delta+\theta_{1} y_{t-1}+\theta_{2} y_{t-2}+v_{t}\). Suppose that \[1-\theta_{1} z-\theta_{2} z^{2}=\left(1-c_{1} z ight)\left(1-c_{2} z ight)\]...
-
A \(0.25-\mathrm{kg}\) cart is held at rest against a compressed spring as in Figure \(5.8 a\) and then released. The cart's speed after it separates from the spring is \(2.5 \mathrm{~m} /...
-
The two cubes in Figure P6.40 have different inertias. The cubes are connected to each other by a spring, and a hammer strikes them in the two ways, \((a)\) and \((b)\), shown in the figure. Assuming...
-
Simplify: ww15 Provide your answer below:
-
Determine the volume of the parallelepiped of Fig. 3.25 when (a) P = 4i 3j + 2k, Q = 2i 5j + k, and S = 7i + j k, (b) P = 5i j + 6k, Q = 2i + 3j + k, and S = 3i 2j + 4k. P
-
The following table, stored in Smartphone Sales, represents the annual percentage of smartphones sold in 2011, 2012, and 2013 (projected). a. What conclusions can you reach about the market for...
-
The file SUV contains the overall MPG of 2013 small SUVs: 22 23 21 22 25 26 22 22 21 19 22 22 26 23 24 21 22 Source: Data extracted from "Ratings," Consumer Reports, April 2013, pp. 34-35. a....
-
Medical wires are used in the manufacture of cardiovascular devices. A study was conducted to determine the effect of several factors on the ratio of the load on a test specimen (YS) to the ultimate...
-
Using the potential theory obtain the damping for a cycle of (i) plunge, (ii) pitch oscillations.
-
Consider a delta wing with sweep angle \(\Lambda\). Show that the expressions 8.11 and 8.12 give the same lift line slope for the delta wing. Eq 8.11 Eq 8.12 = CD CD+CL tan
-
Using the Polhamus theory obtain the drag polar for a delta wing with sweep angle \(75^{\circ}\).
Study smarter with the SolutionInn App