In: Statistics and Probability
Calculate the Mean, Median, Standard Deviation, Coefficient of
Variation and 95%
population mean confidence intervals for property prices of Houses
based on the following
grouping:
Proximity of the property to CBD
Note: Calculate above statistics for both “Up to 5KM” and “Between
5KM and
10KM”
Number of bedrooms
Note: Calculate above statistics for “One bedroom”, “Two bedrooms”
and “Three
bedrooms or more”
Number of bathrooms
Note: Calculate above statistics for “One bathroom”, “Two
bathrooms”, “Three
bathrooms or more”)
Note: In total, you need to show your results for 8 different
categories. Provide all results in
one table (see a sample table at the end of this document).
DATA:
TYPE | 1 | House |
2 | Unit | |
PROXIMITY | 1 | up to 5KM |
2 | Between 5KM and 10KM | |
BEDROOM | 1 | one bedroom |
2 | two bedrooms | |
3 | three bedrooms and above | |
BATHROOM | 1 | one bathroom |
2 | two bathrooms | |
3 | three bathrooms and above |
PRICE (in 10,000 AU Dollars) | TYPE | PROXIMITY | BEDROOM | BATHROOM |
310 | 1 | 1 | 2 | 1 |
307 | 1 | 1 | 2 | 1 |
305 | 1 | 1 | 2 | 1 |
300 | 1 | 1 | 2 | 1 |
290 | 1 | 1 | 2 | 1 |
287 | 1 | 1 | 2 | 1 |
280 | 1 | 1 | 1 | 1 |
279 | 1 | 1 | 1 | 1 |
278 | 1 | 1 | 1 | 1 |
277 | 1 | 1 | 1 | 1 |
277 | 1 | 1 | 2 | 1 |
276 | 1 | 1 | 2 | 1 |
269 | 1 | 1 | 2 | 1 |
268 | 1 | 1 | 1 | 1 |
267 | 1 | 1 | 1 | 1 |
267 | 1 | 1 | 1 | 1 |
266 | 1 | 1 | 1 | 1 |
265 | 1 | 1 | 2 | 1 |
257 | 1 | 1 | 1 | 1 |
256 | 1 | 1 | 3 | 1 |
252 | 1 | 1 | 3 | 1 |
250 | 1 | 1 | 1 | 1 |
249 | 1 | 1 | 2 | 1 |
247 | 1 | 1 | 1 | 1 |
247 | 1 | 1 | 1 | 1 |
247 | 1 | 1 | 2 | 1 |
245 | 1 | 1 | 1 | 1 |
244 | 1 | 1 | 1 | 1 |
243 | 1 | 1 | 3 | 1 |
240 | 1 | 1 | 3 | 1 |
235 | 1 | 1 | 3 | 1 |
230 | 1 | 1 | 1 | 1 |
223 | 1 | 1 | 3 | 1 |
217 | 1 | 1 | 1 | 1 |
213 | 1 | 1 | 3 | 1 |
209 | 1 | 1 | 3 | 1 |
208 | 1 | 1 | 2 | 1 |
207 | 1 | 1 | 2 | 1 |
207 | 1 | 1 | 2 | 1 |
207 | 1 | 1 | 2 | 1 |
205 | 1 | 1 | 2 | 1 |
202 | 1 | 1 | 3 | 1 |
201 | 1 | 1 | 2 | 1 |
199 | 1 | 1 | 3 | 1 |
190 | 1 | 1 | 2 | 2 |
189 | 1 | 2 | 2 | 1 |
188 | 1 | 1 | 2 | 2 |
188 | 1 | 1 | 1 | 2 |
186 | 1 | 1 | 1 | 2 |
185 | 1 | 2 | 2 | 1 |
183 | 1 | 1 | 3 | 1 |
181 | 1 | 1 | 3 | 1 |
179 | 1 | 2 | 2 | 2 |
177 | 1 | 2 | 2 | 2 |
173 | 1 | 1 | 3 | 1 |
171 | 1 | 1 | 3 | 1 |
164 | 1 | 1 | 2 | 2 |
163 | 1 | 1 | 3 | 1 |
159 | 1 | 1 | 2 | 2 |
145 | 1 | 1 | 1 | 2 |
144 | 1 | 1 | 3 | 1 |
143 | 1 | 1 | 3 | 1 |
143 | 1 | 1 | 1 | 2 |
140 | 1 | 1 | 1 | 2 |
139 | 1 | 1 | 1 | 2 |
133 | 1 | 1 | 2 | 2 |
132 | 1 | 1 | 2 | 2 |
130 | 1 | 1 | 3 | 1 |
120 | 1 | 2 | 3 | 2 |
119 | 1 | 2 | 3 | 2 |
118 | 1 | 2 | 2 | 2 |
117 | 1 | 2 | 2 | 2 |
115 | 1 | 1 | 1 | 2 |
112 | 1 | 1 | 1 | 2 |
111 | 1 | 2 | 2 | 2 |
104 | 1 | 2 | 2 | 2 |
85 | 1 | 1 | 2 | 2 |
83 | 1 | 1 | 2 | 2 |
77 | 1 | 2 | 3 | 3 |
74 | 1 | 2 | 3 | 3 |
74 | 1 | 1 | 2 | 2 |
73 | 1 | 1 | 2 | 2 |
72 | 1 | 2 | 1 | 3 |
71 | 1 | 1 | 1 | 3 |
69 | 1 | 1 | 1 | 3 |
69 | 1 | 2 | 1 | 3 |
29 | 1 | 2 | 1 | 3 |
27 | 1 | 2 | 1 | 3 |
199 | 2 | 2 | 3 | 1 |
193 | 2 | 2 | 3 | 1 |
186 | 2 | 2 | 2 | 1 |
185 | 2 | 2 | 2 | 1 |
184 | 2 | 2 | 3 | 1 |
183 | 2 | 2 | 2 | 1 |
183 | 2 | 2 | 3 | 1 |
182 | 2 | 2 | 2 | 1 |
177 | 2 | 2 | 3 | 1 |
175 | 2 | 2 | 3 | 1 |
163 | 2 | 1 | 1 | 2 |
162 | 2 | 1 | 1 | 2 |
161 | 2 | 2 | 2 | 2 |
159 | 2 | 2 | 2 | 2 |
159 | 2 | 2 | 2 | 2 |
157 | 2 | 2 | 2 | 2 |
156 | 2 | 2 | 3 | 1 |
155 | 2 | 2 | 3 | 1 |
141 | 2 | 1 | 2 | 2 |
139 | 2 | 1 | 2 | 2 |
138 | 2 | 2 | 2 | 2 |
137 | 2 | 2 | 1 | 2 |
135 | 2 | 2 | 2 | 2 |
133 | 2 | 2 | 1 | 2 |
129 | 2 | 1 | 3 | 3 |
126 | 2 | 1 | 3 | 3 |
125 | 2 | 1 | 1 | 2 |
124 | 2 | 1 | 1 | 2 |
123 | 2 | 2 | 1 | 2 |
122 | 2 | 2 | 1 | 2 |
119 | 2 | 1 | 3 | 2 |
117 | 2 | 1 | 3 | 2 |
116 | 2 | 2 | 2 | 3 |
111 | 2 | 2 | 2 | 3 |
106 | 2 | 1 | 1 | 3 |
104 | 2 | 1 | 1 | 3 |
99 | 2 | 2 | 2 | 2 |
97 | 2 | 2 | 2 | 2 |
89 | 2 | 1 | 2 | 2 |
87 | 2 | 1 | 2 | 2 |
79 | 2 | 1 | 2 | 3 |
75 | 2 | 1 | 2 | 3 |
71 | 2 | 2 | 3 | 2 |
70 | 2 | 2 | 2 | 2 |
69 | 2 | 2 | 2 | 2 |
69 | 2 | 2 | 3 | 2 |
69 | 2 | 1 | 2 | 3 |
69 | 2 | 2 | 3 | 3 |
68 | 2 | 1 | 2 | 3 |
68 | 2 | 1 | 1 | 3 |
67 | 2 | 1 | 3 | 3 |
66 | 2 | 1 | 3 | 3 |
66 | 2 | 2 | 3 | 3 |
65 | 2 | 1 | 1 | 3 |
65 | 2 | 1 | 2 | 3 |
65 | 2 | 1 | 2 | 3 |
65 | 2 | 2 | 2 | 3 |
64 | 2 | 1 | 2 | 3 |
64 | 2 | 2 | 2 | 3 |
63 | 2 | 1 | 2 | 3 |
60 | 2 | 2 | 2 | 2 |
59 | 2 | 1 | 2 | 3 |
58 | 2 | 1 | 2 | 3 |
57 | 2 | 2 | 2 | 2 |
56 | 2 | 1 | 2 | 3 |
55 | 2 | 1 | 2 | 3 |
55 | 2 | 1 | 2 | 3 |
55 | 2 | 1 | 2 | 3 |
55 | 2 | 1 | 1 | 3 |
54 | 2 | 1 | 1 | 3 |
53 | 2 | 1 | 2 | 3 |
52 | 2 | 1 | 3 | 3 |
51 | 2 | 1 | 1 | 3 |
51 | 2 | 1 | 1 | 3 |
51 | 2 | 1 | 2 | 3 |
51 | 2 | 1 | 3 | 3 |
50 | 2 | 1 | 2 | 3 |
49 | 2 | 1 | 2 | 3 |
48 | 2 | 1 | 3 | 3 |
48 | 2 | 1 | 2 | 3 |
46 | 2 | 1 | 3 | 3 |
45 | 2 | 1 | 2 | 3 |
45 | 2 | 1 | 1 | 3 |
45 | 2 | 1 | 2 | 3 |
44 | 2 | 1 | 2 | 3 |
43 | 2 | 1 | 1 | 3 |
43 | 2 | 1 | 2 | 3 |
43 | 2 | 1 | 2 | 3 |
41 | 2 | 1 | 2 | 3 |
41 | 2 | 1 | 2 | 3 |
40 | 2 | 1 | 3 | 2 |
40 | 2 | 1 | 3 | 3 |
39 | 2 | 1 | 3 | 2 |
39 | 2 | 1 | 3 | 3 |
39 | 2 | 1 | 3 | 3 |
38 | 2 | 1 | 3 | 3 |
38 | 2 | 2 | 2 | 3 |
36 | 2 | 2 | 2 | 3 |
36 | 2 | 1 | 3 | 3 |
34 | 2 | 1 | 3 | 3 |
31 | 2 | 2 | 1 | 3 |
29 | 2 | 2 | 1 | 3 |
Descriptive Statistics: PRICE (in 10,000 AU Dollars)
Statistics
Variable | TYPE | Mean | StDev | CoefVar | Median | Mode | N for Mode |
PRICE (in 10,000 AU Dollars) | 1 | 189.23 | 72.90 | 38.53 | 194.50 | 207, 247 | 3 |
2 | 88.59 | 49.26 | 55.61 | 66.50 | 51, 55, 65, 69 | 4 |
Statistics
Variable | PROXIMITY | Mean | StDev | CoefVar | Median | Mode | N for Mode |
PRICE (in 10,000 AU Dollars) | 1 | 142.70 | 87.00 | 60.96 | 131.00 | 51, 55 | 4 |
2 | 117.25 | 52.88 | 45.10 | 118.50 | 69 | 4 |
Statistics
Variable | BEDROOM | Mean | StDev | CoefVar | Median | Mode | N for Mode |
PRICE (in 10,000 AU Dollars) | 1 | 148.3 | 85.9 | 57.90 | 135.0 | 29, 51, 69, 247 | 2 |
2 | 130.68 | 80.30 | 61.45 | 111.00 | 55, 65, 159, 207 | 3 | |
3 | 130.25 | 70.29 | 53.97 | 129.50 | 39 | 3 |
The data contain at least five mode values. Only the smallest four are shown.
Statistics
Variable | BATHROOM | Mean | StDev | CoefVar | Median | Mode | N for Mode |
PRICE (in 10,000 AU Dollars) | 1 | 224.67 | 45.88 | 20.42 | 220.00 | 183, 207, 247 | 3 |
2 | 122.41 | 38.89 | 31.77 | 123.50 | 159 | 3 | |
3 | 58.90 | 22.07 | 37.47 | 55.00 | 51, 55, 65, 69 | 4 |