Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show all Excel works and Excel formula for each question. Thanks a lot!! The data in the file Customers shows the number of customers
Please show all Excel works and Excel formula for each question. Thanks a lot!!
The data in the file "Customers" shows the number of customers for a growing business, every quarter from June 2012 to June 2019. (Copy the data in sheet3 of your Excel file) a. Use Holt's method to forecasts one quarter into the future, for the entire series. Find the forecast for Sep 2019. Use alpha=0.6 and beta =0.4. (4 marks). Calculate the forecast error from March-13 onwards, find RMSE (3marks) b. Try different values for alpha and beta (try 2-3 different values) and find an improved value for RMSE. Write the value of RMSE for each run in your file and compare them. You do not need to find the optimised value, but your final values for alpha and beta should produce a better RMSE. (First copy your work from "part a " into a new sheet and then work on it.) (2 marks) c. Draw a chart for "part a" showing the Customers data together with the Holt's method forecasts. Your charts must show all the forecasts, including Sep-2019. (2 marks) The data in the file "Customers" shows the number of customers for a growing business, every quarter from June 2012 to June 2019. (Copy the data in sheet3 of your Excel file) a. Use Holt's method to forecasts one quarter into the future, for the entire series. Find the forecast for Sep 2019. Use alpha=0.6 and beta =0.4. (4 marks). Calculate the forecast error from March-13 onwards, find RMSE (3marks) b. Try different values for alpha and beta (try 2-3 different values) and find an improved value for RMSE. Write the value of RMSE for each run in your file and compare them. You do not need to find the optimised value, but your final values for alpha and beta should produce a better RMSE. (First copy your work from "part a " into a new sheet and then work on it.) (2 marks) c. Draw a chart for "part a" showing the Customers data together with the Holt's method forecasts. Your charts must show all the forecasts, including Sep-2019. (2 marks)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started