You have the following data: Gasoline Sales during 2017.1 to 2020.4 (in 000 of barrels) Year and quarter Gasoline Sales Year and quarter Gasoline sales 2017.1 22434 2019.1 22776 2017.2 23766 2019.2 24491 2017.3 23860 2019.3 24751 2017.4 23391 2019.4 24170         2018.1 22662 2020.1 23302 2018.2 24032 2020.2 24045 2018.3 24171 2020.3 25437 2018.4 23803 2020.4 25272 (A)Using data on gasoline sales (in thousands of barrels) from the first quarter of 2017 to the last quarter of 2020, estimate the secular linear trend equation. (B) Accordingly, forecast gasoline sales for the four quarters of 2021. (C)Use the dummy variables methods to adjust the trend forecasts for the four quarters of2021 you made in (B) above to take the seasonal variations into account.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 2CYU
icon
Related questions
icon
Concept explainers
Topic Video
Question

You have the following data:

Gasoline Sales during 2017.1 to 2020.4 (in 000 of barrels)

Year and quarter

Gasoline Sales

Year and quarter

Gasoline sales

2017.1

22434

2019.1

22776

2017.2

23766

2019.2

24491

2017.3

23860

2019.3

24751

2017.4

23391

2019.4

24170

       

2018.1

22662

2020.1

23302

2018.2

24032

2020.2

24045

2018.3

24171

2020.3

25437

2018.4

23803

2020.4

25272

(A)Using data on gasoline sales (in thousands of barrels) from the first quarter of 2017 to the last quarter of 2020, estimate the secular linear trend equation.

(B) Accordingly, forecast gasoline sales for the four quarters of 2021.

(C)Use the dummy variables methods to adjust the trend forecasts for the four quarters of2021 you made in (B) above to take the seasonal variations into account.

Expert Solution
steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
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.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning