Assignment Part II Answers to the six assignment tasks in Part II must be based on the sample data file that you have created in Part I. All tasks in this assignment require you to obtain an Excel output prior to performing some analysis. Copy and Paste these outputs to your assignment MS- Word document immediately preceding any subsequent analysis. Explanations must be precise and to the point. Charts and tables must have appropriate titles and numerical values must be rounded to an appropriate number of decimal places and accompanied by the correct units of measure. Task 2 (10 marks) 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? (1 mark) 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; P Lp = (n+)100' and the three associated rules (Slide 11 of Week 2 Seminar, Session 1) (1 mark) to determine: Remember to show The 70th percentile. (1 mark) (ii) The first and third quartiles. (2 mark) all working! (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