Question

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

Homework Answers

Answer #1

Last four periods are 9,10,11 and 12 with data values 73,66,69 and 74 respectively

We know that weighted moving average formula for forecast is given as

where xi are given data values and Wi are their respective weights, i.e. Weights: (0.63, 0.26, 0.08, 0.03)

Required forecast for 13 period is 70.89 or 71 (rounded to nearest integer)

In Excel, apply sum product function to calculate the weighted moving average for 13 period forecast.

=SUMPRODUCT(M10:M13, N10:N13)..................where M10:M13 is data value and N10:N13 are respective weights

= 70.89

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
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 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)...
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...
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...
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...
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...
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...
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:...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.8. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97
Create a frequency distribution using age and male-yes. It's supposed to be a bar chart. Age...
Create a frequency distribution using age and male-yes. It's supposed to be a bar chart. Age 55 50 42 47 58 67 64 64 62 43 51 58 42 51 66 69 57 48 51 50 43 46 49 48 55 51 50 41 47 55 54 52 64 68 51 40 53 67 65 47 48 56 64 45 57 50 52 60 66 70 63 63 63 32 70 66 50 67 63 59 63 34 70 50...