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.

find the cost of your paper

consider doing a market research study to forecast demand for the office units prior to beginning construction.

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,….

Test the claim that there is a difference in times between two trials.

Mental measurements of young children are often made by giving them blocks and telling them to build a tower as tall as possible. One experiment of block building was repeated….

 Identify the distribution of X—name and parameter(s).

1. When local calls are made in NYC, 60% go through on the first try, and the rest get a busy signal. (We assume there is no third possibility). Let….