Question

In: Statistics and Probability

The following table gives information on the amount of sugar (in grams) and the calorie count...

The following table gives information on the amount of sugar (in grams) and the calorie count in one serving of a sample of 13 varieties of Kellogg's cereal. Sugar (grams) 5 15 12 11 8 6 7 2 7 14 20 5 13 Calories 130 200 160 110 130 80 210 120 120 190 190 110 120 Find the predictive regression equation of the number of calories on the amount of sugar. Carry out all calculations exactly, and round the final answers to three decimal places.

Solutions

Expert Solution

Line of Regression Y on X i.e Y = bo + b1 X
X Y (Xi - Mean)^2 (Yi - Mean)^2 (Xi-Mean)*(Yi-Mean)
5 130 21.302 191.717 63.906
15 200 28.994 3153.249 302.366
12 160 5.686 260.945 38.52
11 110 1.917 1145.565 -46.863
8 130 2.61 191.717 22.367
6 80 13.071 4076.337 230.83
7 210 6.84 4376.325 -173.019
2 120 57.994 568.641 181.598
7 120 6.84 568.641 62.367
14 190 19.225 2130.173 202.366
20 190 107.84 2130.173 479.289
5 110 21.302 1145.565 156.214
13 120 11.456 568.641 -80.71

calculation procedure for regression
mean of X = ∑ X / n = 9.6154
mean of Y = ∑ Y / n = 143.8462
∑ (Xi - Mean)^2 = 305.077
∑ (Yi - Mean)^2 = 20507.69
∑ (Xi-Mean)*(Yi-Mean) = 1439.231
b1 = ∑ (Xi-Mean)*(Yi-Mean) / ∑ (Xi - Mean)^2
= 1439.231 / 305.077
= 4.718
bo = ∑ Y / n - b1 * ∑ X / n
bo = 143.8462 - 4.718*9.6154 = 98.485
value of regression equation is, Y = bo + b1 X
Y'=98.485+4.718* X          


Related Solutions

The following table gives information on the amount of sugar (in grams) and the calorie count...
The following table gives information on the amount of sugar (in grams) and the calorie count in one serving of a sample of 13 varieties of Kellogg’s cereal. Calories is the dependent variable. Calculate the r-sqr, correlation coefficient, and explain each value. Index 1 2 3 4 5 6 7 8 9 10 11 12 13 Sugar (grams) 4 15 12 11 8 6 7 2 7 14 20 3 13 Calories 120 200 140 110 120 80 190 100...
The following table gives information on the amount of sugar (in grams) and the calorie count...
The following table gives information on the amount of sugar (in grams) and the calorie count in one serving of a sample of 13 varieties of Kellogg’s cereal. Calories is the dependent variable. Calculate the r-sqr, correlation coefficient, and explain each value. Index 1 2 3 4 5 6 7 8 9 10 11 12 13 Sugar (grams) 4 15 12 11 8 6 7 2 7 14 20 3 13 Calories 120 200 140 110 120 80 190 100...
The following table gives information on the calorie count and grams of fat for the11types of...
The following table gives information on the calorie count and grams of fat for the11types of bagels produced by Panera Bread. Bagel Calories Fat (grams) Asiago Cheese 330 5.0 Blueberry 330 2.2 Chocolate Chip 370 5.8 Cinnamon Crunch 430 8.0 Cinnamon Swirl & Raisin 320 1.5 Everything 300 2.9 French Toast 350 5.6 Jalapeno & Cheddar 310 2.2 Plain 290 2.4 Sesame 310 1.7 Sweet Onion & Poppyseed 390 6.9 a. Find the least squares regression line with calories as...
Do questions E-G The following table gives information on the amount of sugar (in grams) and...
Do questions E-G The following table gives information on the amount of sugar (in grams) and the calorie count in one serving of a sample of 8 varieties of Kellogg’s cereal. Sugar (grams), ? 4 14 12 10 8 6 7 3 Calories, ? 110 140 130 110 120 100 120 190 a. Construct a scatter diagram for these data. Does the scatter diagram exhibit a linear relationship between the amount of sugar and the number of calories per serving?...
The data in the table to the right represent the calories and sugar​ (in grams) in...
The data in the table to the right represent the calories and sugar​ (in grams) in one serving of seven different types of breakfast cereals. a. Compute and interpret the coefficient of​ correlation, r. b. At the 0.05 level of​ significance, is there a significant linear relationship between calories and​ sugar? Product   Calories   Sugar Cereal 1   75               6 Cereal 2   105           1 Cereal 3   104          4 Cereal 4   114          5 Cereal 5   126          5 Cereal 6   189  ...
The following table gives mean daily calorie intake (all residents) and infant mortality rate (per 1000...
The following table gives mean daily calorie intake (all residents) and infant mortality rate (per 1000 births) for ten countries. Country                Mean Daily Calories           Infant Mortality Rate      Afghanistan                      1523                              154              Austria                         3495                                 6              Burundi                        1941                              114             Colombia                       2678                               24              Ethiopia                         1610                             107             Germany                        3443                                6               Liberia                          1640                             153          New Zealand                     3362                                 7              Turkey                          3429                               44                USA                           3671                                 7 a) Find the regression equation. b) Calculate the correlation coefficient, accurate to three decimal places   c) Test the significance of the correlation coefficient with a 0.05 level of significance. Include definition of hypotheses, test statistic, p-value or critical value, decision about Ho, and...
#1) The following table gives mean daily calorie intake (all residents) and infant mortality rate (per...
#1) The following table gives mean daily calorie intake (all residents) and infant mortality rate (per 1000 births) for ten countries. Country               Mean Daily Calories           Infant Mortality Rate          Afghanistan                     1523                               154              Austria                         3495                                  6              Burundi                        1941                               114             Colombia                        2678                                24              Ethiopia                         1610                              107             Germany                         3443                                 6               Liberia                          1640                              153          New Zealand                      3362                                  7             ...
5. In this video, Oliver gives a visual demonstration about the extreme amount of sugar in...
5. In this video, Oliver gives a visual demonstration about the extreme amount of sugar in chocolate milk. He also makes a very bold statement in saying, "Any judge in the whole world would look at the statics and the evidence and would find any government of old guilty of child abuse." Using the education you have received from this class regarding nutrition and the concept of child abuse, do you agree and What can you do to take a...
The table below gives the amount invested and betas for three stocks. Stock      Amount Invested...
The table below gives the amount invested and betas for three stocks. Stock      Amount Invested          Beta GM            K10, 000                      1.2 IBM           K10, 000                      1.0 WMT        K20, 000                      0.7 REQUIRED: Using the CAPM, if the expected return for the market is 6% and the risk-free rate is 1.5%, what is the expected return for each stock?    What is the beta for this portfolio based on the invested amounts? Using the CAPM, what...
The following table gives information about 500 people according to their smoking status and gender and...
The following table gives information about 500 people according to their smoking status and gender and opinion on a tax reform bill. It is of interest to know if the gender and smoking status are associated. Non-Smoker Regular Smoker Occasional total Male 138 83 64 285 Female 64 67 84 215 Total 202 150 148 500 a. Write the relevant null and alternative hypotheses b. If the calculated Chi-Square test statistic is 22.153, find the corresponding p-value c. Write your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT