Question

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 |

Answer #1

Enter the data in excel sheet, then select the entire data set including period and data column, click on insert

Under insert tab, click on scatter plot

In scatter plot, click on trendline, then polynomial with degree 2. This will give us the scatter plot with the required quadratic equation

Quadratic equation is

setting x = 13, we get

**So, forecast for period 13 is 75.41 (rounded to 2
decimals)**

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

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

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

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

Consider the below vector x, which you can copy and
paste directly into Matlab. The vector contains the final grades
for each student in a large linear algebra course.
x = [61 52 63 58 66 92 64 55 76 60 70 78 76 73 45 63
97 70 100 76 50 64 42 100 67 81 81 59 68 62 72 99 66 76 81 59 47 84
67 75 63 86 73 44 51 69 48 74 61...

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 3 minutes ago

asked 4 minutes ago

asked 9 minutes ago

asked 10 minutes ago

asked 14 minutes ago

asked 24 minutes ago

asked 24 minutes ago

asked 48 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago