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.