Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Differential Equations For Engineers

Authors: Wei Chau Xie

1st Edition

0511771037, 9780511771033

More Books

Students also viewed these Mathematics questions

Question

Describe recruitment and selection for international operations.

Answered: 1 week ago