for Dr.Loizeaux only
jusdak313
week_2_team_a_withmycomments.xlsxRaw Data
| Count | Address | Price | Sq/Ft | Bedrooms | Frequency Distribution | ||||||||||
| 1 | 6603 Trenton Rd | $595,000 | 2,013 | 2 | k | 7 | Row Labels | Bedroom Distribution | |||||||
| 1 | 10405 Cherrywood Dr | $459,900 | 3,095 | 4 | Class Interval | 80000 | 2 | 21 | |||||||
| 1 | 6116 NE 103rd Ct | $454,900 | 3,215 | 4 | 3 | 63 | |||||||||
| 1 | 3004 White Cedar Ct | $425,000 | 2,892 | 3 | Prices | Count | 4 | 13 | |||||||
| 1 | 1118 NW 13th St | $400,000 | 7,000 | 5 | 0-79999 | 22 | 5 | 3 | |||||||
| 1 | 9620 SW 35th Ter | $393,100 | 3,931 | 5 | 80000-159999 | 33 | Grand Total | 100 | |||||||
| 1 | 6204 Waterford Blvd Apt 27 | $375,000 | 1,610 | 2 | 160000-239999 | 26 | |||||||||
| 1 | 8204 Golden Oaks Rd | $340,000 | 2,967 | 3 | 240000-319999 | 10 | |||||||||
| 1 | 5013 SW 127th Ct | $333,500 | 2,578 | 4 | 320000-399999 | 4 | |||||||||
| 1 | 5301 NW 117th Ter | $310,254 | 2,300 | 3 | 400000-479999 | 4 | |||||||||
| 1 | 1320 Atalon Dr | $310,000 | 2,371 | 3 | 560000-639999 | 1 | |||||||||
| 1 | 722 NW 34th St | $300,000 | 1,963 | 3 | 100 | 63% of the homes are 3 bedroom homes. | |||||||||
| 1 | 2008 Edgewater Dr | $294,900 | 2,295 | 3 | |||||||||||
| 1 | 11516 Brockton Pl | $285,000 | 2,985 | 4 | The frequency distribution indicates that the prices are negatively skewed towards the lower end of the price scale. | ||||||||||
| 1 | 8625 NW 110th St | $273,079 | 2,051 | 4 | |||||||||||
| 1 | 1430 NE 12th St | $250,000 | 1,230 | 3 | |||||||||||
| 1 | 12605 Chateaux Rd | $249,900 | 2,149 | 4 | |||||||||||
| 1 | 4908 SW 126th Ter | $249,900 | 2,967 | 4 | |||||||||||
| 1 | 5505 NW 106th St | $240,000 | 2,355 | 3 | Central Tendancy - Prices | Central Tendancy - Sq/Ft | Price | Sq/Ft | |||||||
| 1 | 7034 Cherokee Xing E | $236,900 | 2,010 | 3 | Range | $ 565,100.00 | 6280 | ||||||||
| 1 | 646 Crescent Cir | $232,000 | 2,459 | 3 | Mean | $ 168,758.15 | Mean | 1,702.2 | Variance | 11424196312.5934 | 721648.329191919 | ||||
| 1 | 1029 NW 191st St | $229,900 | 1,220 | 3 | SD | $ 106,348.27 | 845.2407029362 | ||||||||
| 1 | 11809 Springhollow Rd | $220,000 | 1,906 | 3 | Median | $ 146,250.00 | Median | 1,542.0 | |||||||
| 1 | 11809 Springhollow Rd | $220,000 | 1,906 | 3 | 106884.032074924 | ||||||||||
| 1 | 7001 N Cherokee Xing W | $219,500 | 1,868 | 3 | Mode | $ 171,900.00 | Mode | 1,906.0 | |||||||
| 1 | 14605 Harli Ln | $215,000 | 1,963 | 3 | |||||||||||
| 1 | 3724 NW 69th St | $207,500 | 1,223 | 3 | Quartile - Price | Quartile - Sq/Ft | |||||||||
| 1 | 3109 Carey Pl | $199,999 | 1,163 | 3 | $ 29,900.00 | 0% | 720 | 0% | |||||||
| 1 | 8112 Westwood Ln | $199,900 | 2,025 | 3 | $ 89,675.00 | 25% | 1,163 | 25% | |||||||
| 1 | 3209 NW 22nd St | $199,900 | 1,748 | 3 | $ 146,250.00 | 50% | 1,534 | 50% | |||||||
| 1 | 7243 Skylark Ln | $199,243 | 3,050 | 4 | $ 216,125.00 | 75% | 1,941 | 75% | |||||||
| 1 | 6405 Bentley Dr | $195,000 | 1,941 | 3 | $ 595,000.00 | 100% | 7,000 | 100% | |||||||
| 1 | 2820 Huntleigh Dr | $189,900 | 1,616 | 3 | |||||||||||
| 1 | 2416 NW 113th St | $189,500 | 3,371 | 5 | |||||||||||
| 1 | 12720 Briar Hollow Ln | $179,900 | 2,257 | 4 | |||||||||||
| 1 | 1628 SW 31st St | $179,900 | 1,711 | 3 | |||||||||||
| 1 | 629 SW 163rd St | $175,000 | 1,194 | 3 | |||||||||||
| 1 | 8812 SW 36th Ter | $171,900 | 1,542 | 3 | Chebyshev's Theorem | ||||||||||
| 1 | 8605 SW 37th St | $171,900 | 1,906 | 3 | |||||||||||
| 1 | 8601 SW 37th St | $171,900 | 1,060 | 3 | |||||||||||
| 1 | 900 Carol Ann Pl | $169,900 | 1,525 | 3 | Listing Price | Square Footage | Number of Bedrooms | According to Chebyshev's inequality, atleast 75% of values must lie within 2 standard deviations of the mean and 89% within 3 standards deviations | |||||||
| 1 | 8508 Timberwood Ln | $165,000 | 1,564 | 3 | mean - 2s | ($45,009.91) | $3.21 | $1.62 | |||||||
| 1 | 12328 Hickory Creek Blvd | $164,600 | 1,808 | 4 | mean + 2s | $382,526.21 | $3,401.21 | $4.34 | |||||||
| 1 | 682 SW 12th St | $162,500 | 1,586 | 4 | counts of obs in this range | 94 | 98 | 97 | |||||||
| 1 | 2709 Narrowleaf Ln | $162,341 | 1,220 | 3 | % of obs in this range | 94.00% | 98.00% | 97.00% | |||||||
| 1 | 613 Westridge Dr | $159,900 | 2,431 | 4 | |||||||||||
| 1 | 13420 Mayberry Pl | $159,900 | 1,558 | 3 | price square feet | square feet | Bedrooms | The empirical rule shows that 68% will fall within the first standard deviation, 95% within the first two standard deviations, and 99.7% will fall within the first 3 standard deviations of the mean | |||||||
| 1 | 2229 Oxford Way | $154,900 | 2,431 | 2 | mean - 3s | ($151,893.95) | ($846.29) | $0.94 | |||||||
| 1 | 2036 NW 19th St | $149,900 | 2,197 | 3 | mean + 3s | $489,410.25 | $4,250.71 | $5.02 | |||||||
| 1 | 2816 NW 21st St | $147,500 | 1,872 | 3 | counts of obs in this range | 100 | 99 | 100 | |||||||
| 1 | 4116 NW 52nd St | $145,000 | 1,542 | 3 | % of obs in this range | 100.00% | 99.00% | 100.00% | |||||||
| 1 | 619 SW 38th Pl | $142,000 | 1,481 | 3 | |||||||||||
| 1 | 4925 NW 31st Ter | $139,900 | 1,333 | 3 | Listing Price | Square Footage | Number of Bedrooms | Clearly, Chebychev's theorem is valid here | |||||||
| 1 | 3148 NW 42nd St | $139,900 | 1,661 | 3 | mean - 1s | $275,642.18 | $2,551.71 | $3.66 | |||||||
| 1 | 2340 NW 33rd St | $136,000 | 1,333 | 3 | mean + 1 | $61,874.12 | $852.71 | $2.30 | |||||||
| 1 | 240 Chaucer Crescent St | $135,000 | 1,778 | 4 | counts of obs in this range | 73 | 83 | 63 | |||||||
| 1 | 6720 Greenway Dr | $134,000 | 1,584 | 3 | % of obs in this range | 73.00% | 83.00% | 63.00% | |||||||
| 1 | 3741 NW 59th Ter | $131,000 | 1,061 | 3 | |||||||||||
| 1 | 3610 N Independence Ave | $130,000 | 1,872 | 3 | |||||||||||
| 1 | 12421 Coywood | $129,900 | 1,447 | 3 | |||||||||||
| 1 | 2813 Tealwood Dr | $128,900 | 1,484 | 3 | |||||||||||
| 1 | 8816 NW 84th St | $125,000 | 1,429 | 3 | |||||||||||
| 1 | 8300 S Villa Ave | $124,900 | 1,370 | 3 | |||||||||||
| 1 | 1206 NW 41st St | $119,000 | 1,455 | 3 | |||||||||||
| 1 | 8525 Placker Pl | $115,000 | 1,310 | 3 | |||||||||||
| 1 | 221 SW 92nd St | $112,900 | 1,060 | 2 | |||||||||||
| 1 | 3825 Newport St | $110,000 | 1,581 | 3 | |||||||||||
| 1 | 4201 NW 20th St | $110,000 | 1,072 | 2 | |||||||||||
| 1 | 1016 NW 7th Pl | $109,900 | 1,108 | 3 | |||||||||||
| 1 | 2500 Crystal Dr | $109,900 | 1,163 | 3 | |||||||||||
| 1 | 2500 Crystal Dr | $109,900 | 1,163 | 3 | |||||||||||
| 1 | 6116 SE 84th St | $100,000 | 1,581 | 3 | |||||||||||
| 1 | 5925 N Asbury St | $96,000 | 988 | 3 | |||||||||||
| 1 | 8800 S Miller Blvd | $92,500 | 945 | 3 | |||||||||||
| 1 | 9305 Greystone Ave | $89,900 | 1,600 | 2 | |||||||||||
| 1 | 979 SW 4th Pl | $89,000 | 1,194 | 2 | |||||||||||
| 1 | 212 Kelly Dr | $83,000 | 1,600 | 3 | |||||||||||
| 1 | 304 Lotus Ave | $80,000 | 1,108 | 3 | |||||||||||
| 1 | 4629 NW 11th St | $76,300 | 1,366 | 3 | |||||||||||
| 1 | 4629 NW 11th St | $76,300 | 1,366 | 3 | |||||||||||
| 1 | 1105 SW 54th St | $75,000 | 1,215 | 3 | |||||||||||
| 1 | 300 N King Ave | $74,000 | 936 | 2 | |||||||||||
| 1 | 11437 N May Ave | $69,900 | 1,065 | 2 | |||||||||||
| 1 | 6041 NW 54th Pl | $65,900 | 1,012 | 2 | |||||||||||
| 1 | 608 Skylark Dr | $65,000 | 1,374 | 2 | |||||||||||
| 1 | 2129 Meench Dr | $65,000 | 800 | 2 | |||||||||||
| 1 | 3840 NW Liberty St | $63,000 | 918 | 2 | |||||||||||
| 1 | 1408 N Southminster St | $59,500 | 1,223 | 3 | |||||||||||
| 1 | 3929 SE 11th St | $58,000 | 800 | 3 | |||||||||||
| 1 | 11411 N May Ave Unit B | $56,999 | 1,035 | 2 | |||||||||||
| 1 | 1414 NW 98th St | $53,500 | 848 | 3 | |||||||||||
| 1 | 3317 S Douglas Ave | $53,000 | 1,265 | 3 | |||||||||||
| 1 | 6042 NW 47th St | $50,000 | 888 | 2 | |||||||||||
| 1 | 2306 SW 22nd St | $49,900 | 1,278 | 2 | |||||||||||
| 1 | 2504 SW 35th St | $49,900 | 884 | 2 | |||||||||||
| 1 | 3809 NW 14th St | $49,000 | 1,010 | 2 | |||||||||||
| 1 | 6303 Anderson Dr | $43,500 | 720 | 2 | |||||||||||
| 1 | 6303 Anderson Dr | $43,500 | 720 | 2 | |||||||||||
| 1 | 4005 SE 46th St | $39,600 | 1,061 | 3 | |||||||||||
| 1 | 3949 NW 9th St | $29,900 | 836 | 2 | |||||||||||
Price - Freqency Distribution Histogram
Count 0-79999 80000-159999 160000-239999 240000-319999 320000-399999 400000-479999 560000-639999 22 33 26 10 4 4 1
Bedrooms
Total
2 3 4 5 21 63 13 3
