3 Above is the data set, houses.2017.xls, contains information about the price,
ID: 3207772 • Letter: 3
Question
3
Above is the 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 below questions of this data set.
For the variable PRICE, use Excel to answer Q 2 – 7.
4. range
5. IQR (interquartile range)
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
4)range =maximum-minimum =185900-40250=145650
5)from excel quartile function
Q1 =quartile(array,1) =79900
and Q3=quartile(array,3) =109900
hence interquartile range =Q3-Q1 =109900-79900=30000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.