The following data report total, monthly U.S. gasoline sales in millions of dollars from January 2017...

Transcribed Image Text:

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 2017 2017 2017 2017 2017 2017 2017 2017 Aug 2017 Sep 2017 Oct 2017 Nov 2017 Dec 2018 Jan 2018 2018 2018 2018 2018 Jan Feb Mar Apr May Jun Jul Feb Mar 2018 Apr 2018 May 2018 Jun 2018 Jul 2018 Aug 2018 Sep Oct Nov Dec Sales ($ millions) 35530 33872 38522 38873 40639 39909 39697 41117 41246 41617 40086 39946 39123 37277 42548 43009 47949 47446 47891 48733 45485 48242 43139 39526 d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period 1 2 MAD= Month- Year 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Month 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 RH6681957 10 11 12 Sales ($ Million) 35,530 33,872 38,522 38,873 40,639 39,909 39,697 41,117 41,246 41,617 40,086 39,946 39,123 37,277 42,548 43,009 47,949 47,446 47,891 48,733 45,485 48,242 43,139 39,526 Trend Index Forecast Absolute Error e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month Index 1 2 3 4 5 6 7 8 9 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 Sales million million million million 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 2017 2017 2017 2017 2017 2017 2017 2017 Aug 2017 Sep 2017 Oct 2017 Nov 2017 Dec 2018 Jan 2018 2018 2018 2018 2018 Jan Feb Mar Apr May Jun Jul Feb Mar 2018 Apr 2018 May 2018 Jun 2018 Jul 2018 Aug 2018 Sep Oct Nov Dec Sales ($ millions) 35530 33872 38522 38873 40639 39909 39697 41117 41246 41617 40086 39946 39123 37277 42548 43009 47949 47446 47891 48733 45485 48242 43139 39526 d. Evaluate a seasonally adjusted trend forecasting model. What is the MAD? (Round your answers to 3 decimal places.) Period 1 2 MAD= Month- Year 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Month 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 RH6681957 10 11 12 Sales ($ Million) 35,530 33,872 38,522 38,873 40,639 39,909 39,697 41,117 41,246 41,617 40,086 39,946 39,123 37,277 42,548 43,009 47,949 47,446 47,891 48,733 45,485 48,242 43,139 39,526 Trend Index Forecast Absolute Error e. What are the monthly indexes? (Round your answers to 3 decimal places.) Month Index 1 2 3 4 5 6 7 8 9 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 Sales million million million million

Answer rating: 100% (QA)

Solution ... View the full answer