The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 to December 2018. (To find the data, go to the site https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts.”)   d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.)

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter1: Expressions And Functions
Section1.5: Descriptive Modeling And Accuracy
Problem 15PPS
icon
Related questions
Question

The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 to December 2018. (To find the data, go to the site https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts.”)
 

d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.)

The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 to December 2018. (To find the
data, go to the site https://www.census.gov/retail/index.html#mrts, find "Monthly Retail Trade Report," then select "Time Series/Trend
Charts.")
Year
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
2018
Sales
Month ($ millions)
Jan
$34,230
Feb
32,572
Mar
37,222
Apr
37,573
May
39,339
Jun
38,609
Jul
38,397
39,817
39,946
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
40,317
38,786
38,646
37,823
35,977
41,248
41,709
46,649
46,146
46,591
47,433
44,185
46,942
41,839
38,226
Click here for the Excel Data File
d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.)
Transcribed Image Text:The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 to December 2018. (To find the data, go to the site https://www.census.gov/retail/index.html#mrts, find "Monthly Retail Trade Report," then select "Time Series/Trend Charts.") Year 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2017 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Sales Month ($ millions) Jan $34,230 Feb 32,572 Mar 37,222 Apr 37,573 May 39,339 Jun 38,609 Jul 38,397 39,817 39,946 Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 40,317 38,786 38,646 37,823 35,977 41,248 41,709 46,649 46,146 46,591 47,433 44,185 46,942 41,839 38,226 Click here for the Excel Data File d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.)
d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.)
Period
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Month-Year
Jan-2017
Feb-2017
Mar-2017
Apr-2017
May-2017
Jun-2017
Jul-2017
Aug-2017
Sep-2017
Oct-2017
Nov-2017
Dec-2017
Jan-2018
Feb-2018
Mar-2018
Apr-2018
May-2018
Jun-2018
Jul-2018
Aug-2018
Sep-2018
Oct-2018
Nov-2018
Dec-2018
Month
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
Sales
($ Million)
34,230
32,572
37,222
37,573
39,339
38,609
38,397
39,817
39,946
40,317
38,786
38,646
37,823
35,977
41,248
41,709
46,649
46,146
46,591
47,433
44,185
46,942
41,839
38,226
Trend
Index
0.960
0.900
1.020
1.020
1.060
1.020
1.007
1.030
1.030
1.020
0.970
0.960
0.930
0.880
0.990
1.100
1.080
1.080
1.090
1.004
1.060
0.930
0.840
Forecast
MAD=
Absolute
Error
Transcribed Image Text:d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Month-Year Jan-2017 Feb-2017 Mar-2017 Apr-2017 May-2017 Jun-2017 Jul-2017 Aug-2017 Sep-2017 Oct-2017 Nov-2017 Dec-2017 Jan-2018 Feb-2018 Mar-2018 Apr-2018 May-2018 Jun-2018 Jul-2018 Aug-2018 Sep-2018 Oct-2018 Nov-2018 Dec-2018 Month 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 Sales ($ Million) 34,230 32,572 37,222 37,573 39,339 38,609 38,397 39,817 39,946 40,317 38,786 38,646 37,823 35,977 41,248 41,709 46,649 46,146 46,591 47,433 44,185 46,942 41,839 38,226 Trend Index 0.960 0.900 1.020 1.020 1.060 1.020 1.007 1.030 1.030 1.020 0.970 0.960 0.930 0.880 0.990 1.100 1.080 1.080 1.090 1.004 1.060 0.930 0.840 Forecast MAD= Absolute Error
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell