Descriptive Statistics – Real Estate Data Part 1
lotrdeja1
team_b_week_2.xlsxFrequency Distribution
| Frequency Distribution - Quantitative | |||||||||
| Listing Price | cumulative | ||||||||
| lower | upper | midpoint | width | frequency | percent | frequency | percent | ||
| 50,000 | < | 100,000 | 75,000 | 50,000 | 6 | 6.0 | 6 | 6.0 | |
| 100,000 | < | 150,000 | 125,000 | 50,000 | 21 | 21.0 | 27 | 27.0 | |
| 150,000 | < | 200,000 | 175,000 | 50,000 | 30 | 30.0 | 57 | 57.0 | |
| 200,000 | < | 250,000 | 225,000 | 50,000 | 17 | 17.0 | 74 | 74.0 | |
| 250,000 | < | 300,000 | 275,000 | 50,000 | 9 | 9.0 | 83 | 83.0 | |
| 300,000 | < | 350,000 | 325,000 | 50,000 | 8 | 8.0 | 91 | 91.0 | |
| 350,000 | < | 400,000 | 375,000 | 50,000 | 1 | 1.0 | 92 | 92.0 | |
| 400,000 | < | 450,000 | 425,000 | 50,000 | 3 | 3.0 | 95 | 95.0 | |
| 450,000 | < | 500,000 | 475,000 | 50,000 | 3 | 3.0 | 98 | 98.0 | |
| 500,000 | < | 550,000 | 525,000 | 50,000 | 1 | 1.0 | 99 | 99.0 | |
| 550,000 | < | 600,000 | 575,000 | 50,000 | 0 | 0.0 | 99 | 99.0 | |
| 600,000 | < | 650,000 | 625,000 | 50,000 | 1 | 1.0 | 100 | 100.0 | |
| 649999.99 | |||||||||
| 100 | 100.0 | ||||||||
Histogram
50000 100000 150000 200000 250000 300000 350000 400000 450000 500000 550000 600000 649999.99 6 21 30 17 9 8 1 3 3 1 0 1Listing Price
Percent
PieChart Bedrooms
| Number of Bedrooms | Count of Number of Bedrooms |
| 2 bd | 3 |
| 3 bd | 59 |
| 4 bd | 33 |
| 5 bd | 4 |
| 6 bd | 1 |
Count of Number of Bedrooms
Total 2 bd 3 bd 4 bd 5 bd 6 bd 3 59 33 4 1
Descriptive Staistics SqFt
| Descriptive statistics | |
| Square Footage | |
| count | 100 |
| mean | 2,109.83 |
| sample standard deviation | 725.47 |
| sample variance | 526,301.76 |
| minimum | 856.0 |
| maximum | 4169.0 |
| range | 3313.0 |
| confidence interval 95.% lower | 1,967.64 |
| confidence interval 95.% upper | 2,252.02 |
| margin of error | 142.19 |
| z | 1.96 |
| empirical rule | |
| mean - 1s | 1,384.36 |
| mean + 1s | 2,835.30 |
| percent in interval (68.26%) | 71.0% |
| mean - 2s | 658.90 |
| mean + 2s | 3,560.76 |
| percent in interval (95.44%) | 94.0% |
| mean - 3s | -66.57 |
| mean + 3s | 4,286.23 |
| percent in interval (99.73%) | 100.0% |
| skewness | 0.66 |
| kurtosis | 0.17 |
| coefficient of variation (CV) | 34.39% |
| 1st quartile | 1,573.00 |
| median | 2,071.00 |
| 3rd quartile | 2,500.75 |
| interquartile range | 927.75 |
| mode | 2,291.00 |
| low extremes | 0 |
| low outliers | 0 |
| high outliers | 2 |
| high extremes | 0 |
Descriptive Statistics Price
| Descriptive statistics | |
| Listing Price | |
| count | 100 |
| mean | 217,626.95 |
| sample standard deviation | 104,193.16 |
| sample variance | 10,856,215,490.78 |
| minimum | 55000.0 |
| maximum | 618990.0 |
| range | 563990.0 |
| confidence interval 95.% lower | 197,205.47 |
| confidence interval 95.% upper | 238,048.43 |
| margin of error | 20,421.48 |
| z | 1.96 |
| empirical rule | |
| mean - 1s | 113,433.79 |
| mean + 1s | 321,820.11 |
| percent in interval (68.26%) | 81.0% |
| mean - 2s | 9,240.62 |
| mean + 2s | 426,013.28 |
| percent in interval (95.44%) | 92.0% |
| mean - 3s | -94,952.54 |
| mean + 3s | 530,206.44 |
| percent in interval (99.73%) | 98.0% |
| skewness | 1.51 |
| kurtosis | 2.53 |
| coefficient of variation (CV) | 47.88% |
| 1st quartile | 148,675.00 |
| median | 185,000.00 |
| 3rd quartile | 250,000.00 |
| interquartile range | 101,325.00 |
| mode | 145,000.00 |
| low extremes | 0 |
| low outliers | 0 |
| high outliers | 7 |
| high extremes | 1 |
Data
| Property Address | Listing Price | Number of Bedrooms | Square Footage | |||||
| 1 | 2304 Autumn Oaks Trl, Arlington, TX 76006 | $437,000 | 4 bd | 3,620 | Median | $185,000 | ||
| 2 | 3801 Denise Ct, Arlington, TX 76001 | $327,000 | 4 bd | 3,172 | Mean | 217626.95 | ||
| 3 | 5106 Atlantis Ter, Arlington, TX 76016 | $176,000 | 3 bd | 1,671 | Mode | -2291 | ||
| 4 | 7706 Water Fowl Trl, Arlington, TX 76002 | $175,000 | 3 bd | 1,726 | ||||
| 5 | 4124 Timber Trail Dr, Arlington, TX 76016 | $269,900 | 4 bd | 2,612 | ||||
| 6 | 1218 W Mitchell St, Arlington, TX 76013 | $165,000 | 4 bd | 2,224 | ||||
| 7 | 2227 Templeton Dr, Arlington, TX 76006 | $339,900 | 4 bd | 3,500 | ||||
| 8 | 1005 Whippoorwill Ct, Arlington, TX 76014 | $129,000 | 3 bd | 1,612 | ||||
| 9 | 2003 Mill Run Dr, Arlington, TX 76006 | $235,000 | 3 bd | 2,356 | ||||
| 10 | 505 Corbin Dr, Arlington, TX 76002 | $225,000 | 3 bd | 1,996 | ||||
| 11 | 5307 Cody Dr, Arlington, TX 76018 | $145,000 | 3 bd | 1,448 | ||||
| 12 | 6716 Cherrytree Dr, Arlington, TX 76001 | $135,000 | 3 bd | 1,431 | ||||
| 13 | 3916 Gentle Breeze Ct, Arlington, TX 76017 | $294,500 | 3 bd | 2,515 | ||||
| 14 | 1607 Southmoor Dr, Arlington, TX 76010 | $99,000 | 3 bd | 1,895 | ||||
| 15 | 2224 Mainsail Ln, Arlington, TX 76002 | $179,500 | 4 bd | 2,092 | ||||
| 16 | 3913 Gentle Breeze Ct, Arlington, TX 76017 | $275,233 | 3 bd | 2,136 | ||||
| 17 | 3925 Canton Jade Way, Arlington, TX 76005 | $446,900 | 4 bd | 2,770 | ||||
| 18 | 1504 Brookleaf Dr, Arlington, TX 76018 | $149,900 | 3 bd | 1,495 | ||||
| 19 | 903 Prairie Ridge Ln, Arlington, TX 76005 | $469,990 | 3 bd | 2,774 | ||||
| 20 | 4103 Pearl Cres, Arlington, TX 76005 | $428,990 | 3 bd | 2,586 | ||||
| 21 | 1809 Park Highland Way, Arlington, TX 76012 | $459,900 | 4 bd | 3,936 | ||||
| 22 | 7025 Escondido Dr, Arlington, TX 76016 | $225,000 | 4 bd | 2,354 | ||||
| 23 | 9307 Water Bend Dr, Arlington, TX 76002 | $199,900 | 3 bd | 1,849 | ||||
| 24 | 7003 Evening Shade Ln, Arlington, TX 76002 | $180,000 | 3 bd | 1,860 | ||||
| 25 | 1601 Gentle Wind Dr, Arlington, TX 76018 | $117,000 | 3 bd | 1,191 | ||||
| 26 | 2101 Cross Creek Ct, Arlington, TX 76017 | $478,900 | 4 bd | 4,169 | ||||
| 27 | 4800 Winding Oaks Ct, Arlington, TX 76016 | $240,000 | 4 bd | 2,320 | ||||
| 28 | 1209 Boardwalk St, Arlington, TX 76011 | $224,900 | 4 bd | 2,033 | ||||
| 29 | 4615 Lake Park Dr, Arlington, TX 76016 | $250,000 | 5 bd | 3,721 | ||||
| 30 | 5211 Bellefontaine Dr, Arlington, TX 76017 | $155,000 | 3 bd | 1,540 | ||||
| 31 | 2408 Winding Hollow Ln, Arlington, TX 76006 | $320,000 | 4 bd | 3,051 | ||||
| 32 | 904 Dunkirk Ln, Arlington, TX 76017 | $160,000 | 4 bd | 2,314 | ||||
| 33 | 7610 Cutlass Ct, Arlington, TX 76016 | $359,000 | 5 bd | 3,632 | ||||
| 34 | 1316 Pegasus Dr, Arlington, TX 76013 | $205,000 | 3 bd | 1,872 | ||||
| 35 | 2705 Olympia Dr, Arlington, TX 76013 | $180,000 | 3 bd | 2,050 | ||||
| 36 | 5815 Sterling Green Trl, Arlington, TX 76017 | $178,900 | 4 bd | 1,627 | ||||
| 37 | 6729 Silvercrest Dr, Arlington, TX 76002 | $172,900 | 3 bd | 2,294 | ||||
| 38 | 1014 Silver Spruce Dr, Arlington, TX 76001 | $199,999 | 4 bd | 2,239 | ||||
| 39 | 4226 Glen Pines Ct, Arlington, TX 76016 | $118,000 | 3 bd | 856 | ||||
| 40 | 1616 Kent Dr, Arlington, TX 76010 | $95,000 | 3 bd | 968 | ||||
| 41 | 1704 Park Hill Dr, Arlington, TX 76012 | $149,900 | 3 bd | 1,687 | ||||
| 42 | 5124 Melia Dr, Arlington, TX 76060 | $299,990 | 3 bd | 2,228 | ||||
| 43 | 1905 Tudor Ct, Arlington, TX 76017 | $300,000 | 4 bd | 2,812 | ||||
| 44 | 2109 Royal Dominion Ct, Arlington, TX 76006 | $339,000 | 4 bd | 3,036 | ||||
| 45 | 3117 Sandcastle Trl, Arlington, TX 76012 | $249,900 | 4 bd | 2,496 | ||||
| 46 | 6304 Big Springs Dr, Arlington, TX 76001 | $133,900 | 3 bd | 1,240 | ||||
| 47 | 1804 Jackson Dr, Arlington, TX 76013 | $139,900 | 3 bd | 1,512 | ||||
| 48 | 1215 Andromeda Way, Arlington, TX 76013 | $315,000 | 5 bd | 3,066 | ||||
| 49 | 6409 Brooklawn Dr, Arlington, TX 76018 | $145,000 | 3 bd | 1,654 | ||||
| 50 | 2406 Sunflower Dr, Arlington, TX 76014 | $55,000 | 3 bd | 1,156 | ||||
| 51 | 1102 N Blue Lake Blvd, Arlington, TX 76005 | $544,990 | 3 bd | 3,069 | ||||
| 52 | 812 Lombardy Ln, Arlington, TX 76013 | $165,000 | 3 bd | 1,858 | ||||
| 53 | 1104 Blue Lake Blvd, Arlington, TX 76005 | $618,990 | 4 bd | 3,830 | ||||
| 54 | 2718 Jewell Dr, Arlington, TX 76016 | $140,000 | 3 bd | 1,357 | ||||
| 55 | 6209 Pierce Arrow Dr, Arlington, TX 76001 | $180,000 | 3 bd | 1,999 | ||||
| 56 | 1410 Niagara Falls Ct, Arlington, TX 76002 | $220,000 | 3 bd | 2,350 | ||||
| 57 | 6505 Big Springs Dr, Arlington, TX 76001 | $117,900 | 3 bd | 1,233 | ||||
| 58 | 2003 Alamo Dr, Arlington, TX 76012 | $198,400 | 4 bd | 1,905 | ||||
| 59 | 5111 Santa Rosa Dr, Arlington, TX 76060 | $313,935 | 3 bd | 3,231 | ||||
| 60 | 7906 Corona Ct, Arlington, TX 76002 | $165,000 | 3 bd | 1,614 | ||||
| 61 | 6436 Brookhaven Trl, Arlington, TX 76001 | $90,000 | 2 bd | 992 | ||||
| 62 | 6407 Redding Ct, Arlington, TX 76001 | $126,500 | 3 bd | 1,455 | ||||
| 63 | 2604 Nelwin Pl, Arlington, TX 76016 | $150,000 | 3 bd | 1,552 | ||||
| 64 | 7000 Echo Lake Ct, Arlington, TX 76001 | $200,000 | 4 bd | 2,355 | ||||
| 65 | 1831 Larkspur Dr, Arlington, TX 76013 | $200,000 | 3 bd | 2,172 | ||||
| 66 | 1907 Parktree Dr, Arlington, TX 76001 | $249,900 | 5 bd | 2,618 | ||||
| 67 | 1603 Miller Ct, Pantego, TX 76013 | $224,000 | 3 bd | 2,249 | ||||
| 68 | 1916 Westview Ter, Arlington, TX 76013 | $269,900 | 3 bd | 2,488 | ||||
| 69 | 1130 Rimcrest Dr, Arlington, TX 76017 | $128,900 | 3 bd | 1,172 | ||||
| 70 | 5309 Atlantis Ter, Arlington, TX 76016 | $169,900 | 3 bd | 1,706 | ||||
| 71 | 5105 Glen Meadow Dr, Arlington, TX 76001 | $299,900 | 4 bd | 3,000 | ||||
| 72 | 4100 Double Oak Ct, Arlington, TX 76001 | $195,000 | 6 bd | 2,518 | ||||
| 73 | 2200 Polo Club Ct, Arlington, TX 76017 | $145,000 | 3 bd | 1,367 | ||||
| 74 | 4920 Sandalwood Ln, Arlington, TX 76017 | $114,900 | 3 bd | 1,122 | ||||
| 75 | 5811 Mansfield Rd, Arlington, TX 76017 | $79,999 | 2 bd | 917 | ||||
| 76 | 6308 Fox Hunt Dr, Arlington, TX 76001 | $209,000 | 4 bd | 2,309 | ||||
| 77 | 5228 Bellefontaine Dr, Arlington, TX 76017 | $150,000 | 3 bd | 1,658 | ||||
| 78 | 5121 Trail Dust Ln, Arlington, TX 76017 | $90,000 | 2 bd | 1,143 | ||||
| 79 | 4911 Oldfield Dr, Arlington, TX 76016 | $179,000 | 3 bd | 1,992 | ||||
| 80 | 1308 Oak Glen Trl, Arlington, TX 76012 | $206,190 | 3 bd | 2,291 | ||||
| 81 | 1024 Telluride Dr, Arlington, TX 76001 | $145,000 | 3 bd | 1,580 | ||||
| 82 | 800 Dove Meadows Dr, Arlington, TX 76002 | $157,000 | 3 bd | 1,635 | ||||
| 83 | 7206 Fossil Lake Dr, Arlington, TX 76002 | $168,000 | 4 bd | 1,845 | ||||
| 84 | 6303 Fannin Dr, Arlington, TX 76001 | $250,000 | 4 bd | 2,897 | ||||
| 85 | 719 Gardiner St, Arlington, TX 76012 | $115,000 | 3 bd | 1,102 | ||||
| 86 | 1801 Daytona Dr, Arlington, TX 76014 | $139,500 | 4 bd | 1,450 | ||||
| 87 | 2619 Nelwin Pl, Arlington, TX 76016 | $134,900 | 3 bd | 1,398 | ||||
| 88 | 104 Colony Dr, Arlington, TX 76002 | $145,000 | 3 bd | 1,411 | ||||
| 89 | 4701 El Salvador Ct, Arlington, TX 76017 | $349,900 | 4 bd | 2,565 | ||||
| 90 | 3206 Avon Dr, Arlington, TX 76015 | $195,000 | 4 bd | 1,873 | ||||
| 91 | 9123 Rainland Ct, Arlington, TX 76002 | $237,499 | 3 bd | 2,161 | ||||
| 92 | 1908 McCartney Ct, Arlington, TX 76012 | $249,900 | 4 bd | 2,383 | ||||
| 93 | 8307 Cotton Valley Ln, Arlington, TX 76002 | $190,000 | 4 bd | 2,198 | ||||
| 94 | 5515 Royal Meadow Ln, Arlington, TX 76017 | $180,000 | 3 bd | 2,146 | ||||
| 95 | 2201 Chapel Downs Dr, Arlington, TX 76017 | $165,000 | 3 bd | 1,516 | ||||
| 96 | 2801 Meadowview Dr, Arlington, TX 76016 | $178,900 | 4 bd | 2,171 | ||||
| 97 | 1506 Newsom Ct, Pantego, TX 76013 | $279,990 | 3 bd | 2,589 | ||||
| 98 | 301 Hudson Falls Dr, Arlington, TX 76002 | $230,000 | 3 bd | 2,291 | ||||
| 99 | 6604 Hillgreen Dr, Arlington, TX 76002 | $190,000 | 3 bd | 2,193 | ||||
| 100 | 8015 McMurtry Dr, Arlington, TX 76002 | $170,000 | 4 bd | 1,663 |
