What is the relationship between the price of crude oil and the price you pay at the
Question:
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 388 weeks, ending June 2, 2017.
Source: Data extracted from www.eia.gov.
a. Construct a scatter plot with the price of oil on the horizontal axis and the price of gasoline on the vertical axis.
b. 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.
c. Interpret the meaning of the slope, b1, in this problem.
d. Plot the residuals versus the time period.
e. Compute the Durbin-Watson statistic.
f. At the 0.05 level of significance, is there evidence of positive autocorrelation among the residuals?
g. Based on the results of (d) through (f), is there reason to question the validity of the model?
h. 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?
Step by Step Answer:
Basic Business Statistics Concepts And Applications
ISBN: 9780134684840
14th Edition
Authors: Mark L. Berenson, David M. Levine, Kathryn A. Szabat, David F. Stephan