Business Statistics - QBM117 | Assignment

QBM117 Business Statistics
Name of the Student
Name of the University
Author Note

Question 1
a. Variable from the data set:
i. Qualitative and Nominal:
Suburb, Address, Type, Result, and Agent
ii. Qualitative and Ordinal:
No Variable
iii. Quantitative and Ratio:
Price
iv. Quantitative and Ordinal:
Bedrooms
b. Overall outcome to the appropriate results:
Result code Overall Outcome
PI, NB, VB Didnot sell
SP, PN Soldprior to the auction
S, SN Soldat the auction
SA, SS Soldafter the auction
W Withdrawnfromsale
c. Answers:
Below are the four properties where the number of bedrooms is missing
from the data set:
Suburb Address
Darlington 9/299 Abercrombie St
Kirribilli 49/20 Carabella St
Manly 1/19-23 Pittwater Rd
North Sydney 307/54 High St
Out of these four properties below two are errors:
Suburb Address Bedrooms Type Price Result 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 are errors based on below mentioned reasons:
1. In both cases, the price of the property is not disclosed;
2. In both cases, property sold before the auction and thus there is no
existence of these properties during auction.
d. Pivot Table

CountofResultColumnLabels
RowLabels PI PN S SN SP VB W GrandTotal
h 36 8 159 28 72 5 5 313
1 1 1
2 2 18 3 6 1 30
3 15 4 60 12 29 120
4 6 4 54 7 27 2 2 102
5 7 22 4 9 1 2 45
6 3 4 1 1 1 10
7 3 1 4
8 1 1
studio 2 2
(blank) 2 2
t 1 3 15 3 1 23
2 1 3 1 5
3 1 2 10 2 1 16
4 1 1
5 1 1
u 6 5 68 3 46 1 129
1 9 12 21
2 4 3 45 1 30 1 84
3 1 12 2 4 19
4 1 2 3
(blank) 2 2
GrandTotal 43 16 244 31 121 6 6 467
e. Answers:
i. From the above table, it can be said that total 467 properties were
originally listed for auction for the day.
ii. A total of 244 + 31 + 121 = 396 of these were sold (at auction, prior or
after).
iii. The percentage of properties sold (at auction, prior or after) is 396/467 =
84.8%
f. Answers:
i. From the above tale, it can be said that there are 102 houses, 4 unit or
duplex and 1 townhouse, that is, total 106 four bedroom houses were
originally listed for auction for the day.
ii. Total 91 of these were sold (at auction, prior or after).
iii. The percentage of four bedroom houses sold (at auction, prior or after) is
91/106 = 85.8%

iv. The clearance rate of all properties listed is 84.8%, whereas the clearance
rate for four bedroom house is 85.8%. Hence, clearance rate for four
bedroom houses are better than the clearance rate for all properties that
week.
g. Answers:
i. Pivot Table:
CountofResultColumnLabels
RowLabels PI PN S SN SP VB W GrandTotal
h 36 8 159 28 72 5 5 313
studio 2 2
t 1 3 15 3 1 23
u 6 5 68 3 46 1 129
GrandTotal 43 16 244 31 121 6 6 467
ii. 100% component bar chart
iii. From the above graph it can be said that unit or duplex and township
types of properties had approximately the same proportion of properties
passed in that week.
h. Answers:
i. Descriptive Statistics for Price