The generic formula are x1 -b b 2 - 4ac 05 2a and x2 -b - b 2 - 4ac 05 2a. In this new column we want each cell to be the square of our respective predictor observation. Once with plus.
For this example we will use a quadratic equation of the form ax2bxc0.
- B SQRT B 2 - 4 A C 2 A This is the other possible solution. Once with plus. Solve Linear Equations in Excel with Matrix System. This produces the value 36.