Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following data (first four columns) report total, monthly gasoline sales in millions of dollars from January 2017 to December 2018. A a seasonally adjusted
The following data (first four columns) report total, monthly gasoline sales in millions of dollars from January 2017 to December 2018. A a seasonally adjusted trend forecasting model needs to be evaluated. The first step is already done for you: Trend is the predicted sales model based on the trend model. Based on the data below, what is the monthly seasonal index for January? Period Month-Year Month Sales Smillion Trend Jan-2017 34230 35609.677 2 Feb-2017 32572 36028.480 W N 3 Mar-2017 37222 36447.284 4 Apr-2017 37573 36866.087 5 May-2017 39339 37284.891 6 Jun-2017 6 38609 37703.694 7 Jul-2017 38397 38122.498 Aug-2017 39817 38541.301 9 Sep-2017 39946 38960.104 10 Oct-2017 10 40317 39378.908 11 Nov-2017 11 38786 39797.711 12 Dec-2017 12 38646 40216.515 13 Jan-2018 37823 40635.318 14 Feb-2018 35977 41054.122 15 Mar-2018 41248 41472.925 16 Apr-2018 41709 41891.729 17 May-2018 5 46649 42310.532 18 Jun-2018 6 46146 42729.336 19 Jul-2018 7 46591 43148.139 20 Aug-2018 8 47433 43566.943 21 Sep-2018 9 44185 43985.746 22 Oct-2018 10 46942 44404.550 23 Nov-2018 11 41839 44823.353 24 Dec-2018 12 38226 45242.1570.946 0.890 0.961 0.931
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