1: Descriptive statistics (10 Marks) Data The data for assignment 1 can be found in the Assessments block in Moodle. It is saved as BUGEN1502 Assignment 1 data.xlsx. There are two variables in the dataset, weekly rental cost (in dollars), and the location of the property. Questions Q1 (2 marks) Construct a frequency distribution of the rental properties Areas Frequency Percentage Area 1 Area 2 Area 3 Total Insert the result table below Click or tap here to enter text. Q2 (1 Mark) Create a bar chart of the frequency of properties in each area Insert the bar chart below. Click or tap here to enter text. Q3 (1 Mark) Create a pie chart of the percentage of the properties in each area Insert the pie chart below Click or tap here to enter text. Q4 (2 Marks) Create a grouped percentage frequency distribution table for rental cost for each area. Frequencies Percentage% Range Area 1 Area 2 Area 3 Area 1 Area 2 Area 3 0 to 50 Over 50 to 100 Over 100 to 150 Over 150 to 200 Over 200 to 250 Over 250 to 300 Over 300 to 350 Over 350 to 400 Over 400 to 450 Over 450 to 500 Over 500 to 550 Over 550 to 600 Total Insert the frequency and percentage table below Click or tap here to enter text. Q5 (1 Mark) Create percentage frequency polygons for each of the three areas in one graph Insert the percentage frequency polygon below Click or tap here to enter text. Q6 (1 Mark) Using the percentage frequency polygon, make a comparison of the price in the three areas in terms of distribution, mean, and standard deviation. Click or tap here to enter text. Q7 (1 Mark) Calculate the central tendency (mean, median, and mode) and dispersion (standard deviation, and range) for each of the three areas Insert a table of the calculation result below Click or tap here to enter text. Q8 (1 Mark) Using the calculation result of Q7, make a comparison of the price in the three areas in terms of distribution, mean, and standard deviation. Click or tap here to enter text