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)