Excel Statistics Problems

Please complete the homework excel file. The third tab with 6 questions.

price
above AC acres age
basement baths beds car cond
92500 1122 1 0.149 66.5
0
1
2 0 Normal
107000
706 1 0.242 64.3
0
1
2 0 Above Normal
88000
893 1 0.229 60.2
432
1
3 0 Above Normal
160000 1301 1 0.175 54.8
400
1
3 0 Above Normal
170000 1567 1 0.197 89.8
0
2
3 0 Above Normal
161900 1336 1 0.252 73.8
0
2
3 1 Above Normal
62500 1600 1 0.152
97
0
1
3 0 Normal
122000
988 1 0.208 51.8
450
1
3 1 Above Normal
145000 1050 1 0.153 92.1
0
1
2 0 Above Normal
207500 1795 1 0.187 89.8
0
3
3 0 Above Normal
50000
824 1 0.471 96.4
0
1
2 0 Normal
205350 2080 1 0.198 91.4
0
1
3 2 Above Normal
104500 1335 1 0.149 108.2
484
2
3 0 Above Normal
162500 1673 1 0.232 24.8
0
2
3 2 Normal
98500 1056 0 0.161 65.8
0
1
2 0 Above Normal
168700 1567 1 0.162 87.5
0
1
3 0 Above Normal
217250 1589 1 0.364 88.6
0
2
3 0 Above Normal
103000 1008 1 0.234 85.2
0
1
2 0 Above Normal
55000
872 1 0.153 97.8
0
1
2 0 Normal
156700 1402 1 0.482 49.9
600
2
3 0 Above Normal
144000 1303 1 0.155 67.6
0
2
4 0 Above Normal
109000 1108 1 0.193 58.5
400
1
3 1 Above Normal
165000 1393 1 0.202 25.1
0
2
3 2 Normal
87000 1264 1 0.169
100
0
1
2 0 Below Normal
125000 1404 1 0.256 30.9
0
1
4 0 Above Normal
115000
864 1 0.243 58.7
400
1
2 1 Normal
115000
928 1 0.144 11.3
500
1
3 0 Above Normal
119500 1088 1 0.161 75.1
0
1
2 0 Normal
247500 1693 1 0.273 73.9
380
2
3 2 Above Normal
42000 1380 1 0.149 113.9
0
1
4 0 Normal
118000 1008 1 0.166 65.5
0
1
3 0 Above Normal
84000
768 0 0.161 68.1
0
1
2 0 Normal
106480
999 1 0.152 82.6
0
1
2 0 Above Normal
330000 2701 1 0.451 23.5
600
3
4 2 Normal
98000 1010 1 0.484 89.5
0
1
2 0 Above Normal
99500
925 1 0.206 54.3
0
1
3 1 Normal
84900
960 1 0.608 96.2
0
1
2 0 Above Normal
189900 2056 1 0.372 48.6
0
2
4 2 Above Normal
165000 1438 1 0.28 85.5
0
1
2 1 Above Normal
65000
768 0 0.158 89.7
0
1
2 0 Above Normal
180000 1574 1 0.138 80.7
0
2
3 0 Above Normal
119000
892 1 0.183 49.1
400
1
2 0 Above Normal
196000 1456 1 0.173
7.6
600
3
3 2 Normal
35500
890 0 0.156 95.2
0
1
2 0 Normal
163000 1704 1 0.209 51.1
700
1
4 0 Above Normal
64900
996 0 0.289 79.8
0
1
2 0 Below Normal
rooms season toilets
3 spring
0
2 spring
0
2 winter
0
2 fall
1
3 fall
0
3 summer
0
2 winter
0
2 fall
0
4 winter
0
4 fall
0
3 spring
0
4 spring
3
2 winter
0
3 fall
0
2 fall
0
3 spring
0
4 summer
0
3 winter
0
2 fall
0
4 fall
1
3 summer
0
3 spring
0
2 winter
1
3 fall
0
2 fall
0
2 summer
0
2 spring
0
3 winter
0
4 fall
1
4 fall
0
2 summer
0
2 winter
0
3 summer
1
4 spring
1
3 summer
1
2 spring
1
3 winter
0
4 summer
1
5 spring
1
3 summer
0
3 summer
0
3 winter
1
3 summer
1
3 winter
0
3 winter
1
2 fall
0
174000
103390
150000
103600
76000
425000
106000
123500
179000
200000
290000
175000
148000
97500
155000
79000
152000
212000
85000
124000
153500
105000
330000
95000
59000
52200
127000
68500
84000
132500
34150
65000
127000
167000
162000
248500
158000
98000
78000
127500
136000
95000
73800
61750
100000
70000
264500
1542
1019
1620
1409
1019
2538
720
864
1393
2136
2221
1477
1385
1470
1476
905
1699
1400
1052
1400
1382
1298
2389
672
897
1380
1037
870
945
1056
790
1016
1040
1504
1050
1762
1598
1190
1666
824
2114
880
1229
672
1144
1182
2108
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0
1
1
1
1
1
1
0
1
1
1
1
1
0
1
1
1
0.316
0.161
0.319
0.16
0.172
0.445
0.161
0.26
0.499
0.776
0.247
0.193
0.183
0.152
0.175
0.172
0.153
0.174
0.167
0.217
0.131
0.189
0.229
0.177
0.153
0.149
0.139
0.144
0.182
0.218
0.145
0.168
0.468
0.161
0.166
0.2
0.163
0.12
0.3
0.169
0.186
0.145
0.147
0.161
0.172
0.305
0.231
6.4
54.7
58.9
91.4
56.1
108.3
73.6
41.7
85.4
35.3
76.2
73.9
9.4
102.8
60.9
118
62.4
84.6
51.9
44
20.7
55.3
62.3
64.4
65.1
113.9
64.4
63.8
72.8
38.7
93.4
63.5
41.3
84.6
80.4
11.4
90.6
103.6
107
86.8
34.9
27.5
89.8
73.5
56.2
34.4
86.5
0
0
0
0
500
0
350
750
0
0
750
0
0
0
550
0
0
0
0
0
0
0
0
300
0
0
525
0
0
0
0
0
500
0
350
0
850
0
144
0
840
0
0
0
750
0
0
2
1
1
1
1
2
1
2
1
2
2
2
2
2
1
2
2
1
1
1
2
1
2
1
1
1
1
1
1
2
1
1
1
1
1
3
2
1
1
1
2
1
1
1
2
1
2
3
3
3
3
2
4
2
3
2
3
3
2
3
4
3
2
4
3
3
3
3
3
3
2
2
4
3
2
2
4
1
3
3
3
3
3
3
2
4
2
3
2
3
2
3
3
4
2 Normal
0 Normal
2 Above Normal
0 Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
3 Normal
0 Above Normal
1 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
0 Normal
0 Normal
0 Normal
0 Below Normal
0 Above Normal
2 Normal
0 Above Normal
0 Above Normal
3 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
1 Normal
0 Above Normal
2 spring
2 summer
3 fall
2 spring
3 winter
4 spring
2 summer
2 summer
2 spring
3 spring
4 winter
5 fall
2 spring
4 fall
4 fall
5 fall
3 spring
3 summer
2 fall
4 winter
3 fall
2 spring
4 spring
2 spring
2 winter
4 fall
2 spring
3 fall
3 fall
2 summer
3 spring
2 spring
2 spring
3 summer
3 spring
4 spring
3 summer
2 summer
3 fall
4 fall
5 fall
2 spring
2 fall
2 summer
2 winter
3 spring
5 spring
1
0
0
0
0
1
0
0
1
0
1
0
1
0
2
1
0
1
0
1
0
1
0
0
0
0
0
0
0
0
0
0
1
0
1
1
0
0
1
0
0
0
0
0
1
1
0
118000
119000
78000
82500
105500
123000
135000
35000
107500
179900
99000
160000
89300
170000
110000
90000
133500
125000
114900
103000
149900
165000
363500
85000
55000
102500
82500
145000
87500
125000
119500
26000
200000
148000
40000
75000
87000
155000
140000
70000
80000
215120
128000
95000
126000
96000
109000
940
962
1544
1365
1010
1298
1248
864
1040
1304
884
1188
768
1317
864
822
1340
1753
1085
1440
1115
1185
1708
864
864
675
912
1401
922
1400
889
928
1400
853
1796
876
836
1708
1138
856
1168
1695
964
1068
1120
912
1372
1
1
1
1
1
1
0
0
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
0
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0.165
0.161
0.152
0.213
0.172
0.197
0.632
0.117
0.175
0.172
0.149
0.22
0.218
0.271
0.184
0.227
0.176
0.18
0.377
0.152
0.16
0.194
0.48
0.199
0.15
0.152
0.251
0.228
0.185
0.188
0.199
0.149
0.275
0.193
0.176
0.193
0.189
0.231
0.264
0.16
0.629
0.22
0.16
0.408
0.166
0.152
0.172
67.7
98.5
91.8
92.4
92.3
74.7
62.5
109.2
50.4
10.4
57
5.9
50.6
97.6
45
67.6
98.8
89.3
91.6
101.4
5.7
56.4
54.2
102.2
98.2
58.6
93.2
61.9
89.5
42.5
72.2
103.5
6.7
51.6
94.6
67.2
63.8
65.8
54.5
98.9
74.3
1.6
63.9
59.5
6.3
96.6
53.8
216
0
0
0
0
0
700
0
250
0
660
1100
0
0
0
0
0
0
500
0
0
0
800
0
0
450
0
150
432
200
0
0
910
800
144
0
0
0
528
0
0
0
350
350
0
0
0
1
1
1
1
1
1
2
1
1
2
1
2
1
2
1
1
1
2
1
1
2
1
3
1
1
1
1
1
1
1
1
1
3
2
2
1
1
1
1
1
1
2
1
1
2
1
1
2
2
3
3
2
2
2
2
3
2
2
3
2
3
3
2
2
3
2
3
3
3
3
2
2
2
3
2
2
4
3
2
3
3
3
2
2
3
4
2
3
3
2
2
3
2
3
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
2 Normal
0 Below Normal
0 Above Normal
2 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
2 Normal
0 Normal
0 Normal
0 Above Normal
0 Normal
2 Above Normal
0 Above Normal
2 Above Normal
1 Normal
0 Below Normal
2 Normal
1 Above Normal
0 Below Normal
0 Normal
0 Above Normal
0 Above Normal
2 Above Normal
0 Normal
0 Normal
3 Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
0 Above Normal
3 summer
3 spring
3 summer
2 spring
3 winter
3 summer
2 summer
2 winter
2 spring
4 spring
3 fall
2 fall
2 summer
5 summer
2 fall
2 summer
3 fall
4 winter
2 summer
3 spring
2 summer
2 spring
3 winter
2 winter
3 winter
2 summer
6 winter
3 fall
3 spring
3 summer
2 winter
3 spring
2 summer
1 summer
6 summer
2 winter
2 fall
4 fall
2 summer
3 fall
2 winter
4 summer
3 fall
3 spring
2 spring
3 summer
2 summer
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
1
0
1
0
1
0
0
0
0
0
0
0
0
1
0
0
1
0
0
0
0
1
147000
65000
70000
122000
102700
100000
95500
160000
182500
132500
45000
148000
121000
49900
71000
68000
124000
123000
137500
147500
82000
80000
222000
102900
68450
154000
97000
72000
118900
82500
105000
136500
65000
95900
159000
70450
165000
86000
140000
150000
113000
187500
158000
132000
102000
120000
75000
1040
1296
898
1370
1241
1123
912
1571
1800
1157
660
1131
1518
660
786
720
1663
1078
1100
1177
672
1596
2172
868
968
1063
900
864
900
995
1621
1114
1883
662
1342
660
1932
1113
1217
1075
912
1719
1208
858
1056
970
1030
1
1
1
0
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0.19
6.9
0.164 103.6
0.289 62.4
0.222 63.7
0.49 93.7
0.148 38.3
0.175 53.9
0.196 12.3
0.164 10.2
0.163 92.7
0.344 91.8
0.215 58.6
0.255 62.5
0.146 98.2
0.169 62.4
0.172 64.7
0.318 62.2
0.356 42.2
0.227 46.3
0.179 60.7
0.152 73.2
0.893 58.3
0.201
8.9
0.162 72.5
0.152 100.5
0.181
9.9
0.158 40.5
0.152 88.7
0.312 51.5
0.149 75.6
0.182 107.8
0.143 93.6
0.143 59.3
0.203 56.9
0.198 52.3
0.575 88.8
0.208 83.5
0.195 75.5
0.166
15
0.242 48.1
0.186 61.1
0.224 12.6
0.21 17.3
0.2 97.7
0.186 62.6
0.272 52.5
0.146 96.8
0
0
0
0
0
0
0
0
0
0
0
0
300
0
350
0
0
280
650
436
400
0
632
868
0
750
0
0
0
0
0
0
0
0
700
0
700
230
676
600
300
0
676
0
400
400
0
2
1
1
1
1
1
1
2
2
1
1
1
1
1
1
1
1
1
2
2
2
1
4
1
1
2
1
1
1
1
1
2
1
1
1
1
1
1
3
1
1
2
2
1
1
2
1
3
3
2
3
3
3
3
3
3
3
1
3
3
2
2
2
4
3
4
3
2
4
3
2
2
3
3
2
3
3
3
3
4
2
3
2
3
2
4
3
3
3
3
2
2
3
2
0 Normal
2 Normal
0 Normal
0 Normal
0 Above Normal
0 Normal
1 Above Normal
3 Normal
2 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Normal
0 Normal
0 Above Normal
2 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Normal
1 Above Normal
1 Below Normal
2 Normal
0 Above Normal
0 Normal
2 Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 fall
3 summer
2 spring
2 summer
3 summer
3 spring
2 fall
3 spring
3 spring
2 summer
2 fall
2 summer
2 summer
2 winter
2 spring
2 summer
3 winter
2 winter
1 spring
3 summer
2 winter
5 spring
2 fall
2 spring
2 spring
3 fall
2 summer
3 summer
2 summer
2 summer
3 fall
3 summer
2 spring
2 fall
2 spring
2 fall
4 spring
3 spring
4 winter
2 winter
2 winter
4 summer
3 spring
3 summer
2 summer
2 spring
2 summer
0
0
0
1
0
0
0
1
1
0
0
0
1
0
0
0
0
0
0
0
0
1
1
1
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
1
0
1
0
0
0
0
0
122000
77900
129900
31250
53000
115000
131500
109500
108900
119900
37000
79900
75000
104000
69500
94900
127500
160000
209000
187000
88500
35000
44000
79900
75500
144320
122000
141000
105000
170000
260000
202000
99500
149000
165000
78500
161900
98000
80000
103000
200000
320000
59000
90000
184500
126000
80000
1057
784
985
790
1278
744
941
802
802
1202
840
1238
884
1060
1040
1301
1040
1227
1607
1864
1339
660
1468
1209
1209
1224
825
1151
1336
2009
2370
1818
826
1098
1364
740
1104
752
902
1122
1267
1782
1264
1513
2066
844
1088
1
1
1
0
0
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0.154 74.3
0.304 75.5
0.184 55.9
0.146 94.6
0.142
104
0.179 64.9
0.176 42.4
0.199 22.7
0.227 21.4
0.161 96.7
0.159 91.9
0.149 61.4
0.163 53.2
0.135 59.9
0.126 101.8
0.227 65.9
0.663 96.1
0.157 65.3
0.138 90.4
0.285 13.8
0.156 46.4
0.152 47.3
0.129 60.2
0.172 66.7
0.212 47.2
0.381 46.8
0.291 66.5
0.355 32.5
0.207 74.6
0.789 63.4
0.24 41.7
0.501
27
0.152 55.4
0.422 43.8
0.251
1.2
0.26
43
0.258 30.6
0.149 88.7
0.134 50.1
0.192 47.4
0.17 84.6
0.411 59.8
0.336 57.5
0.344 107.9
0.115 121.5
0.165 67.7
0.179 57.1
0
0
0
0
400
0
456
350
743
0
0
0
0
0
0
0
0
0
288
0
0
0
0
0
0
0
300
0
0
260
0
0
0
500
0
350
300
0
250
0
0
700
500
0
0
357
544
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
2
2
2
1
1
1
1
2
1
1
1
2
2
2
1
1
2
2
2
1
2
1
1
3
2
1
2
2
1
3
2
3
2
3
2
2
2
2
2
2
3
3
2
3
4
3
3
3
3
4
2
3
2
3
2
2
2
2
3
4
3
3
3
3
2
3
2
2
3
3
4
2
4
3
2
3
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Below Normal
0 Below Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
3 Normal
0 Normal
0 Normal
0 Normal
0 Above Normal
0 Normal
0 Above Normal
1 Above Normal
2 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Above Normal
0 Normal
0 Normal
2 Normal
0 Normal
2 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
3 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
3 spring
2 spring
2 fall
2 summer
2 fall
2 fall
3 spring
2 fall
2 spring
4 summer
3 fall
2 spring
2 winter
2 fall
3 fall
2 fall
3 winter
2 spring
4 spring
3 fall
3 spring
2 spring
3 winter
2 summer
2 winter
4 fall
3 summer
3 summer
3 summer
3 spring
4 summer
3 winter
2 spring
2 fall
3 spring
2 winter
3 summer
2 summer
3 winter
3 spring
2 summer
4 fall
3 spring
2 fall
4 spring
2 summer
2 winter
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
1
1
0
0
1
0
1
1
1
0
0
0
0
1
125000
110000
127000
54900
147500
193500
88500
54080
112000
210000
100000
225000
70000
79000
108900
133000
110000
140000
100000
89000
160000
113500
90000
108000
175000
182000
124000
126500
106500
141000
80000
122500
105000
114000
65000
67900
127000
80000
82500
30000
126000
129000
139900
57000
85000
49000
64000
1088
929
917
738
1326
2002
907
884
1144
2004
924
2033
768
956
936
950
840
1388
1144
804
1168
1477
672
1068
1458
1688
1282
1102
1877
1932
672
1248
1140
992
1302
764
1134
928
1085
924
1378
1000
1054
960
1336
884
752
1
1
0
0
1
1
1
1
1
1
1
1
1
1
1
1
0
1
0
1
1
1
1
1
1
1
1
0
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0.173 66.5
0.193 26.1
0.164 64.3
0.175 63.5
0.156 11.2
0.239 16.6
0.149 72.6
0.202 57.4
0.23
7.2
0.313 12.9
0.148 59.9
0.152 75.2
0.201
63
0.152 118.8
0.191 58.4
0.172 39.9
0.145 44.1
0.16
74
0.156 56.3
0.161 72.5
0.191 61.6
0.151
89
0.447 94.8
0.155 86.8
0.703 15.5
0.179 87.5
0.447 44.4
0.141 61.9
0.273 41.2
0.208 82.4
0.157 71.8
0.194 51.9
0.344 52.9
0.161 73.4
0.348
56
0.152 96.3
0.175 58.4
0.169 99.9
0.184
51
0.152
102
0.212 56.7
0.574
63
0.194 22.6
0.507 64.4
0.202 109.8
0.193 33.9
0.161 66.7
330
360
450
0
972
900
0
0
0
0
0
0
0
0
468
460
0
0
0
0
0
0
0
352
800
600
0
400
900
700
0
400
560
0
0
350
0
0
0
800
260
550
750
0
0
0
200
1
1
1
1
2
2
1
1
2
2
1
1
1
1
1
1
1
2
1
1
1
1
1
2
3
2
1
2
3
1
1
1
2
1
1
1
1
1
1
1
1
2
1
1
1
1
1
3
3
3
1
3
4
2
3
3
3
3
3
2
2
2
3
3
4
2
2
3
3
2
2
3
3
3
3
3
3
2
2
4
2
3
1
3
2
3
2
4
4
3
2
2
2
2
0 Normal
0 Above Normal
0 Above Normal
0 Normal
2 Normal
2 Normal
0 Above Normal
0 Normal
0 Normal
2 Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Below Normal
1 Above Normal
0 Above Normal
1 Above Normal
0 Above Normal
0 Normal
2 Normal
0 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Normal
0 Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 spring
2 winter
3 spring
2 spring
2 winter
2 summer
2 summer
2 spring
2 winter
3 fall
2 fall
4 winter
2 fall
3 fall
3 spring
2 fall
2 winter
2 winter
2 spring
2 spring
2 summer
3 fall
2 fall
4 fall
2 summer
3 spring
2 spring
2 fall
3 winter
4 spring
2 fall
5 fall
2 fall
3 spring
2 fall
3 spring
3 spring
3 fall
2 fall
4 fall
2 summer
1 fall
2 summer
2 spring
5 summer
2 fall
2 summer
0
0
1
0
0
1
0
0
0
1
0
1
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
1
0
0
0
141000
139900
263000
63000
53000
97500
72420
120000
202000
64900
130000
117000
180000
248500
110000
130000
149900
177500
129900
114500
86500
115000
23000
134000
180000
124500
120000
149500
88000
192500
88000
131000
114460
95000
149500
162500
160000
160000
73000
78000
70000
87500
147370
305000
117000
115000
415000
1208
1360
1909
750
707
690
1449
924
1610
940
992
914
1792
1932
1510
1040
1078
1255
940
1275
765
836
672
1254
2015
864
1020
1192
1344
1740
864
903
948
880
1128
1748
1107
1140
1071
744
1173
781
1404
2288
1040
672
2534
1
1
1
0
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0.154 16.5
0.265 75.3
0.319 92.2
0.172 72.8
0.145 94.2
0.256 64.9
0.139 114.8
0.172 55.7
0.443 78.8
0.155 59.6
0.193 54.4
0.213 46.4
0.218 11.4
0.255 95.5
0.162 104.7
0.179 55.3
0.193 47.1
0.206
9.8
0.165 67.9
0.207
58
0.287 73.8
0.152 103.2
0.172 57.3
0.18 55.3
0.248 49.9
0.462 63.3
0.193 48.6
0.191 55.7
0.119 87.5
0.23 47.5
0.318 59.4
0.482 90.9
0.162 53.6
0.177 73.6
0.184 55.2
0.801 59.3
0.193 64.7
0.784
1
0.152 10.4
0.193 36.4
0.187 94.9
0.153 64.2
0.22 51.8
0.243 53.4
0.19
57
0.161 64.7
0.863
48
676
0
0
0
0
170
0
600
0
0
0
0
500
0
0
600
765
800
0
0
300
0
0
0
0
0
500
0
0
0
200
850
400
0
500
0
216
0
0
0
0
0
1122
120
1040
0
0
2
2
1
1
1
1
2
1
2
1
1
1
3
3
1
2
1
3
1
1
1
1
1
1
2
1
1
1
1
2
1
1
1
1
1
2
2
2
1
1
1
1
2
2
1
1
2
3
2
3
3
2
2
2
3
3
2
3
3
4
3
3
3
3
3
2
3
2
2
2
2
3
3
3
3
3
3
3
2
3
3
3
3
3
3
3
2
2
2
3
4
3
2
4
2 Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Below Normal
0 Normal
2 Above Normal
0 Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Above Normal
2 Normal
0 Normal
1 Above Normal
0 Below Normal
0 Above Normal
2 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Above Normal
3 spring
4 spring
5 winter
2 summer
2 winter
2 fall
5 summer
2 summer
3 summer
2 summer
2 spring
2 spring
2 spring
3 spring
3 summer
2 spring
3 winter
2 fall
3 fall
3 fall
2 summer
2 winter
2 spring
3 spring
3 fall
2 spring
3 summer
2 summer
4 summer
3 summer
3 spring
2 fall
2 summer
2 summer
3 winter
4 spring
3 summer
2 winter
2 spring
2 spring
4 fall
2 winter
4 fall
4 spring
2 fall
2 summer
5 fall
0
0
1
0
0
0
1
0
0
0
0
1
1
0
0
1
1
0
0
0
0
0
0
1
1
0
1
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
1
1
0
0
1
125000
107000
45000
110000
185000
125000
155000
84500
340000
101000
65000
121400
102000
135000
125000
91000
115000
97750
75000
269000
141500
167000
153000
75000
93500
104500
118650
175000
133000
188000
96000
154000
175000
87400
150000
48000
112000
171000
153500
219000
142000
150000
79000
114000
186000
96500
110000
1352
1128
1080
936
1672
936
1416
720
2272
816
720
1092
960
1096
1390
653
932
1019
1632
2306
1500
1047
1870
950
1170
894
924
1394
1384
2026
1555
1808
1328
1008
1672
864
781
1100
1590
1470
1303
1627
672
1412
1750
768
1848
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
0.112 88.2
0.3 104.9
0.16 91.7
0.207 56.7
0.157 81.7
0.193 58.9
0.258 57.3
0.152 63.8
0.262 44.1
0.263 55.3
0.152 33.3
0.238 56.5
0.422 60.5
0.212 45.6
0.241 60.4
0.249 64.3
0.354 66.3
0.299 96.4
0.186 94.8
0.496
20
0.272 59.8
0.31 53.5
0.271 40.1
0.152 104.6
0.193 52.5
0.194 58.7
0.168 21.7
0.146
2.9
0.181 51.3
0.275 44.4
0.153 98.1
0.193 51.4
0.242
9.9
0.172 64.4
0.225 90.5
0.158 94.6
0.186 42.4
0.178 49.6
0.277
9.5
0.243
8
0.152 55.6
0.153 61.4
0.216 40.1
0.264 64.3
0.239 54.6
0.203
101
0.224 94.6
0
0
0
0
0
480
0
0
150
400
0
0
0
400
0
0
150
0
0
800
450
0
0
0
0
600
400
550
830
0
0
0
0
0
0
0
600
288
0
909
0
0
0
0
720
0
0
1
1
1
1
1
1
1
1
2
2
1
1
1
2
1
1
1
1
1
3
1
1
2
1
1
1
1
2
2
2
1
1
2
1
1
1
2
2
2
3
1
1
1
1
1
1
1
3
3
2
3
4
2
3
2
3
2
2
3
3
3
3
2
2
2
3
4
3
3
3
3
2
2
2
3
3
3
3
3
3
3
2
2
3
3
3
3
3
3
2
3
3
2
4
1 Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Above Normal
0 Above Normal
2 Above Normal
1 Above Normal
1 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
2 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
1 Normal
1 Above Normal
1 Normal
2 Normal
0 Above Normal
2 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
2 Normal
3 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
3 winter
2 fall
4 summer
2 summer
3 summer
3 fall
2 spring
2 fall
4 winter
2 winter
2 spring
2 summer
2 spring
2 summer
2 spring
2 spring
3 spring
4 spring
4 summer
4 fall
3 fall
2 spring
3 winter
3 summer
2 spring
2 summer
2 summer
3 fall
2 spring
2 spring
4 winter
3 spring
2 fall
2 spring
6 spring
3 summer
1 spring
2 summer
3 summer
2 winter
3 summer
4 spring
2 winter
3 spring
2 summer
3 fall
3 summer
0
1
0
0
1
0
2
0
1
0
0
0
0
1
0
0
0
0
1
1
0
1
0
0
0
0
0
1
0
0
0
1
0
0
0
0
0
0
1
0
0
0
0
1
1
0
0
113500
80000
312000
59000
142900
107500
80070
95200
169900
178000
132000
115000
114000
215000
144000
122500
91000
155000
123500
133450
365000
108000
125000
197000
85000
179900
159000
118550
126000
78000
105000
141270
129000
87500
116500
162500
134000
195000
141000
213500
124900
158000
111500
95000
96000
95000
125000
1320
1452
2602
906
1311
845
880
751
1209
1601
1496
774
888
1749
1052
1050
1188
1034
1140
1579
1713
988
1048
1520
1060
1540
1721
1395
1008
888
820
1148
1006
676
1556
1830
1229
1320
1164
1657
948
1394
1040
780
907
900
1372
1
1
1
0
1
1
1
1
1
1
1
0
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
0
1
1
1
1
1
1
1
1
1
1
0.15 103.6
0.162 76.5
0.159 53.4
0.115
109
0.139 91.7
0.184 63.4
0.47 94.5
0.227 75.4
0.193 50.3
0.165 94.6
0.16 101.7
0.138 51.4
0.147
75
0.46 50.5
0.174 52.5
0.18 47.3
0.195
59
0.187 44.1
0.315 64.2
0.768 68.1
0.48 54.2
0.861 41.4
0.188 48.9
0.171 90.5
0.153 48.4
0.187 25.6
0.24 20.2
0.146 63.3
0.321 39.6
0.202 40.9
0.128 91.9
0.178 59.4
0.145 54.4
0.156 60.7
0.152 67.2
0.207 101.6
0.275 71.8
0.161 10.7
0.278 11.2
0.249 89.6
0.248 55.3
0.144 19.6
0.145 49.8
0.24 60.5
0.161 74.1
0.152 91.6
0.276 58.9
0
0
0
0
0
400
0
0
888
853
260
670
0
800
260
900
0
150
0
0
800
0
520
225
0
0
920
0
360
344
0
570
550
0
0
720
0
500
0
0
0
0
0
0
300
0
0
1
1
2
1
1
1
1
1
1
2
2
2
1
2
1
2
2
1
1
1
3
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
2
1
2
2
2
1
1
1
1
1
3
4
4
2
3
2
2
2
4
3
3
2
2
5
3
4
4
3
2
2
3
3
3
3
3
3
3
4
2
3
2
3
3
2
4
3
3
2
3
4
2
3
2
2
2
2
3
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Above Normal
0 Above Normal
0 Above Normal
1 Above Normal
0 Above Normal
1 Normal
0 Normal
2 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Above Normal
0 Normal
2 Normal
0 Above Normal
0 Above Normal
2 Normal
0 Normal
0 Normal
0 Above Normal
0 Above Normal
2 Above Normal
3 summer
3 spring
4 spring
3 winter
2 summer
2 spring
2 spring
3 spring
1 spring
5 summer
3 summer
2 spring
3 fall
1 spring
2 summer
1 spring
2 fall
2 winter
2 winter
5 winter
3 winter
2 spring
2 fall
3 spring
3 spring
3 summer
3 winter
2 spring
3 summer
2 fall
3 fall
3 spring
2 spring
2 summer
2 winter
3 summer
2 fall
3 summer
2 winter
3 summer
2 winter
3 summer
3 fall
2 summer
3 winter
4 summer
2 fall
0
0
0
0
0
0
0
0
1
0
0
0
0
1
1
0
0
1
0
0
0
0
0
1
0
1
1
0
1
0
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
143500
60000
112900
87000
165000
75000
55000
320000
190900
144000
32000
168000
135500
154900
98000
180000
138900
145000
55000
182900
125000
175000
28000
54900
91650
88500
155600
82500
137000
51000
291500
119500
58900
72000
87900
108700
167900
220000
149500
125500
228500
167500
132900
66500
71500
116000
52500
1060
1554
720
897
1994
760
672
2542
1568
1032
744
1486
966
1249
768
1583
1529
1390
720
1788
1177
1628
744
1486
998
1192
1565
864
930
752
2009
1408
720
680
860
1018
1356
1786
1541
820
2270
1536
960
1057
904
948
768
1
0
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
0.179 49.5
0.163 94.9
0.18 76.3
0.179 66.9
0.559 52.2
0.146 67.1
0.11 64.1
0.277 79.1
0.252
1.5
0.156 10.6
0.352 83.7
0.137 11.3
0.226 40.3
0.166 74.5
0.145
87
0.416 18.8
0.184 74.6
0.165 67.3
0.328 38.5
0.215 56.5
0.187
60
0.239 18.3
0.119 96.7
0.867 98.6
0.184 67.8
0.187
100
0.165 62.9
0.129 58.5
0.172 48.5
0.161 88.8
0.258 66.8
0.237 58.7
0.152 88.6
0.122 56.5
0.18 88.8
0.172 61.8
0.223 15.7
0.221 16.4
0.204 23.7
0.329 41.5
0.367 23.2
0.18 76.4
0.248 90.8
0.138 108.6
0.207 58.6
0.197 57.3
0.178 53.7
580
0
612
150
500
0
0
400
0
0
250
600
0
0
0
0
0
400
0
600
0
400
0
0
0
0
550
0
530
0
0
0
0
0
0
400
0
728
0
768
0
450
0
0
0
0
0
1
1
2
1
2
1
1
3
2
1
1
2
1
1
1
2
2
2
1
1
1
3
1
2
1
1
1
1
2
1
2
2
1
1
1
1
2
3
2
2
2
3
1
1
1
1
1
3
2
2
3
3
2
2
4
3
3
1
3
3
3
2
2
3
4
2
3
3
3
1
4
2
3
4
2
4
2
3
3
1
2
2
2
3
3
3
3
4
3
2
2
3
3
2
0 Above Normal
0 Below Normal
0 Above Normal
0 Above Normal
3 Normal
0 Above Normal
0 Above Normal
2 Above Normal
2 Normal
0 Normal
1 Below Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Below Normal
0 Below Normal
1 Above Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
2 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
3 Normal
2 Normal
0 Above Normal
3 Normal
1 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Normal
2 summer
5 fall
2 spring
1 fall
3 winter
2 winter
2 winter
3 winter
2 spring
2 summer
2 summer
3 spring
2 spring
2 spring
3 fall
3 fall
3 summer
3 spring
2 spring
3 summer
3 winter
3 spring
3 summer
3 summer
3 fall
3 fall
2 fall
2 summer
1 spring
2 summer
3 fall
2 summer
2 summer
2 summer
3 fall
2 fall
2 summer
3 spring
2 summer
1 spring
3 winter
2 spring
4 fall
4 summer
2 summer
2 spring
2 summer
0
0
0
0
1
0
0
0
1
0
0
1
0
1
0
1
0
0
0
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
1
0
1
0
0
0
0
1
0
99900
87000
53000
60000
94900
121500
140000
116500
190500
113000
119000
134000
158000
45000
120000
136000
125000
69900
117500
111000
104000
340000
126000
90000
58000
318000
68000
154500
88500
78000
128500
80000
93000
86000
237000
77500
129900
123500
127500
240000
135000
69500
93000
105000
85000
123500
80250
1056
720
630
1200
1145
1080
1193
1036
1554
1298
1270
1598
1235
660
1176
1678
1166
672
858
829
1144
2258
720
1404
1144
2279
984
1285
1026
1080
1026
1318
946
956
2459
1173
897
980
1080
1624
1452
984
1030
1036
922
1331
1363
1
1
0
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0.152 99.6
0.193 56.9
0.146 96.9
0.145 88.5
0.172 62.8
0.196 65.2
0.264
11
0.217 50.6
0.212
1.4
0.521 91.8
0.329 63.1
0.356 66.5
0.286 63.2
0.152 47.4
0.172 54.9
0.258 75.8
0.176 62.6
0.26 60.6
0.228 36.7
0.145 56.3
0.16 64.6
0.153 55.9
0.2 63.9
0.235 60.8
0.262 55.5
0.372 89.5
0.238 61.9
0.189 66.5
0.152 90.4
0.15 51.8
0.179 24.2
0.254 51.8
0.174 56.5
0.161 63.2
0.555
100
0.154 103.5
0.177 63.7
0.162 74.9
0.515 60.8
0.23 26.8
0.2 54.7
0.115 101.7
0.474 42.1
0.241 49.9
0.152 20.6
0.171 61.7
0.451
64
320
300
0
0
0
0
0
0
0
0
0
0
350
0
260
400
0
0
400
0
0
0
0
0
0
600
0
0
0
0
500
0
0
0
0
0
570
0
0
400
550
0
200
450
0
0
0
1
1
1
1
1
1
2
1
2
2
2
1
1
1
1
1
1
1
2
1
1
2
1
1
1
2
1
1
1
1
2
1
1
1
1
1
1
1
1
2
2
1
2
1
1
1
2
3
2
1
3
3
2
3
3
3
3
3
3
3
2
4
3
2
2
3
2
3
4
2
4
3
3
2
3
2
2
3
3
3
2
3
3
2
2
3
3
3
2
2
2
3
4
4
0 Above Normal
0 Normal
0 Above Normal
1 Below Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
2 Normal
0 Normal
0 Above Normal
1 Above Normal
0 Above Normal
0 Normal
1 Above Normal
2 Above Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Normal
0 Normal
0 Above Normal
1 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
2 Above Normal
0 Above Normal
0 Normal
0 Normal
0 Normal
0 Normal
0 Normal
0 Above Normal
3 summer
2 fall
3 fall
1 spring
2 fall
4 winter
2 winter
2 summer
3 spring
4 summer
3 winter
3 spring
3 winter
2 spring
2 fall
4 fall
3 summer
2 summer
2 summer
2 spring
2 summer
6 fall
2 fall
2 fall
2 summer
4 spring
3 fall
2 spring
3 spring
3 fall
2 winter
3 fall
2 summer
2 winter
4 fall
3 spring
3 summer
3 fall
2 fall
2 fall
3 summer
3 summer
3 winter
2 fall
2 summer
2 summer
2 fall
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
1
0
0
0
106420
80000
203000
260000
66500
103000
130000
174900
142500
340000
156000
123500
123900
264900
132000
66500
75000
230000
124000
125500
35000
76440
45000
144500
319000
129000
111000
179000
75000
221500
29200
145000
135000
115000
140000
165000
130000
202000
194000
112900
104000
88000
85000
115000
54000
95000
109900
978
720
1972
1512
1020
1057
1008
1424
1052
2605
1580
2025
1090
2060
952
1107
864
1830
1363
1232
822
1080
664
1096
1760
1052
1152
1578
834
1401
826
1578
997
1235
1126
1136
912
2388
1473
928
960
777
1057
1374
704
1330
1635
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
0
1
0
1
1
1
1
1
0
0
1
1
0
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0.248
0.161
0.229
0.232
0.276
0.312
0.175
0.283
0.184
0.201
0.22
0.183
0.142
0.184
0.16
0.178
0.205
0.277
0.439
0.167
0.126
0.448
0.153
0.254
0.312
0.195
0.135
0.387
0.152
0.189
0.152
0.188
0.198
0.18
0.213
0.189
0.172
0.2
0.178
0.171
0.179
0.235
0.189
0.159
0.153
0.271
0.174
55.6
91.1
12
76.2
54.7
50.1
26.9
57.6
64.4
66.1
50.3
98.7
65.5
48.9
93.5
53.1
57.2
9.5
48.7
67.3
88.4
14.6
94.5
10.6
53.4
50.5
95.7
21.3
65
98.6
102.7
41.5
55.5
63.3
42.6
11.3
56.4
99
5.8
61.3
29.8
100.6
56.2
120.2
99.9
101.7
91.6
0
0
800
470
400
300
960
588
0
0
384
0
450
280
0
0
0
0
310
440
0
0
0
680
800
494
300
600
0
0
0
336
0
850
260
600
400
350
0
0
300
0
0
0
0
0
144
1
1
2
1
1
1
2
2
1
3
1
1
1
2
2
1
1
2
2
2
1
2
1
1
3
1
1
3
1
2
1
1
1
1
1
2
1
2
2
1
1
1
1
1
1
1
1
3
2
3
3
3
2
3
3
3
4
4
5
3
3
3
3
3
3
4
3
2
3
2
3
4
3
3
4
2
3
2
4
3
3
3
3
2
3
3
2
3
2
2
3
4
2
3
0 Above Normal
0 Normal
3 Normal
2 Above Normal
0 Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Below Normal
0 Normal
3 Normal
2 Normal
0 Above Normal
0 Normal
0 Normal
0 Normal
2 Normal
2 Normal
0 Above Normal
0 Above Normal
2 Normal
0 Normal
0 Above Normal
0 Normal
2 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
0 Above Normal
0 Above Normal
2 Normal
1 Above Normal
0 Normal
0 Above Normal
1 Normal
0 Above Normal
2 Above Normal
0 Normal
0 Above Normal
2 summer
2 winter
3 winter
3 winter
2 summer
2 winter
2 fall
3 summer
2 spring
3 winter
3 spring
2 summer
2 summer
4 fall
3 spring
2 winter
2 winter
2 summer
2 summer
3 spring
3 spring
2 summer
2 spring
3 summer
2 spring
2 spring
3 summer
1 spring
2 fall
4 summer
2 summer
3 spring
2 spring
3 winter
2 summer
3 spring
2 spring
6 fall
2 fall
3 winter
2 fall
1 summer
3 winter
3 winter
2 fall
3 summer
3 summer
0
0
1
1
0
0
0
1
0
0
1
1
1
1
0
1
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
2
0
1
2
1
1
1
1
0
0
0
0
1
0
0
0
87500
100000
114000
106000
138000
54000
113000
135000
90000
39160
107000
75140
134900
250000
53000
102000
270000
97500
81000
75000
325000
175000
85000
81000
162000
69500
65000
80000
111000
152500
385000
130000
47000
76300
79600
100000
134000
51500
119900
105000
140000
169200
59900
125000
64000
87500
160000
900
875
769
997
1178
778
1071
1482
1050
852
996
792
1834
1624
1971
840
1964
975
1248
864
2650
1920
1158
940
1196
987
768
1075
1037
1290
2342
1372
704
768
1305
798
1001
680
996
1031
1430
1211
1148
1332
1032
774
1249
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
0
1
1
1
1
0
0
1
0
1
1
1
0
1
1
0.149
0.193
0.235
0.158
0.161
0.157
0.241
0.232
0.183
0.153
0.193
0.172
0.379
0.901
0.193
0.119
0.414
0.161
0.195
0.11
0.601
0.23
0.262
0.169
0.3
0.118
0.145
0.172
0.19
0.427
0.627
0.172
0.112
0.118
0.189
0.468
0.16
0.327
0.179
0.442
0.238
0.213
0.16
0.176
0.496
0.17
0.266
88.3
28.2
75.4
56.6
91
90.4
53.3
49.4
61.2
85.1
65.2
61.5
60.5
46.5
58.8
90.3
59.8
52.3
100.4
89.1
71
9.4
61.3
63.1
57.9
74.6
91.1
114.4
44.3
31.1
24.5
39.8
62.1
94.9
113.6
32.5
64.3
96.4
67.9
94.3
103.9
50.5
74.9
65.4
48.8
64.8
94
360
0
0
0
0
0
294
256
0
0
0
0
0
1140
0
0
600
150
300
0
1200
0
0
0
0
0
200
0
0
0
1000
0
0
0
0
350
564
0
0
0
0
1000
0
0
0
0
0
1
1
1
1
1
1
1
2
1
1
1
1
1
2
3
1
2
1
1
1
3
2
1
1
2
1
1
1
1
1
3
2
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
2
3
2
3
2
2
3
3
3
2
3
2
3
4
3
2
3
3
3
3
4
4
2
2
3
2
2
2
3
3
3
3
2
2
3
3
3
1
2
3
3
3
4
2
2
2
3
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
1 Normal
1 Above Normal
0 Below Normal
2 Normal
0 Above Normal
0 Above Normal
2 Above Normal
0 Below Normal
0 Above Normal
2 Normal
0 Normal
0 Below Normal
0 Above Normal
0 Above Normal
3 Normal
1 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
1 Above Normal
0 Below Normal
1 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 spring
2 winter
2 spring
2 summer
4 fall
2 spring
2 spring
3 spring
2 winter
2 winter
2 winter
3 spring
7 spring
3 spring
4 fall
3 spring
3 fall
2 spring
3 spring
2 winter
2 fall
3 spring
2 spring
3 winter
2 fall
4 summer
2 winter
3 spring
2 spring
2 winter
2 spring
3 fall
2 winter
2 fall
4 summer
2 summer
2 spring
3 spring
2 fall
3 winter
3 fall
1 summer
2 fall
4 spring
3 fall
2 fall
3 fall
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
1
1
0
0
1
0
0
0
0
1
1
1
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
50000
81600
136000
174000
121000
95000
84750
174000
138000
123500
131000
123750
50000
63000
189000
172200
105900
90000
96750
75000
141000
104900
85000
139000
115000
80000
119900
80000
77000
139000
107000
175000
215500
87000
113000
55700
199000
146690
164900
94000
185500
41000
92500
131000
109000
119000
60000
936
760
1495
1248
888
876
902
1732
1063
1176
1144
1012
872
918
1439
1568
780
940
751
1035
1316
844
1110
876
1937
1436
963
950
1761
1147
1292
1318
2319
1012
1372
660
2004
2212
1474
1038
1727
700
660
1114
916
1288
770
0
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
0.172 43.6
0.14 42.1
0.242 41.8
0.469 68.5
0.161 48.1
0.218 58.2
0.17 86.5
0.207 13.5
0.15 63.9
0.163 57.4
0.168 53.5
0.2 59.9
0.156
93
0.454 95.5
0.156 13.7
0.218 16.7
0.196 66.6
0.178 56.8
0.2
67
0.152 89.7
0.171 66.6
0.16 62.3
0.169
98
0.149 90.6
0.152
59
0.172 63.5
0.321 19.3
0.168 55.2
0.227 63.5
0.207 55.8
0.175 58.3
0.22 13.6
0.23
9.3
0.172 54.9
0.172 42.4
0.367 73.3
0.258 46.8
0.129 76.1
0.177
4.7
0.152 35.5
0.328 36.4
0.16 55.2
0.162 91.3
0.161 31.6
0.115 36.5
0.147 105.9
0.149
103
0
0
0
0
800
0
350
0
350
350
0
500
0
0
860
0
0
0
0
0
700
0
0
0
0
0
0
0
0
500
400
0
0
0
0
0
0
400
0
515
400
400
0
0
720
0
0
1
1
1
2
2
1
2
2
3
1
1
1
1
1
3
1
1
1
1
1
1
1
1
1
3
1
2
1
1
1
1
2
2
1
1
1
2
1
2
1
2
1
1
1
1
1
1
3
2
4
2
3
3
2
3
3
2
4
2
2
3
2
3
2
3
2
3
3
2
2
2
3
3
3
3
3
3
3
2
4
3
3
2
4
3
3
2
3
2
2
2
3
3
2
0 Above Normal
0 Above Normal
2 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
1 Above Normal
0 Normal
0 Normal
2 Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
3 Normal
0 Above Normal
0 Above Normal
0 Normal
2 Above Normal
0 Above Normal
2 Normal
0 Above Normal
2 Above Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
2 summer
3 winter
4 fall
2 summer
2 winter
2 winter
2 spring
2 summer
2 fall
3 spring
2 spring
2 fall
3 fall
2 spring
3 summer
2 summer
2 summer
2 fall
3 fall
3 summer
2 summer
2 spring
4 winter
3 summer
4 fall
3 summer
2 spring
2 winter
3 spring
3 fall
2 spring
3 summer
2 spring
2 fall
2 spring
2 spring
4 summer
4 winter
3 fall
2 spring
5 spring
2 winter
2 spring
3 summer
2 spring
3 fall
2 fall
0
0
1
0
1
0
0
1
0
0
1
1
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
1
1
0
1
1
1
0
1
1
1
0
1
0
0
1
1
1
0
104500
185000
146500
172500
80000
193000
67100
120000
103000
125000
101000
207000
86500
109500
117900
133000
73000
100000
86000
78000
185000
27500
75000
55000
119900
165000
93500
133500
385000
135000
115000
122000
160000
193500
220000
85000
79900
127900
140000
219000
115000
129000
127000
80000
116000
39020
128750
1460
2371
1360
1681
1312
2523
864
1416
864
905
840
1960
1227
1013
832
1094
1272
744
637
992
1740
1474
816
777
876
1020
1992
1038
2227
894
1504
1602
1635
2046
1775
1322
1016
1032
1092
2240
1021
1338
1012
779
1451
624
1198
0
1
1
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
0
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
0
1
0.126
0.371
0.162
0.223
0.367
0.226
0.164
0.266
0.199
0.316
0.235
0.199
0.108
0.194
0.163
0.369
0.135
0.192
0.242
0.158
0.18
0.138
0.152
0.117
0.174
0.231
0.152
0.199
0.255
0.196
0.158
0.461
0.245
0.188
0.383
0.333
0.237
0.289
0.292
0.255
0.164
0.16
0.166
0.155
0.223
0.437
0.277
58.6
31.3
76
92.6
59.5
21.7
64.7
62
58.2
38.3
51.8
89.4
62.9
93.2
89.7
42.5
114.3
45.8
64.7
92
73.6
102.6
55.9
99.5
59.3
64.5
59.4
74.7
90.4
36.9
85.4
105.1
14.3
16.4
84.4
59.3
60.4
16.7
51.3
11.9
100.8
86.3
68.4
41.8
82.4
81.6
48.9
0
450
0
0
0
0
0
708
0
600
0
0
0
0
0
500
0
0
0
0
0
0
0
0
400
0
0
446
1000
500
0
350
0
0
0
0
0
900
500
700
450
0
200
0
0
0
1042
2
3
1
1
1
2
1
1
1
1
1
1
1
1
1
2
1
1
1
1
1
1
1
1
1
1
1
2
2
1
2
2
2
2
1
1
1
2
1
3
1
1
2
1
1
1
2
2
4
3
3
3
3
3
3
2
2
3
3
4
3
2
3
3
2
2
2
3
4
2
2
2
2
5
2
3
3
3
4
4
4
3
2
2
3
3
4
2
3
2
2
3
2
1
0 Above Normal
3 Above Normal
0 Above Normal
0 Above Normal
0 Normal
2 Normal
0 Above Normal
2 Normal
0 Normal
0 Above Normal
0 Normal
1 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
1 Below Normal
0 Above Normal
0 Normal
0 Above Normal
1 Above Normal
0 Above Normal
1 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
3 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Normal
0 Above Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Below Normal
0 Above Normal
5 summer
4 spring
4 winter
5 summer
2 spring
5 fall
2 summer
3 winter
3 winter
3 spring
2 fall
3 spring
1 fall
2 winter
2 summer
3 spring
3 spring
3 summer
2 summer
2 winter
4 summer
4 summer
2 fall
3 spring
3 spring
3 spring
3 spring
5 summer
3 spring
2 fall
4 spring
3 winter
2 spring
4 spring
3 spring
3 spring
2 spring
2 summer
3 spring
4 fall
3 fall
4 spring
2 spring
3 fall
3 spring
2 summer
3 fall
0
1
0
1
0
1
0
1
0
0
0
1
0
2
0
0
0
0
0
0
1
0
0
0
0
0
1
0
1
1
0
0
1
1
1
0
0
0
0
1
0
1
0
0
0
0
0
120000
190000
105000
80000
97000
170000
110000
74500
79500
85000
53500
41500
115000
345000
150000
100000
97500
50000
98000
76000
125600
116000
123000
112000
85900
154900
140000
113620
129000
460000
165000
77400
86000
117500
86500
40000
91500
150000
167500
35000
48000
160000
106000
115000
124900
187000
2037
1479
997
1088
912
1333
1290
796
864
924
1052
808
1334
2573
1359
1120
912
640
1242
876
942
1796
1037
918
864
1548
1876
1583
1032
2480
1708
889
736
816
778
1176
894
1400
1451
728
1230
1377
942
1326
1008
1468
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
1
0
0
1
1
1
1
1
0.179
0.16
0.295
0.155
0.207
0.166
0.187
0.165
0.107
0.161
0.104
0.162
0.143
0.4
0.173
0.196
0.22
0.18
0.234
0.164
0.217
0.172
0.244
0.172
0.199
0.193
0.296
0.153
0.205
0.405
0.213
0.274
0.146
0.22
0.169
0.117
0.233
0.208
0.209
0.215
0.135
0.16
0.227
0.341
0.409
0.31
50.2
62.4
13.2
118.3
57.6
61.8
10.3
60.8
60.3
58.6
113.5
118.5
58.7
103
13.2
53.6
58.8
92
7.3
77
36.8
96.8
46.6
59.3
56.8
85.6
66.1
91.9
9.4
85.1
58.5
97.8
74.3
37.3
94
62
101.5
14
91.3
53.6
114.9
67
94.6
73.5
58.3
10.8
0
0
0
0
0
390
110
0
0
0
0
0
0
0
0
0
0
0
0
0
600
315
600
0
0
350
350
0
624
520
300
0
360
0
0
0
0
0
0
0
0
0
0
0
0
0
2
2
1
1
1
1
2
1
1
1
1
1
1
2
2
1
1
1
2
1
1
1
1
1
1
1
1
1
1
3
2
1
1
2
1
1
1
2
1
1
1
1
1
1
1
2
4
4
3
3
3
3
3
2
3
3
2
2
3
4
3
3
2
2
3
2
3
4
2
3
3
3
3
3
3
3
3
2
2
4
2
3
2
3
3
2
3
3
3
2
3
3
1 Normal
0 Above Normal
0 Normal
0 Below Normal
0 Normal
0 Above Normal
0 Normal
1 Normal
0 Below Normal
0 Above Normal
0 Below Normal
0 Below Normal
0 Normal
0 Above Normal
0 Normal
1 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
0 Above Normal
1 Above Normal
0 Normal
0 Above Normal
0 Above Normal
0 Normal
2 Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Normal
2 Normal
0 Above Normal
0 Normal
0 Below Normal
0 Above Normal
0 Above Normal
0 Above Normal
0 Above Normal
2 Normal
2 winter
2 spring
2 spring
2 winter
2 summer
2 fall
2 spring
2 fall
2 spring
3 summer
5 spring
3 spring
2 summer
6 fall
3 winter
2 summer
2 fall
2 fall
2 spring
3 fall
2 fall
4 fall
3 summer
2 spring
2 fall
3 summer
4 winter
3 fall
2 spring
3 winter
4 spring
2 summer
2 spring
4 spring
3 fall
2 fall
2 spring
2 fall
2 spring
3 summer
3 fall
4 fall
2 summer
4 spring
2 spring
3 fall
0
0
1
1
0
1
0
0
0
0
1
0
0
1
1
1
0
0
0
0
0
0
0
0
0
1
1
0
0
0
1
0
1
0
0
1
1
1
1
0
0
1
0
1
0
1
walkout
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
price
above
AC
acres
age
basement
baths
beds
car
cond
rooms
season
toilets
walkout
price the home was sold for
above ground living space (sq ft)
1 if home has air conditioning, 0 if not
size of lot home sits on (acres)
age of home at time of sale
below ground finished living space (sq ft)
number of full- or 3/4-baths
number of bedrooms
number of covered stalls for parking cars
overall condition of home (BelowNormal, Normal, or AboveNormal)
number of rooms, which are not bedrooms
season at time of sale (winter, spring, summer, or fall)
number of 1/2-baths
1 if home has a walkout basement, 0 if not
Data collected from Polk County (Iowa) Assessor
http://www.assess.co.polk.ia.us/index.html
List names of all group members here:
State the base case you chose for the “Season” variable:
State the base case you chose for the “Condition” variable:
1) (2 points) Using the Principle of Parsimony method outlined in the module videos, provide the final regression equation th
price in terms of the remaining significant X-variables. Work for this problem should be shown in separate Exce
When writing the equation for this question, you may round your intercept and slope coefficients to nearest hu
Final Regression Equation:
2) (1 point) Based upon the final regression equation, what does the model predict for the price of a house with the followin
(Use exact values from final regression output in your calculations. Answer cell should show formula/cell refere
above
1100
AC
1
acres
0.65
age basement
75
300
baths
2
beds
2
car
1
Predicted Price:
3) (2 points) Based upon the final regression output, discuss 1 reason supporting the statement that the coefficient on the “R
and discuss 1 reason supporting the statement that the coefficient on the “Rooms” variable doesn’t make sense
(One or two sentences for each supporting point is sufficient.)
The coefficient on the “rooms” variable makes sense because:
The coefficient on the “rooms” variable doesn’t make sense because:
4) (1 point) Based upon the final regression output and using the rule of thumb outlined in the module videos, is the standar
Highlight the correct answer and provide a brief justification/work.
Yes
No
Justification:
5) (1 point) Based upon the final regression output, do the residuals appear to be independent of the “AC” variable?
Highlight your answer and provide a brief justification. Place a copy of the AC residual plot here, and refer to it
Yes
No
Justification:
6) (1 point) Based upon the final regression output, are the residuals normally distributed? Must show work in form of a his
Highlight your answer, and place your histogram/justification to the right.
Consider using bin-widths (groupings) in your histogram of 10,000 with a minimum of -175,000 and a maximium
Yes
No
Place histogram here:
the final regression equation that models
hould be shown in separate Excel spreadsheets in form of regression outputs.
d slope coefficients to nearest hundredth.
rice of a house with the following characterstics:
should show formula/cell reference/work.)
cond
Normal
rooms
5
season
spring
toilets
1
walkout
1
ent that the coefficient on the “Rooms” variable makes sense,
ms” variable doesn’t make sense.