Question

13.35 What is the relationship between the price of crude oil and the price you pay at the pump for gasoline? The file Oil & Gasoline contains the price ($)

for a barrel of crude oil(Cushing, Oklahoma, spot price) and a gallon of gasoline (U.S.average conventional spot price) for 287 weeks, ending June 26,2015. (Data extracted from eia..doe.gov Construct a scatter plot with the price of oil on the horizontal axis and the price of gasoline on the vertical axis. .Use the least-squares method to develop a simple linear regression equation to predict the price of a gallon of gasoline using the price of a barrel of crude oil as the independent variable. Interpret the meaning of the slope, b, in this problem. Plot the residuals versus the time period. Compute the Durbin-Watson statistic. At the 0.05 level of significance, is there evidence of positiveautocorrelation among the residuals? Based on the results of (d) through (f), is there reason to ques-tion the validity of the model? 1. What conclusions can you reach concerning the relationship between the price of a barrel of crude oil and the price of a gallon of gasoline?

Question image 1Question image 2Question image 3Question image 4Question image 5Question image 6Question image 7Question image 8Question image 9