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

Thank you :)

Answer 1

Solution:-

Quadratic Regression analysis using Excel

Regression Equation:-

y = -0.0005x² + 2.4051x + 44.227

Here, X represent Period, and y represent Data

when x=13

y=-0.0005*13*13+2.4051*13+44.227

=75.4088

Hence,

The forecast for period 13 will be 75