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

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

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