Data found at https://docs.google.com/spreadsheets/d/1AiysLgVOhaFiAGjRdLpLarjs-zaGocJC/edit#gid=1176564555

Ms Jenny Wong is a property agent dealing with rental of private property in Singapore. She wanted to examine what the key factors affecting the rent of private property are. She recorded the following data for her most recent 105 transactions:

RENT: Monthly rent of property (S$)

SIZE: Build-up area (sq ft)

TIME: Walking time to the nearest MRT station (minutes)

POOL: 1 means the property has a swimming pool 0 means the property does not have a swimming pool

The dataset can be found in the TOA Data File 'Question_4' worksheet. The RENT is the dependent variable and the other variables are independent variables. (

a) Describe the relationship between RENT and the three (3) independent variables by writing down the linear equation. Interpret the coefficients to show how each of the independent variables impacts the rent. You are required to present the whole regression output table. (6 marks)

(b) Jenny wants to estimate the rent for a particular property in which the build-up area is 4,500 sq ft, the walking time to the nearest MRT station is 15 minutes, and it has a swimming pool. What is your estimate of the rent? (4 marks)

(c) Interpret the adjusted coefficient of multiple determination. Explain what the implication in this case is. (5 marks)

(d) Execute appropriate hypothesis tests to advise Jenny on which variable(s) is/are statistically significant at the 5% significance level. Write down your steps in detail. (10 marks)