MGSC-5113-15 Quantitative Methods Assessment
- Subject Code :
MGSC-5113-15
- Country :
Canada
Assignment-1
The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in Cape Breton neighborhood in the past 36 months.
SELLING PRICE ($) |
SQUARE FOOTAGE |
BEDROOMS |
AGE (YEARS) |
82,038 |
1,631 |
2 |
19 |
74,221 |
1,258 |
3 |
7 |
86,316 |
1,615 |
3 |
10 |
115,239 |
1,767 |
3 |
1 |
122,123 |
2,203 |
3 |
3 |
128,645 |
2,169 |
3 |
3 |
141,486 |
2,255 |
3 |
1 |
156,135 |
2,263 |
4 |
2 |
149,165 |
2,633 |
3 |
2 |
165,379 |
2,461 |
4 |
10 |
169,188 |
2,452 |
2 |
3 |
171,052 |
2,437 |
2 |
30 |
169,677 |
2,327 |
3 |
25 |
171,818 |
3,024 |
3 |
30 |
180,614 |
2,454 |
3 |
40 |
192,516 |
4,000 |
4 |
18 |
187,143 |
2,739 |
3 |
30 |
132,500 |
2,234 |
3 |
30 |
155,000 |
2,736 |
4 |
10 |
84,000 |
1,670 |
2 |
30 |
79,000 |
1,339 |
2 |
25 |
91,500 |
1,712 |
3 |
30 |
120,000 |
1,840 |
3 |
40 |
127,500 |
2,300 |
3 |
18 |
132,500 |
2,234 |
3 |
30 |
145,000 |
2,311 |
3 |
19 |
164,000 |
2,377 |
3 |
7 |
155,000 |
2,736 |
4 |
10 |
168,000 |
2,500 |
3 |
1 |
172,500 |
2,500 |
4 |
3 |
174,000 |
2,479 |
3 |
3 |
175,000 |
2,400 |
3 |
1 |
177,500 |
3,124 |
4 |
1 |
184,000 |
2,500 |
3 |
2 |
195,500 |
4,062 |
4 |
10 |
195,000 |
2,854 |
3 |
3 |
![]() |
Develop three regression models to predict the selling price based upon each of the other factors individually.
Write the equation of your developed regression models. 20 Marks
Calculate the SST, SSE and SSR for each model. 15 Marks
Calculate the F-Statistics values for those three models. 20 Marks
Predict separately the selling price of a 10-year-old, 2,000-square-foot house with three bedrooms. 10 Marks
Among these three models, which one is the best? 6 Marks
Develop a multivariate-regression model (using Excel, R or Python) to predict selling price based on the square footage, number of bedrooms, and age. Write the equation of the regression line. 15 Marks
Predict the selling price of a 10-year-old, 2,000-square-foot house with three bedrooms.
6 Marks
Compare the developed multiple regression model with previously developed individual simple regression models. 8 Marks