diff_months: 20

# MGSC-5113-15 Quantitative Methods Assessment

Order Code: 475135
• Subject Code :

MGSC-5113-15

• Country :

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.

1. Write the equation of your developed regression models.                                                                                                               20 Marks

2. Calculate the SST, SSE and SSR for each model.                                                                                                               15 Marks

3. Calculate the F-Statistics values for those three models.                                                                                                              20 Marks

4. Predict separately the selling price of a 10-year-old, 2,000-square-foot house with three bedrooms.                                                                                                             10 Marks

5. Among these three models, which one is the best?                                                                                                               6 Marks

6. 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

7. Predict the selling price of a 10-year-old, 2,000-square-foot house with three bedrooms.

6 Marks

8. Compare the developed multiple regression model with previously developed individual simple regression models.                                                                                                           8 Marks

• Uploaded By : Katthy Wills
• Posted on : November 09th, 2022
• Views : 259

## Choose a Plan

80 USD
• All in Gold, plus:
• 30-minute live one-to-one session with an expert
• Understanding Marking Rubric
• Structuring & Formatting
• Referencing & Citing
Most
Popular

### Gold

30 50 USD
• Get the Full Used Solution
(Solution is already submitted and 100% plagiarised.
Can only be used for reference purposes)
Save 33%

### Silver

20 USD
• Journals
• Peer-Reviewed Articles
• Books
• Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more