To Examine the Local Housing Market in a Particular Region

question 45

Essay

To examine the local housing market in a particular region, a sample of 120 homes sold during a year are collected. The data are given below:




Partition the data into training (50 percent), validation (30 percent), and test (20 percent) sets. Predict the sale price using multiple linear regression. Use Sale Price as the output variable and all the other variables as input variables. To generate a pool of models to consider, execute the following steps. In Step 2 of XLMiner's Multiple Linear Regression procedure, click the Best subset option. In the Best Subset dialog box, check the box next to Perform best subset selection, enter 6 in the box next to Maximum size of best subset:, enter 1 in the box next to Number of best subsets:, and check the box next to Exhaustive search.
a. From the generated set of multiple linear regression models, select one that you believe is a good fit. Express the model as a mathematical equation relating the output variable to the input variables.
b. For your model, what is the RMSE on the validation data and test data?
c. What is the average error on the validation data and test data? What does this suggest?

---

Definitions:

Edward Snowden

A former National Security Agency contractor who leaked thousands of classified documents to the press, revealing extensive global surveillance programs.

Department of Homeland Security

A federal agency established to secure the United States against threats, including terrorist attacks, natural disasters, and other emergencies.

Border Safety

Measures and policies implemented to protect a country's borders against illegal crossings, trafficking, and to ensure the security of its citizens.

Emergency Preparedness

The process of planning and implementing actions to prevent, respond to, and recover from natural disasters, accidents, or terrorist attacks.