Question: Consider the data set in Table 9.9 and smooth the data using Browns exponential smoothing method with smoothing factors 0.1 and 0.9. Time point 1

Consider the data set in Table 9.9 and smooth the data using Brown’s exponential smoothing method with smoothing factors 0.1 and 0.9.

Time point 1 2 3 4 5 6 7 00 9 10 Table 9.9 Series value 5.38 5.36 5.38 5.65 5.59 5.43 5.53 5.43 5.4 5.35 Time

Time point 1 2 3 4 5 6 7 00 9 10 Table 9.9 Series value 5.38 5.36 5.38 5.65 5.59 5.43 5.53 5.43 5.4 5.35 Time point 11 12 13 14 15 16 17 18 19 20 Series value 5.3 5.51 5.49 5.38 5.57 5.91 5.91 5.86 5.62 5.49 Time point 21 22 23 24 25 26 27 28 29 30 Series value 5.49 5.38 5.46 5.43 5.35 5.28 5.54 5.38 5.35 5.45

Step by Step Solution

3.45 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Figure 938 presents the Excel solution Figure 939 illustrates the original data and exponential smoo... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Statistics Using Excel Questions!