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

×

×