forecasting method mathematics, Exercises of Mathematics

it shows excel on how to do additive calculation in forecasting method

Typology: Exercises

2019/2020

Uploaded on 06/15/2020

shrrutii-rajoo
shrrutii-rajoo 🇲🇾

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
alpha 0.05
beta 0.3
gamma 0.5
MSE 1229.547
Quarter t Y L b s Forecast error
1 1 40 40
2 2 41 41
3 3 38 38
4 4 45 41 0.75 45
1 5 43 41.75 0.75 28.375 81.75 -38.75
2 6 46 42.5 0.75 29.75 83.5 -37.5
3 7 40 43.25 0.75 25.625 81.25 -41.25
4 8 47 44 0.75 32.4 89 -42
1 9 44 44.75 0.75 19.6375 73.125 -29.125
2 10 47 45.5 0.75 21.275 75.25 -28.25
3 11 42 46.25 0.75 16.6625 71.875 -29.875
4 12 49 47 0.75 23.28 79.4 -30.4
1 13 67.3875 SUM
2 14 136.55
3 15 190.9875
4 16 281.12
pf2

Partial preview of the text

Download forecasting method mathematics and more Exercises Mathematics in PDF only on Docsity!

Quarter t Y L b s Forecast error

  • alpha 0.
  • beta 0.
  • gamma 0.
  • MSE 1229.
  • 4 4 45 41 0.75
  • 1 5 43 41.75 0.75 28.375 81.75 -38.
  • 2 6 46 42.5 0.75 29.75 83.5 -37.
  • 3 7 40 43.25 0.75 25.625 81.25 -41.
  • 4 8 47 44 0.75 32.4 89 -
  • 1 9 44 44.75 0.75 19.6375 73.125 -29.
  • 2 10 47 45.5 0.75 21.275 75.25 -28.
  • 3 11 42 46.25 0.75 16.6625 71.875 -29.
  • 4 12 49 47 0.75 23.28 79.4 -30.
  • 2 14 136. 1 13 67.3875 SUM
  • 3 15 190.
  • 4 16 281. - esq
    - 924.