The following data report total, monthly U.S. book-store sales in millions of dollars from January 2016 to March 2019. (Go to https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for the total U.S. bookstore sales.) Year Month         2016      2017       2018         2019 January     $1,468    $1,386    $1,271      $1,144 February     727       691          709           666 March         719       707          734           685 April            709       729          710 May            778       781          787 June           713       704          727 July            687       669          701 August       1,524    1,374       1,364 September 1,064    997          986 October      715       689          741 November  742       703          768 December  1,256    1,157       1,259         g. Predict book sales for the next 9 months. (Round your answers to 4 decimal places.) Year    Month                Forecast Sales 2019    April     2019    May     2019    June     2019    July     2019    August     2019    September     2019    October     2019    November     2019    December

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. book-store sales in millions of dollars from January 2016 to March 2019. (Go to https://www.census.gov/retail/index.html#mrts, find “Monthly Retail Trade Report,” then select “Time Series/Trend Charts” to find the data for the total U.S. bookstore sales.)
Year
Month         2016      2017       2018         2019
January     $1,468    $1,386    $1,271      $1,144
February     727       691          709           666
March         719       707          734           685
April            709       729          710
May            778       781          787
June           713       704          727
July            687       669          701
August       1,524    1,374       1,364
September 1,064    997          986
October      715       689          741
November  742       703          768
December  1,256    1,157       1,259

 

 

 

 

g. Predict book sales for the next 9 months. (Round your answers to 4 decimal places.)
Year    Month                Forecast Sales
2019    April    
2019    May    
2019    June    
2019    July    
2019    August    
2019    September    
2019    October    
2019    November    
2019    December    

e. What is the average monthly trend in book-store sales? (Negative amounts should be indicated by a minus sign. Round your
answer to 4 decimal places.)
Average monthly trend in book-store sales
f-1. What are the monthly indexes? (Round your answers to 4 decimal places.)
Month
1
2
3
4
5
6
7
8
9
10
11
12
million dollars per month
Index
Transcribed Image Text:e. What is the average monthly trend in book-store sales? (Negative amounts should be indicated by a minus sign. Round your answer to 4 decimal places.) Average monthly trend in book-store sales f-1. What are the monthly indexes? (Round your answers to 4 decimal places.) Month 1 2 3 4 5 6 7 8 9 10 11 12 million dollars per month Index
d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 4 decimal places.)
$ Sales
(Millions)
Absolute
Error
Month Number
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
4
5
6
7
8
9
10
11
12
1
2
3
1,468
727
719
709
778
713
687
1,524
1,064
715
742
1,256
1,386
691
707
729
781
704
669
1,374
997
689
703
1,157
1,271
709
734
710
787
727
701
1,364
986
741
768
1,259
1,144
666
685
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
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Trend
Index
Forecast
MAD=-
Transcribed Image Text:d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 4 decimal places.) $ Sales (Millions) Absolute Error Month Number 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 1,468 727 719 709 778 713 687 1,524 1,064 715 742 1,256 1,386 691 707 729 781 704 669 1,374 997 689 703 1,157 1,271 709 734 710 787 727 701 1,364 986 741 768 1,259 1,144 666 685 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 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Trend Index Forecast MAD=-
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 21 images

Blurred answer
Similar questions
  • SEE MORE 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