Running Head: BUSINESS STATISTICS 16 16 Business Statistics Name of the University Author Note

Running Head: BUSINESS STATISTICS
Business Statistics
Name of the Student
Name of the University
Author Note

BUSINESS STATISTICS1
ANSWER 1
Part a
i. Variables from the dataset, which are Qualitative and Normal, are Suburb,
Address, Type, Result and Agent.
ii. There are no variables in the dataset, which are both Qualitative and Normal.
iii. Variable from the dataset, which is Quantitative and ratio is price.
iv. The variable from the dataset, which is both Quantitative and Ordinal, is bedroom.
Part b
Result Code Overall Outcome
PI, NB, VB Property not sold
SP, PN Property sold prior to auction
S, SN Property sold at auction
SA, SS Property sold after auction
W Withdrawn from auction
Part c
i. By Suburb and Address, the four properties where the number of bedrooms is
missing is shown by the following table:
Suburb Address
Darlington 9/299 Abercrombie St.
Kirribilli 49/20 Carabella St.
Manly 1/19-23 Pittwater Rd.
North Sydney 307/54 High St.

BUSINESS STATISTICS2
ii. The properties which are errors, from the above identified properties are given as
follows:
Suburb Address Bedroo
ms Type Price Resul
t Agent
Darlington 9/299 Abercrombie St u N/A PN Blues Point Real Estate
North Sydney 307/54 High St u N/A PN Blues Point Real Estate
These two properties are the errors because the price of the property is missing in
both the cases and both of the properties were sold before auction. Thus, these two
properties do not have any records during the auction.
Part d
Part e
i. It can be seen from the pivot table that there were 467 properties, which was listed for
auction in that day.

BUSINESS STATISTICS3
ii. The total number of properties that were sold that day (at auction, prior or after) is 244 +
31 + 121 = 396.
iii. The percentage of the number of properties sold at auction is = 396/467 = 84.8%.
Part f
i. The number of four bedroom houses listed for the auction that day is 106. These include
102 houses, 4 duplex and 1 townhouse.
ii. Out of these 106 houses, 91 were sold at the auction, prior or after.
iii. The percentage of the number of four bedroom houses sold (at the auction, prior or after)
is 91/106 = 85.8%
iv. Of all the listed properties, the clearance rate is 84.8% and for the four bedroom houses,
the clearance rate is 85.8%. Thus, it can be said the rate of clearance for the four bedroom
houses is better than the rate of clearance of all the properties overall for that week.
Part g
i. The two way pivot table for type by result is given below:
ii. The single horizontal component chart is given below: