The actual values for 12 periods (shown in order) are:
(1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 55 (7) 64 (8) 58 (9) 73 (10) 66 (11) 69 (12) 74
Using a 5 period simple moving average, the forecast for period 13 will be:
QUESTION 2
Using the 4 period weighted moving average, the forecast for period 13 will be:
QUESTION 3
With exponential smoothing, the forecast for period 13 will be:
QUESTION 4
With linear regression, the forecast for period 13 will be:
QUESTION 5
With quadratic regression, the forecast for period 13 will be:
QUESTION 6
Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4)...
The actual values for 12 periods (shown in order) are: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 In Excel, create forecasts for periods 6-13 using each of the following methods: -------- -5 period simple moving average; Using a 5 period simple moving average, the forecast for period 13 will be: 68 -4 period weighted moving average (0.63, 0.26, 0.08, 0.03); Using...
The actual values for 12 periods (shown in order) are: (1) 45 (2) 52 (3) 48 (4) 59 (5) 55 (6) 54 (7) 64 (8) 59 (9) 72 (10) 66 (11) 67 (12) 78 Using a 5 period simple moving average, the forecast for period 13 will be:
In Excel, create a forecast for periods 6-13 using the following method: Exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); With exponential smoothing, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 Thank you :)
In Excel, create a forecast for periods 6-13 using the following method: Quadratic regression with the equation based on all 12 periods. With quadratic regression, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 Thank you :)
In Excel, create a forecast for periods 6-13 using the following method: 5 period simple moving average. Using a 5 period simple moving average, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74
Exercise # 1-0M6322-week 4-Forecasting using Exponential Smoothing The first five periods of demand data are shown in the following table Let the smoothing coefficient, alpha, equal 0.2.Compute the exponentially smoothed forecasts for periods one through four Initialize the procedure with a forecast value for period one of 37 Period Aggregate Demand Forecast demand 38 42 40 36 42 37 Determine the Running Sum of Forecast Errors (RSFE), the Mean Absolute Deviation, MADt Land the Tracking Signal(TS) at the end of...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 16 12 18 14 a. Which of the following is a correct time series plot for this data? - Select your answer -plot #1plot #2plot #3Item 1 What type of pattern exists in the data? - Select your answer -VerticalHorizontalScatterItem 2 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week (to 2 decimals if necessary)....
Please help Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...
Period 2 3 4 5 6 3 Period Moving Average 4 Period Moving Average Observation Forecast Error Error A2 Abs Error Forecast Exponential Smoothing Error Error 2 Abs Error Forecast Error 86 Error A2 Abs Error 85 Assume FAI 80 81 86 89 95 88 91 92 88 96 MSE MSE MSE MAD MAD Alpha 02 8 9 10 11 12 13 MAD According to MSE, what is the best forecasting model to MAD, what is the best forecasting model
Homework: Homework #2 Score: 0 of 1 pt 4 of 15 (3 Problem 4.13 can see Heart Transplants 45.0 50.0 55.0 56.0 58.0 a) Using exponential smoothing with a of 0.60 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to ane decimal place) 56.6 Forecast 41.0 43.4 474 2 ound yo response to one decimal place For the forecast made us ng exponential smoothing with α-Ο 60 and the given...