First highlight all of the values in column B and drag them to column C. Lets start by pressing Display R-squared value on chart at the very bottom. D b 2 - 4ac -12 2 - 4 3 -15 144 180 324.
To perform a quadratic regression we first need to create a new variable.
With Solver open select the cell that contains the SUMSQ formula as the objective and the cells containing the values for a and b as the variable cells. - B SQRT B 2 - 4 A C 2 A. Click on cell A3. We need to solve 3x 2 - 12x 95 245.