e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month 1 2 3 4 5 6 7 8 9 10 11 12 Index f. Forecast 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 Slaes million million million million

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.”)
Year   Month             Sales
                                 ($ millions)
2017   Jan                $35,630
2017   Feb                  33,972
2017   Mar                   38,622
2017   Apr                    38,973
2017   May                  40,739
2017   Jun                   40,009
2017   Jul                    39,797
2017   Aug                  41,217
2017   Sep                  41,346
2017   Oct                   41,717
2017   Nov                  40,186
2017   Dec                  40,046
2018   Jan                   39,223
2018   Feb                   37,377
2018   Mar                   42,648
2018   Apr                    43,109
2018   May                   48,049
2018   Jun                    47,546
2018   Jul                     47,991
2018   Aug                   48,833
2018   Sep                   45,585
2018   Oct                    48,342
2018    Nov                  43,239
2018    Dec                  39,626

e. What are the monthly indexes? (Round your answers to 3 decimal places.)
Month
1
2
3
4
5
6
7
8
9
10
11
12
Index
f. Forecast 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 Slaes
million
million
million
million
Transcribed Image Text:e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month 1 2 3 4 5 6 7 8 9 10 11 12 Index f. Forecast 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 Slaes million million million million
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)
35,630
33.972
38,622
38,973
40,739
40,009
39,797
41,217
41,346
41,717
40,186
40,046
39,223
37,377
42,648
43,109
48,049
47,546
47,991
48,833
45.585
48,342
43,239
39,626
Trend
Index
Forecast
MAD=
Absolute
Error
Transcribed Image Text: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) 35,630 33.972 38,622 38,973 40,739 40,009 39,797 41,217 41,346 41,717 40,186 40,046 39,223 37,377 42,648 43,109 48,049 47,546 47,991 48,833 45.585 48,342 43,239 39,626 Trend Index Forecast MAD= Absolute Error
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 10 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