Description
Complete the homework problems identified above in Excel. Put each problem on a separate worksheet (tab). Restate the homework problem at the top of each worksheet. Code all input cells in blue and all outputs in green. Build all formulas in the Excel worksheet so that all outputs are automatically calculated based on the input variables. Sample problems including correct formatting will be completed in the weekly (online) classroom session. To make the best use of the classroom session you should attempt all the homework problems prior to the classroom session so you can ask very specific questions to help you complete the homework. This homework will address the learning objectives of demonstrating the use of forecasting and regression models, and comparing moving averages, exponential smoothing, and trend time-series models.