| Grading Rubric for Week 5, Assignment 2: Individual Assignment – Regression (Real Estate data) |
| Criteria | Points Available | Points Earned |
| Include a brief description of your data set including dropped rows, dummy code key, etc. This is required and the project will not be graded if meta data is not provided |
| Appropriate correlation matrix | 2 |
| What is multicollinearity? Do you need to address it? If so, how? | 5 |
| Discuss which variables have the best correlation with price | 3 |
| Model 1 |
| Is the model significant? | 2 |
| How much of price is explained by the independent variables? | 5 |
| What is the model? | 3 |
| Are all of the independent variable significant? Discuss | 5 |
| What variables have the largest impact on home selling price? | 5 |
| How much does a bathroom add to the value of a home? | 5 |
| Model 2 |
| Discussion of changes made for Model #2 | 5 |
| Is the model significant? | 2 |
| How much of price is explained by the independent variables? | 5 |
| What is the model? | 3 |
| Are all of the independent variable significant? Discuss | 5 |
| What variables have the largest impact on home selling price? | 5 |
| How much does a bathroom add to the value of a home? | 5 |
| Assessment |
| Predict selling price of 2 test homes with model #1 and #2 | 5 |
| How accurate is your model? (predicted price - actual price)/actual price | 10 |
| Which model is better? Why? | 5 |
| Conclusions |
| If you had the time, money, expertise, etc. what would you have done differently and why? | 10 |
| Prepare your discussion and labeled summary tables in one document | 5 |
| One Excel file (with data, correlation and regression output) posted. The assignment will not be considered complete unless this file is posted. If I need to request the file, I will deduct late points | REQUIRED |
| TOTAL | 100 | 0 |
Kings23
W5_A2_Grading_Rubric.xlsx
