Type ' = linest(' andthen drag down to hilite your column of Y-values- this should now look like ' = linest(B2:B12'. Have your Y values ina vertical column (column B), the Xvalues in the next column to the right (column C), the X^2values to the right of the X values (column D), etc.īelow this block of numbers select a block just as wideas that one and 2 to 4 rows high - so if you just have Yand X values (linear equation)the new highlighted block is 2 columns by 2 to 4 rows.

To use Excel to fit an equation by LinearLeast Squares Regression: Y = A + BX + CX^2+ DX^3 +.