A real estate company conducted a study on weekly rental cost for university students in two major Australian cities. 150 university students residing in Sydney and Melbourne were surveyed and their...

A real estate company conducted a study on weekly rental cost for university students in two major Australian cities. 150 university students residing in Sydney and Melbourne were surveyed and their information was recorded for the year 2015 and 2016. This information recorded on each student is described below and is available in the Rental.xlsx data file on iLearn. This file will be required to answer Questions 1 to 4.
Variable Name        Variable Description
ID                Unique student identifier
Sex                0 = Male, 1 = Female
Rent_2015    Amount ($) spent on rent each week in 2015
Rent_2016    Amount ($) spent on rent each week in 2016
City    Melbourne, Sydney




a.    In the Excel worksheet create new column/s and calculate the differences between the rental cost for each participant in 2015 and in 2016.



i.    What proportion of participants included in the study is based in Sydney?





ii.    What proportion of participants based in Sydney paid a higher rent in 2016 than the year before?