Statistics

profileRameshpradhan
assign2_sol.pdf

TSTA602 Assignment 2 Solutions

June 14, 2020

Instructions. This assignment has a total of 30 marks and worth 30% of the final grade of TSTA602. The detailed marks allocation are provided at the beginning of each question. You are encouraged to discuss the assignment with your peers, but must write down your own solution. This assignment is due at 5pm on Friday of Week 11 (12th June, 2020). Please submit your assignment on Moodle before the deadline.

Scenario. You, as a property investor, are interested in understanding which factor (or factors) drives the prices of investment properties. A dataset is collected which contains the prices (in thousand dollars, as denoted by apart price) for 50 one- bedroom apartments in city X, their corresponding rents per week (in dollars, as denoted by rent) and the costs to hold each of these properties per week (in dollars, as denoted by cost of property). Following the procedures below to analyse the dataset ’assign2 data.csv’ by using Rstudio. Please only include relevant outputs from Rstudio in your solution and attach the R codes as appendice.

(a). (2 marks) Import the data into Rstudio, draw two scatter plots: apart price versus rent and apart price versus cost.

400 500 600 700 800

5 5

0 6

0 0

6 5

0 7

0 0

7 5

0 8

0 0

8 5

0 9

0 0

Price vs Rent

Rent

P ri

c e

500 600 700 800

5 5

0 6

0 0

6 5

0 7

0 0

7 5

0 8

0 0

8 5

0 9

0 0

Price vs Cost

Cost

P ri

c e

(b). (4 marks) Fit the following two linear models:

Model 1: apart price = b0 + b1 × rent

Model 2: apart price = c0 + c1 × cost

1

Write down the equations of the two models with correct coefficients.

Model 1: apart price = 259.7 + 0.80rent

Model 2: apart price = −6.30 + 1.14cost

(c). (4 marks) Comment on the significance of all coefficients obtained from (b) based on the p-values (from the outputs of Rtudio). The significance level is 0.05.

p− values are

< 2e−16 (significant)

< 2e−16 (significant)

0.0765 (not significant)

< 2e−16 (significant)

(d). (6 marks) Produce residual plots for each model in (b), comment on each plot.

400 500 600 700 800

− 4

− 2

0 2

4 6

Residual Plot − Rent

Rent

re s id

u a l

500 600 700 800

− 5

0 5

Residual Plot − Cost

Cost

re s id

u a l

Linearity: There are no obvious pattern in each residual plots; linear relation- ship seems to be reasonable.

Constant Variance: Both plots show a rough band shape; constant variance assumption did not violate.

(e). (4 marks) Produce normal qq plots for each model in (b), and comment on each plot.

2

−2 −1 0 1 2

− 4

− 2

0 2

4 6

QQ Plot − Rent

Theoretical Normal Quantiles

R e s id

u a ls

−2 −1 0 1 2

− 5

0 5

QQ Plot − Cost

Theoretical Normal Quantiles R

e s id

u a ls

Each figure above shows a rough linear relationship in the qq plot which suggests normality assumption on error are appropriate.

(f). (3 marks) Fit the following linear model:

Model 3: apart price = d0 + d1rent + d2cost

Write down the equation of the model with correct coefficients.

Model 3: apart price = 186.23 + 0.58rent + 0.32cost

(g). (3 marks) Comment on the significance of all coefficients obtained from (f) based on the p-values (from the outputs of Rtudio). The significance level is 0.05.

p− values are

2.35e−10 (significant)

8.11e−11 (significant)

0.00268 (significant)

(h). (2 marks) Compare Model 1 and Model 3, explain which one is better.

From ANOVA, we see that the p-value is 0.002683 < 0.05 which suggests Model 3 is better.

(i). (2 marks) Given rent = 810 and cost = 800, predict prices under Model 1 and Model 3.

Model 3: apart price = 259.7 + 0.80rent = 907.7

Model 3: apart price = 186.23 + 0.58rent + 0.32cost = 912.03

3

Marking Guidelines

(a). 1 mark for scatter plot apart price versus rent; 1 mark for scatter plot apart price versus cost.

(b). 1 mark for each correct coefficient.

(c). 1 mark for each correct conclusion.

(d). 1 mark for each residial plot; 1 mark for each comment on linearity; 1 mark for each comment on constant variacne.

(e). 1 mark for each correct normal qq plot; 1 mark for each comment on normality.

(f). 1 mark for each correct coefficient.

(g). 1 mark for each correct conclusion.

(h). 1 mark for using ANOVA; 1 mark for correct conclusion.

(h). 1 mark for each correct prediction.

Note: if no codes are attached, 3 marks are taken away.

4