Question: need help with these in excel please When the price of gasoline at the pump increases, oil companies often claim that the increase is caused

need help with these in excel please

need help with these in excel please When the price of gasolineat the pump increases, oil companies often claim that the increase is

When the price of gasoline at the pump increases, oil companies often claim that the increase is caused by an increase in the price of crude oil. To examine this claim, we listed on the right the average price of a gallon of unleaded regular (U.S. average) and the domestic price of a barrel of crude oil for every month from 1999 to 2001. The source of this data is U.S. Department of Energy. All prices are in dollars. Do a regression analysis and send the Regression output to Cell H58. Year Month Gasoline Price Crude Price Let 1999 0.972 3.57 X = Price of a barrel of crude oil 1999 2 0.955 8.6 Y = Price of a gallon of unleaded regular gasoline 1999 3 0.991 10.76 1999 4 1.177 12.82 1999 1.178 13.92 1999 6 1.148 14.39 1999 1.189 16.12 1999 8 1.255 17.58 1999 1.28 20.03 1999 10 1.274 19.71 1999 1 1 1.264 21.35 1999 12 1.298 22.55 2000 1 L.301 23.53 2000 2 1.369 25.48 2000 w L.541 26.19 2000 1.506 23.2 2000 .498 25.58 2000 1.617 27.62 2000 1.593 26.81 2000 8 1.51 27.91 2000 9 .582 29.72 2000 10 1.559 29.65 2000 1 1 1.555 2000 12 1.489 24.4 2001 1 1.472 24.64 2001 IN 1.484 25.27 2001 w 1.447 22.98 2001 1.564 23.39 2001 .729 24.06 2001 6 1.64 23.43 2001 1.482 22.822001 7 1.482 22.82 2001 8 1.427 23.08 2001 9 1.531 22.37 2001 10 1.362 18.73 2001 11 1.263 16.4 2001 12 1.131 15.54 1. What is the the correlation coefficient between X and Y 2. What is the Slope b, of the regression line 3. . What is the Intercept bo of the regression line 4. Compute the gasoline price for a given crude price of $20.45. 5. Comment on the relationship between X and Y (is it strong? Weak?). Regression Output

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!