Table 1 is monthly sales with four months of no sales in 201

Table 1 is monthly sales with four months of no sales in 2014 due to tornado

Forecast the sales that would have occurred at our store had there been no tornado (in excel, seasonality with trend, each month is a \"season\" for this problem).

Year
Month 2010 2011 2012 2013 2014
Jan 2.019 2.346 3.142 3.579
Feb 2.107 2.799 3.184 3.614
Mar 2.478 2.912 3.973 4.426
April 3.040 3.204 3.754 4.148
May 3.448 3.226 4.471 4.303
June 3.345 3.975 4.407 5.008
July 4.251 5.141 4.665 5.493
Aug 3.555 3.885 4.611 5.393
Sept 3.274 3.817 3.526 4.010
Oct 2.528 2.694 3.149 4.217
Nov 2.752 2.635 2.624 3.283
Dec 2.642 2.744 2.715 2.802

Solution

Table 1 is monthly sales with four months of no sales in 2014 due to tornado Forecast the sales that would have occurred at our store had there been no tornado

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site