# Coco S. A. has requested that a local property company undertake an analysis of property prices. The

## Question:

Coco S. A. has requested that a local property company undertake an analysis of property prices. The initial data collection has been undertaken and independent variables identified: square feet, age, and local property tax. The Excel regression analysis has been performed with the results presented in Figures 8.56–8.60.

(a) State the least squares linear regression equation ŷ = b_{0} + b_{1}x_{1} + b_{2}x_{2}.

(b) Comment on model reliability (r and COD).

(c) Is the overall model significant (F test)?

(d) Are the independent variables significant (t-tests)?

(e) Check model assumptions (residual and normality checks).

Fantastic news! We've Found the answer you've been seeking!

## Step by Step Answer:

**Related Book For**