3 The above data set, houses.2017.xls, contains information about the price, siz
ID: 3206488 • Letter: 3
Question
3
The above data set, houses.2017.xls, contains information about the price, size (in square feet), and number of bedrooms of a sample of 200 homes. Please answer the questions below.
Answer
1. a) How many quantitative variables are in this dataset? Name them.
b) How many categorical variables are in this dataset? Name them.
For the variable PRICE, use Excel to answer Q 2 – 7.
2. Q1
3. median
Price SqFt Bedrooms 40250 932 1 61500 780 3 62000 1500 3 62900 760 2 64900 900 2 64900 1206 3 65000 925 3 65000 925 3 67900 672 2 68900 760 2 69500 750 2 69900 1504 3 69900 902 3 69900 1272 2 71000 989 3 72500 1073 3 72900 1100 2 73500 1120 3 75000 1216 3 76900 1030 3 77000 1073 4 77500 1056 3 77900 864 3 78900 864 3 79000 1073 3 79900 1080 3 79900 1288 3 79900 1568 3 79900 1568 3 84900 1107 3 87900 1092 3 89000 1738 3 89900 1384 3 89900 1760 3 89900 864 3 94900 1288 4 95000 1646 3 129900 1488 3 139000 1522 3 139900 1762 3 169900 1568 4 172000 1762 4 185900 2484 3 52000 1370 3 59900 1204 3 59900 1316 3 69900 1142 2 72000 945 3 72500 698 2 72900 766 2 73500 980 3 73900 777 2 73900 912 2 78900 896 3 79900 900 3 79900 1073 3 81500 925 3 82900 941 2 84500 984 3 84900 1108 3 84900 1040 2 84900 1144 3 84900 1250 3 86000 1300 4 86000 1064 3 87500 1064 3 87900 925 3 88000 980 4 88500 978 3 89900 975 3 89900 1405 3 89900 1300 3 89900 1125 3 89900 936 3 91600 1326 3 92800 1026 3 92900 960 3 93500 1416 3 94500 1456 3 94900 1100 3 94900 1560 3 94900 1100 3 95000 2229 4 95000 1296 3 96500 1400 3 99500 864 2 100900 1746 4 101500 1954 3 104000 1124 3 104900 1262 3 105000 1617 4 109900 1663 4 112500 1550 4 113000 1815 3 114900 1581 3 119900 1576 3 122900 1627 3 129900 1445 3 134900 1604 3 144900 1988 3 150000 2322 4 150500 2300 3 159900 2202 4 62000 1000 2 63900 1350 4 65000 853 3 72900 720 2 72900 944 3 72900 932 2 75000 2188 4 76500 925 3 76900 1400 3 79900 1096 3 79900 1300 3 79900 1172 3 81900 796 2 84500 864 2 84900 1350 3 84900 1400 3 89600 1504 3 87000 1200 2 87500 1359 3 88000 902 3 89000 944 2 89000 876 2 89000 1112 3 93900 1230 3 94500 1170 2 94900 1220 3 94900 1462 2 96000 1350 3 96500 1086 3 96900 1260 3 99900 1292 3 99900 1136 3 99900 1299 3 99900 1250 3 101900 1124 3 103500 1627 4 103500 1221 3 104500 1253 3 104900 1200 3 104900 1600 3 104900 1480 3 105000 1440 3 105000 1300 4 105500 1135 3 105900 1216 3 105900 1216 3 105900 1125 3 105900 1125 3 105900 1125 3 105900 1125 3 105900 1418 3 106000 1371 3 107500 1504 3 108500 1464 3 108500 1053 3 109000 1870 4 109500 1214 3 109500 1600 3 109900 1422 3 109900 1307 3 109900 1125 3 109900 1216 3 109900 1125 3 109900 1125 3 109900 1125 3 109900 1216 3 109900 1125 3 109900 1125 3 109900 1125 3 109900 1900 4 109900 1630 3 109900 1550 3 109900 1223 3 109900 1125 3 109900 1088 3 111000 1316 3 111900 1134 3 112000 1449 3 112000 1377 3 112900 1768 3 112900 1042 3 112900 2120 4 113900 1200 3 114500 1580 3 114500 1408 3 114900 1225 3 114900 1225 3 114900 1450 3 114900 1630 3 115000 1712 4 115000 1355 3 115000 1126 3 115900 1329 3 116000 1420 3 116900 1429 3 116900 1344 3 117000 13123
Explanation / Answer
1)
a) There are 3 quantitative variables are in this dataset . They are price, size (in square feet), and number of bedrooms .
b) There is no any categorical variable in this dataset.
2)
a) For the variable PRICE, using Excel
a) First quartile =Q1 =79900 (excel command is =QUARTILE(A1:A200,1))
b) Median=Q2=94900 (excel command is =QUARTILE(A1:A200,2) 0r =MEDIAN(A1:A200))
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.