Question

Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...

Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two decimal places.

The actual values for 12 periods (shown in order) are:

(1) 45  (2) 52 (3) 48 (4) 59  (5) 55  (6) 58  (7) 64  (8) 61  (9) 71  (10) 66  (11) 69  (12) 77

1. Using a 5 period simple moving average, the forecast for period 13 will be:

2. Using the 4 period weighted moving average, the forecast for period 13 will be:

3. With exponential smoothing, the forecast for period 13 will be:

4. With linear regression, the forecast for period 13 will be:

5.With quadratic regression, the forecast for period 13 will be:

6. Considering only the forecasts for period 6-12, what is the lowest MAD value for any of the methods?

Homework Answers

Answer #1

1)

Using a 5-period simple moving average,

The forecast for period 13 will be 68.8

2)

Using the 4-period weighted moving average,

Function =(F5*0.63+F4*0.26+F3*0.08+F2*0.03)

The forecast for period 13 will be:73.86

MAD=29.29

3)

With exponential smoothing

4)

With linear regression

5)

With quadratic regression:

6. Considering only the forecasts for period 6-12, MAD value for each method is

Moving average Length 5 =63.15

WMA =33.47

Exponential smoothing=102.42

Linear regression=8.86

Quadratic regression= 10.83

So the lowest MAD value for is for linear regression viz 8.86

PS: Don't forget to rate this answer.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. A. The...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. The actual values for 12 periods (shown in order) are: (1) 45  (2)...
Can you please answer number 6! Its the only one i need thanks!!! The actual values...
Can you please answer number 6! Its the only one i need thanks!!! 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:...
In Excel, create a forecast for periods 6-13 using the following method: Quadratic regression with the...
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
In Excel, create a forecast for periods 6-13 using the following method: 4 period weighted moving...
In Excel, create a forecast for periods 6-13 using the following method: 4 period weighted moving average. Weights: (0.63, 0.26, 0.08, 0.03) Using the 4 period weighted 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
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 16 11 18 13 (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 19 2 12 3 16 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   What is the forecast for week 7? (c) Use α = 0.2 to compute...
The CEO requested forecasts based on the given historical data.  Put your final answers in the table....
The CEO requested forecasts based on the given historical data.  Put your final answers in the table. Round answers to 3 decimals for each method. Show work for full credit. Period Actual Demand 3 Month Moving Average Moving Average Tracking Signal 3 Month Weighted Average Weighted Average Tracking Signal 1 62 X X X X 2 59 X X X X 3 48 X X X X 4 57 56.33 59.4 5 60 54.66 54.4 6 56 55 52.83 MAD X...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT