Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. In the Housing Data sheetDatasheet compute the different Percentiles for the Price column - NE Sector = 'Yes', NE Sector = 'No' and overall.

1. In the Housing Data sheetDatasheet

compute the different Percentiles for the Price column - NE Sector = 'Yes', NE Sector = 'No' and overall. (b) Comment on the House Prices for the two areas (NE sector and not NE Sector) , observing values up to the 50th Percentile and beyond. (c) What conclusions do you draw?

Square Feet Age Features NE Sector Corner Lot Offer Pending Annual Tax
1,236 3 4 No No No 707 (a) Univariate Statistics
1,740 4 3 No No No 816 Complete this table
1,715 4 3 No No No 900 Price
1,273 4 4 No No No 638
970 4 4 No No Yes 541 NE Sector = 'No' NE Sector = 'Yes' Overall
900 5 3 No No No 391
1,850 5 5 No Yes Yes 973 1st Percentile
1,720 5 4 No No No 867 5th Percentile
1,606 5 4 No No No 811 10th Percentile
1,305 5 3 No No No 647 25th Percentile
1,700 6 4 No No No 725 50th Percentile
1,620 6 4 No No No 800 75th Percentile
1,630 6 4 No No No 750 90th Percentile
1,540 6 2 No No Yes 826 95th Percentile
1,229 6 3 No No No 721 99th Percentile
1,500 7 3 No Yes Yes 700
1,535 7 5 No No Yes 668
1,415 7 4 No No No 866 (b) Comment on the House Prices for the two areas (NE sector and not NE Sector) , observing values upto the 50th Percentile and beyond.
1,165 7 4 No No No 694
1,200 7 4 No No Yes 634
1,920 8 4 No No No 944
1,580 9 3 No No No 810
1,739 13 3 No No No 880
1,505 14 2 No No Yes 591
1,198 14 4 No No No 459 (c) What conclusions do you draw?
2,563 14 2 No Yes No 1,189
1,051 15 2 No No No 426
3,750 19 4 No Yes Yes 1,200
1,080 21 3 No Yes No 600
1,142 21 0 No No No 223
1,464 22 2 No No No 376
2,116 25 3 No Yes No 1,209
1,159 25 0 No No No 225
1,280 38 3 No No No 447
1,428 40 2 No No No 701
1,375 40 1 No No No 585
1,480 40 4 No No No 475
2,250 40 6 No Yes No 915
1,400 45 1 No Yes Yes 481
1,920 1 5 Yes Yes No 1,161
1,710 1 3 Yes Yes No 1,010
2,774 2 4 Yes No No 1,765
2,921 3 6 Yes Yes No 1,635
1,275 3 5 Yes No No 570
2,580 4 4 Yes Yes No 1,732
2,580 4 4 Yes No No 1,534
1,837 4 5 Yes No No 1,191
2,848 4 6 Yes Yes No 1,487
1,338 4 3 Yes No Yes 649
997 4 4 Yes No No 461
1,280 5 1 Yes No No 599
1,900 5 3 Yes No No 780
2,664 6 5 Yes Yes No 1,193
1,173 6 4 Yes No No 456
1,365 6 2 Yes No No 673
1,030 6 1 Yes No No 486
1,549 7 4 Yes No No 723
1,258 7 4 Yes No Yes 821
1,880 8 6 Yes No No 930
2,600 10 4 Yes Yes No 1,088
2,150 10 4 Yes No No 1,050
1,746 10 2 Yes No No 591
837 10 2 Yes No No 342
2,000 11 3 Yes Yes No 1,076
1,560 11 5 Yes No Yes 638
1,725 12 3 Yes No No 923
2,650 13 7 Yes Yes No 1,639
1,430 13 3 Yes No No 752
1,050 13 2 Yes No Yes 553
1,680 13 4 Yes No No 875
1,350 13 2 Yes No No 622
1,894 14 5 Yes Yes No 1,112
1,360 14 4 Yes No No 696
1,326 14 4 Yes No No 668
1,706 14 4 Yes No No 810
1,948 14 4 Yes No No 899
1,314 14 2 Yes No No 671
2,150 15 3 Yes No No 984
1,630 15 3 Yes No Yes 867
1,500 15 4 Yes No No 743
1,215 15 3 Yes No No 477
1,027 15 3 Yes No No 427
1,348 15 2 Yes Yes No 520
1,767 16 4 Yes No No 794
1,400 16 2 Yes No Yes 731
1,385 16 2 Yes No No 653
1,710 16 4 Yes Yes No 800
1,680 17 4 Yes No Yes 750
1,573 17 6 Yes No No 768
2,180 17 4 Yes No Yes 1,141
1,928 18 8 Yes Yes No 600
2,440 19 5 Yes Yes No 1,265
1,007 19 6 Yes No No 513
1,657 20 4 Yes No No 865
1,565 20 3 Yes Yes No 648
1,543 20 3 Yes No No 820
1,181 21 4 Yes No No 440
1,464 22 2 Yes Yes No 566
1,083 22 4 Yes No No 504
1,830 23 3 Yes No No 733
1,156 23 1 Yes No No 650
2,253 23 4 Yes Yes No 939
1,299 24 6 Yes No No 585
1,320 24 5 Yes No No 580
2,277 25 4 Yes Yes No 920
2,743 25 5 Yes Yes Yes 1,232
2,200 26 4 Yes No No 1,076
2,931 28 3 Yes No Yes 1,142
2,200 28 4 Yes No No 1,035
1,713 30 4 Yes No Yes 600
1,140 30 3 Yes No Yes 490
1,900 34 3 Yes No No 690
1,050 40 1 Yes No No 542
1,190 41 1 Yes No No 600
1,733 43 6 Yes No No 656
1,121 46 4 Yes No No 398
1,478 53 3 Yes No Yes 626
NE Sector = 'No' NE Sector = 'Yes' Overall
1st Percentile
5th Percentile
10th Percentile
25th Percentile
50th Percentile
75th Percentile
90th Percentile
95th Percentile
99th Percentile

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Economics Of The Industrial Revolution Internet, Artificial Intelligence And Blockchain

Authors: Nicholas Johnson, Brendan Markey Towler

1st Edition

042977169X, 9780429771699

More Books

Students also viewed these General Management questions

Question

Define paraphrasing and reflecting.

Answered: 1 week ago