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) $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 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 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.)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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.”)

 

e. What are the monthly indexes? (Round your answers to 3 decimal places.)

 

f. Forecast sales for January, February, March, and April of 2019. (Round your answers to 2 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.)
e. What are the monthly indexes? (Round your answers to 3 decimal places.)
f.
Month
1
2
3
4
5
6
7
8
9
10
11
12
Index
cast sales for January, February, March, and April of 2019. (Round your answers to 2 decimal places.)
Period 25 Sales
Period 26 Sales
Period 27 Sales
Period 28 Sales
Forecasted Sales
million
million
million
million
Transcribed Image Text:e. What are the monthly indexes? (Round your answers to 3 decimal places.) f. Month 1 2 3 4 5 6 7 8 9 10 11 12 Index cast sales for January, February, March, and April of 2019. (Round your answers to 2 decimal places.) Period 25 Sales Period 26 Sales Period 27 Sales Period 28 Sales Forecasted Sales million million million million
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman