Question

In: Statistics and Probability

Calculate the Mean, Median, Standard Deviation, Coefficient of Variation and 95% population mean confidence intervals for...

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

Solutions

Expert Solution

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

Related Solutions

Construct 95% confidence intervals for the population variance and population standard deviation of the given values...
Construct 95% confidence intervals for the population variance and population standard deviation of the given values below Sketch the results and interpret your findings (15 points). 1.286   1.138   1.240   1.132   1.381   1.137 1.300   1.167   1.240   1.401   1.241   1.171 1.217   1.360   1.302   1.331   1.383
one can calculate the 95% confidence interval for the mean with the population standard deviation knowing...
one can calculate the 95% confidence interval for the mean with the population standard deviation knowing this gives us an upper and lower confidence limit what happens if we decide to calculate the 99% confidence interval describe how the increase in the confidence level has changed the width of the confidence interval
One can calculate the 95% confidence interval for the mean with the population standard deviation known....
One can calculate the 95% confidence interval for the mean with the population standard deviation known. This will give us an upper and a lower confidence limit. What happens if we decide to calculate the 99% confidence interval? Describe how the increase in the confidence level has changed the width of the confidence interval. Do the same for the confidence interval set at 80%. Include an example with actual numerical values for the intervals in your post to help with...
One can calculate the 95% confidence interval for the mean with the population standard deviation known....
One can calculate the 95% confidence interval for the mean with the population standard deviation known. This will give us an upper and a lower confidence limit. What happens if we decide to calculate the 99% confidence interval? Your task for this discussion is as follows: Describe how the increase in the confidence level has changed the width of the confidence interval. Do the same for the confidence interval set at 80%. Include an example with actual numerical values for...
Find the mean, standard deviation, 80%, 95%, and 99% confidence intervals, and margin of error for...
Find the mean, standard deviation, 80%, 95%, and 99% confidence intervals, and margin of error for those intervals. Show all work. $32,096 $29,716 $29,227 $27,209 $22,794 $19,306 $19,238 $19,164 18,994 $18,329 $17,978 $17,626 $16,823 $16,709 $15,967 $15,921 $15,908 $15,905 $15,638 $15,629 $14,414 $14,229 $14,137 $14,051 $13,907 $13,776 $13,281 $12,739 $12,300 $11,994 $11,262 $11,112 $10,984 $10,824 $10,823 $10,448 $10,081 $9,883 $9,668 $9,663 $9,337 $8,855 $8,741 $8,596 $8,385 $7,204 $7,072 $6,503 $5,653 $4,602
mean 94.6129 n= 31 standard deviation is 45.0612 find the 95% and 99% confidence intervals of...
mean 94.6129 n= 31 standard deviation is 45.0612 find the 95% and 99% confidence intervals of the standard devaition find the 95% and 99% confidence interval for population mean data set 10 19 35 39 41 56 67 67 69 73 75 78 81 82 83 83 84 91 92 94 123 125 137 138 140 142 150 152 161 163 183
Construct two 95% confidence intervals for each sample. SD = $35,989.61 Apply the population standard deviation...
Construct two 95% confidence intervals for each sample. SD = $35,989.61 Apply the population standard deviation (σ) in the formula to form z-distribution since the population standard deviation is known. Loan Amount Type Sample 1 $    30,500.00 Commercial $    78,500.00 Commercial $    90,000.00 Commercial $    19,000.00 Commercial $    36,000.00 Commercial $    89,500.00 Commercial $    22,000.00 Commercial $    65,000.00 Commercial $ 109,000.00 Commercial $     5,500.00 Commercial $    93,500.00 Commercial $     6,000.00 Commercial $    85,500.00 Commercial $    98,000.00 Commercial $    57,000.00 Commercial...
. It is desired to design 95 confidence intervals for the ratio between standard deviation of...
. It is desired to design 95 confidence intervals for the ratio between standard deviation of two electroplating lines in a micro-electro-mechanical system (MEMS) company. If independent samples of size n1=10 from line-1 has a standard deviation of S1=0.035 mil and sample size of n2=12 from line-2 has a standard deviation of s2=0.062 mil, estimate the confidence intervals for the ratio of standard deviation of line-1 to line-2 (s12/s22)
Calculate the two-sided 95% confidence interval for the population standard deviation (sigma) given that a sample...
Calculate the two-sided 95% confidence interval for the population standard deviation (sigma) given that a sample of size n=8 yields a sample standard deviation of 7.96.
Calculate the range, interquartile range, variance, standard deviation and coefficient of variation.
A sample has data values 27, 25, 20, 15, 30, 34, 28, 25. Calculate the range, interquartile range, variance, standard deviation and coefficient of variation.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT