1. Using thestream of dataprovided and the same assumptions about handling the smoothed and trending portions of the early periods of the data stream, optimize the forecast by sequentially: 1) finding the alpha (to thenearest increment of 0.05) that produces the lowest Se, then 2) holding that alpha constant, and finding the beta (to the nearest 0.05) which provides the overall lowest Se. Remember, when changing alpha or beta using this model, you must change the entire column,not just one row at a time.
2. What were the final optimal alphas and betas?
3. What is the eventual lowest forecast error using this process?
4. How might you proceed to find a forecast with even lower error?
5. What is the point estimate for the next unknown period? What is the 95% confidence interval estimate?

forecast5410 O X A B C D E G H 1 1 b C d 2 2 alpha beta actual S forecast error squared error 3 3 0.5 0.5 500 4 4 0.5 0.5 512 5 5 0.5 0.5 533 =(D3+D4+D5)/3 =(D5-D3)/3 6 6 0.5 0.5 576 =(B6'D6)+((1-B6)"(E5+F5)) =(C6*(E6-E5))+((1-C6)"F5) =E6+F6 7 7 0.5 0.5 614 =(B7'D7)+((1-B7)"(E6+F6)) =(C7'(E7-E6))+((1-C7)"F6) =87+F7 8 8 0.5 0.5 656 =(B8'D8)+((1-B8)"(E7+F7)) =(C8*(E8-E7))+((1-C8)"F7) =E8+F8 =D9-G8 =H8*H8 9 9 0.5 0.5 642 =(B9*D9)+((1-B9)*(E8+F8)) =(C9*(E9-E8))+((1-C9)"F8) =E9+F9 =D10-G9 =H9*H9 10 100.5 0.5 1698 =(B10'D10)+((1-B10)"(E9+F9)) =(C10'(E10-E9))+((1-C10)'F9) =E10+F10 =D11-G10 =H10'H10 11 110.5 0.5 700 =(B11*D11)+((1-B11)*(E10+F10)) =(C11 (E11-E10))+((1-C11)"F10) =E11+F11 =D12-G11 =H11*H11 12 120.5 0.5 712 =(B12'D12)+((1-812)"(E11+F11)) =(C12 (E12-E11))+((1-C12)'F11) =E12+F12 13 =SUM(18:111) 14 =113/3 15 forecast error =SQRT(114) 16 17 95% confidence interval =G12-(1.96*115) to =G12+(1.96*115) 18 19 20 21 22 23 24 25 26 1 > > Sheet1 /Sheet2 /Sheet3 /3\f