The first three questions aim to give a picture of the level of availability of rental properties in the areas sampled.
1. Using COUNTIF, construct a frequency distribution for the availability of rental properties. (Complete Table (a)).
2. Provide an appropriate chart showing the percentage of rental properties in each availability category.
3. Briefly summarise the information obtained in the above table and graph about the number of rental properties in each category.
The remaining questions are based on analysis of the similarities and differences in weekly rent for those properties which are within a five?minutes walk of public transport (labelled as Near) and properties which do not have easy access to public transport (labelled as Other).
4. Provide a table of summary stats for the weekly rents for each of the Two categories (Near and Other) (Table (d)). Give your answers in this table to two decimal places and make sure you indicate units.
5. Complete the grouped frequency table for the weekly rents for the two categories for the sample (Table (e)). Find frequency and hence calculate percentage frequency for the two categories.
6. Construct percentage frequency polygons of the weekly rents for each of the two categories of rental properties as one chart as Graph.
7. Comment on the shapes of the two distributions
8. Based on your answers to questions 4, 5 and 6, discuss and compare the central locations of the distributions for different categories of rental properties.
9. List the four measures of variability given in the table. The rents of which category of rental property show more variability.
10. Comment on any particular interesting and unusual features of the weekly rent distributions for the two categories of rental properties. What conclusions do you think the student union should draw about the affordability of student housing which has easily accessible public transport options to the university.