Real Estate Regression Exercise

Sheet2

Bin	Frequency
200000	71
395000	1
590000	27
785000	0
980000	0
1175000	0
1370000	0
1565000	2
5000000	2
More	0

Histogram

Frequency 200000 395000 590000 785000 980000 1175000 1370000 1565000 5000000 More 71 1 27 0 0 0 0 2 2 0

Bin

Frequency

Sheet1

Property Address	Listing Price	SQ Footage	# Bedrooms		Upper Limits	Listing Price BIN	Frequency	Relative Frequency
1510 Pearl St., Bakersfield, Ca 93308	63,000	400	1		200000	5,000-200,000	71	0.6893203883
1097 Robinson St., Bakersfield, Ca 93305	65,000	556	2		395000	200,001-395,000	1	0.0097087379
1101 Owen St., Bakersfield, Ca 93305	179,950	2168	3		590000	395,001-590,000	27	0.2621359223
1518 Robinson St., Bakersfield, Ca 93305	80,000	1304	4		785000	590,001-785,000	0	0
1212 Organ St., Bakersfield, Ca 93305	119,000	873	3		980000	785,001-980,000	0	0
1132 Quincy St., Bakersfield, Ca 93305	80,000	957	4		1175000	980,001-1,175,000	0	0
2020 Hailey St., Bakersfield, Ca 93305	109,950	1115	3		1370000	1,175,001-1,370,000	0	0
20700 Mirador Dr., Bakersfield, Ca 93305	109,500	936	3		1565000	1,370,001-1,565,000	2	0.0194174757
1501 Crestview Dr., Bakersfield, Ca 93305	149,000	974	3		5000000	1,565,001-5,000,000	2	0.0194174757
1909 Bakers St., Bakersfield, Ca 93305	175,000	2264	5
2100 North Inyo St., Bakersfield, Ca 93305	99,900	969	3			Total	103
212 Flower St., Bakersfield, Ca 93305	127,900	1189	2
119 Lincoln St., Bakersfield, Ca 93305	149,950	1769	4
18 Irene St., Bakersfield, Ca 93305	159,990	1464	4
3901 Union Ave. 2, Bakersfield, Ca 93305	119,000	1279	1
117 Loma Linda Dr, Bakersfield, Ca 93305	190,000	1521	3
109 Columbus St., Bakersfield, Ca 93305	160,000	1242	3
2505 Lomita Verde Dr., Bakersfield, Ca 93305	154,950	1036	2
313 Knot St., Bakersfield, Ca 93305	149,000	1602	5
7107 Benji Way, Bakersfield, Ca 93313	79,500	1567	3
16 6th St., Bakersfield, Ca 93304	50,000	756	2
412 9th St, Bakersfield, Ca 93304	124,850	988	2
331 East 3rd St., Bakersfield, Ca 93307	75,000	708	2
604 East 3rd St, Bakersfield, Ca 93307	105,000	952	3
1205 Texas St, Bakersfield, Ca 93307	83,450	1118	3
1424 East 19th St., Bakersfield, Ca 93307	17,500	1228	3
314 Kincaid St., Bakersfield, Ca 93307	20,000	952	3
109 Griffith St., Bakersfield, Ca 93309	27,823	912	3
708 Vine Dr., Bakersfield, Ca 93304	41,270	704	2
2605 Echo Ave, Bakersfield, Ca 93304	39,000	781	2
2222 S O St., Bakersfield, Ca 93304	43,000	1366	4
106 Washington Ave, Bakersfield, Ca 93308	45,000	850	2
12 Knots St., Bakersfield, Ca 93305	45,000	650	2
815 Lincoln Ave, Bakersfield, Ca 93308	63,000	688	2
5257 Sandrini Rd., Bakersfield, Ca 93307	425,000	53579	5
905 Soria Ave., Bakersfield, Ca 93309	110,000	1579	3
700 Hewlett St., Bakersfield, Ca 93309	110,000	1643	3
8603 Rollingbay Dr., Bakersfield, Ca 93312	94,630	1390	3
5013 Evanston Ct., Bakersfield, Ca 93309	85,000	1165	3
8510 Tucana Ave, Bakersfield, Ca 93306	70,000	1027	3
221 Bloomquist Dr., Bakersfield, Ca 93309	65,000	1668	4
610 6th St.,Bakersfield, Ca 93304	50,000	756	2
2224 S O St., Bakersfield, Ca 93304	43,000	1366	4
710 Vine Dr.,Bakersfield, Ca 93304	41,270	704	2
112 Griffith St., Bakersfield, Ca 93304	27,823	912	3
1426 E 19th St.,Bakersfield, Ca 93307	17,500	1228	3
5818 S Fairfax Rd.,Bakersfield, Ca 93305	5,000,000	1524600	3
10201 Coran Dr.,Bakersfield, Ca 93311	2,450,000	8030	6
10600 Granite Rd, Bakersfield, Ca 93308	1,495,000	2700	3
2902 Cormier Dr, Bakersfield, Ca 93311	1,398,000	5015	4
111 Delaney Dr, Bakersfield, Ca 93307	10,546	1120	3
2213 River Oaks Dr., Bakersfield, Ca 93307	13,433	1079	2
167 Hickorywood Lane, Bakersfield, Ca 93307	16,500	1440	3
627 Edwin Dr., Bakersfield, Ca 93308	20,000	1292	2
3806 Barbara Ave, Bakersfield, Ca 93309	22,500	967	2
407 17th St, Bakersfield, Ca 93301	24,791	528	1
1641 Elm St. Bakersfield, Ca 93301	65,000	556	2
6208 Gratz Way, Bakersfield, Ca 93306	69,000	959	2
3301 Rio Grande Lane, Bakersfield, Ca 93313	69,950	936	2
8533 Rollingbay Dr, Bakersfield, Ca 93312	69,950	702	2
5404 Varese Dr., Bakersfield, Ca 93308	62,500	600	2
8300 Black Knot Ct., Bakersfield, Ca 93313	199,900	2094	4
1108 Statskowski Ct, Bakersfield, Ca 93307	199,900	1965	3
5909 Indian Wells Ave, Bakersfield, Ca 93307	199,900	1164	3
3718 Kathy Suzanne Way, Bakersfield, Ca 93313	199,900	1834	2
5016 North Hills Dr., Bakersfield, Ca 93307	199,900	1274	3
6318 Straub Lane, Bakersfield, Ca 93307	199,977	1766	3
35301 7th Standard, Bakersfield, Ca 93314	200,000	2001	3
6351 Deacon Ave, Bakersfield, Ca 93307	200,000	1941	4
18122 Brimhall Rd, Bakersfield, Ca 93314	198,000	1512	3
11015 Hartland St., Bakersfield, Ca 93307	198,500	1750	2
1639 Kuhio St., Bakersfield, Ca 93313	199,900	1922	4
10500 Cliffside St, Bakersfield, Ca 93311	199,900	2053	3
9204 Lake Victoria Rd, Bakersfield, Ca 93312	199,900	1507	4
1209 Brightwater Way, Bakersfield, Ca 93311	450,200	2899	4
9416 Lake Victoria Rd, Bakersfield, Ca 93312	450,000	3033	3
7508 Live Oak Way, Bakersfield, Ca 93308	450,000	1630	3
405 Brookway Ct., Bakersfield, Ca 93312	450,000	2357	4
1210 Ridgemont Pl, Bakersfield, Ca 93311	449,900	2312	4
6211 Vista Estrella, Bakersfield, Ca 93306	449,900	2759	4
2528 Evenida Escuella St., Bakersfield, Ca 93307	445,000	3469	4
2643 S Fairfax Rd, Bakersfield, Ca 93307	445,000	3128	4
2025 Jewetta Ave, Bakersfield, Ca 93307	442,900	3211	4
11412 Martinsville Ave., Bakersfield, Ca 93307	440,000	3217	4
14728 Redwood Springs Rd, Bakersfield, Ca 93314	440,000	2573	4
13828 Rosedale Highway, Bakersfield, Ca 93314	439,950	2040	3
6718 Artino Way, Bakersfield, Ca 93306	435,000	2706	5
12409 Long Medow Way, Bakersfield, Ca 93312	435,000	3177	3
9238 Garrens Rd., Bakersfield, Ca 93311	434,950	2758	5
11900 April Ann Ave, Bakersfield, Ca 93312	434,850	2591	5
817 Ferdinand Ct., Bakersfield, Ca 93309	434,500	2668	3
9611 Lake Powell Dr., Bakersfield, Ca 93312	425,000	2658	4
14124 Edenberry Ave, Bakersfield, Ca 93314	425,000	1404	3
3456 Beechwood St., Bakersfield, Ca 93309	425,000	3449	4
107 Robinson St., Bakersfield, Ca 93305	425,000	2698	3
1227 Gray St., Bakersfield, Ca 93307	424,950	2198	4
211 Harding Ave, Bakersfield, Ca 93307	420,000	2600	4
506 Woodrow Ave, Bakersfield, Ca 93307	420,000	4196	6
630 Edwin Dr., Bakersfield, Ca 93308	419,900	3218	4
1738 Trapp Inyo Ct., Bakersfield, Ca 93307	449,000	3024	4
Mean	291,836	17501.35
Median	152,450	1485.5
Mode	199900	556
	MAX	MIN	Range
range for Price	5,000,000	10,546	4,989,454
Range for SQ Footage	1524600	400	1524200
Variance for Price	331578226285.20
Variace for SQ footage	23202704918.0278
Standard Deviation for Price	575828.30
Standard Deviation for Square Footage	152324.34