Question:

Individual Question #1 "Realtor’s Challenge"

Your Individual Question:

Estimate multiple linear regression model for selling price of residential properties using 4 explanatory variables in the "Data" worksheet. These variables include Age, Size, Bedrooms, and Bathrooms.

Steps:

 Make sure to read about multiple regression model and squared multiple correlation R Square in the assigned readings for this week module.

 Open "Data" worksheet and locate the response and four explanatory variables. Estimate multiple regression model for selling price using these four variables. Select all 4 independent variables at once when running Data Analysis/ Regression tool and use the constant term. Make sure to watch the instructional video to see a demonstration of how to estimate multiple regression in Excel.

 In the regression output, locate the regression coefficients. Are the regression slopes significant? Do you insignificant variables in your model? Test the hypothesis about slope significance using either t-statistic, or p-value, or confidence interval of the estimated coefficient.

 Locate R Square in the regression output (table "Summary Output"). How much variation in the selling price of residential properties does your model explain?

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document