diff_months: 20

MGSC-5113-15 Quantitative Methods Assessment

Download Solution Now
Added on: 2022-11-09 07:01:16
Order Code: 475135
Question Task Id: 0
  • 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.

  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
  • Downloads : 0
  • Views : 259

Download Solution Now

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan

Premium

80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • 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