LINEAR REGRESSION:

Now, as a further check, use LINEST to calculate the coefficients of the regression equation and compare them with those determined by the Trendline tool. As shown above, you will need to create columns of x2 and x3 values adjacent to the x-values for the LINEST calculation. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download