Real Estate Regression Exercise
lttlxmntqle
week_5_team_assignment_team_d.xlsxWeek 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 |
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
Wk3 Q1+Q2
| 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 |
Wk3 Q3
| $ 749,000.00 | 308,843,768,775.38 | 6660 | 20,580,911.95 | |||
| $ 545,000.00 | 123,719,015,655.38 | 4673 | 6,500,557.05 | |||
| $ 454,000.00 | 67,983,856,175.38 | 4570 | 5,985,944.53 | |||
| $ 449,000.00 | 65,401,484,775.38 | 3812 | 2,851,434.13 | |||
| $ 445,000.00 | 63,371,587,655.38 | 3582 | 2,127,569.39 | |||
| $ 434,900.00 | 58,388,507,427.38 | 3314 | 1,417,573.60 | |||
| $ 379,000.00 | 34,498,285,175.38 | 3220 | 1,202,573.23 | |||
| $ 325,000.00 | 17,354,674,055.38 | 3152 | 1,058,057.05 | |||
| $ 299,900.00 | 11,371,479,627.38 | 3142 | 1,037,584.67 | |||
| $ 299,000.00 | 11,180,342,775.38 | 3130 | 1,013,281.81 | |||
| $ 299,000.00 | 11,180,342,775.38 | 3120 | 993,249.43 | |||
| $ 289,900.00 | 9,338,736,827.38 | 3119 | 991,257.19 | |||
| $ 279,500.00 | 7,436,844,315.38 | 3098 | 949,882.20 | |||
| $ 275,000.00 | 6,680,960,055.38 | 3020 | 803,925.63 | |||
| $ 269,900.00 | 5,873,251,227.38 | 2963 | 704,960.07 | |||
| $ 259,900.00 | 4,440,508,427.38 | 2829 | 497,898.17 | |||
| $ 250,000.00 | 3,219,103,055.38 | 2754 | 397,680.32 | |||
| $ 235,800.00 | 1,809,408,279.38 | 2732 | 370,417.09 | |||
| $ 233,500.00 | 1,619,027,435.38 | 2726 | 363,149.66 | |||
| $ 225,000.00 | 1,007,246,055.38 | 2680 | 309,824.71 | |||
| $ 224,000.00 | 944,771,775.38 | 2620 | 246,630.43 | |||
| $ 214,900.00 | 468,165,827.38 | 2590 | 217,733.29 | |||
| $ 214,900.00 | 468,165,827.38 | 2539 | 172,739.15 | |||
| $ 213,900.00 | 425,891,547.38 | 2518 | 155,724.16 | |||
| $ 209,000.00 | 247,657,575.38 | 2484 | 130,046.06 | |||
| $ 208,900.00 | 244,520,147.38 | 2467 | 118,074.02 | |||
| $ 208,900.00 | 244,520,147.38 | 2400 | 76,518.07 | |||
| $ 204,900.00 | 135,423,027.38 | 2355 | 53,647.36 | |||
| $ 199,900.00 | 44,051,627.38 | 2332 | 43,521.89 | |||
| $ 196,000.00 | 7,491,935.38 | 2327 | 41,460.70 | |||
| $ 190,000.00 | 10,646,255.38 | 2285 | 26,120.70 | |||
| $ 189,900.00 | 11,308,827.38 | 2275 | 22,988.32 | |||
| $ 189,900.00 | 11,308,827.38 | 2266 | 20,340.18 | |||
| $ 189,000.00 | 18,171,975.38 | 2221 | 9,529.47 | |||
| $ 185,000.00 | 68,274,855.38 | 2208 | 7,160.38 | |||
| $ 184,500.00 | 76,787,715.38 | 2205 | 6,661.66 | |||
| $ 184,000.00 | 85,800,575.38 | 2144 | 425.14 | |||
| $ 179,900.00 | 178,566,027.38 | 2137 | 185.48 | |||
| $ 179,000.00 | 203,429,175.38 | 2132 | 74.29 | |||
| $ 176,900.00 | 267,743,187.38 | 2123 | 0.15 | |||
| $ 175,000.00 | 333,532,055.38 | 2112 | 129.53 | |||
| $ 174,500.00 | 352,044,915.38 | 2097 | 695.96 | |||
| $ 174,000.00 | 371,057,775.38 | 2084 | 1,550.86 | |||
| $ 173,900.00 | 374,920,347.38 | 2082 | 1,712.39 | |||
| $ 171,000.00 | 495,634,935.38 | 2082 | 1,712.39 | |||
| $ 169,900.00 | 545,823,227.38 | 2080 | 1,881.91 | |||
| $ 169,900.00 | 545,823,227.38 | 2080 | 1,881.91 | |||
| $ 169,000.00 | 588,686,375.38 | 2068 | 3,067.06 | |||
| $ 169,000.00 | 588,686,375.38 | 2064 | 3,526.10 | |||
| $ 166,900.00 | 695,000,387.38 | 2052 | 5,095.25 | |||
| $ 164,900.00 | 804,451,827.38 | 2048 | 5,682.30 | |||
| $ 159,900.00 | 1,113,080,427.38 | 2008 | 13,312.78 | |||
| $ 159,900.00 | 1,113,080,427.38 | 1995 | 16,481.68 | |||
| $ 158,900.00 | 1,180,806,147.38 | 1968 | 24,143.26 | |||
| $ 157,900.00 | 1,250,531,867.38 | 1960 | 26,693.35 | |||
| $ 157,000.00 | 1,314,995,015.38 | 1958 | 27,350.88 | |||
| $ 156,900.00 | 1,322,257,587.38 | 1928 | 38,173.74 | |||
| $ 154,900.00 | 1,471,709,027.38 | 1920 | 41,363.83 | |||
| $ 154,900.00 | 1,471,709,027.38 | 1917 | 42,593.12 | |||
| $ 153,900.00 | 1,549,434,747.38 | 1900 | 49,899.07 | |||
| $ 153,000.00 | 1,621,097,895.38 | 1893 | 53,075.41 | |||
| $ 151,000.00 | 1,786,149,335.38 | 1876 | 61,197.36 | |||
| $ 150,000.00 | 1,871,675,055.38 | 1840 | 80,304.79 | |||
| $ 150,000.00 | 1,871,675,055.38 | 1791 | 110,477.13 | |||
| $ 149,900.00 | 1,880,337,627.38 | 1750 | 139,413.37 | |||
| $ 149,900.00 | 1,880,337,627.38 | 1744 | 143,929.94 | |||
| $ 149,000.00 | 1,959,200,775.38 | 1742 | 145,451.47 | |||
| $ 148,000.00 | 2,048,726,495.38 | 1732 | 153,179.09 | |||
| $ 145,000.00 | 2,329,303,655.38 | 1719 | 163,523.99 | |||
| $ 144,900.00 | 2,338,966,227.38 | 1719 | 163,523.99 | |||
| $ 144,000.00 | 2,426,829,375.38 | 1714 | 167,592.80 | |||
| $ 140,000.00 | 2,836,932,255.38 | 1710 | 170,883.85 | |||
| $ 139,900.00 | 2,847,594,827.38 | 1693 | 185,227.81 | |||
| $ 139,900.00 | 2,847,594,827.38 | 1664 | 211,030.90 | |||
| $ 139,900.00 | 2,847,594,827.38 | 1660 | 214,721.95 | |||
| $ 139,900.00 | 2,847,594,827.38 | 1640 | 233,657.19 | |||
| $ 139,900.00 | 2,847,594,827.38 | 1610 | 263,560.05 | |||
| $ 139,500.00 | 2,890,445,115.38 | 1596 | 278,130.72 | |||
| $ 139,500.00 | 2,890,445,115.38 | 1590 | 284,495.29 | |||
| $ 137,000.00 | 3,165,509,415.38 | 1583 | 292,011.63 | |||
| $ 136,000.00 | 3,279,035,135.38 | 1572 | 304,021.01 | |||
| $ 135,000.00 | 3,394,560,855.38 | 1560 | 317,398.15 | |||
| $ 134,900.00 | 3,406,223,427.38 | 1547 | 332,215.06 | |||
| $ 134,500.00 | 3,453,073,715.38 | 1540 | 340,333.39 | |||
| $ 134,000.00 | 3,512,086,575.38 | 1525 | 358,059.82 | |||
| $ 132,900.00 | 3,643,674,867.38 | 1506 | 381,159.30 | |||
| $ 132,000.00 | 3,753,138,015.38 | 1449 | 454,789.73 | |||
| $ 130,000.00 | 4,002,189,455.38 | 1432 | 478,007.69 | |||
| $ 129,900.00 | 4,014,852,027.38 | 1415 | 501,803.64 | |||
| $ 129,900.00 | 4,014,852,027.38 | 1412 | 506,062.93 | |||
| $ 129,900.00 | 4,014,852,027.38 | 1402 | 520,390.55 | |||
| $ 129,500.00 | 4,065,702,315.38 | 1400 | 523,280.07 | |||
| $ 126,000.00 | 4,524,292,335.38 | 1400 | 523,280.07 | |||
| $ 124,900.00 | 4,673,480,627.38 | 1369 | 569,090.69 | |||
| $ 124,900.00 | 4,673,480,627.38 | 1334 | 623,122.36 | |||
| $ 124,000.00 | 4,797,343,775.38 | 1326 | 635,816.46 | |||
| $ 122,500.00 | 5,007,382,355.38 | 1322 | 642,211.51 | |||
| $ 120,000.00 | 5,367,446,655.38 | 1300 | 677,956.27 | |||
| $ 120,000.00 | 5,367,446,655.38 | 1248 | 766,291.90 | |||
| $ 120,000.00 | 5,367,446,655.38 | 1200 | 852,632.47 | |||
| $ 120,000.00 | 5,367,446,655.38 | 1085 | 1,078,235.10 | |||
| $ 119,000.00 | 5,514,972,375.38 | 1080 | 1,088,643.91 | |||
| $ 119,900.00 | 5,382,109,227.38 | 1048 | 1,156,444.30 | |||
| $ 119,900.00 | 5,382,109,227.38 | 1040 | 1,173,714.39 | |||
| $ 119,900.00 | 5,382,109,227.38 | 850 | 1,621,499.17 | |||
| $ 193,262.86 | 995,761,305,142.86 | 9,483,441,001.36 | 2123.380952381 | 71,756,108.76 | 683,391.51 |
Wk3 Q4
| GROUP I | GROUP II | GROUP III | GROUP IV | GROUP V | GROUP VI | GROUP VI | GROUP VIII | GROUP IX | GROUP X | ||
| $ 299,000.00 | $ 454,000.00 | $ 545,000.00 | $ 120,000.00 | $ 139,900.00 | $ 171,000.00 | $ 130,000.00 | $ 139,900.00 | $ 173,900.00 | $ 213,900.00 | ||
| $ 185,000.00 | $ 157,000.00 | $ 445,000.00 | $ 169,900.00 | $ 150,000.00 | $ 190,000.00 | $ 208,900.00 | $ 209,000.00 | $ 184,500.00 | $ 199,900.00 | ||
| $ 119,900.00 | $ 225,000.00 | $ 137,000.00 | $ 184,000.00 | $ 140,000.00 | $ 149,000.00 | $ 208,900.00 | $ 166,900.00 | $ 299,000.00 | $ 279,500.00 | ||
| $ 325,000.00 | $ 157,900.00 | $ 153,000.00 | $ 153,900.00 | $ 119,900.00 | $ 120,000.00 | $ 189,900.00 | $ 119,900.00 | $ 189,000.00 | $ 119,000.00 | ||
| $ 149,900.00 | $ 174,500.00 | $ 139,500.00 | $ 233,500.00 | $ 204,900.00 | $ 250,000.00 | $ 129,900.00 | $ 169,000.00 | $ 135,000.00 | $ 289,900.00 | ||
| $ 749,000.00 | $ 379,000.00 | $ 132,900.00 | $ 164,900.00 | $ 129,900.00 | $ 144,000.00 | $ 214,900.00 | $ 189,900.00 | $ 124,900.00 | $ 134,500.00 | ||
| $ 269,900.00 | $ 148,000.00 | $ 124,900.00 | $ 179,000.00 | $ 139,900.00 | $ 214,900.00 | $ 126,000.00 | $ 169,000.00 | $ 150,000.00 | $ 196,000.00 | ||
| $ 179,900.00 | $ 154,900.00 | $ 151,000.00 | $ 299,900.00 | $ 149,900.00 | $ 129,900.00 | $ 136,000.00 | $ 235,800.00 | $ 129,500.00 | $ 156,900.00 | ||
| $ 132,000.00 | $ 139,500.00 | $ 175,000.00 | $ 259,900.00 | $ 120,000.00 | $ 434,900.00 | $ 449,000.00 | $ 159,900.00 | $ 134,000.00 | $ 139,900.00 | ||
| $ 145,000.00 | $ 124,000.00 | $ 134,900.00 | $ 122,500.00 | $ 174,000.00 | $ 159,900.00 | $ 169,900.00 | $ 224,000.00 | $ 158,900.00 | $ 120,000.00 | ||
| MEAN | $ 255,460.00 | $ 211,380.00 | $ 213,820.00 | $ 188,750.00 | $ 146,840.00 | $ 196,360.00 | $ 196,340.00 | $ 178,330.00 | $ 167,870.00 | $ 184,950.00 | |
| STANDARD DEVIATION | $ 188,018.59 | $ 112,710.48 | $ 150,696.44 | $ 58,491.33 | $ 25,828.93 | $ 92,716.74 | $ 95,824.78 | $ 36,512.40 | $ 51,532.69 | $ 62,420.91 | |
| STDEV FOR THE ALL | 99,600.1354 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | |
| POPULATION STDEV | $ 99,600.14 | ||||||||||
Compute the standard deviation of those 10 means and compare the standard deviation of the 10 means to the population standard deviation of all 100 listing prices. · Explain why it is significantly higher, or lower, than the population standard deviation.
10 samples standard deviation is more innacurate because the sample size is too small compared to the population. The greater the sample size the higher the degree of accurancy.
Wk3 Q5
| GROUP I | GROUP II | GROUP III | GROUP IV | GROUP V | GROUP VI | GROUP VI | GROUP VIII | GROUP IX | GROUP X | |
| $ 299,000.00 | $ 454,000.00 | $ 545,000.00 | $ 120,000.00 | $ 139,900.00 | $ 171,000.00 | $ 130,000.00 | $ 139,900.00 | $ 173,900.00 | $ 213,900.00 | |
| $ 185,000.00 | $ 157,000.00 | $ 445,000.00 | $ 169,900.00 | $ 150,000.00 | $ 190,000.00 | $ 208,900.00 | $ 209,000.00 | $ 184,500.00 | $ 199,900.00 | |
| $ 119,900.00 | $ 225,000.00 | $ 137,000.00 | $ 184,000.00 | $ 140,000.00 | $ 149,000.00 | $ 208,900.00 | $ 166,900.00 | $ 299,000.00 | $ 279,500.00 | |
| $ 325,000.00 | $ 157,900.00 | $ 153,000.00 | $ 153,900.00 | $ 119,900.00 | $ 120,000.00 | $ 189,900.00 | $ 119,900.00 | $ 189,000.00 | $ 119,000.00 | |
| $ 149,900.00 | $ 174,500.00 | $ 139,500.00 | $ 233,500.00 | $ 204,900.00 | $ 250,000.00 | $ 129,900.00 | $ 169,000.00 | $ 135,000.00 | $ 289,900.00 | |
| $ 749,000.00 | $ 379,000.00 | $ 132,900.00 | $ 164,900.00 | $ 129,900.00 | $ 144,000.00 | $ 214,900.00 | $ 189,900.00 | $ 124,900.00 | $ 134,500.00 | |
| $ 269,900.00 | $ 148,000.00 | $ 124,900.00 | $ 179,000.00 | $ 139,900.00 | $ 214,900.00 | $ 126,000.00 | $ 169,000.00 | $ 150,000.00 | $ 196,000.00 | |
| $ 179,900.00 | $ 154,900.00 | $ 151,000.00 | $ 299,900.00 | $ 149,900.00 | $ 129,900.00 | $ 136,000.00 | $ 235,800.00 | $ 129,500.00 | $ 156,900.00 | |
| $ 132,000.00 | $ 139,500.00 | $ 175,000.00 | $ 259,900.00 | $ 120,000.00 | $ 434,900.00 | $ 449,000.00 | $ 159,900.00 | $ 134,000.00 | $ 139,900.00 | |
| $ 145,000.00 | $ 124,000.00 | $ 134,900.00 | $ 122,500.00 | $ 174,000.00 | $ 159,900.00 | $ 169,900.00 | $ 224,000.00 | $ 158,900.00 | $ 120,000.00 | |
| MEAN | $ 255,460.00 | $ 211,380.00 | $ 213,820.00 | $ 188,750.00 | $ 146,840.00 | $ 196,360.00 | $ 196,340.00 | $ 178,330.00 | $ 167,870.00 | $ 184,950.00 |
| STANDARD DEVIATION | $ 188,018.59 | $ 112,710.48 | $ 150,696.44 | $ 58,491.33 | $ 25,828.93 | $ 92,716.74 | $ 95,824.78 | $ 36,512.40 | $ 51,532.69 | $ 62,420.91 |
| POPULATION | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 | $ 99,600.14 |
| DIFFERENCE | $ 88,418.46 | $ 13,110.35 | $ 51,096.31 | $ (41,108.80) | $ (73,771.20) | $ (6,883.40) | $ (3,775.35) | $ (63,087.73) | $ (48,067.45) | $ (37,179.23) |
Explain how much more or less the standard deviation of sample means was than the population standard deviation. According to the formula for standard deviation of sample means, it should be far less.
From the calculated standard deviation only the first three groups had a stardard deviation higher the population standard deviation.
Wk3 Q6+Q7+Q8
| Empirical Rule Calculations | ||||||||||||||||||||||||||
| Mean | $ 193,262.86 | |||||||||||||||||||||||||
| StandDev | $ 97,382.96 | |||||||||||||||||||||||||
| Q6 | Range 1 | $ 95,879.90 | $ 290,645.82 | One standard deviation | ||||||||||||||||||||||
| Q7 | Range 2 | $ (1,503.06) | $ 388,028.78 | Two standard deviation | ||||||||||||||||||||||
| CURVE | ||||||||||||||||||||||||||
| 1010 Dunham Dr | $ 299,000.00 | 0.00 | GROUP I | GROUP II | GROUP III | GROUP IV | GROUP V | GROUP VI | GROUP VI | GROUP VIII | GROUP IX | GROUP X | ||||||||||||||
| 1015 Shady Ln | $ 185,000.00 | 0.00 | $ 299,000.00 | $ 454,000.00 | $ 545,000.00 | $ 120,000.00 | $ 139,900.00 | $ 171,000.00 | $ 130,000.00 | $ 139,900.00 | $ 173,900.00 | $ 213,900.00 | ||||||||||||||
| 10185 Boleyn Rd | $ 119,900.00 | 0.00 | $ 185,000.00 | $ 157,000.00 | $ 445,000.00 | $ 169,900.00 | $ 150,000.00 | $ 190,000.00 | $ 208,900.00 | $ 209,000.00 | $ 184,500.00 | $ 199,900.00 | ||||||||||||||
| 10257 Emberwoood | $ 325,000.00 | 0.00 | $ 119,900.00 | $ 225,000.00 | $ 137,000.00 | $ 184,000.00 | $ 140,000.00 | $ 149,000.00 | $ 208,900.00 | $ 166,900.00 | $ 299,000.00 | $ 279,500.00 | ||||||||||||||
| 1030 Melrose Ter | $ 149,900.00 | 0.00 | $ 325,000.00 | $ 157,900.00 | $ 153,000.00 | $ 153,900.00 | $ 119,900.00 | $ 120,000.00 | $ 189,900.00 | $ 119,900.00 | $ 189,000.00 | $ 119,000.00 | ||||||||||||||
| 1 | 1105 Grove Ter. | $ 749,000.00 | 0.00 | $ 149,900.00 | $ 174,500.00 | $ 139,500.00 | $ 233,500.00 | $ 204,900.00 | $ 250,000.00 | $ 129,900.00 | $ 169,000.00 | $ 135,000.00 | $ 289,900.00 | |||||||||||||
| 1134 Langworthy St. | $ 269,900.00 | 0.00 | $ 749,000.00 | $ 379,000.00 | $ 132,900.00 | $ 164,900.00 | $ 129,900.00 | $ 144,000.00 | $ 214,900.00 | $ 189,900.00 | $ 124,900.00 | $ 134,500.00 | ||||||||||||||
| 1145 Mt Pleasant St | $ 179,900.00 | 0.00 | $ 269,900.00 | $ 148,000.00 | $ 124,900.00 | $ 179,000.00 | $ 139,900.00 | $ 214,900.00 | $ 126,000.00 | $ 169,000.00 | $ 150,000.00 | $ 196,000.00 | ||||||||||||||
| 1156 Center PL | $ 132,000.00 | 0.00 | $ 179,900.00 | $ 154,900.00 | $ 151,000.00 | $ 299,900.00 | $ 149,900.00 | $ 129,900.00 | $ 136,000.00 | $ 235,800.00 | $ 129,500.00 | $ 156,900.00 | ||||||||||||||
| 1215 University Ave | $ 145,000.00 | 0.00 | $ 132,000.00 | $ 139,500.00 | $ 175,000.00 | $ 259,900.00 | $ 120,000.00 | $ 434,900.00 | $ 449,000.00 | $ 159,900.00 | $ 134,000.00 | $ 139,900.00 | ||||||||||||||
| 2 | 12421 Brittany Ct | $ 454,000.00 | 0.00 | $ 145,000.00 | $ 124,000.00 | $ 134,900.00 | $ 122,500.00 | $ 174,000.00 | $ 159,900.00 | $ 169,900.00 | $ 224,000.00 | $ 158,900.00 | $ 120,000.00 | |||||||||||||
| 1292 Wood St | $ 157,000.00 | 0.00 | ||||||||||||||||||||||||
| 13949 Barrington Lake | $ 225,000.00 | 0.00 | MEAN | $ 255,460.00 | $ 211,380.00 | $ 213,820.00 | $ 188,750.00 | $ 146,840.00 | $ 196,360.00 | $ 196,340.00 | $ 178,330.00 | $ 167,870.00 | $ 184,950.00 | |||||||||||||
| 1465 Parkway St | $ 157,900.00 | 0.00 | ||||||||||||||||||||||||
| 1575 Montrose Ter | $ 174,500.00 | 0.00 | 100% of the samples means will be within one standard deviation to the population's mean | |||||||||||||||||||||||
| 16329 Country View | $ 379,000.00 | 0.00 | ||||||||||||||||||||||||
| 1645 Earl Dr | $ 148,000.00 | 0.00 | ||||||||||||||||||||||||
| 1690 Auburn St | $ 154,900.00 | 0.00 | Chebyshev's Theorem | |||||||||||||||||||||||
| 1698 N Algona ST | $ 139,500.00 | 0.00 | ||||||||||||||||||||||||
| 1709 Lawndale St | $ 124,000.00 | 0.00 | "at least 3/4 (75%) of the data lie within two standard deviations of the mean" | |||||||||||||||||||||||
| 3 | 17173 Ballymore Dr. | $ 545,000.00 | 0.00 | |||||||||||||||||||||||
| 4 | 17400 Ballymore Ln | $ 445,000.00 | 0.00 | For this data set: | ||||||||||||||||||||||
| 1745 Bristol Dr | $ 137,000.00 | 0.00 | 94% of the data lies within two standard deviations of the mean | |||||||||||||||||||||||
| 1748 Avalon Rd | $ 153,000.00 | 0.00 | 6% lie within three standard deviations of the mean. | |||||||||||||||||||||||
| 1765 Alta Vista St | $ 139,500.00 | 0.00 | ||||||||||||||||||||||||
| 1775 Glen Oak St | $ 132,900.00 | 0.00 | This results indicate the Chebyshev's theorem is true for this data set. | |||||||||||||||||||||||
| 1785 Sarah St | $ 124,900.00 | 0.00 | ||||||||||||||||||||||||
| 1820 Hale St | $ 151,000.00 | 0.00 | ||||||||||||||||||||||||
| 1836 Carter RD | $ 175,000.00 | 0.00 | ||||||||||||||||||||||||
| 1837 Lori St | $ 134,900.00 | 0.00 | ||||||||||||||||||||||||
| 1849 Jackson ST | $ 120,000.00 | 0.00 | ||||||||||||||||||||||||
| 1896 Carter Rd | $ 169,900.00 | 0.00 | ||||||||||||||||||||||||
| 1925 St Anne Ct | $ 184,000.00 | 0.00 | ||||||||||||||||||||||||
| 1970 Fillmore ST | $ 153,900.00 | 0.00 | ||||||||||||||||||||||||
| 2010 Alta Vista St | $ 233,500.00 | 0.00 | ||||||||||||||||||||||||
| 2015 Lombard ST | $ 164,900.00 | 0.00 | ||||||||||||||||||||||||
| 2130 Fairway Dr | $ 179,000.00 | 0.00 | ||||||||||||||||||||||||
| 2215 Aspen Dr. | $ 299,900.00 | 0.00 | ||||||||||||||||||||||||
| 2221 Aspen Dr | $ 259,900.00 | 0.00 | ||||||||||||||||||||||||
| 2240 Schroeder ST | $ 122,500.00 | 0.00 | ||||||||||||||||||||||||
| 2290 EvergreenDr | $ 139,900.00 | 0.00 | ||||||||||||||||||||||||
| 2350 Pearl St | $ 150,000.00 | 0.00 | ||||||||||||||||||||||||
| 2455 Asbury Rd | $ 140,000.00 | 0.00 | ||||||||||||||||||||||||
| 251 N Booth St | $ 119,900.00 | 0.00 | ||||||||||||||||||||||||
| 2540 Knob Hill Dr | $ 204,900.00 | 0.00 | ||||||||||||||||||||||||
| 2545 Marywood Dr | $ 129,900.00 | 0.00 | ||||||||||||||||||||||||
| 2555 Univeristy Ave | $ 139,900.00 | 0.00 | ||||||||||||||||||||||||
| 2629 Millstone | $ 149,900.00 | 0.00 | ||||||||||||||||||||||||
| 2635 Fulton St | $ 120,000.00 | 0.00 | ||||||||||||||||||||||||
| 2652 Mineral St | $ 174,000.00 | 0.00 | ||||||||||||||||||||||||
| 2715 Ken Ct | $ 171,000.00 | 0.00 | ||||||||||||||||||||||||
| 2725 Shady Ln | $ 190,000.00 | 0.00 | ||||||||||||||||||||||||
| 2735 Windsor Ave | $ 149,000.00 | 0.00 | ||||||||||||||||||||||||
| 2765 Brunswick ST | $ 120,000.00 | 0.00 | ||||||||||||||||||||||||
| 2820 Illinois Ave | $ 250,000.00 | 0.00 | ||||||||||||||||||||||||
| 2820 Van Buren St | $ 144,000.00 | 0.00 | ||||||||||||||||||||||||
| 2820 Wildwood Ct | $ 214,900.00 | 0.00 | ||||||||||||||||||||||||
| 2825 Davenport ST | $ 129,900.00 | 0.00 | ||||||||||||||||||||||||
| 5 | 2828 Arbor Hills Dr. | $ 434,900.00 | 0.00 | |||||||||||||||||||||||
| 285 Princeton Pl | $ 159,900.00 | 0.00 | ||||||||||||||||||||||||
| 2860 Indiana Ave | $ 130,000.00 | 0.00 | ||||||||||||||||||||||||
| 2870 N Grandview | $ 208,900.00 | 0.00 | ||||||||||||||||||||||||
| 2890 N Grandview | $ 208,900.00 | 0.00 | ||||||||||||||||||||||||
| 2905 St Anne Dr | $ 189,900.00 | 0.00 | ||||||||||||||||||||||||
| 2918 Indiana Ave | $ 129,900.00 | 0.00 | ||||||||||||||||||||||||
| 2929 Brueck Rd | $ 214,900.00 | 0.00 | ||||||||||||||||||||||||
| 2930 Balke ST | $ 126,000.00 | 0.00 | ||||||||||||||||||||||||
| 2939 Van Buren St | $ 136,000.00 | 0.00 | ||||||||||||||||||||||||
| 6 | 2975 Arbor Hills Dr. | $ 449,000.00 | 0.00 | |||||||||||||||||||||||
| 2975 St Anne Dr | $ 169,900.00 | 0.00 | ||||||||||||||||||||||||
| 2995 Davenport St | $ 139,900.00 | 0.00 | ||||||||||||||||||||||||
| 3023 W 32nd ST | $ 209,000.00 | 0.00 | ||||||||||||||||||||||||
| 3030 Kaufmann Ave | $ 166,900.00 | 0.00 | ||||||||||||||||||||||||
| 3040 Brunswick St | $ 119,900.00 | 0.00 | ||||||||||||||||||||||||
| 3045 Deerwood Cr | $ 169,000.00 | 0.00 | ||||||||||||||||||||||||
| 3049 Judson Ct | $ 189,900.00 | 0.00 | ||||||||||||||||||||||||
| 3063 Westmore Dr | $ 169,000.00 | 0.00 | ||||||||||||||||||||||||
| 3084 Oak View Ct | $ 235,800.00 | 0.00 | ||||||||||||||||||||||||
| 3085 Keokuk | $ 159,900.00 | 0.00 | ||||||||||||||||||||||||
| 3094 Oak View Ct | $ 224,000.00 | 0.00 | ||||||||||||||||||||||||
| 3103 Asbury Rd | $ 173,900.00 | 0.00 | ||||||||||||||||||||||||
| 3160 Sheridan Rd | $ 184,500.00 | 0.00 | ||||||||||||||||||||||||
| 3202 Honeysuckle DR | $ 299,000.00 | 0.00 | ||||||||||||||||||||||||
| 3215 Blasen Rd | $ 189,000.00 | 0.00 | ||||||||||||||||||||||||
| 343 Hill St | $ 135,000.00 | 0.00 | ||||||||||||||||||||||||
| 3915 Inwood Ave | $ 124,900.00 | 0.00 | ||||||||||||||||||||||||
| 4100 Peru Rd | $ 150,000.00 | 0.00 | ||||||||||||||||||||||||
| 500 Alta Vista St | $ 129,500.00 | 0.00 | ||||||||||||||||||||||||
| 515 Strauss ST | $ 134,000.00 | 0.00 | ||||||||||||||||||||||||
| 525 Stevens Ct | $ 158,900.00 | 0.00 | ||||||||||||||||||||||||
| 530 Sapphire Cr | $ 213,900.00 | 0.00 | ||||||||||||||||||||||||
| 561 Tanzanite Dr. | $ 199,900.00 | 0.00 | ||||||||||||||||||||||||
| 586 W 7th St | $ 279,500.00 | 0.00 | ||||||||||||||||||||||||
| 60 Alpine St | $ 119,000.00 | 0.00 | ||||||||||||||||||||||||
| 6504 N Dorchester | $ 289,900.00 | 0.00 | ||||||||||||||||||||||||
| 670 Harvard ST | $ 134,500.00 | 0.00 | ||||||||||||||||||||||||
| 679 Bluff St | $ 196,000.00 | 0.00 | ||||||||||||||||||||||||
| 705 Wilson ST | $ 156,900.00 | 0.00 | ||||||||||||||||||||||||
| 714 W 8th ST | $ 139,900.00 | 0.00 | ||||||||||||||||||||||||
| 725 Clarke Dr | $ 120,000.00 | 0.00 |
According to the Empirical Rule, what percentage of your sample means should be within 1 standard deviation of the population mean? Using your computed σ do your sample means seem to conform to the rule?
DISTRIBUTION CURVE
299000 185000 119900 325000 149900 749000 269900 179900 132000 145000 454000 157000 225000 157900 174500 379000 148000 154900 139500 124000 545000 445000 137000 153000 139500 132900 124900 151000 175000 134900 120000 169900 184000 153900 233500 164900 179000 299900 259900 122500 139900 150000 140000 119900 204900 129900 139900 149 900 120000 174000 171000 190000 149000 120000 250000 144000 214900 129900 434900 159900 130000 208900 208900 189900 129900 214900 126000 136000 449000 169900 139900 209000 166900 119900 169000 189900 169000 235800 159900 224000 173900 184500 299000 189000 135000 124900 150000 129500 134000 158900 213900 199900 279500 119000 289900 134500 196000 156900 139900 120000 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 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
About 68% of the data will be within one standard deviation of the mean, about 95% will be within two standard deviations of the mean, and about 99.7% will be within three standard deviations of the mean (Empirical Rule)
From the distribution curve the data does not conform to EMPIRICAL RULE because it does not have a normal distribution curve.
Week 4
| Sq. Footage | Price | ||||||||||
| 2137 | $ 299,000.00 | ||||||||||
| 3152 | $ 185,000.00 | ||||||||||
| 1040 | $ 119,900.00 | ||||||||||
| 3020 | $ 325,000.00 | ||||||||||
| 1719 | $ 149,900.00 | ||||||||||
| 6660 | $ 749,000.00 | ||||||||||
| 2068 | $ 269,900.00 | ||||||||||
| 1928 | $ 179,900.00 | ||||||||||
| 1958 | $ 132,000.00 | ||||||||||
| 1547 | $ 145,000.00 | ||||||||||
| 4673 | $ 454,000.00 | ||||||||||
| 1995 | $ 157,000.00 | ||||||||||
| 2518 | $ 225,000.00 | ||||||||||
| 1920 | $ 157,900.00 | ||||||||||
| 2590 | $ 174,500.00 | ||||||||||
| 1900 | $ 379,000.00 | ||||||||||
| 1560 | $ 148,000.00 | ||||||||||
| 1334 | $ 154,900.00 | ||||||||||
| 1326 | $ 139,500.00 | ||||||||||
| 1732 | $ 124,000.00 | ||||||||||
| 3220 | $ 545,000.00 | ||||||||||
| 3314 | $ 445,000.00 | ||||||||||
| 1590 | $ 137,000.00 | ||||||||||
| 1693 | $ 153,000.00 | SUMMARY OUTPUT | |||||||||
| 2097 | $ 139,500.00 | ||||||||||
| 1596 | $ 132,900.00 | Regression Statistics | |||||||||
| 1664 | $ 124,900.00 | Multiple R | 0.811306127 | ||||||||
| 1369 | $ 151,000.00 | R Square | 0.6582176318 | ||||||||
| 2332 | $ 175,000.00 | Adjusted R Square | 0.6548993564 | ||||||||
| 1610 | $ 134,900.00 | Standard Error | 57482.2604173095 | ||||||||
| 850 | $ 120,000.00 | Observations | 105 | ||||||||
| 2144 | $ 169,900.00 | ||||||||||
| 2355 | $ 184,000.00 | ANOVA | |||||||||
| 2080 | $ 153,900.00 | df | SS | MS | F | Significance F | |||||
| 2112 | $ 233,500.00 | Regression | 1 | 655427648086.468 | 655427648086.468 | 198.361362014 | 9.35981953020106E-26 | ||||
| 2726 | $ 164,900.00 | Residual | 103 | 340333657056.389 | 3304210262.68339 | ||||||
| 1960 | $ 179,000.00 | Total | 104 | 995761305142.857 | |||||||
| 2754 | $ 299,900.00 | ||||||||||
| 3120 | $ 259,900.00 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | ||
| 1415 | $ 122,500.00 | Intercept | -9673.9654091529 | 15462.4219045511 | -0.6256436067 | 0.5329325815 | -40340.0323638089 | 20992.101545503 | -40340.0323638089 | 20992.101545503 | |
| 1750 | $ 139,900.00 | Sq. Footage | 95.5724983425 | 6.7858522302 | 14.0840818662 | 9.3598195302016E-26 | 82.1143609226 | 109.0306357625 | 82.1143609226 | 109.0306357625 | |
| 2208 | $ 150,000.00 | ||||||||||
| 1080 | $ 140,000.00 | ||||||||||
| 1048 | $ 119,900.00 | ||||||||||
| 2400 | $ 204,900.00 | ||||||||||
| 1449 | $ 129,900.00 | ||||||||||
| 1506 | $ 139,900.00 | ||||||||||
| 1540 | $ 149,900.00 | ||||||||||
| 1085 | $ 120,000.00 | ||||||||||
| 2008 | $ 174,000.00 | ||||||||||
| 2732 | $ 171,000.00 | ||||||||||
| 2285 | $ 190,000.00 | ||||||||||
| 1968 | $ 149,000.00 | ||||||||||
| 1714 | $ 120,000.00 | ||||||||||
| 3119 | $ 250,000.00 | ||||||||||
| 2327 | $ 144,000.00 | ||||||||||
| 2963 | $ 214,900.00 | ||||||||||
| 1893 | $ 129,900.00 | ||||||||||
| 4570 | $ 434,900.00 | ||||||||||
| 2132 | $ 159,900.00 | ||||||||||
| 1300 | $ 130,000.00 | ||||||||||
| 1400 | $ 208,900.00 | ||||||||||
| 1412 | $ 208,900.00 | ||||||||||
| 2221 | $ 189,900.00 | ||||||||||
| 1640 | $ 129,900.00 | ||||||||||
| 2084 | $ 214,900.00 | ||||||||||
| 1525 | $ 126,000.00 | ||||||||||
| 1660 | $ 136,000.00 | ||||||||||
| 3582 | $ 449,000.00 | ||||||||||
| 2123 | $ 169,900.00 | ||||||||||
| 2082 | $ 139,900.00 | ||||||||||
| 2275 | $ 209,000.00 | ||||||||||
| 2205 | $ 166,900.00 | ||||||||||
| 1400 | $ 119,900.00 | ||||||||||
| 1840 | $ 169,000.00 | ||||||||||
| 2484 | $ 189,900.00 | ||||||||||
| 2080 | $ 169,000.00 | ||||||||||
| 3142 | $ 235,800.00 | ||||||||||
| 1719 | $ 159,900.00 | ||||||||||
| 3098 | $ 224,000.00 | ||||||||||
| 1876 | $ 173,900.00 | ||||||||||
| 3812 | $ 184,500.00 | ||||||||||
| 3130 | $ 299,000.00 | ||||||||||
| 2620 | $ 189,000.00 | ||||||||||
| 1742 | $ 135,000.00 | ||||||||||
| 1432 | $ 124,900.00 | ||||||||||
| 1200 | $ 150,000.00 | ||||||||||
| 1248 | $ 129,500.00 | ||||||||||
| 1322 | $ 134,000.00 | ||||||||||
| 2052 | $ 158,900.00 | ||||||||||
| 2082 | $ 213,900.00 | ||||||||||
| 2048 | $ 199,900.00 | ||||||||||
| 2829 | $ 279,500.00 | ||||||||||
| 1572 | $ 119,000.00 | ||||||||||
| 1791 | $ 289,900.00 | ||||||||||
| 1744 | $ 134,500.00 | ||||||||||
| 2539 | $ 196,000.00 | ||||||||||
| 2064 | $ 156,900.00 | ||||||||||
| 2467 | $ 139,900.00 | ||||||||||
| 1402 | $ 120,000.00 | ||||||||||
| 1583 | $ 144,900.00 | ||||||||||
| 2266 | $ 176,900.00 | ||||||||||
| 1710 | $ 139,900.00 | ||||||||||
| 1917 | $ 154,900.00 | ||||||||||
| 2680 | $ 275,000.00 | ||||||||||
| 193262.857 | $ 2,123.38 |
Price 2137 3152 1040 3020 1719 6660 2068 1928 1958 1547 4673 1995 2518 1920 2590 1900 1560 1334 1326 1732 3220 3314 1590 1693 2097 1596 1664 1369 2332 1610 850 2144 2355 2080 2112 2726 1960 2754 3120 1415 1750 2208 1080 1048 2400 1449 1506 1540 1085 2008 2732 2285 1968 1714 3119 2327 2963 1893 4570 2132 1300 1400 1412 2221 1640 2084 1525 1660 3582 2123 2082 2275 2205 1400 1840 2484 2080 3142 1719 3098 1876 3812 3130 2620 1742 1432 1200 1248 1322 2052 2082 2048 2829 1572 1791 1744 2539 2064 2467 1402 1583 2266 1710 1917 2680 299000 185000 119900 325000 149900 749000 269900 179900 132000 145000 454000 157000 225000 157900 174500 379000 148000 154900 139500 124000 545000 445000 137000 153000 139500 132900 124900 151000 175000 134900 120000 169900 184000 153900 233500 164900 179000 299900 259900 122500 139900 150000 140000 119900 204900 129900 139900 149900 120000 174000 171000 190000 149000 120000 250000 144000 214900 129900 434900 159900 130000 208900 208900 189900 129900 214900 126000 136000 449000 169900 139900 209000 166900 119900 169000 189900 169000 235800 159900 224000 173900 184500 299000 189000 135000 124900 150000 129500 134000 158900 213900 199900 279500 119000 289900 134500 196000 156900 139900 120000 144900 176900 139900 154900 275000
