Help me with Economics Calculations
Get the best assignment help from MakeMyAssignments.com
Use Excel to produce a Frequency Column Chart (4 marks) and a Relative Frequency Pie-Chart (3 marks) for your sample to show the number and proportion, respectively, of each building type.
Use these graphical summaries to answer the following questions:
(a) How many properties in your sample consist of brick buildings? (1 mark)
(b) Which building type occurs most frequently in your sample? (1 mark)
(c) What proportion of properties in your sample consists of weatherboard buildings?
Task 3 (10 marks)
(a) Use Excel to sort your sample ”Sold Price” data and paste into your MS Word assignment document. (1 mark)
(b) Use the percentile location formula;
Lp = (n + 1) P/100 , and the three associated rules (1 mark) to determine:
(i) The 70. percentile. (1 mark)
Remember to show all working!
(ii) The first and third quartiles. (2 mark)
(c) Briefly explain what the 70. Percentile that you have determined informs you about your sample “Sold Price’ data. (2 mark)
(d) Determine the Inter-Quartile Range of your sample “Sold Price” data and provide a brief explanation of what information this statistic provides about your sample data.
Task 4 (15 marks)