Question

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 |

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

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 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 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 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, 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 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, 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 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 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
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...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 25 minutes ago

asked 31 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago