Microsoft Office Tutorials and References
In Depth Information
Multi-Regression
FIGURE 14.3 Activating the Regression Component of the Data Analysis Add-In
FIGURE 14.4 The Data Analysis Regression Menu
Regression, the output will be displayed on a new sheet. The sheet First Regression is
displayed in Figure 14.5 with the results of our regression.
Let us focus on four areas of output, circled above in the results shown in
Figure 14.5.
1. Coefficients are displayed in cells B17:19. The Y-Intercept is
64.175 (rounded
to 3 decimals), Apartment Size coefficient is 0.4544 and the Bathrooms coeffi-
cient is 60.65. The equation estimating Price, using the above format
Y
¼
a
þ
b 1 X 1
þ
b 2 X 2
will be:
Price
¼
64
:
175
þ
0
:
4544
Apartment-Size
þ
60
:
65
Bathrooms
×
×
Search JabSto ::




Custom Search