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. (Complete Graph(b)).
3.Briefly summarise the information obtained in the above table and graph about the number of rental properties in each category (3 to 4 sentences – Textbox (c)).
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
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 (f).
7.Comment on the shapes of the two distributions (Textbox (g)).
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 (Textbox (h)).
9.List the four measures of variability given in the table. The rents of which category of rental property show more variability? (Textbox (i)).