The predicted values are calculated
using the computed regression equation.
The equation is applied to the original independent variables for each
row in the range. For example, if row 4
is the first row with data, the regression coefficients are multiplied by the
respective data on row four and summed to form the predicted value with those
observations for the independent variables.
The residuals are computed as the difference between
the actual and predicted values.