Sampling Distributions – Real Estate Part 2

profilelttlxmntqle
week_3_team_assignment_team_d.xlsx

Week 2

Address Price Sq. Footage # Bedrooms
1010 Dunham Dr $ 299,000.00 2137 3
1015 Shady Ln $ 185,000.00 3152 5 Frequency Distribution Table: Listing Price
10185 Boleyn Rd $ 119,900.00 1040 2
10257 Emberwoood $ 325,000.00 3020 4 Price Number of Listings Relative Freqency Found
1030 Melrose Ter $ 149,900.00 1719 4 1mil-725K 1 0.01 1/105
1105 Grove Ter. $ 749,000.00 6660 10 724k-500k 1 0.01 1/105
1134 Langworthy St. $ 269,900.00 2068 4 499k-250k 15 0.14 15/105
1145 Mt Pleasant St $ 179,900.00 1928 4 249k-0 88 0.84 88/105
1156 Center PL $ 132,000.00 1958 3 Total 105 1
1215 University Ave $ 145,000.00 1547 3
12421 Brittany Ct $ 454,000.00 4673 3
1292 Wood St $ 157,000.00 1995 2 Info On Listing Price
13949 Barrington Lake $ 225,000.00 2518 3 Mean $ 193,262.86
1465 Parkway St $ 157,900.00 1920 4 Median $ 159,900.00
1575 Montrose Ter $ 174,500.00 2590 4 Mode $ 139,900.00
16329 Country View $ 379,000.00 1900 3 1st Quartile $ 208,900.00
1645 Earl Dr $ 148,000.00 1560 3 2nd Quartile $ 159,900.00
1690 Auburn St $ 154,900.00 1334 3 3rd Quartile $ 138,250.00
1698 N Algona ST $ 139,500.00 1326 3 4th quartile $ 119,900.00
1709 Lawndale St $ 124,000.00 1732 2 Range $ 24,000.00
17173 Ballymore Dr. $ 545,000.00 3220 4 Varience $ 9,483,441,001.36
17400 Ballymore Ln $ 445,000.00 3314 4 Standard Deviation $ 97,382.96 Chebyshev's $ 1.00
1745 Bristol Dr $ 137,000.00 1590 3
1748 Avalon Rd $ 153,000.00 1693 3
1765 Alta Vista St $ 139,500.00 2097 3 Info on Square Footage
1775 Glen Oak St $ 132,900.00 1596 3 Mean 2123.381
1785 Sarah St $ 124,900.00 1664 3 Median 2008
1820 Hale St $ 151,000.00 1369 3 Modes 2082, 2080, 1719, 1400
1836 Carter RD $ 175,000.00 2332 3 1st Quartile 2433.5
1837 Lori St $ 134,900.00 1610 2 2nd Quartile 2008
1849 Jackson ST $ 120,000.00 850 1 3rd Quartile 1650
1896 Carter Rd $ 169,900.00 2144 4 4th Quartile 850
1925 St Anne Ct $ 184,000.00 2355 3 Range 5810
1970 Fillmore ST $ 153,900.00 2080 3 Varience 683391.512018143
2010 Alta Vista St $ 233,500.00 2112 4 Standard Deviation 826.675 Chebyshev's $ 1.00
2015 Lombard ST $ 164,900.00 2726 4
2130 Fairway Dr $ 179,000.00 1960 3
2215 Aspen Dr. $ 299,900.00 2754 3 # of Bedrooms Homes Frequency
2221 Aspen Dr $ 259,900.00 3120 4 1 BDRM 1 1%
2240 Schroeder ST $ 122,500.00 1415 3 2 BDRM 10 10%
2290 EvergreenDr $ 139,900.00 1750 3 3 BDRM 60 57%
2350 Pearl St $ 150,000.00 2208 3 4 BDRM 28 27%
2455 Asbury Rd $ 140,000.00 1080 2 5 BDRM 4 4%
251 N Booth St $ 119,900.00 1048 2 6 BDRM 1 1%
2540 Knob Hill Dr $ 204,900.00 2400 3 10 BDRM 1 1%
2545 Marywood Dr $ 129,900.00 1449 3 105 100%
2555 Univeristy Ave $ 139,900.00 1506 4
2629 Millstone $ 149,900.00 1540 3
2635 Fulton St $ 120,000.00 1085 3
2652 Mineral St $ 174,000.00 2008 3
2715 Ken Ct $ 171,000.00 2732 3
2725 Shady Ln $ 190,000.00 2285 4
2735 Windsor Ave $ 149,000.00 1968 3
2765 Brunswick ST $ 120,000.00 1714 2
2820 Illinois Ave $ 250,000.00 3119 3
2820 Van Buren St $ 144,000.00 2327 5
2820 Wildwood Ct $ 214,900.00 2963 4
2825 Davenport ST $ 129,900.00 1893 4
2828 Arbor Hills Dr. $ 434,900.00 4570 4
285 Princeton Pl $ 159,900.00 2132 2
2860 Indiana Ave $ 130,000.00 1300 3
2870 N Grandview $ 208,900.00 1400 3
2890 N Grandview $ 208,900.00 1412 3
2905 St Anne Dr $ 189,900.00 2221 3
2918 Indiana Ave $ 129,900.00 1640 3
2929 Brueck Rd $ 214,900.00 2084 3
2930 Balke ST $ 126,000.00 1525 3
2939 Van Buren St $ 136,000.00 1660 3
2975 Arbor Hills Dr. $ 449,000.00 3582 5
2975 St Anne Dr $ 169,900.00 2123 4
2995 Davenport St $ 139,900.00 2082 2
3023 W 32nd ST $ 209,000.00 2275 3
3030 Kaufmann Ave $ 166,900.00 2205 3
3040 Brunswick St $ 119,900.00 1400 3
3045 Deerwood Cr $ 169,000.00 1840 3
3049 Judson Ct $ 189,900.00 2484 3
3063 Westmore Dr $ 169,000.00 2080 3
3084 Oak View Ct $ 235,800.00 3142 4
3085 Keokuk $ 159,900.00 1719 4
3094 Oak View Ct $ 224,000.00 3098 4
3103 Asbury Rd $ 173,900.00 1876 3
3160 Sheridan Rd $ 184,500.00 3812 6
3202 Honeysuckle DR $ 299,000.00 3130 4
3215 Blasen Rd $ 189,000.00 2620 4
343 Hill St $ 135,000.00 1742 4
3915 Inwood Ave $ 124,900.00 1432 3
4100 Peru Rd $ 150,000.00 1200 3
500 Alta Vista St $ 129,500.00 1248 3
515 Strauss ST $ 134,000.00 1322 2
525 Stevens Ct $ 158,900.00 2052 3
530 Sapphire Cr $ 213,900.00 2082 4
561 Tanzanite Dr. $ 199,900.00 2048 3
586 W 7th St $ 279,500.00 2829 3
60 Alpine St $ 119,000.00 1572 3
6504 N Dorchester $ 289,900.00 1791 3
670 Harvard ST $ 134,500.00 1744 3
679 Bluff St $ 196,000.00 2539 5
705 Wilson ST $ 156,900.00 2064 4
714 W 8th ST $ 139,900.00 2467 3
725 Clarke Dr $ 120,000.00 1402 3
760 Kauffman Ave $ 144,900.00 1583 3
819 Kaufmann Ave $ 176,900.00 2266 4
829 Lawther ST $ 139,900.00 1710 3
881 Berkley Pl $ 154,900.00 1917 3
949 Spires Dr $ 275,000.00 2680 4
Mean $ 193,262.86 2123.381 3.324
1mil-725K 724k-500k 499k-250k 249k-0 1 1 15 88

1 BDRM 2 BDRM 3 BDRM 4 BDRM 5 BDRM 6 BDRM 10 BDRM 1 10 60 28 4 1 1 1 BDRM 2 BDRM 3 BDRM 4 BDRM 5 BDRM 6 BDRM 10 BDRM

Week 3

1010 Dunham Dr $ 299,000.00 2137 3
1015 Shady Ln $ 185,000.00 3152 5
10185 Boleyn Rd $ 119,900.00 1040 2
10257 Emberwoood $ 325,000.00 3020 4
1030 Melrose Ter $ 149,900.00 1719 4
1105 Grove Ter. $ 749,000.00 6660 10
1134 Langworthy St. $ 269,900.00 2068 4
1145 Mt Pleasant St $ 179,900.00 1928 4
1156 Center PL $ 132,000.00 1958 3
1215 University Ave $ 145,000.00 1547 3 $ 255,460.00
12421 Brittany Ct $ 454,000.00 4673 3
1292 Wood St $ 157,000.00 1995 2
13949 Barrington Lake $ 225,000.00 2518 3
1465 Parkway St $ 157,900.00 1920 4
1575 Montrose Ter $ 174,500.00 2590 4
16329 Country View $ 379,000.00 1900 3
1645 Earl Dr $ 148,000.00 1560 3
1690 Auburn St $ 154,900.00 1334 3
1698 N Algona ST $ 139,500.00 1326 3
1709 Lawndale St $ 124,000.00 1732 2
$ 211,380.00
17173 Ballymore Dr. $ 545,000.00 3220 4
17400 Ballymore Ln $ 445,000.00 3314 4
1745 Bristol Dr $ 137,000.00 1590 3
1748 Avalon Rd $ 153,000.00 1693 3
1765 Alta Vista St $ 139,500.00 2097 3
1775 Glen Oak St $ 132,900.00 1596 3
1785 Sarah St $ 124,900.00 1664 3
1820 Hale St $ 151,000.00 1369 3
1836 Carter RD $ 175,000.00 2332 3
1837 Lori St $ 134,900.00 1610 2
$ 213,820.00
1849 Jackson ST $ 120,000.00 850 1
1896 Carter Rd $ 169,900.00 2144 4
1925 St Anne Ct $ 184,000.00 2355 3
1970 Fillmore ST $ 153,900.00 2080 3
2010 Alta Vista St $ 233,500.00 2112 4
2015 Lombard ST $ 164,900.00 2726 4
2130 Fairway Dr $ 179,000.00 1960 3
2215 Aspen Dr. $ 299,900.00 2754 3
2221 Aspen Dr $ 259,900.00 3120 4
2240 Schroeder ST $ 122,500.00 1415 3
$ 188,750.00
2290 EvergreenDr $ 139,900.00 1750 3
2350 Pearl St $ 150,000.00 2208 3
2455 Asbury Rd $ 140,000.00 1080 2
251 N Booth St $ 119,900.00 1048 2
2540 Knob Hill Dr $ 204,900.00 2400 3
2545 Marywood Dr $ 129,900.00 1449 3
2555 Univeristy Ave $ 139,900.00 1506 4
2629 Millstone $ 149,900.00 1540 3
2635 Fulton St $ 120,000.00 1085 3
2652 Mineral St $ 174,000.00 2008 3
$ 146,840.00
2715 Ken Ct $ 171,000.00 2732 3
2725 Shady Ln $ 190,000.00 2285 4
2735 Windsor Ave $ 149,000.00 1968 3
2765 Brunswick ST $ 120,000.00 1714 2
2820 Illinois Ave $ 250,000.00 3119 3
2820 Van Buren St $ 144,000.00 2327 5
2820 Wildwood Ct $ 214,900.00 2963 4
2825 Davenport ST $ 129,900.00 1893 4
2828 Arbor Hills Dr. $ 434,900.00 4570 4
285 Princeton Pl $ 159,900.00 2132 2
$ 196,360.00
2860 Indiana Ave $ 130,000.00 1300 3
2870 N Grandview $ 208,900.00 1400 3
2890 N Grandview $ 208,900.00 1412 3
2905 St Anne Dr $ 189,900.00 2221 3
2918 Indiana Ave $ 129,900.00 1640 3
2929 Brueck Rd $ 214,900.00 2084 3
2930 Balke ST $ 126,000.00 1525 3
2939 Van Buren St $ 136,000.00 1660 3
2975 Arbor Hills Dr. $ 449,000.00 3582 5
2975 St Anne Dr $ 169,900.00 2123 4
$ 196,340.00
2995 Davenport St $ 139,900.00 2082 2
3023 W 32nd ST $ 209,000.00 2275 3
3030 Kaufmann Ave $ 166,900.00 2205 3
3040 Brunswick St $ 119,900.00 1400 3
3045 Deerwood Cr $ 169,000.00 1840 3
3049 Judson Ct $ 189,900.00 2484 3
3063 Westmore Dr $ 169,000.00 2080 3
3084 Oak View Ct $ 235,800.00 3142 4
3085 Keokuk $ 159,900.00 1719 4
3094 Oak View Ct $ 224,000.00 3098 4
$ 178,330.00
3103 Asbury Rd $ 173,900.00 1876 3
3160 Sheridan Rd $ 184,500.00 3812 6
3202 Honeysuckle DR $ 299,000.00 3130 4
3215 Blasen Rd $ 189,000.00 2620 4
343 Hill St $ 135,000.00 1742 4
3915 Inwood Ave $ 124,900.00 1432 3
4100 Peru Rd $ 150,000.00 1200 3
500 Alta Vista St $ 129,500.00 1248 3
515 Strauss ST $ 134,000.00 1322 2
525 Stevens Ct $ 158,900.00 2052 3
$ 167,870.00
530 Sapphire Cr $ 213,900.00 2082 4
561 Tanzanite Dr. $ 199,900.00 2048 3
586 W 7th St $ 279,500.00 2829 3
60 Alpine St $ 119,000.00 1572 3
6504 N Dorchester $ 289,900.00 1791 3
670 Harvard ST $ 134,500.00 1744 3
679 Bluff St $ 196,000.00 2539 5
705 Wilson ST $ 156,900.00 2064 4
714 W 8th ST $ 139,900.00 2467 3
725 Clarke Dr $ 120,000.00 1402 3
$ 184,950.00
Mean of all sample means $ 194,010.00

Sheet2

$ 749,000.00 308843768775.38 6660 20580911.951161
$ 545,000.00 123719015655.38 4673 6500557.045161
$ 454,000.00 67983856175.3796 4570 5985944.531161
$ 449,000.00 65401484775.3796 3812 2851434.127161
$ 445,000.00 63371587655.3796 3582 2127569.387161
$ 434,900.00 58388507427.3796 3314 1417573.603161
$ 379,000.00 34498285175.3796 3220 1202573.231161
$ 325,000.00 17354674055.3796 3152 1058057.047161
$ 299,900.00 11371479627.3796 3142 1037584.667161
$ 299,000.00 11180342775.3796 3130 1013281.811161
$ 299,000.00 11180342775.3796 3120 993249.431161
$ 289,900.00 9338736827.3796 3119 991257.193161
$ 279,500.00 7436844315.3796 3098 949882.195161
$ 275,000.00 6680960055.3796 3020 803925.631161
$ 269,900.00 5873251227.3796 2963 704960.065161
$ 259,900.00 4440508427.3796 2829 497898.173161
$ 250,000.00 3219103055.3796 2754 397680.323161
$ 235,800.00 1809408279.3796 2732 370417.087161
$ 233,500.00 1619027435.3796 2726 363149.659161
$ 225,000.00 1007246055.3796 2680 309824.711161
$ 224,000.00 944771775.379601 2620 246630.431161
$ 214,900.00 468165827.379601 2590 217733.291161
$ 214,900.00 468165827.379601 2539 172739.153161
$ 213,900.00 425891547.379601 2518 155724.155161
$ 209,000.00 247657575.3796 2484 130046.063161
$ 208,900.00 244520147.3796 2467 118074.017161
$ 208,900.00 244520147.3796 2400 76518.0711610001
$ 204,900.00 135423027.3796 2355 53647.3611610001
$ 199,900.00 44051627.3796002 2332 43521.8871610001
$ 196,000.00 7491935.37960008 2327 41460.6971610001
$ 190,000.00 10646255.3795999 2285 26120.701161
$ 189,900.00 11308827.3795999 2275 22988.321161
$ 189,900.00 11308827.3795999 2266 20340.179161
$ 189,000.00 18171975.3795999 2221 9529.469161
$ 185,000.00 68274855.3795998 2208 7160.375161
$ 184,500.00 76787715.3795998 2205 6661.661161
$ 184,000.00 85800575.3795997 2144 425.143161
$ 179,900.00 178566027.3796 2137 185.477161
$ 179,000.00 203429175.3796 2132 74.287161
$ 176,900.00 267743187.3796 2123 0.145161
$ 175,000.00 333532055.3796 2112 129.527161
$ 174,500.00 352044915.379599 2097 695.957161
$ 174,000.00 371057775.379599 2084 1550.863161
$ 173,900.00 374920347.379599 2082 1712.387161
$ 171,000.00 495634935.379599 2082 1712.387161
$ 169,900.00 545823227.379599 2080 1881.911161
$ 169,900.00 545823227.379599 2080 1881.911161
$ 169,000.00 588686375.379599 2068 3067.055161
$ 169,000.00 588686375.379599 2064 3526.103161
$ 166,900.00 695000387.379599 2052 5095.247161
$ 164,900.00 804451827.379599 2048 5682.295161
$ 159,900.00 1113080427.3796 2008 13312.775161
$ 159,900.00 1113080427.3796 1995 16481.681161
$ 158,900.00 1180806147.3796 1968 24143.255161
$ 157,900.00 1250531867.3796 1960 26693.351161
$ 157,000.00 1314995015.3796 1958 27350.875161
$ 156,900.00 1322257587.3796 1928 38173.7351609999
$ 154,900.00 1471709027.3796 1920 41363.8311609999
$ 154,900.00 1471709027.3796 1917 42593.1171609999
$ 153,900.00 1549434747.3796 1900 49899.0711609999
$ 153,000.00 1621097895.3796 1893 53075.4051609999
$ 151,000.00 1786149335.3796 1876 61197.3591609999
$ 150,000.00 1871675055.3796 1840 80304.7911609999
$ 150,000.00 1871675055.3796 1791 110477.129161
$ 149,900.00 1880337627.3796 1750 139413.371161
$ 149,900.00 1880337627.3796 1744 143929.943161
$ 149,000.00 1959200775.3796 1742 145451.467161
$ 148,000.00 2048726495.3796 1732 153179.087161
$ 145,000.00 2329303655.3796 1719 163523.993161
$ 144,900.00 2338966227.3796 1719 163523.993161
$ 144,000.00 2426829375.3796 1714 167592.803161
$ 140,000.00 2836932255.3796 1710 170883.851161
$ 139,900.00 2847594827.3796 1693 185227.805161
$ 139,900.00 2847594827.3796 1664 211030.903161
$ 139,900.00 2847594827.3796 1660 214721.951161
$ 139,900.00 2847594827.3796 1640 233657.191161
$ 139,900.00 2847594827.3796 1610 263560.051161
$ 139,500.00 2890445115.3796 1596 278130.719161
$ 139,500.00 2890445115.3796 1590 284495.291161
$ 137,000.00 3165509415.3796 1583 292011.625161
$ 136,000.00 3279035135.3796 1572 304021.007161
$ 135,000.00 3394560855.3796 1560 317398.151161
$ 134,900.00 3406223427.3796 1547 332215.057161
$ 134,500.00 3453073715.3796 1540 340333.391161
$ 134,000.00 3512086575.3796 1525 358059.821161
$ 132,900.00 3643674867.3796 1506 381159.299161
$ 132,000.00 3753138015.3796 1449 454789.733161
$ 130,000.00 4002189455.3796 1432 478007.687161
$ 129,900.00 4014852027.3796 1415 501803.641161
$ 129,900.00 4014852027.3796 1412 506062.927161
$ 129,900.00 4014852027.3796 1402 520390.547161
$ 129,500.00 4065702315.3796 1400 523280.071161
$ 126,000.00 4524292335.3796 1400 523280.071161
$ 124,900.00 4673480627.3796 1369 569090.693161
$ 124,900.00 4673480627.3796 1334 623122.363161
$ 124,000.00 4797343775.3796 1326 635816.459161
$ 122,500.00 5007382355.3796 1322 642211.507161
$ 120,000.00 5367446655.3796 1300 677956.271161
$ 120,000.00 5367446655.3796 1248 766291.895161
$ 120,000.00 5367446655.3796 1200 852632.471161
$ 120,000.00 5367446655.3796 1085 1078235.101161
$ 119,000.00 5514972375.3796 1080 1088643.911161
$ 119,900.00 5382109227.3796 1048 1156444.295161
$ 119,900.00 5382109227.3796 1040 1173714.391161
$ 119,900.00 5382109227.3796 850 1621499.171161
$ 193,262.86 995761305142.862 9483441001.36059 2123.380952381 71756108.761905 683391.512018143