Real Estate Regression Exercise

Sheet1

Real Estate Data Part 1
	100 Single Family Homes in Cathedral City
Property Address	Listing Price	Square Footage	Number of Bedrooms
31831 Avenida La Paloma	$175,000	1,252	4
33142 Pueblo Trl	$200,000	2,058	4
69445 Mccallum Way	$304,990	1,947	3
68205 Verano Rd	$269,000	1,863	4
34260 Corregidor Dr	$185,000	910	2
30310 Keith Ave	$339,900	1,954	4
68539 Iroquois St	$284,000	1,654	3
39120 Karen St	$349,900	1,350	3
32925 Canyon Vista Rd	$245,000	1,567	4
32795 Cielo Vista Rd	$269,000	960	3
68690 San Felipe Rd	$349,000	2,615	5
68214 Pasada Rd	$285,500	1,675	3
30699 Keith Ave	$349,900	2,010	3
30212 Muirfield Way,	$295,000	1,766	3
35260 Corregidor Dr	$199,000	1,140	3
69225 Nilda Dr	$249,000	1,500	4
69770 Mccallum Way	$299,900	1,560	3
68270 Concepcion Rd	$399,000	2,789	4
31465 Whispering Palms Trl	$285,000	1,495	4
68205 Santiago Rd	$295,000	1,580	3
68711 E St	$245,000	994	2
31325 Avenida La Gaviota	$345,000	1,906	4
67180 Ontina Rd	$235,000	1,654	3
69403 Cypress Rd	$299,000	1,404	3
67260 Vista Chino	$249,900	1,477	3
30226 Avenida Del Padre	$349,000	2,061	4
38665 Paradise Way	$369,000	1,320	2
352 Andorra Way	$65,000	1,968	2
30905 Mission Dr	$180,000	1,456	4
67870 Quijo	$165,000	1,350	3
19 Ikes Pl	$69,500	1,250	3
68245 Perlita Rd	$349,000	2,000	4
31905 Neuma Dr	$249,900	1,621	4
31100 Avenida El Mundo	$239,000	1,300	3
29467 Sandy Ct	$259,900	1,711	3
30090 Travis Ave	$299,900	1,990	4
35331 Corregidor Dr	$210,000	1,104	3
28541 W Natoma Dr	$379,500	2,100	3
67637 S Natoma Dr	$339,500	1,905	2
29784 Sandy Ct	$319,000	2,117	3
37585 Cathedral Canyon Dr	$214,900	2,488	4
28340 Avenida Duquesa	$299,500	1,636	3
69320 Nilda Dr	$266,900	1,308	4
31359 San Luis Rey Dr	$170,000	1,100	3
31120 Avenida Ximino	$319,900	1,604	3
35684 Calle Sonoma	$390,000	1,751	3
67203 Asistencia Dr,	$190,000	1,248	3
10 Coble Dr	$74,000	2,100	2
35200 Cathedral Canyon Dr	$89,900	1,080	1
29733 E Trancas Dr	$227,880	1,461	2
31100 Date Palm Dr	$244,900	1,575	4
31855 Avenida Maravilla	$230,000	1,411	3
67680 S Natoma Dr	$288,000	1,533	2
67612 S Natoma Dr	$295,000	1,425	2
37499 Melrose Dr	$239,900	1,410	3
69515 Las Camelias	$254,000	1,630	3
28621 W Natoma Dr,	$369,900	1,952	3
29802 Sandy Ct	$300,000	1,841	3
29675 Avenida Maravilla	$248,500	1,166	3
27345 Hombria Dr	$249,995	1,450	3
69801 Ramon Rd	$115,000	600	1
67592 S Laguna Dr	$299,000	1,425	2
69557 Paseo Del Sol	$499,999	2,236	3
34575 Judy Ln	$253,900	1,552	3
32742 Pueblo Trl,	$289,900	1,700	4
69281 Woodside Ave	$327,900	2,023	3
29460 Avenida La Vis	$325,000	1,700	4
29282 W Laguna Dr	$285,000	1,608	2
67639 S Natoma Dr	$384,500	1,604	2
38110 Chris Dr	$265,000	1,440	3
68125 Peladora Rd	$238,000	1,250	3
67335 Ontina Rd	$324,900	1,815	4
31620 San Eljay Ave	$219,900	1,174	3
67120 Garbino Rd	$239,900	1,486	3
33515 Wishing Well Trl	$265,000	1,455	3
67405 Verona Rd	$230,000	1,619	3
68157 Durango Rd	$489,000	3,419	4
67684 S Laguna Dr	$379,000	1,604	2
67649 S Natoma Dr	$419,000	1,533	2
69597 Paseo Del Sol	$658,500	2,642	4
68550 30th Ave	$309,000	1,993	3
30175 Avenida Alvera	$369,000	2,268	3
69345 Nilda Dr	$249,000	1,601	3
30750 Avenida Juarez	$283,000	1,868	4
30455 Avenida Juarez	$219,900	1,270	3
33352 Whispering Palms Trl	$289,900	1,935	4
68393 Sharpless Rd	$439,000	2,400	4
67802 S Trancas Dr	$233,900	1,461	2
33163 Cathedral Canyon Dr	$189,000	1,343	3
31760 Avenida Ximino	$237,900	1,651	3
36333 Artisan Way	$848,000	3,688	5
69997 Brookview Way	$320,000	1,451	3
33730 Cathedral Canyon Dr	$279,499	1,892	4
30139 Amy Cir	$359,900	2,133	4
32420 El Pueblo Trl	$319,500	2,200	4
39421 Bel Air Dr	$399,000	1,400	2
31420 Victor Rd	$225,000	1,300	3
36229 Artisan Way	$719,000	3,458	5
68830 Jarana Rd	$262,000	2,200	3
28621 W Natoma Dr	$369,000	1,951	3
69399 Sawgrass Rd	$299,000	1,536	4
Listing Price	Frequency
150,000 or Less	5
150,000 - 200,000	9
200,000 - 250,000	24
250,000 - 300,000	28
300,000 - 350,000	17
350,000 - 400,000	11
400,000 and Above	6
Mean	$ 292,438.25
Median	$ 285,000.00
Mode	$ 349,000.00
Number of Bedrooms	Price of Home	Square Footage		Bedrooms	Frequency
4	$175,000	1,252		1 Bedroom	2
4	$200,000	2,058		2 Bedrooms	16
3	$304,990	1,947		3 Bedrooms	49
4	$269,000	1,863		4 Bedrroms	30
2	$185,000	910		5 Bedrooms	3
4	$339,900	1,954
3	$284,000	1,654
3	$349,900	1350
4	$245,000	1567
3	$269,000	960
5	$349,000	2,615
3	$285,500	1,675
3	$349,900	2,010
3	$295,000	1,766
3	$199,000	1,140				A sample of 100 homes being sold in Cathedral City shows a range of one Joe Palakiko:
4	$249,000	1,500				to five bedrooms. According to www.zillow.com, there are only 2 one bedroom
3	$299,900	1,560				homes available on the market, which results in the least common listing.
4	$399,000	2,789				The most common listings are three bedroom homes with 49 total listings.
4	$285,000	1,495
3	$295,000	1,580
2	$245,000	994
4	$345,000	1,906
3	$235,000	1,654
3	$299,000	1,404
4	$249,900	1,477
4	$349,000	2,061
2	$369,000	1,320
2	$65,000	1,968
4	$180,000	1,456
3	$165,000	1,350
3	$69,500	1,250
4	$349,000	2,000
4	$299,000	1,536
3	$170,000	1,100
4	$266,900	1,308
3	$299,500	1,636
4	$214,900	2,488
3	$319,000	2,117
2	$339,500	1,905
3	$379,900	2,100
3	$259,000	1,542
3	$210,000	1,104
4	$299,900	1,990
3	$259,900	1,711
3	$239,000	1,300
4	$249,900	1,621
3	$319,900	1,604
3	$390,000	1,751
3	$190,000	1,248
2	$74,000	2,100
1	$89,900	1,080
2	$277,880	1,461
4	$244,900	1,575
3	$230,000	1,411
2	$288,000	1,533
2	$295,000	1,425
3	$239,900	1,410
3	$245,000	1,630
3	$369,900	1,951
3	$300,000	1,841
3	$248,500	1,166
3	$249,995	1,450
1	$115,000	600
2	$299,000	1,425
3	$499,999	2,236
3	$253,900	1,552
4	$289,900	1,700
3	$327,900	2,023
4	$325,000	1,700
2	$285,000	1,608
2	$384,500	1,604
3	$265,000	1,440
3	$238,000	1,250
4	$324,900	1,815
3	$219,900	1,174
3	$239,900	1,486
3	$265,000	1,455
3	$230,000	1,619
4	$489,000	3,419
2	$379,000	1,604
2	$419,000	1,533
4	$658,500	2,642
3	$309,900	1,993
3	$369,900	2,268
3	$249,000	1,601
4	$283,000	1,868
3	$219,900	1,270
4	$289,900	1,935
4	$439,000	2,400
2	$233,900	1,461
3	$189,000	1,343
3	$237,900	1,651
5	$848,000	3,688
3	$320,000	1,451
4	$279,499	1,892
4	$359,900	2,133
4	$319,500	2,200
2	$399,500	1,400
3	$225,000	1,300
5	$719,000	3,458
MEAN	$292,080	1,698
MEDIAN	$284,500.00	1,604
MODE	$245,000	1,604
1st Quartile	187	2100
3rd Quartile	251.4	2400
Min	125	1600
Max	345.3	2900
Range	220.3	1300
Variance	2218.919	61831.5018
Standard Deviation	47.1054	248.659409
Chebyshev	99.95%	100.00%
Empirical Rule	97.52%	99.07%

