April 19 decimal place July forecast July forecast decimal p

April 19 decimal place.) July forecast July forecast decimal place

Solution

Demand T January 15 1 February 15 2 March 19 3 April 16 4 May 20 5 June 19 6 Weights a April 0.1 May 0.3 June 0.6 July forecast 19 b Simple three month moving average July forecast 18.33 c Simple exponential smoothing Alpha 0.3 June forecast 11 July forecast 13.4 d SUMMARY OUTPUT Regression Statistics Multiple R 0.7598971 R Square 0.57744361 Adjusted R Square 0.47180451 Standard Error 1.63590662 Observations 6 ANOVA df SS MS F Significance F Regression 1 14.62857 14.62857 5.466192 0.079553 Residual 4 10.70476 2.67619 Total 5 25.33333 Coefficients Standard Error t Stat P-value Lower 95% Intercept 14.1333333 1.522946 9.280258 0.00075 9.904957 T 0.91428571 0.391056 2.337989 0.079553 -0.17146 Regression equation Y = 14.133 + 0.9143*X e Using Regression July forecast 20.53 Using X as 7 for july