Refer to the real estate data for the Halifax area, on Connect, which include in
ID: 3181550 • Letter: R
Question
Refer to the real estate data for the Halifax area, on Connect, which include information on home listings.
A. A recent article indicated that the mean list price of the homes is more than $600 000. Can we conclude that the mean list price is more than $600 000? Use the 0.01 significance level. What is the p-value? Interpret the p-value.
B. The same article reported the mean size was more than 2100 square feet. Can we conclude that the mean size of homes listed is more than 2100 square feet? Use the 0.01 significance level. What is the p-value? Interpret the p-value.
C .Determine the proportion of homes that are apartments. At the 0.05 significance level, can we conclude that more than 60% of the homes listed are apartments? What is the p-value? Interpret the p-value.
D. Determine the proportion of homes with more than two bedrooms. At the 0.05 significance level, can we conclude that more than 60% of the homes listed have more than two bathrooms? What is the p-value? Interpret the p-value.
List Price Type Number of Bedrooms Full Baths Half Baths Total Square Feet $164,900 Townhouse 1 1 0 515 $167,510 Apartment 1 1 0 518 $179,000 Apartment 1 1 0 720 $179,000 Apartment 1 1 0 720 $184,900 Apartment 1 1 0 500 $189,000 Apartment 1 1 0 840 $192,779 Apartment 1 1 0 612 $214,900 Apartment 2 1 1 1050 $219,500 Apartment 2 1 0 1130 $220,000 Apartment 2 1 0 1010 $222,400 House 2 1 1 1428 $227,000 Apartment 2 1 0 1014 $229,000 Apartment 2 1 1 1050 $237,500 Apartment 1 1 0 742 $239,000 Apartment 1 1 0 609 $241,745 Apartment 1 1 0 749 $244,900 Apartment 1 1 0 713 $249,000 Apartment 2 2 0 1293 $249,999 Townhouse 2 1 0 1150 $269,000 Apartment 1 1 0 831 $274,900 House 3 1 0 1104 $274,900 Townhouse 2 1 1 1105 $289,900 Apartment 1 1 0 550 $292,000 Apartment 2 2 0 1057 $295,000 Townhouse 3 1 0 1200 $299,000 Apartment 1 1 0 880 $299,900 House 3 1 0 1560 $299,900 Townhouse 2 1 1 1379 $324,900 Townhouse 3 1 1 1600 $332,000 Apartment 1 2 0 937 $335,000 Apartment 1 1 0 780 $339,900 Apartment 1 1 0 800 $349,900 Apartment 2 2 0 1190 $354,200 Apartment 2 2 0 1155 $368,500 Apartment 2 1 0 1117 $379,200 Townhouse 3 2 1 1692 $379,900 House 6 2 0 2520 $380,900 Apartment 1 2 0 937 $387,900 Apartment 2 1 1 1102 $392,900 Townhouse 3 1 1 1686 $404,900 Apartment 2 2 0 1310 $425,000 Apartment 1 1 0 781 $425,000 House 2 1 1 1400 $429,900 Apartment 2 2 0 1032 $430,000 Apartment 2 2 0 1154 $440,500 Apartment 2 2 0 1316 $448,900 Apartment 2 2 0 1390 $449,000 House 3 2 0 1342 $449,900 Apartment 2 2 0 1000 $450,500 Apartment 2 2 0 1092 $451,900 Apartment 2 2 0 1304 $459,000 Apartment 1 2 0 1313 $464,900 Townhouse 2 2 1 2191 $464,900 Townhouse 2 2 1 2181 $469,900 Apartment 2 2 0 1038 $477,900 Townhouse 2 2 1 2188 $479,900 Apartment 2 2 0 1380 $484,000 Townhouse 3 2 1 2261 $489,900 House 2 2 0 1726 $495,000 Apartment 3 2 0 1524 $495,500 Townhouse 3 1 1 2274 $499,000 House 5 4 0 3085 $499,900 Apartment 2 2 0 1670 $499,900 Apartment 2 2 0 1085 $509,900 Apartment 3 2 0 1230 $515,000 House 4 2 0 1600 $535,000 Apartment 2 2 1 1952 $539,900 Apartment 2 2 0 1370 $575,000 Apartment 2 2 0 1230 $585,000 Apartment 2 2 0 1057 $599,900 Apartment 3 2 0 1627 $639,900 Apartment 3 2 0 1352 $649,900 House 4 2 1 2180 $685,000 House 3 2 0 2100 $699,000 House 3 1 0 1840 $699,900 Apartment 2 2 0 1296 $709,000 Townhouse 5 2 1 3220 $759,000 House 3 1 1 2440 $795,000 House 4 3 0 2800 $799,000 Apartment 2 2 0 1600 $799,900 Apartment 3 2 0 1350 $799,900 Apartment 2 2 0 1318 $859,900 House 4 2 1 2273 $975,000 House 7 3 2 4860 $995,000 Apartment 3 2 1 2347 $995,000 House 5 2 1 3580 $999,900 House 4 3 0 4000 $999,999 House 4 2 1 3307 $1,180,000 House 5 2 1 4357 $1,300,000 Apartment 2 2 0 1346 $1,395,000 House 4 3 1 4724 $1,399,000 House 5 3 1 3218 $1,425,000 Apartment 2 2 1 2472 $1,575,000 Apartment 3 2 1 1911 $1,579,750 House 4 3 1 3617 $1,599,000 House 5 4 1 5200 $1,895,000 House 4 4 1 5200 $2,490,000 House 6 4 1 5025Explanation / Answer
a) H0 : m = 600000; Ha: m > 600000
= 0.01, n = 98, df = 97
From data,
t = (x-m)/(s/sqrt(n)) = (567496.8-600000)/(416469.3/sqrt(98)) = -0.7726
p = 0.77918120,
Fail to reject Ho
b) H0 : m = 2100 sq ft; Ha: m > 2100
= 0.01, n = 98, df = 97
From data,
Standard deviation,s = 1103.162
t = (x-m)/(s/sqrt(n)) = (1710.01-2100)/(1103.162/sqrt(98)) = -3.4997
p = 0.99964739,
Fail to reject Ho
c) H0 : p0 = 0.6; Ha: p0 > 0.6
= 0.05, n = 98, df = 97
From data,
P = 58/98 = 0.5918
z = (p – P0) / = (0.5918 – 0.6)/4.866 = 0.001685
p = 0.5007
Fail to reject Ho
d) H0 : p0 = 0.6; Ha: p0 > 0.6
= 0.05, n = 98, df = 97
From data,
P = 37/98 = 0.3776
z = (p – P0) / = (0.3776 – 0.6)/0.04897 = -4.5426
p = 1.0000(approx.)
Fail to reject Ho
All test are right tailed. The proportion wer found using =COUNTIF() function in excel mean using =AVERAGE() function and Std. deviation using =STDEV.S() function
Please check the data that was provided once again
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.