Number of Bedrooms for Homes for Sale in Cathedral City, CA.

Frequency

1 Bedroom 2 Bedrooms 3 Bedrooms 4 Bedrroms 5 Bedrooms 2.0 16.0 49.0 30.0 3.0

Cathedral City House Listings Price

Frequency 150,000 or Less 150,000 - 200,000 200,000 - 250,000 250,000 - 300,000 300,000 - 350,000 350,000 - 400,000 400,000 and Above 5.0 9.0 24.0 28.0 17.0 11.0 6.0

Conclude whether Chebyshev's or Empirical Rule is more accurate with each of listing prices and square footages. With each of the listing prices and square footages, the Chebyshev’s Theorem is in fact applying to the data set. As the data provided as it provided per the Chebyshev’s Theorem of the minimum proportion of the measurements within one, two, or more standard deviation of the mean. As this concludes that the empirical rule provides accurate data as it has more information about the shape of the measurements. By the empirical rule contains the predication and the percentage with a vast range compared to the Chebyshev Theorem. This conclusion is based on how the empirical rule is used for forecasting final outcomes, such the listing prices and square footages

Listing Price ($)

Frequency

A sample was taken of 100 homes being sold in Cathedral City. Based on this frequency chart, there are 28 homes being sold at the range of $250,000 - $300,000. This is the most common price range of homes being sold in Cathedral City, CA. Of this sample, the least common price range is $150,000 or less. The shape of the histogram is bell-shaped which means that it is a normal distribution.