1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 PROPERTY ADDRESS 3532 Maunalei Ave, Honolulu, HI 96816 4675 Aukai Ave, Honolulu, HI 96816 66-912 Kamakahala St Unit 2, Waialua, HI 96791 94-322 Hanawai Cir, Waipahu, HI 96797 68-024 Apuhihi St Unit 102W, Waialua, HI 96791 1505 Halekoa Dr, Honolulu, HI 96821 85-132 Waianae Valley Rd, Waianae, HI 96792 87-234 Holopono St, Waianae, HI 96792 2073 St Louis Dr, Honolulu, HI 96816 54-223 Kamehameha Hwy, Hauula, HI 96717 54-215 Kamehameha Hwy, Hauula, HI 96717 94-805 Nolupe St, Waipahu, HI 96797 91-213 Lukini Pl Unit 9, Ewa Beach, HI 96706 92-831 Makakilo Dr Apt 17, Kapolei, HI 96707 91-1205 Kupipi Pl, Ewa Beach, HI 96706 94-648 Kuaie St, Mililani, HI 96789 98-1925 Hapaki St, Aiea, HI 96701 94-1005 Lauwi Pl, Waipahu, HI 96797 3825 Likini St, Honolulu, HI 96818 715 Pahumele Way, Kailua, HI 96734 54-063 Hauula Homestead Rd, Hauula, HI 96717 84-018 Makau St, Waianae, HI 96792 99-078 Olopana St, Aiea, HI 96701 98-1660 Apala Loop, Aiea, HI 96701 1092 Kuekue St, Honolulu, HI 96825 86-258 Kawili St, Waianae, HI 96792 95-203 Hoahele Pl, Mililani, HI 96789 1811 Lanikeha Pl, Pearl City, HI 96782 1613 Kamole St, Honolulu, HI 96821 91-1016 Hooilo Pl, Ewa Beach, HI 96706 91-6221 Kapolei Pkwy Unit 301, Ewa Beach, HI 96706 95-1317 Wikao St Unit 56, Mililani, HI 96789 169 Kuukama St, Kailua, HI 96734 1044 Waiholo St, Honolulu, HI 96821 1242A 9th Ave, Honolulu, HI 96816 582 Pepeekeo Pl, Honolulu, HI 96825 591 Kahiau Loop, Honolulu, HI 96821 88 Piikoi St Apt 3205, Honolulu, HI 96814 95-187 Aumea Loop, Mililani, HI 96789 94-1112 Huakai St, Waipahu, HI 96797 2357 Aina Lani Pl, Honolulu, HI 96822 94-1149 Eleu St, Waipahu, HI 96797 1320 Kainui Dr, Kailua, HI 96734 94-1017 Waiopae St, Waipahu, HI 96797 42-125 Kooku Pl, Kailua, HI 96734 94-514 Farrington Hwy, Waipahu, HI 96797 12 Kailua Rd, Kailua, HI 96734 84-575 Kili Dr Apt 1, Waianae, HI 96792 92-736 Kuhoho Pl, Kapolei, HI 96707 1326 13th Ave Unit A, Honolulu, HI 96816 4203 Kaimanahila St, Honolulu, HI 96816 91-701F Pohakupuna Rd, Ewa Beach, HI 96706 94-347 Hene St, Waipahu, HI 96797 87-1034 Anaha St, Waianae, HI 96792 86-315 Puuhulu Pl, Waianae, HI 96792 170 Poipu Dr, Honolulu, HI 96825 4148 Kilauea Ave, Honolulu, HI 96816 3908 Maunaloa Ave, Honolulu, HI 96816 929 Ocean View Dr, Honolulu, HI 96816 45-584 Holomakani St, Kaneohe, HI 96744 478 Kaumakani St, Honolulu, HI 96825 4017 Hoku Ave Unit A, Honolulu, HI 96816 4764 Aukai Ave, Honolulu, HI 96816 94-506 Loaa St, Waipahu, HI 96797 47-062 Okana Pl, Kaneohe, HI 96744 44-646 Kaneohe Bay Dr Unit B, Kaneohe, HI 96744 66-831 Kamakahala St, Waialua, HI 96791 53-898 Kamehameha Hwy, Hauula, HI 96717 95-681 Alohilani St, Mililani, HI 96789 91-6221 Kapolei Pkwy Unit 203, Ewa Beach, HI 96706 87-1009 Kaiamekala St, Waianae, HI 96792 2517 Saul Pl Apt A, Honolulu, HI 96816 5365 Poola St, Honolulu, HI 96821 1055 Hilala St, Honolulu, HI 96825 1074 Koko Kai Pl, Honolulu, HI 96825 91-1035 Waikai St, Ewa Beach, HI 96706 91-1069 Aawa Dr, Ewa Beach, HI 96706 1661 Quincy Pl, Honolulu, HI 96816 1345 Kaeleku St, Honolulu, HI 96825 98-574 Holopuni St Unit 35, Aiea, HI 96701 LISTING PRICE SQ FT $1,249,000 2,055 $3,750,000 2,828 $689,000 1,287 $740,000 2,483 $259,000 586 $1,495,000 2,700 $315,000 912 $290,000 880 $825,000 1,309 $1,250,000 2,589 $1,199,000 1,641 $649,000 1,378 $649,000 1,705 $589,000 1,401 $615,000 1,496 $745,000 1,360 $850,000 1,436 $574,900 1,000 $795,000 2,243 $899,000 1,392 $670,000 1,848 $529,000 1,656 $535,000 720 $820,000 1,760 $1,425,000 2,495 $545,000 2,112 $895,500 1,920 $1,075,000 1,593 $2,168,000 3,087 $675,000 1,228 $590,000 1,456 $565,000 1,197 $1,785,000 2,059 $2,288,000 2,820 $998,000 1,680 $915,000 1,482 $6,000,000 5,226 $1,250,000 1,039 $660,000 1,848 $479,000 1,460 $1,750,000 2,741 $600,000 1,559 $1,777,000 4,195 $599,900 1,092 $3,100,000 3,200 $500,000 748 $6,900,000 1,146 $698,000 1,474 $769,000 1,637 $865,000 2,193 $2,980,000 5,515 $430,000 1,032 $549,000 1,760 $469,000 1,557 $950,000 3,770 $2,395,000 4,097 $949,500 1,160 $680,000 642 $798,000 904 $1,370,000 3,507 $1,350,000 3,168 $930,000 2,016 $3,880,000 4,474 $550,000 1,296 $1,349,000 3,899 $1,650,000 2,498 $825,000 3,632 $560,000 1,656 $729,500 1,248 $570,000 1,456 $539,000 1,217 $985,000 1,042 $1,530,000 2,260 $1,599,000 2,969 $1,350,000 1,931 $1,300,000 3,550 $649,772 1,795 $775,000 1,288 $888,888 1,658 $598,000 1,458 # OF BEDROOMS 5 3 3 8 1 5 3 3 4 6 3 3 3 4 3 3 3 3 4 3 6 5 3 4 4 2 4 3 4 3 4 3 4 3 5 3 4 2 4 4 5 3 7 3 4 3 2 3 3 3 5 3 4 3 13 6 3 2 3 5 4 3 5 3 7 4 9 4 3 3 3 3 3 3 3 5 3 4 3 3 SQ FT 6,000 5,000 4,000 3,000 2,000 1,000 0 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 91-492 Makalea St Unit 129, Ewa Beach, HI 96706 617 Kuaaina Way, Kailua, HI 96734 91-1021 Kaileonui St, Ewa Beach, HI 96706 1319 Hoakoa Pl, Honolulu, HI 96821 2404 Orchid St, Honolulu, HI 96816 1638 Laukahi St, Honolulu, HI 96821 987 Kapa Pl, Honolulu, HI 96825 1796 Laukahi St, Honolulu, HI 96821 59-171-C Ke Nui Rd, Haleiwa, HI 96712 91-319 Hoalauna Pl, Ewa Beach, HI 96706 42-100 Kalanianaole Hwy Unit 18, Kailua, HI 96734 990 Kapa Pl, Honolulu, HI 96825 47 Kaapuni Dr, Kailua, HI 96734 460 Kamaaha Ave Unit 18, Kapolei, HI 96707 87-2165 Pakeke St, Waianae, HI 96792 91-1140 Hoiliili St, Ewa Beach, HI 96706 1903-A 10th Ave, Honolulu, HI 96816 2002 Wilder Ave, Honolulu, HI 96822 2301 Hoohai St, Pearl City, HI 96782 2021 10th Ave Unit B, Honolulu, HI 96816 $559,000 $820,000 $629,900 $988,000 $685,000 $2,060,000 $1,288,000 $1,250,000 $3,298,000 $678,900 $3,450,000 $1,088,000 $3,880,000 $646,735 $449,000 $695,000 $899,000 $900,000 $700,000 $1,184,000 1,320 952 1,275 2,160 846 2,943 2,348 2,582 2,864 1,762 5,408 1,915 5,278 1,548 1,387 1,776 2,170 1,004 1,068 2,704 3 2 3 5 2 4 4 4 4 3 4 4 6 4 4 4 5 4 3 3 Real Estate Regression Exercise QNT/351 Version 5 University of Phoenix Material Real Estate Regression Exercise Directions: Use the real estate data you used for your Week 2 learning team assignment. Analyze the data and explain your answers. You are consulting for a large real estate firm. You have been asked to construct a model that can predict listing prices based on square footages for homes in the city you've been researching. You have data on square footages and listing prices for 100 homes. 1. Which variable is the independent variable (x) and which is the dependent variable (y)? The listing price is based on the square footage, so the listing price is the dependent variable and the square footage is the independent variable. 2. Click on any cell. Click on InsertScatterScatter with markers (upper left). To add a trendline, click ToolsLayoutTrendlineLinear Trendline Does the scatterplot indicate observable correlation? If so, does it seem to be strong or weak? In what direction? 3. Click on DataData AnalysisRegressionOK. Highlight your data (including your two headings) and input the correct columns into Input Y Range and Input X Range, respectively. Make sure to check the box entitled \"Labels\". Copyright 2016 by University of Phoenix. All rights reserved. 1 Real Estate Regression Exercise QNT/351 Version 5 (a) What is the Coefficient of Correlation between square footage and listing price? (b) Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not? (c) What proportion of the variation in listing price is determined by variation in the square footage? What proportion of the variation in listing price is due to other factors? (d) Check the coefficients in your summary output. What is the regression equation relating square footage to listing price? (e) Test the significance of the slope. What is your t-value for the slope? Do you conclude that there is no significant relationship between the two variables or do you conclude that there is a significant relationship between the variables? (f) Using the regression equation that you designated in #3(d) above, what is the predicted sales price for a house of 2100 square feet? Copyright 2016 by University of Phoenix. All rights reserved. 2