Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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, 608 $1, 526 $1, 411 $1, 284 February 867 831 849 806 March 859 847 874 825 April 849 869 850 May 918 921 927 June 853 844 867 July 827 809 841 August 1, 664 1, 514 1, 504 September 1, 204 1, 137 1, 126 October 855 829 881 November 882 843 908 December 1, 396 1, 297 1, 399e. What is. the average monthly trend in bookstore sales? {Negative amounts should be indicated by a minus sign. Round your answer to 4 decimal placesJ fv'l. What are the monthly indexes? (Round your answers to 4 decimal places} f-2. When are book sales the highest? When are book sales the highestf-3. When are book sales the lowest? When are book sales the lowest 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 Decemberplaces.) d. Evaluate a seasonally adjusted trend forecasting model What Is the MAD? (Round your answers to 4 decimal X Answer is not complete. Month 5 Sales Number (Millions) Period Trend Index Forecast Absolute 1 1,608 Error 1 867 859 1,053.7561v 0.8204] 849 1,052.8580 918 1,051.9594 353 1,051.0617 827 1,050.1635 1,664 1,049.2653 1,204 1,048.3671] 855 10 1,047.4640 11 882 11 1,046.5708 12 1,396 12 1,045.6728 1,526 13 14 847 15 0.8204] 869 16 ON - 921 17 844 18 809 19 1,514 20 1,137 21 10 829 22 11 843 23 12 1,297 24 1,411 25 849 26 874 27 850 28 927 29 867 30 841 31 1,504 32 1,126 33 381 34 908 35 12 1,399 36 1,284 37 806 38 39 0.8204 MAD=
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started