Dante Development Corporation is considering bidding on a contract for a new office building complex. Figure 4.17 shows the decision tree prepared by one of Dante’s analysts. At node 1,….

## Construct a frequency distribution of the rental properties

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.