QBM117 Business Statistics

1
QBM117 Business Statistics
Name:
Institution:

2
Question one
a. Table
Result Code Overall Outcome
PI, NB, VB property passed no bid vendor bid
SP, PN property sold prior not disclosed
S, SN property sold not disclosed
SA, SS sold after auction price not disclosed
W withdrawn prior to auction
KEY: S - property sold; SP - property sold prior; PI - property passed in; PN - sold prior
not disclosed; SN - sold not disclosed; NB - no bid; VB - vendor bid; W - withdrawn
prior to auction; SA - sold after auction; SS - sold after auction price not disclosed. N/A -
price or highest bid not available
b. Errors
i. Surry Hills, 71/175-189 Campbell St
ii. Queenscliff, 83 Queenscliff Rd
c. Pivot Table
d. Clearance rate of all properties
i. How many properties = 330
ii. S = 174 SP = 71 SA =1
iii. S = 174/330 = 52.72% SP = 21.52% SA =1/330 = 0.303 %
e. Clearance rate of four bedroom
i. Four-bedroom houses = 80
ii. S= 40 SP = 17 SA = 0
iii. S = 40/80 = 50% SP = 17/80 = 21.25%
iv. The clearance rate of four-bedroom houses is slightly lower compared to all
properties

3
f. Comparison
i. Pivot table
ii. Bar chart
house
studio
townhouse
unit
(blank)
0% 2000% 4000% 6000% 8000% 10000%
Bar Chart (blank)
W
VB
SS
SP
SN
SA
S
PN
PI
Percentage
Type
iii. Town house and studio
g. House Data
i. Descriptive Statistics
Price
Mean 1515538.012
Standard Error 59717.89647
Median 1395000
Mode 1400000
Standard Deviation 780912.8275
Sample Variance 6.09825E+11
Kurtosis 7.15058297
Skewness 2.158086364
Range 5190000
Minimum 510000
Maximum 5700000
Sum 259157000
Count 171