Answered step by step
Verified Expert Solution
Link Copied!

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!!

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Process To Profits Strategic Planning For A Growing Business

Authors: William Lasher

1st Edition

0324223870, 9780324223873

More Books

Students also viewed these Finance questions