Question: NOTE: You should use MS EXCEL. Upload also your EXCEL file! The number of visitors (children) visiting the Theme Park since its opening are recorded

 NOTE: You should use MS EXCEL. Upload also your EXCEL file!

NOTE: You should use MS EXCEL. Upload also your EXCEL file! The number of visitors (children) visiting the Theme Park since its opening are recorded as follows: a. Compute the values of the intercept a and the slope b from the regression equation Write down the regression equation b. Use the numbers that you have found in part a as the initial values of slope and intercept required in Holt's (Double Exponential Smoothing) method. Assume =0.15 and =0.10 for all calculations. c. Suppose that the actual number of children visiting the park in July was 25500 and the number in August was 26600. Use Holt's method to update the estimates of the slope and intercept based on these observations. d. What are the one-step-ahead and two-step-ahead forecasts that Holt's method gives for the number of visitors in September and October? e. What is the forecast made at the end of July for the number of visitors in December

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 General Management Questions!