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.

The post Central tendency appeared first on My Assignment Online.