This paper circulates around the core theme of Macro Economics together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 89. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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
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 (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)).