Microsoft Office Tutorials and References
In Depth Information
Note that the calculated value 653.4118 is very close the original observed value
of 656. This original value is higher by about 2.88 ($2,880) of the forecasted/cal-
Excel calls the calculated value Predicted Price.
The differences are called Residuals.
If you recall we requested the Residuals on the Regression menu of Figure 14.7 to
calculate these Residuals. This resulted in the Predicted Price and the Residuals for all
the apartments on the list. See Figure 14.9 for a partial list.
The Residuals are the calculated difference of the actual price from the predicted
price computed by the model. It helps you understand how close your forecasts to the
actual values are.
Refer back to the Regression results in Figure 14.8. What the model reveals are
Every additional square foot adds approximately $467.80 to the value of the
Each additional bathroom adds approximately $66,961.80 to the price.
A city address adds $38,543.30 value to the asset.
Corner apartment is worth $20,643.90 more than a conventional one.
In addition, having a balcony adds $11,370.50 to the value.
FIGURE 14.9 Partial Lists of Predicted Price and Residuals