Posted: September 6th, 2022
This portion is a written assignment. It is being used to assess PC-2.1: Achieve goals through planning and prioritization.
Use Microsoft Word to complete this assignment. When you are ready to submit your completed assignment, select the “Assignments” link on the navigation bar at the top of your screen. Next, select “Assessment Dropbox” for the appropriate assignment. Then select the “Add a file” button at the bottom of the screen to submit your file(s).
A time series model is a forecasting technique that attempts to predict the future values of a variable by using only historical data on that variable. There are many variables you can use, as long as you have values that are recorded at successive intervals of time. Here are some examples of variables you can use to forecast.
● Currency price: XE (http://www.xe.com/currencyconverter/)
● GNP: Trading Economics (http://www.tradingeconomics.com/united-states/gross-national-product)
● Average home sales: National Association of Realtors (http://www.realtor.org/topics/existing-home-sales)
● College tuition: National Center for Education Statistics (https://nces.ed.gov/fastfacts/display.asp?id=76)
● Weather temperature or precipitation: (http://www.weather.gov/help-past-weather)
● Stock price: Yahoo Finance (https://finance.yahoo.com)
1. Select a dataset with a variable you would like to forecast. You may use a different source other than the ones listed above (be sure to reference the website).
2. State the variable you are forecasting.
3. Select at least eight consecutive data values.
4. Using the Time Series Forecasting Templates, determine the following for the selected variable:
○ moving average,
○ weighted moving average, and
○ exponential smoothing (see the video in the Module 5 LiveBinder for additional information).
5. Copy/paste the results of each method into your post. Be sure to state:
○ the number of periods used in the moving average method.
○ the weights used in the weighted moving average.
○ the value of α used in exponential smoothing.
6. Clearly indicate the “next period” prediction for each method.
7. Choose one of the following:
○ Write a sentence that identifies the prediction.
○ Circle, draw, etc. on the chart to indicate which value is the prediction for the next time period.
8. Suppose that the forecasting results are from three different branches of a company.
○ Based on the MAD (mean absolute deviation) value, how would you prioritize the need to update the forecasting methods to improve overall predictions? Note: The higher the MAD value the worse the forecast.
○ Indicate a rank of 1, 2, or 3 for each forecast with a 1 being the highest priority.
○ Provide a brief recommendation to the company concerning the order in which the forecasts should be completed including why they are ranked in that order.
See guidance. to forecast time series data using a moving average, a weighted moving average, and exponential smoothing. You can also view a Competency Assessment starter video to assist you with the Module 5 Discussion Board in the Module 5 LiveBinder.
Place an order in 3 easy steps. Takes less than 5 mins.