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 of 2021 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 of
2021 you made in (B) above to take the seasonal variations into account.
Transcribed Image Text: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 of 2021 you made in (B) above to take the seasonal variations into account.
Expert Solution
trending now

Trending now

This is a popular 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