Answered step by step
Verified Expert Solution
Question
1 Approved Answer
d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period Month-Year Month Sales Forecast Absolute
d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period Month-Year Month Sales Forecast Absolute ($ Million) Trend Index Error Jan-2017 1 35,430 Feb-2017 2 33,772 3 Mar-2017 3 38,422 A Apr-2017 4 38,773 5 May-2017 5 40,539 6 Jun-2017 6 39,809 Jul-2017 39,597 Aug-2017 8 41,017 9 Sep-2017 9 41,146 10 Oct-2017 10 41,517 11 Nov-2017 11 39,986 12 Dec-2017 12 39,846 13 Jan-2018 1 39,023 14 Feb-2018 2 37,177 15 Mar-2018 42,448 16 Apr-2018 A 42,909 17 May-2018 5 47,849 18 Jun-2018 6 47,346 19 Jul-2018 47,791 20 Aug-2018 8 48,633 21 Sep-2018 9 45.385 22 Oct-2018 10 48,142 23 Nov-2018 11 43,039 24 Dec-2018 12 39,426 MAD=e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month Index 1 A 10 11 12 f. Forecast sales for January, February, March, and April of 2019. (Round your answers to 2 decimal places.) Forecasted Slaes Period 25 Sales million Period 26 Sales million Period 27 Sales million Period 28 Sales millionThe 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,430 2017 Feb 33,772 2017 Mar 38,422 2017 Apr 38,773 2017 May 40,539 2017 Jun 39,809 2017 Jul 39,597 2017 Aug 41,017 2017 Sep 41,146 2017 Oct 41,517 2017 Nov 39,986 2017 Dec 39,846 2018 Jan 39,023 2018 Feb 37,177 2018 Mar 42,448 2018 Apr 42,909 2018 May 47,849 2018 Jun 47,346 2018 Jul 47,791 2018 Aug 48,633 2018 Sep 45,385 2018 Oct 48,142 2018 Nov 43,039 2018 Dec 39,426
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