Question: roblem#2: Code basic Excel and ForecastX with the new truck sales in anada to answer the following questions provided in the sheet called Problem#2 0

roblem\#2: Code basic Excel and ForecastX with the new truck sales in anada to answer the following questions provided in the sheet called Problem\#2 0 marks] A. First use a Double Exponential Smoothing-Holt method in Forecast X and forecast truck sales in Canada from September 2018 to March 2019. Write your answers inside the provided Excel file. For the rest of this problem assume the followings: B. Use dummy variables (binary) to incorporate monthly fluctuations of truck sales. C. Truck sales in Canada was under the influence of the Global Financial Crisis (GFC) over the range of November 2008 to March 2010 . D. Make sure a time trend is included in your forecast model. E. Use a Log-Linear model, and using Data Analysis tool in basic Excel under all of the above assumptions, forecast truck sales in Canada for the period of September 2018 to March 2019 F. Finally, code Forecast X to redo the same steps from B to E. compare and contrast your outputs with what you found in native excel. G. Answer all questions by filling out the provided tables inside the Excel sheet called Problem\# 2 . roblem\#2: Code basic Excel and ForecastX with the new truck sales in anada to answer the following questions provided in the sheet called Problem\#2 0 marks] A. First use a Double Exponential Smoothing-Holt method in Forecast X and forecast truck sales in Canada from September 2018 to March 2019. Write your answers inside the provided Excel file. For the rest of this problem assume the followings: B. Use dummy variables (binary) to incorporate monthly fluctuations of truck sales. C. Truck sales in Canada was under the influence of the Global Financial Crisis (GFC) over the range of November 2008 to March 2010 . D. Make sure a time trend is included in your forecast model. E. Use a Log-Linear model, and using Data Analysis tool in basic Excel under all of the above assumptions, forecast truck sales in Canada for the period of September 2018 to March 2019 F. Finally, code Forecast X to redo the same steps from B to E. compare and contrast your outputs with what you found in native excel. G. Answer all questions by filling out the provided tables inside the Excel sheet called Problem\# 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
