Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017 to December 2018. (To find the data,
3 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.") 5 oints Year Month Sales ($ millions) 2017 Jan $34,930 2017 Feb 33,272 2017 Mar 37,922 2017 eBook Apr 38,273 2017 May 40,039 2017 Jun 39,309 2017 Jul 39,097 2017 Print Aug 40,517 2017 Sep 40,646 2017 Oct 41,017 2017 Nov 39,486 2017 Dec 39,346 References 2018 Jan 38,523 2018 Feb 36,677 2018 Mar 41,948 2018 Apr 42,409 2018 May 47,349 2018 Jun 46,846 2018 Jul 47,291 2018 Aug 48,133 2018 Sep 44,885 2018 Oct 47,642 2018 Nov 42,539 2018 Dec 38,926 Click here for the Excel Data File 2 d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period Month-Year Month Sales ($ Million) Trend Index Forecast Absolute Error mts 1 Jan-2017 1 34,930 2 Feb-2017 2 33,272 3 Mar-2017 3 37,922 eBook 4 Apr-2017 4 38,273 5 May-2017 5 40,039 6 Jun-2017 6 39,309 Print 7 Jul-2017 7 39,097 8 Aug-2017 8 40,517 9 eferences Sep-2017 9 40,646 10 Oct-2017 10 41,017 11 Nov-2017 11 39,486 12 Dec-2017 12 39,346 13 Jan-2018 1 38,523 14 Feb-2018 2 36,677 15 Mar-2018 3 41,948 16 Apr-2018 4 42,409 17 May-2018 5 47,349 18 Jun-2018 6 46,846 19 Jul-2018 7 47,291 20 Aug-2018 8 48,133 21 Sep-2018 9 44,885 22 Oct-2018 10 47,642 23 Nov-2018 11 42,539 24 Dec-2018 12 38,926 MAD= 3 e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month Index ts 1 2 3 eBook 4 5 6 Print 7 8 9 eferences 10 11 12 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
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