Please see the questions below. Questions 1-5 are to be answered from the data spreadsheet provided

Description


Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Assignment on
Please see the questions below. Questions 1-5 are to be answered from the data spreadsheet provided
From as Little as $13/Page

PRICE
ASSESVAL MBMANCLS
281,700 275,800
90
356,800 312,500
140
366,600 303,600
90
345,300 339,700
140
361,100 316,300
90
373,500 301,700
90
331,400 321,100
90
350,300 337,600
90
356,400 311,300
90
475,900 396,400
140
416,800 338,000
140
290,200 268,700
90
311,900 277,800
90
328,800 296,100
140
316,900 288,800
90
373,700 332,100
140
426,900 330,300
140
311,900 287,700
90
302,500 268,700
90
373,000 309,500
140
302,100 276,600
140
379,700 358,900
140
310,300 288,400
90
314,600 245,000
90
502,700 439,000
140
375,000 341,000
90
311,500 297,300
140
359,400 340,700
140
336,000 286,200
90
356,100 281,400
90
345,400 292,000
90
280,900 255,800
90
346,800 297,200
90
477,200 430,800
140
381,200 351,500
140
354,300 290,500
90
341,700 334,600
90
378,500 342,200
140
331,800 266,800
90
367,000 345,500
140
584,400 510,600
140
320,100 303,500
90
297,200 272,500
90
305,000 261,600
90
416,300 390,900
140
AGE
BEDROOMS BATHS FAMILYRM FIREPLCS LIVAREA
25
3
1.50
1
0
1,605
25
3
2.00
1
2
1,727
25
3
1.50
1
1
1,593
25
2
2.50
1
1
2,554
25
3
1.75
0
2
1,483
19
3
2.00
1
1
1,879
25
3
2.25
1
2
2,091
21
3
1.50
1
2
1,973
25
3
1.75
1
1
2,200
25
3
2.75
1
2
2,583
25
3
2.25
2
1
2,029
25
2
1.00
0
1
1,192
26
2
1.75
1
1
1,871
25
3
1.50
0
1
1,365
25
3
1.50
1
1
1,700
25
2
1.75
1
1
1,889
25
3
2.25
1
2
2,158
25
3
1.50
1
1
1,909
22
3
1.00
1
1
1,309
25
3
1.50
1
1
2,123
26
3
1.50
1
0
1,768
22
3
1.50
1
1
2,299
25
3
2.00
1
1
1,793
25
3
1.00
1
0
1,544
25
4
3.00
2
2
3,088
25
3
1.75
1
1
2,031
22
3
1.50
1
1
1,774
18
3
1.50
1
2
2,104
17
3
1.00
0
1
1,134
17
2
1.75
1
1
1,487
18
3
1.50
1
1
1,616
17
3
1.00
1
1
1,370
18
3
1.75
1
1
1,776
7
3
2.00
2
1
2,217
11
2
1.50
0
1
1,146
18
3
1.00
0
1
1,298
17
3
1.50
1
2
2,215
18
3
1.50
1
2
2,229
17
3
1.75
1
1
1,963
17
3
2.00
1
2
2,200
18
3
2.50
2
2
3,013
18
3
1.50
1
1
1,769
18
3
1.00
1
0
1,301
18
2
1.75
1
0
1,482
12
3
2.25
2
2
2,461
407,100
291,400
374,700
297,200
306,100
397,100
381,700
383,000
279,700
392,900
379,700
444,000
362,400
468,600
370,800
322,700
456,200
345,100
365,400
312,400
494,100
377,600
322,700
412,000
416,400
289,700
508,800
289,100
388,000
354,000
325,200
308,400
480,100
515,500
487,600
233,800
343,400
306,000
553,100
322,500
547,600
346,400
373,000
322,700
381,200
283,600
302,000
368,500
295,300
334,100
246,100
250,000
337,300
349,900
332,300
268,600
352,000
338,700
386,600
319,900
387,900
357,100
255,400
381,000
313,500
371,900
281,100
380,200
341,800
322,400
343,200
348,100
256,800
479,500
226,100
331,000
316,100
279,800
249,100
401,400
432,000
437,800
194,800
257,600
264,600
405,800
282,800
445,300
307,800
296,300
346,400
366,900
273,200
245,100
140
90
90
90
90
140
140
140
90
140
140
140
90
140
140
90
140
90
140
90
140
140
90
140
140
90
140
90
140
140
90
90
140
140
140
90
90
90
140
140
150
140
140
140
140
90
140
17
18
17
19
17
17
16
14
18
17
17
17
17
12
16
17
17
17
16
18
17
17
14
17
5
14
17
18
17
16
17
17
13
12
18
18
18
14
19
12
3
24
22
22
14
22
12
3
3
3
3
2
3
3
3
3
3
3
3
2
3
3
3
3
3
3
3
3
3
2
3
3
2
4
3
3
3
3
3
3
3
3
2
3
2
3
3
3
3
3
3
3
3
3
2.25
1.50
1.00
1.50
1.75
1.75
2.50
1.75
1.50
2.50
1.75
2.25
1.75
2.25
2.25
1.00
1.50
1.75
2.25
1.00
2.25
1.75
1.75
2.50
1.50
1.00
2.50
1.00
1.50
1.50
1.50
1.00
2.25
2.75
2.50
1.00
2.00
1.00
2.00
1.50
1.75
2.25
2.00
2.00
2.25
1.00
2.25
1
0
0
1
0
1
1
1
1
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
0
0
1
0
1
0
1
0
2
2
2
0
1
1
2
0
1
1
1
3
1
0
1
2
1
1
0
1
1
2
0
1
2
2
2
1
1
1
1
2
1
1
1
1
1
1
2
0
1
2
1
1
1
0
0
1
2
1
0
1
1
1
1
1
1
1
1
3
0
1
2,297
1,641
1,143
1,297
1,554
2,155
2,388
2,147
1,557
2,027
2,112
2,286
1,862
1,941
2,009
1,415
2,232
1,868
1,951
1,186
1,838
2,155
1,852
2,072
1,305
1,080
2,825
1,203
1,915
1,149
1,498
1,295
2,534
2,426
2,803
847
1,917
1,404
2,342
1,249
1,759
2,105
1,860
2,455
2,121
1,211
1,451
344,900
314,300
371,200
468,800
448,400
332,800
345,300
409,700
394,900
371,000
332,300
355,600
650,300
394,600
303,600
297,500
373,700
415,900
289,000
292,000
514,400
298,300
521,200
365,200
273,100
348,400
296,800
342,900
368,700
304,600
408,200
379,100
318,300
429,200
438,400
330,000
378,700
340,600
348,600
300,600
328,900
346,000
426,300
463,400
384,400
458,300
374,100
318,400
282,900
302,800
360,400
359,100
310,600
288,800
355,500
329,900
332,400
275,000
309,300
574,600
337,900
248,100
284,000
331,500
361,400
290,200
278,000
457,400
278,300
446,200
282,300
236,700
293,800
258,700
295,200
345,400
276,200
343,700
359,900
298,200
378,900
329,300
301,200
366,400
307,800
302,200
266,000
266,300
343,800
362,900
396,100
349,800
371,500
339,300
140
140
140
140
140
90
90
140
140
140
140
140
150
140
90
90
140
140
90
140
140
90
140
140
90
90
140
90
90
140
140
140
140
140
140
140
140
140
140
140
140
140
140
140
140
140
140
1
11
14
17
21
22
23
10
12
18
22
14
21
18
24
19
24
16
22
22
16
24
10
12
23
23
22
20
23
22
18
13
21
16
21
18
12
24
24
15
19
14
16
14
15
14
15
2
2
3
3
4
3
3
3
3
3
3
3
5
3
3
3
2
4
3
2
3
3
3
3
3
3
3
3
3
2
3
3
2
3
3
3
3
3
3
3
3
3
3
3
3
3
3
1.50
1.75
1.50
2.00
1.50
1.75
1.50
1.50
2.25
2.00
1.75
1.50
3.00
1.50
1.00
1.75
1.75
2.00
1.50
1.75
2.25
1.00
1.75
1.75
1.00
1.00
1.75
2.00
1.75
1.75
2.00
2.25
1.75
2.00
2.00
1.00
2.50
1.75
1.75
1.00
1.00
2.25
2.25
1.50
1.50
1.50
2.25
0
1
1
1
1
1
0
0
1
1
0
1
2
1
0
1
1
1
0
1
1
1
1
1
1
1
1
0
1
1
1
1
1
0
1
0
1
1
1
0
1
1
1
1
1
1
1
1
2
2
2
2
1
1
2
1
1
1
1
3
2
0
0
1
2
0
2
2
0
2
0
0
1
1
1
1
0
1
1
1
2
1
1
2
2
1
0
1
2
2
2
2
1
1
1,151
1,166
1,716
1,711
2,196
2,015
1,463
2,170
1,930
2,014
1,231
1,665
3,456
1,896
1,109
1,727
1,985
2,256
1,405
1,996
2,747
1,491
2,878
2,059
1,419
1,584
1,679
1,214
2,164
1,703
2,168
2,303
1,733
2,329
1,718
1,179
2,197
1,893
1,390
1,300
1,650
2,087
1,977
2,226
1,789
1,973
1,817
643,400 574,400
305,600 302,300
398,700 329,000
334,100 248,900
304,500 267,000
448,200 395,600
341,400 318,200
361,600 357,900
316,800 291,600
1,110,100 1,056,300
511,200 450,000
322,300 295,100
539,700 492,500
452,100 379,200
378,300 345,300
321,600 278,800
615,900 401,900
388,000 313,300
339,100 263,800
496,000 415,900
482,700 392,900
443,600 457,800
499,400 407,300
342,600 272,900
300,700 255,500
895,000 850,700
327,600 281,100
476,900 405,700
337,000 264,200
309,100 276,800
334,300 313,700
460,200 375,000
318,000 271,200
478,700 395,300
391,800 362,600
454,600 362,900
354,400 311,500
367,500 305,500
409,700 324,900
318,300 299,700
409,900 343,500
355,700 285,800
543,900 450,500
395,600 347,600
564,100 561,200
316,800 287,000
325,700 274,800
150
140
140
140
140
140
140
140
140
150
150
140
150
140
140
140
140
140
140
140
140
140
150
140
140
150
140
150
140
140
140
140
140
140
140
140
140
140
140
140
140
140
150
140
150
140
140
10
15
15
15
15
12
15
14
16
6
10
19
13
14
13
14
15
15
15
12
12
6
14
19
15
10
15
12
15
15
15
14
15
13
15
15
15
19
15
14
14
19
11
14
6
14
19
4
3
3
3
3
3
3
3
3
6
3
3
4
3
3
3
4
3
3
3
3
3
3
3
3
3
2
3
2
3
3
3
2
4
3
3
3
3
3
2
3
3
3
4
4
3
3
2.50
1.75
1.50
1.00
1.00
2.00
1.50
1.75
1.50
4.00
2.25
1.50
2.50
1.50
2.25
1.00
1.50
1.00
1.00
2.25
2.00
2.50
1.25
1.75
1.00
2.25
1.00
1.50
1.00
1.00
1.50
2.50
1.75
2.75
1.75
1.50
2.00
2.00
1.00
1.00
2.50
1.50
2.50
2.00
2.25
0.50
1.50
2
1
1
0
1
1
1
1
1
2
1
1
1
1
1
0
0
1
1
1
1
1
1
1
0
3
1
1
0
1
0
2
1
2
1
1
1
1
1
0
1
1
1
1
1
0
0
3
1
2
1
1
2
1
2
0
3
2
0
2
1
1
1
2
1
1
1
2
2
2
1
1
3
1
2
0
2
2
2
0
1
2
2
1
1
1
1
2
2
2
1
1
2
1
2,862
1,864
1,900
1,079
1,515
2,176
1,500
1,924
1,973
4,815
2,200
1,699
2,538
1,902
2,146
1,057
1,818
1,789
1,002
2,319
2,220
2,161
2,240
1,730
1,109
4,077
1,535
2,167
954
1,464
1,889
2,648
1,680
2,266
2,029
2,051
1,763
1,809
1,994
1,209
2,340
1,769
2,614
2,113
2,559
1,156
1,583
346,500
317,000
258,200
309,000
285,800
331,400
321,300
326,900
317,400
341,600
345,900
337,800
325,700
299,300
354,600
390,100
345,900
310,500
339,100
307,200
341,300
369,100
648,800
322,900
520,100
427,300
289,300
294,500
363,900
586,200
529,500
371,800
272,600
296,600
362,000
455,900
310,000
317,000
382,900
349,900
334,200
303,500
323,700
303,900
331,200
276,000
274,900
325,000
276,500
291,800
231,200
239,800
277,400
294,100
277,800
291,200
294,100
307,000
268,500
306,000
254,700
261,300
269,700
332,700
267,600
301,600
278,200
324,400
300,400
561,900
272,100
457,400
331,000
268,800
319,400
254,500
540,000
433,700
350,400
271,300
277,900
324,900
347,600
267,800
309,500
329,600
274,300
314,100
253,300
339,900
206,800
254,000
270,600
261,000
140
140
140
90
90
90
140
90
90
90
140
90
90
90
90
90
90
90
140
140
140
140
140
90
140
140
90
90
90
140
140
140
90
90
90
140
90
90
140
90
90
90
140
90
90
90
90
14
14
12
19
18
22
18
20
16
16
18
21
20
15
16
16
25
16
19
16
12
15
1
15
6
11
12
16
20
2
8
8
19
18
16
19
16
13
13
19
8
16
11
20
22
16
15
3
2
2
3
3
3
3
2
3
3
3
3
3
3
3
3
4
2
3
3
3
3
0
3
3
3
3
3
3
4
3
3
3
3
3
3
3
3
3
3
2
3
3
3
3
3
3
1.25
1.00
1.00
1.00
1.00
1.00
1.50
1.50
1.50
1.00
1.50
1.50
2.00
1.00
1.00
1.00
2.25
1.50
1.50
1.50
1.50
2.00
2.50
1.00
1.50
1.50
1.00
1.50
1.00
2.00
2.00
1.75
1.00
1.00
1.00
2.50
1.00
1.75
2.25
1.75
1.50
1.50
1.50
1.50
1.00
1.00
1.00
1
1
0
1
1
0
1
1
1
0
1
1
1
0
1
1
1
1
1
0
0
1
0
1
1
0
0
1
0
1
1
1
0
0
1
1
1
1
1
1
0
1
0
1
1
1
1
1
0
1
0
0
1
1
1
1
2
1
0
1
0
1
1
1
1
1
0
1
1
0
1
1
1
1
2
0
1
2
3
0
0
1
2
1
1
1
1
0
0
1
0
0
1
0
1,952
1,420
1,002
1,387
1,349
1,779
1,776
1,584
1,741
1,410
2,039
2,280
2,038
1,002
1,442
1,686
2,626
1,609
2,035
1,305
1,406
1,880
3,040
1,515
2,067
1,296
1,059
1,728
1,447
2,353
2,570
2,348
1,519
1,474
1,755
2,137
1,430
1,686
1,986
1,764
1,365
1,485
1,273
1,980
1,392
1,648
1,333
300,300
287,300
331,500
601,300
302,300
577,900
276,200
592,700
367,300
286,600
507,800
394,800
312,700
458,400
319,400
465,900
300,800
307,300
288,200
613,700
413,500
413,800
358,900
323,500
433,800
630,500
327,200
273,100
240,800
286,600
483,800
277,100
428,600
238,500
471,000
281,400
239,700
390,300
388,500
260,100
392,600
259,900
308,200
237,600
267,900
251,800
469,300
330,500
370,100
314,400
291,600
312,500
536,200
322,000
90
90
90
140
90
140
90
140
140
90
140
140
90
140
90
140
90
90
90
140
140
140
90
90
140
150
90
21
16
18
3
11
11
20
3
12
22
19
20
16
12
16
19
15
16
15
4
16
15
8
16
19
4
16
3
3
3
3
3
3
3
3
3
2
4
3
3
3
3
3
2
3
2
3
3
3
2
3
3
4
3
2.25
1.00
1.00
2.25
1.50
1.75
2.00
1.25
2.25
1.00
2.25
2.50
1.50
2.25
1.50
1.75
1.00
1.00
1.00
2.00
2.25
2.00
1.50
1.50
1.50
2.25
1.50
1
1
1
1
1
1
0
0
1
0
1
1
1
1
2
1
0
1
0
1
1
1
1
1
1
1
1
1
0
1
1
2
2
0
1
1
1
2
1
0
1
2
2
0
1
0
0
2
1
1
1
1
0
1
1,743
1,391
1,654
2,504
1,859
1,706
1,303
1,782
1,879
1,096
2,636
2,668
1,795
2,292
1,930
1,916
1,179
1,581
1,285
2,059
2,095
2,649
1,365
1,741
1,869
2,195
1,997
WIDTH
67.50
66.00
66.00
62.00
64.00
97.00
70.00
83.00
62.00
111.00
89.50
66.50
59.00
95.00
64.00
71.00
67.50
59.00
92.00
69.50
64.00
70.00
64.00
53.50
89.00
64.00
62.00
67.00
59.00
48.00
53.50
59.00
64.50
107.00
64.00
70.00
61.00
92.00
59.00
64.00
104.00
67.00
65.00
47.00
105.00
DEPTH LOT_SIZE
123.00
8,303
123.00
8,118
123.00
8,118
125.00
7,750
166.00
10,624
135.00
13,095
112.50
7,875
140.00
11,620
142.00
8,804
130.00
14,430
137.50
12,306
123.00
8,180
123.00
7,257
125.00
11,875
112.50
7,200
132.00
9,372
123.00
8,303
123.00
7,257
106.50
9,798
134.00
9,313
123.00
7,872
128.50
8,995
123.00
7,872
99.50
5,323
148.00
13,172
118.00
7,552
150.00
9,300
123.00
8,241
123.00
7,257
133.00
6,384
122.00
6,527
124.00
7,316
128.50
8,288
141.00
15,087
128.50
8,224
123.00
8,610
120.00
7,320
182.00
16,744
118.00
6,962
150.00
9,600
170.00
17,680
139.00
9,313
120.00
7,800
128.50
6,040
114.50
12,023
NBHD
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
ORIGASR COSTVALU COSTASR MRKTVALU MRKTASR
97.91 327,609
116.30 327,473
116.25
87.58 362,336
101.55 344,619
96.59
82.82 354,050
96.58 353,273
96.36
98.38 422,293
122.30 402,147
116.46
87.59 344,610
95.43 365,382
101.19
80.78 373,795
100.08 369,060
98.81
96.89 368,916
111.32 362,980
109.53
96.37 389,641
111.23 368,986
105.33
87.35 351,458
98.61 354,862
99.57
83.29 488,212
102.59 489,063
102.77
81.09 396,488
95.13 411,472
98.72
92.59 291,075
100.30 307,010
105.79
89.07 318,641
102.16 329,655
105.69
90.05 348,002
105.84 360,502
109.64
91.13 330,424
104.27 336,351
106.14
88.87 362,041
96.88 371,286
99.35
77.37 395,210
92.58 402,633
94.32
92.24 351,549
112.71 352,107
112.89
88.83 298,563
98.70 309,928
102.46
82.98 366,219
98.18 362,604
97.21
91.56 356,167
117.90 351,490
116.35
94.52 402,772
106.08 392,249
103.30
92.94 332,966
107.30 338,678
109.15
77.88 285,683
90.81 304,328
96.73
87.33 503,692
100.20 500,616
99.59
90.93 369,954
98.65 353,967
94.39
95.44 344,099
110.47 350,173
112.42
94.80 385,882
107.37 377,685
105.09
85.18 311,707
92.77 298,716
88.90
79.02 310,871
87.30 314,919
88.44
84.54 332,775
96.34 330,949
95.82
91.06 300,041
106.81 299,700
106.69
85.70 341,091
98.35 334,745
96.52
90.28 437,111
91.60 462,319
96.88
92.21 326,812
85.73 319,510
83.82
81.99 323,578
91.33 318,133
89.79
97.92 386,929
113.24 372,814
109.11
90.41 460,821
121.75 446,991
118.10
80.41 369,788
111.45 348,528
105.04
94.14 396,943
108.16 381,024
103.82
87.37 562,696
96.29 549,854
94.09
94.81 336,148
105.01 334,754
104.58
91.69 311,474
104.80 299,873
100.90
85.77 289,577
94.94 288,887
94.72
93.90 450,051
108.11 419,989
100.89
64.00
82.00
82.50
59.50
48.00
59.50
63.00
53.50
48.00
64.00
77.50
64.00
69.50
61.50
60.00
48.00
85.00
64.00
70.00
64.00
113.00
70.00
64.00
76.00
64.00
61.00
100.00
65.00
64.00
64.00
53.50
49.00
71.50
64.00
105.50
40.50
59.00
48.00
91.50
64.00
67.50
62.00
74.00
65.00
84.50
59.50
53.50
118.00
112.50
151.00
116.00
118.00
125.00
124.00
107.00
128.50
139.00
120.00
150.00
125.00
118.00
118.00
123.00
141.00
120.00
124.00
118.00
147.00
124.50
108.00
123.00
128.00
118.00
143.00
128.50
128.50
123.00
128.50
118.00
138.50
121.00
152.00
125.00
140.00
128.50
100.00
107.00
123.00
120.00
134.00
127.00
148.00
154.00
128.50
7,552
9,225
12,458
6,902
5,664
7,438
7,812
5,725
6,168
8,896
9,300
9,600
8,688
7,257
7,080
5,904
11,985
7,680
8,680
7,552
16,611
8,715
6,912
9,348
8,192
7,198
14,300
8,353
8,224
7,872
6,875
5,782
9,903
7,744
16,036
5,063
8,260
6,168
9,150
6,848
8,303
7,440
9,916
8,255
12,506
9,163
6,875
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
90.52
101.34
89.16
82.81
81.67
84.94
91.67
86.76
96.03
89.59
89.20
87.07
88.27
82.78
96.31
79.14
83.52
90.84
101.78
89.98
76.95
90.52
99.91
83.30
83.60
88.64
94.24
78.21
85.31
89.29
86.04
80.77
83.61
83.80
89.79
83.32
75.01
86.47
73.37
87.69
81.32
88.86
79.44
107.34
96.25
96.33
81.16
397,560
345,968
360,283
294,794
301,163
381,582
409,823
374,744
306,404
392,088
376,806
465,169
361,803
408,955
365,154
287,555
407,618
341,057
399,129
298,040
440,123
393,108
351,153
391,043
355,172
295,557
494,713
301,842
369,885
314,344
319,508
284,841
459,376
460,677
515,667
226,332
365,539
300,801
434,284
348,421
471,389
358,275
380,390
405,568
444,482
300,051
360,333
97.66
118.73
96.15
99.19
98.39
96.09
107.37
97.84
109.55
99.79
99.24
104.77
99.84
87.27
98.48
89.11
89.35
98.83
109.23
95.40
89.08
104.11
108.82
94.91
85.30
102.02
97.23
104.41
95.33
88.80
98.25
92.36
95.68
89.37
105.76
96.81
106.45
98.30
78.52
108.04
86.08
103.43
101.98
125.68
116.60
105.80
119.32
392,055
341,391
368,625
287,926
294,406
384,344
404,391
354,448
311,094
416,363
377,487
434,250
367,115
390,899
396,096
291,774
437,307
350,449
411,255
320,422
414,139
369,519
329,829
370,337
364,545
292,902
522,628
314,781
372,594
319,796
315,332
284,883
441,692
458,220
506,797
230,506
351,559
298,703
429,289
359,873
492,541
358,365
371,375
414,092
452,993
300,218
354,865
96.30
117.16
98.38
96.88
96.18
96.79
105.94
92.55
111.22
105.97
99.42
97.80
101.30
83.42
106.82
90.42
95.86
101.55
112.55
102.57
83.82
97.86
102.21
89.89
87.55
101.11
102.72
108.88
96.03
90.34
96.97
92.37
92.00
88.89
103.94
98.59
102.38
97.62
77.62
111.59
89.95
103.45
99.56
128.32
118.83
105.86
117.50
90.00
48.00
80.00
69.50
82.50
72.00
52.50
53.50
64.00
62.00
59.00
68.50
113.50
78.00
64.00
62.00
79.00
69.50
58.00
64.00
80.00
59.00
59.00
64.00
66.00
64.00
64.00
62.00
66.00
60.00
75.00
62.00
68.50
65.80
69.50
82.50
65.00
64.00
59.00
66.00
73.50
56.50
73.00
64.00
80.00
66.00
62.00
143.50
145.50
122.00
150.00
112.50
119.00
120.00
128.50
128.50
144.50
127.50
128.50
128.50
114.50
128.50
117.00
115.00
118.00
123.00
128.50
134.00
125.00
128.50
129.50
128.50
128.50
128.50
114.50
128.50
131.50
140.50
127.00
121.00
128.50
119.00
128.50
128.50
128.50
117.00
112.50
123.00
131.50
118.00
122.00
118.00
112.50
112.50
12,915
6,984
9,760
10,425
9,281
8,568
6,300
6,875
8,224
8,959
7,523
8,802
14,585
8,931
8,224
7,254
9,085
8,201
7,134
8,224
10,720
7,375
7,582
8,288
8,481
8,224
8,224
7,099
8,481
7,890
10,538
7,874
8,289
8,455
8,271
10,601
8,353
8,224
6,903
7,425
9,041
7,429
8,614
7,808
9,440
7,425
6,975
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
92.32
90.01
81.57
76.88
80.08
93.33
83.64
86.77
83.54
89.60
82.76
86.98
88.36
85.63
81.72
95.46
88.71
86.90
100.42
95.21
88.92
93.30
85.61
77.30
86.67
84.33
87.16
86.09
93.68
90.68
84.20
94.94
93.69
88.28
75.11
91.27
96.75
90.37
86.69
88.49
80.97
99.36
85.13
85.48
91.00
81.06
90.70
360,392
329,570
381,965
392,903
390,362
355,756
316,226
406,017
391,179
378,498
305,410
359,008
636,984
380,017
285,596
317,803
370,621
411,061
308,224
371,495
496,274
317,737
515,865
373,128
305,439
342,184
327,843
325,046
369,627
323,105
395,401
444,175
334,645
405,590
373,033
339,328
426,266
362,210
323,107
299,883
336,604
401,271
403,896
426,587
380,495
409,777
379,117
104.49
104.86
102.90
83.81
87.06
106.90
91.58
99.10
99.06
102.02
91.91
100.96
97.95
96.30
94.07
106.82
99.18
98.84
106.65
127.22
96.48
106.52
98.98
102.17
111.84
98.22
110.46
94.79
100.25
106.08
96.86
117.17
105.14
94.50
85.09
102.83
112.56
106.34
92.69
99.76
102.34
115.97
94.74
92.06
98.98
89.41
101.34
351,868
332,761
370,051
409,722
386,048
344,341
314,095
403,108
378,519
370,475
312,999
394,084
658,516
390,429
292,369
312,725
396,688
433,024
310,409
354,004
473,158
307,600
491,841
374,362
308,556
332,321
334,548
315,492
357,108
319,487
388,645
455,696
336,024
443,420
376,634
337,522
441,974
370,569
324,227
305,186
358,650
387,472
397,781
451,175
368,424
390,965
381,594
102.02
105.87
99.69
87.40
86.09
103.47
90.96
98.39
95.85
99.86
94.19
110.82
101.26
98.94
96.30
105.12
106.15
104.12
107.41
121.23
91.98
103.12
94.37
102.51
112.98
95.38
112.72
92.01
96.86
104.89
95.21
120.20
105.57
103.31
85.91
102.28
116.71
108.80
93.01
101.53
109.05
111.99
93.31
97.36
95.84
85.31
102.00
67.50
66.00
67.00
64.00
59.00
53.50
79.00
62.00
66.00
107.00
64.00
64.00
57.00
98.50
57.00
60.00
63.00
10.00
68.00
53.50
66.50
103.00
64.00
69.50
59.00
74.00
54.50
53.50
57.00
59.50
59.00
105.50
48.00
57.00
82.00
94.00
59.00
69.50
79.00
66.00
63.00
59.00
62.00
64.00
71.00
59.50
67.50
134.00
107.00
120.50
113.50
118.00
128.50
123.00
114.50
118.00
134.00
112.50
123.00
128.50
134.00
123.50
145.00
123.00
123.50
120.50
128.50
128.50
103.00
125.00
139.00
118.00
135.50
141.00
128.50
129.50
128.50
128.50
144.50
123.00
128.50
163.50
95.00
118.00
128.50
118.00
130.00
123.00
118.00
128.50
130.00
140.00
116.00
123.00
9,045
7,062
8,074
7,264
6,962
6,875
9,717
7,099
7,788
14,338
7,200
7,872
7,325
13,199
7,040
8,700
7,749
1,235
8,194
6,875
8,545
10,609
8,000
9,661
6,962
10,027
7,685
6,875
7,382
7,646
7,582
15,245
5,904
7,325
13,407
8,930
6,962
8,931
9,322
8,580
7,749
6,962
7,967
8,320
9,940
6,902
8,303
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
6
89.28 570,651
98.92 371,924
82.52 374,845
74.50 299,925
87.68 303,001
88.26 402,347
93.20 357,115
98.98 394,752
92.05 346,247
95.15 1,225,368
88.03 448,157
91.56 329,648
91.25 546,814
83.88 417,916
91.28 391,359
86.69 295,888
65.25 413,952
80.75 370,237
77.79 280,812
83.85 447,852
81.40 418,478
103.20 467,270
81.56 461,346
79.66 338,563
84.97 298,906
95.05 964,613
85.81 339,072
85.07 443,890
78.40 307,169
89.55 340,990
93.84 355,357
81.49 500,763
85.28 321,061
82.58 456,563
92.55 420,933
79.83 406,136
87.90 362,895
83.13 366,057
79.30 379,174
94.16 314,604
83.80 427,191
80.35 332,738
82.83 529,521
87.87 438,911
99.49 524,781
90.59 300,062
84.37 331,425
88.69 606,421
121.70 346,050
94.02 414,822
89.77 297,263
99.51 312,400
89.77 402,188
104.60 343,084
109.17 374,757
109.30 347,530
110.38 1,219,770
87.67 475,897
102.28 323,790
101.32 565,237
92.44 402,579
103.45 424,811
92.00 299,040
67.21 423,407
95.42 365,424
82.81 292,348
90.29 457,666
86.70 406,295
105.34 462,135
92.38 472,546
98.82 337,932
99.40 303,713
107.78 983,377
103.50 369,257
93.08 480,767
91.15 305,816
110.32 316,121
106.30 354,724
108.81 538,261
100.96 302,943
95.38 447,118
107.44 399,542
89.34 400,273
102.40 370,587
99.61 355,578
92.55 390,450
98.84 306,313
104.22 411,487
93.54 337,568
97.36 554,375
110.95 458,667
93.03 589,096
94.72 313,511
101.76 338,745
94.25
113.24
104.04
88.97
102.59
89.73
100.49
103.64
109.70
109.88
93.09
100.46
104.73
89.05
112.29
92.99
68.75
94.18
86.21
92.27
84.17
104.18
94.62
98.64
101.00
109.87
112.72
100.81
90.75
102.27
106.11
116.96
95.27
93.40
101.98
88.05
104.57
96.76
95.30
96.23
100.39
94.90
101.93
115.94
104.43
98.96
104.01
57.00
60.00
69.50
55.00
64.00
62.00
67.00
54.00
70.00
86.00
75.00
59.00
53.50
81.00
62.00
69.00
65.00
64.00
63.00
67.00
66.00
67.00
56.00
66.50
87.50
64.00
48.00
61.50
71.00
81.00
56.00
63.00
64.00
67.50
80.00
75.00
58.50
58.50
66.00
64.00
76.50
59.00
66.00
48.00
64.00
61.50
73.00
123.00
118.00
166.00
109.00
128.50
130.00
118.00
127.00
129.00
130.00
128.50
107.00
107.00
152.00
118.00
112.50
112.00
129.00
125.50
174.50
118.00
131.00
126.50
119.00
134.00
144.00
118.00
122.00
113.50
145.00
126.50
120.00
126.50
118.00
155.00
128.50
113.00
118.00
118.00
128.50
101.00
118.00
133.00
107.00
118.00
142.50
118.00
7,011
7,080
11,537
5,995
8,224
8,060
7,906
6,858
9,030
11,180
9,638
6,313
5,725
12,312
7,316
7,763
7,280
8,256
7,907
11,692
7,788
8,777
7,084
7,914
11,725
9,216
5,664
7,503
8,059
11,745
7,084
7,560
8,096
7,965
12,400
9,638
6,611
6,903
7,788
8,224
7,727
6,962
8,778
5,136
7,552
8,764
8,614
6
6
6
6
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
93.80
87.22
113.01
74.82
83.90
83.71
91.53
84.98
91.75
86.09
88.75
79.48
93.95
85.10
73.69
69.14
96.18
86.18
88.94
90.56
95.05
81.39
86.61
84.27
87.94
77.46
92.91
108.46
69.94
92.12
81.91
94.24
99.52
93.70
89.75
76.24
86.39
97.63
86.08
78.39
93.99
83.46
105.00
68.05
76.69
98.04
94.94
376,209
304,003
335,192
290,922
295,042
319,629
343,670
315,226
330,082
326,587
375,300
362,964
366,510
297,379
305,622
340,319
396,700
318,122
364,632
330,938
336,947
347,557
566,282
317,269
465,488
348,520
281,498
350,091
303,443
517,682
454,311
417,309
307,980
305,185
368,476
414,651
302,869
335,484
367,751
333,898
331,425
293,834
341,465
324,372
295,151
312,531
294,631
108.57
95.90
129.82
94.15
103.23
96.45
106.96
96.43
104.00
95.61
108.50
107.45
112.53
99.36
86.19
87.24
114.69
102.45
107.53
107.73
98.72
94.16
87.28
98.26
89.50
81.56
97.30
118.88
83.39
88.31
85.80
112.24
112.98
102.89
101.79
90.95
97.70
105.83
96.04
95.43
99.17
96.82
105.49
106.74
89.12
113.24
107.18
358,993
298,602
322,438
294,833
301,999
320,636
346,870
314,824
343,111
329,437
375,815
356,055
342,895
291,636
318,418
338,557
380,217
310,265
366,385
329,071
346,341
336,741
624,374
315,604
457,254
347,732
286,090
359,078
305,077
532,321
449,060
399,664
318,798
322,135
377,289
390,751
312,097
318,125
352,525
324,116
301,514
307,188
344,294
316,245
294,683
310,156
293,851
103.61
94.20
124.88
95.42
105.67
96.75
107.96
96.31
108.10
96.44
108.65
105.40
105.28
97.44
89.80
86.79
109.92
99.92
108.05
107.12
101.48
91.23
96.24
97.74
87.92
81.38
98.89
121.93
83.84
90.81
84.81
107.49
116.95
108.61
104.22
85.71
100.68
100.35
92.07
92.63
90.22
101.22
106.36
104.06
88.97
112.38
106.89
70.00
47.00
66.00
86.50
65.00
42.00
47.00
71.50
61.50
62.00
91.00
73.00
62.00
61.00
72.00
75.00
68.50
72.00
61.00
87.00
66.00
73.00
72.00
70.00
64.00
181.50
103.00
118.00
118.00
128.50
111.00
115.00
147.00
118.00
130.00
107.00
129.00
121.50
113.00
118.00
123.00
112.50
128.50
122.00
112.50
112.50
113.00
118.00
118.00
102.50
129.00
122.00
133.00
139.00
8,260
5,546
8,481
9,602
7,475
6,174
5,546
9,295
6,581
7,998
11,057
8,249
7,316
7,503
8,100
9,638
8,357
8,100
6,863
9,831
7,788
8,614
7,380
9,030
7,808
24,140
14,317
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
90.94
83.81
86.46
80.46
91.66
74.17
86.35
79.47
76.61
83.64
76.86
98.40
83.18
85.65
81.37
66.15
78.99
87.18
87.37
76.47
79.93
89.44
87.60
90.14
72.04
85.04
98.41
343,945
284,392
330,329
499,100
364,895
427,101
292,181
458,408
384,044
291,310
465,872
459,143
323,482
415,709
342,574
373,084
281,410
350,178
285,799
475,737
388,211
459,241
326,441
333,275
369,580
618,208
389,074
114.53
98.99
99.65
83.00
120.71
73.91
105.79
77.34
104.56
101.64
91.74
116.30
103.45
90.69
107.26
80.08
93.55
113.95
99.17
77.52
93.88
110.98
90.96
103.02
85.20
98.05
118.91
333,821
295,829
330,707
517,376
355,205
464,310
281,252
494,789
376,384
300,680
438,471
470,955
319,106
401,011
333,803
366,728
284,928
347,743
278,377
513,621
396,760
442,189
311,197
333,989
374,163
637,565
363,304
111.16
102.97
99.76
86.04
117.50
80.34
101.83
83.48
102.47
104.91
86.35
119.29
102.05
87.48
104.51
78.71
94.72
113.16
96.59
83.69
95.95
106.86
86.71
103.24
86.25
101.12
111.03
NOTE: Regression 1 is in columns A through G; Regression 2 is in columns I through O
Regression 1
Descriptive Statistics
Mean
Std. Deviation
N
PRICE
379800.77
99423.451
260
LIVAREA
1849.03
512.382
260
LOT_SIZE
8614.16
2383.777
260
Model
Variables Entered/Removeda
Variables Entered
Variables Removed
Method
1
LOT_SIZE, LIVAREAb
Enter
a. Dependent Variable: PRICE
b. All requested variables entered.
Model Summary
R
Model
1
.776a
a. Predictors: (Constant), LOT_SIZE, LIVAREA
.603
ANOVAa
Sum of Squares
Model
1
Adjusted R
Square
R Square
.599
df
Std. Error of the
Estimate
62923.549
Mean Square
Regression
1542662003401.690
2
771331001700.847
Residual
1017558856444.460
257
3959372982.274
Total
2560220859846.150
259
F
Sig.
194.811 .000b
a. Dependent Variable: PRICE
b. Predictors: (Constant), LOT_SIZE, LIVAREA
Coefficientsa
Unstandardized Coefficients
Model
Standardized
Coefficients
t
Sig.
Model
1
B
Std. Error
Beta
t
Sig.
3.816
.000
16.808
.000
(Constant)
67463.091
17678.336
LIVAREA
136.441
8.118
.703
LOT_SIZE
6.972
1.745
.167
3.995
.000
a. Dependent Variable: PRICE
olumns I through O; Regression 3 is in columns Q through W; Regression 4 is in columns Y thr
Regression 2
Descriptive Statistics
Mean
PRICE
Std. Deviation
N
379800.77
99423.451
260
2.94
.509
260
BATHS
1.6731
.51741
260
LIVAREA
1849.03
512.382
260
LOT_SIZE
8614.16
2383.777
260
BEDROOMS
Model
Variables Entered/Removeda
Variables Entered
Variables Removed
Method
2
LOT_SIZE,
BEDROOMS, BATHS,
LIVAREAb
Enter
a. Dependent Variable: PRICE
b. All requested variables entered.
Model Summary
R
Model
R Square
Adjusted R
Square
2
.613
.607
.783a
a. Predictors: (Constant), LOT_SIZE, BEDROOMS, BATHS, LIVAREA
ANOVAa
Sum of Squares
Model
2
df
Std. Error of the
Estimate
62315.672
Mean Square
Regression
1569993886052.110
4
392498471513.028
Residual
990226973794.040
255
3883243034.486
Total
2560220859846.150
259
F
Sig.
101.075 .000b
a. Dependent Variable: PRICE
b. Predictors: (Constant), LOT_SIZE, BEDROOMS, BATHS, LIVAREA
Coefficientsa
Unstandardized Coefficients
Model
Standardized
Coefficients
t
Sig.
Model
2
B
Std. Error
Beta
t
Sig.
(Constant)
22998.282
24344.433
.945
.346
BEDROOMS
21871.338
8541.120
.112
2.561
.011
BATHS
8488.686
11659.414
.044
.728
.467
LIVAREA
121.885
12.384
.628
9.842
.000
LOT_SIZE
6.148
1.756
.147
3.501
.001
a. Dependent Variable: PRICE
in columns Y through AE
Regression 3
Descriptive Statistics
Mean
PRICE
Std. Deviation
N
379800.77
99423.451
260
2.94
.509
260
1.6731
.51741
260
.86
.534
260
BEDROOMS
BATHS
FAMILYRM
FIREPLCS
1.13
.718
260
LIVAREA
1849.03
512.382
260
LOT_SIZE
8614.16
2383.777
260
Model
3
Variables Entered/Removeda
Variables Entered
Variables Removed
LOT_SIZE,
BEDROOMS,
FAMILYRM,
FIREPLCS, BATHS,
LIVAREAb
Method
Enter
a. Dependent Variable: PRICE
b. All requested variables entered.
Model Summary
R
Model
R Square
Adjusted R
Square
Std. Error of the
Estimate
3
.631
.622
61121.412
.794a
a. Predictors: (Constant), LOT_SIZE, FAMILYRM, FIREPLCS, BEDROOMS, BATHS, LIVAREA
ANOVAa
Sum of Squares
Model
3
df
Mean Square
F
72.053 .000b
Regression
1615056625076.640
6
269176104179.439
Residual
945164234769.517
253
3735827014.899
Total
2560220859846.150
259
Sig.
a. Dependent Variable: PRICE
b. Predictors: (Constant), LOT_SIZE, FAMILYRM, FIREPLCS, BEDROOMS, BATHS, LIVAREA
Coefficientsa
Unstandardized Coefficients
Model
Standardized
Coefficients
t
Sig.
Model
3
B
Std. Error
Beta
t
Sig.
(Constant)
15875.727
24603.926
.645
.519
BEDROOMS
21333.288
8433.350
.109
2.530
.012
BATHS
7440.497
11467.855
.039
.649
.517
FAMILYRM
-29459.525
9326.607
-.158
-3.159
.002
FIREPLCS
8435.817
6298.828
.061
1.339
.182
LIVAREA
136.726
14.099
.705
9.697
.000
LOT_SIZE
6.003
1.725
.144
3.480
.001
a. Dependent Variable: PRICE
Regression 4
Descriptive Statistics
Mean
PRICE
Std. Deviation
N
379800.77
99423.451
260
2.94
.509
260
1.6731
.51741
260
.86
.534
260
BEDROOMS
BATHS
FAMILYRM
FIREPLCS
1.13
.718
260
LIVAREA
1849.03
512.382
260
LOT_SIZE
8614.16
2383.777
260
DEPTH
126.062
12.7385
260
Model
Variables Entered/Removeda
Variables Entered
Variables Removed
Method
4
DEPTH, BEDROOMS,
FAMILYRM,
FIREPLCS, BATHS,
LIVAREA, LOT_SIZEb
Enter
a. Dependent Variable: PRICE
b. All requested variables entered.
Model Summary
R
Model
R Square
Adjusted R
Square
Std. Error of the
Estimate
4
.631
.621
61206.471
.795a
a. Predictors: (Constant), DEPTH, FAMILYRM, BEDROOMS, FIREPLCS, BATHS, LOT_SIZE,
LIVAREA
ANOVAa
Sum of Squares
Model
4
df
Mean Square
F
61.630
Regression
1616170383374.300
7
230881483339.185
Residual
944050476471.855
252
3746232049.491
Total
2560220859846.150
259
a. Dependent Variable: PRICE
b. Predictors: (Constant), DEPTH, FAMILYRM, BEDROOMS, FIREPLCS, BATHS, LOT_SIZE, LIVAREA
Coefficientsa
Unstandardized Coefficients
Model
Standardized
Coefficients
t
Model
4
B
Std. Error
Beta
t
(Constant)
37887.516
47294.445
BEDROOMS
20748.319
8512.959
.106
2.437
BATHS
.801
7436.608
11483.817
.039
.648
FAMILYRM
-29755.382
9355.334
-.160
-3.181
FIREPLCS
8911.774
6367.708
.064
1.400
LIVAREA
136.335
14.137
.703
9.644
LOT_SIZE
6.661
2.108
.160
3.160
-202.450
371.296
-.026
-.545
DEPTH
a. Dependent Variable: PRICE
Sig.
.000b
REA
Sig.
Sig.
.424
.015
.518
.002
.163
.000
.002
.586

Purchase answer to see full
attachment