In this example we will show how to use all the formulae listed in this chapter and

Question:

In this example we will show how to use all the formulae listed in this chapter and we will demonstrate how to use the Data Analysis > Exponential Smoothing to undertake the analysis. Figures 9.40 and 9.41 illustrate the Excel solution with a smoothing constant of α = 0.1 using equations (9.18), (9.19), (9.20), and (9.21), and the Excel Data Analysis > Exponential Smoothing solution.

1 Example 9.21-Excel Data Analysis solution B 6 14 15 16 17 16 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33


Equations

F = F-1 + a(y-1 - F-1) (9.18)

Fayt-1+(1-a)_1 (9.19)

Say + (1-a) St-1 (9.20)= 2 M + 1 (9.21)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: