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! 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
Get step-by-step solutions from verified subject matter experts
