Assignment 1 - Forcasting.docx - Assignment 1 Data...

This preview shows page 1 - 2 out of 2 pages.

Assignment 1: Data Forecasting Group Member Names: Forecasting Excel Deliverable Forecasting is a tool used to predict future values from historical values. It does not require sophisticated tools such as Analytics Solver. Using the provided Excel file (Edmonton_Population_History (template).xlsx), Create a 3-Year, 5-Year, and Exponential Smoothing forecast of Edmonton’s population. Use the following videos as a guide. Tip: Before beginning, copy the sheet twice and rename the three sheets to “3-Year MVA”, “5-Year MVA”, and “Exp Smoothing”. Watch the following videos and follow the step-by-step instructions on creating the following forecasting models: o Moving Averages video: Create a 3-Year Moving Average Model and a 5-Year Moving Average Model o Exponential Smoothing video:

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture