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 338 weeks. ending June 2, 2017. a. Construct a scatter plot with the price of oil on the horizontal axis and price of gasoline on the vertical axis. b. Use the latest-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 slop, b 1 , 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?
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 338 weeks. ending June 2, 2017. a. Construct a scatter plot with the price of oil on the horizontal axis and price of gasoline on the vertical axis. b. Use the latest-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 slop, b 1 , 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?
Solution Summary: The author demonstrates how to construct a scatter plot using Minitab.
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 338 weeks. ending June 2, 2017.
a. Construct a scatter plot with the price of oil on the horizontal axis and price of gasoline on the vertical axis.
b. Use the latest-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 slop,
b
1
,
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?
Definition Definition Representation of the direction and degree of correlation in graphical form. The grouping of points that are plotted makes it a scatter diagram. A line can be drawn showing the relationship based on the direction of points and their distance from each other.
Alejandro is selling HDMI cables on eBay, and is trying to determine the best price to sell at. For the last 10
weeks, he has adjusted his price slightly each week and tracked the number of cables he sold. He plotted the
results, and drew a line he feels fits the data well.
Quantity Sold
200
150
100
50
3
3.25 3.5 3.75 4
Price ($)
cables
4.25 4.5 4.75
a) The line of best fit passes through the points (3.50, 180) and (4.75, 160). Find an equation for the line.
Use variables: p for price in dollars, and Q for quantity of cables sold.
b) Using this model, predict the number of cables Alejandro would sell at a price of $3.65, to the nearest
whole cable.
Part II: Joe and his Dream Porsche
Joe is 16 years old and has decided that he wants a brand-spankin' new Porsche Boxter
Convertible, but his mom says there's no way that he could ever afford it! So, Joe has
decided to show his mom that he will be able to purchase his dream car at the age of 35
if he plans his finances just right. He's asked you to help him plan.
A. How much will his car cost in 19 years?
The following table shows the approximate MSRP (manufacturers suggested retail price)
of a Porsche Boxter Convertible from 2004 to 2008. Create a scatter plot of the data and
determine the line of best fit, finding an appropriate slope and initial value assuming it
started in 2004..
Year
MSRP
2004
$57 510
2005
$59 130
2006
$60 750
2007
$61 965
2008
$63 600
B. Financing Joe's new Porsche
Joe knows that he will have to put 10% down on his car. To save up for this down
payment, he plans on investing a set amount monthly, starting now, into Teen's Choice
Financial's Interest Plus Savings…
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY