Property Address 389 Brenda Dr, Killeen, Tx 76542 6108 Spc Laramore Dr, Killeen, Tx 76542 400 W Vega Ln, Killeen, TX 76542 306 E Orion Dr, Killeen, TX 76542 6911 Aquamarine Dr, Killeen, TX 76542 6513 Deorsam Loop, Killeen, TX 76542 9209 Sandyford CT, Killeen, Tx 76542 9209 Bowfield Dr, Killeen, TX 76542 3310 Shawlands RD, Killeen, Tx 766542 305 William Tell Dr, Killeen, Tx 76542 6106 Malachi Ln, Killeen, Tx 76542 413 Gemini Ln, Killeen, Tx 76542 6104 Marble Falls Dr, Killeen, Tx 76542 4505 Oak Vista Cir, Killeen, TX 76542 4303 Bluestem Ln, Killeen, Tx 76542 5506 Gunnison Dr, Killeen, Tx 76542 4805 Addie Dr, Killeen, Tx 76542 6800 Golden Oak Ln, Killeen, Tx 76542 2801 Tortoise Ln, Killeen, Tx 76542 3706 Solomon Dr, Killeen, Tx 76542 6400 Manganite Dr, Killeen, Tx 76542 5205 Lyra Dr, Killeen, Tx 76542 3511 Greyfriar Dr, Killeen, Tx 76542 2221 Sparrow Rd, Killeen, Tx 76542 5408 English Oak Dr, Killeen, Tx 76542 2404 Riley Dr, Killeen, Tx 76542 270 Little Trimmer Rd, Killeen, Tx 76542 4815 Water Oak Dr, Killeen, Tx 76542 4202 Water Oak Dr, Killeen, Tx 76542 6408 Jovana Dr, Killeen, Tx 76542 2322 Botanical Dr, Killeen, Tx 76542 5409 White Rock Dr, Killeen, Tx 76542 311 W Vega Ln, Killeen, Tx 76542 6101 Emilie Ln, Killeen, Tx 76542 2613 Rampart Loop, Killeen, Tx 76542 5502 Shawn Dr, Killeen, Tx 76542 5413 Siltstone Loop, Killeen, Tx 76542 4412 Rich Dr, Killeen, Tx 76542 211 W Orion Dr, Killeen, Tx 76542 300 W Orion Dr, Killeen, Tx 76542 301 W Orion Dr, Killeen, Tx 76542 7101 Golden Oak Ln, Killeen, Tx 76542 503 Atlas Ave, Killeen, Tx 76542 5608 Boxelder Trl, Killeen, Tx 76542 5703 Turquoise, Killeen, Tx 76542 3508 Castleton Dr, Killeen, Tx 76542 Listing Price 115000 304900 194740 192290 196000 128250 167565 154365 209295 148500 229900 165000 234900 224000 112000 129900 110000 230000 149000 132500 292000 148000 250000 235000 194900 130000 125000 134000 105000 291900 94900 121000 142000 214900 121000 128900 389900 214900 196665 212020 198245 234000 156500 165000 219900 180000 4216 Adobe Dr, Killeen, Tx 76542 6110 Suellen Ln, Killeen, Tx 76542 401 Aries Ave, Killeen, Tx 76542 4304 Frontier Trl, Killeen, Tx 76542 204 Zinnia Dr, Killeen, Tx 76542 7301 Andalucia Ln Killeen, Tx 76542 3004 Bastion Loop, Killeen, Tx 76542 156 Fay Dr, Killeen, Tx 76542 4600 Aspen Dr, Killeen, Tx 76542 203 Fred Patrick, Killen, Tx 76542 3510 Greyfriar Dr, Killeen, Tx 76542 601 Constellation Dr, Killeen, Tx 76542 5606 Drystone Ln, Killeen, Tx 76542 5406 Birmingham Cir, Killeen, Tx 76542 6103 Flat Slate Dr, Killeen, Tx 76542 507 W Libra Dr, Killeen, Tx 76542 6308 Alabaster Dr, Killeen, Tx 76542 7101 Gemstone, Killeen, Tx 76542 10002 Taylor Renee Dr, Killeen, Tx 76542 10004 Taylor Renee Dr, Killeen, Tx 76542 3306 Greyfriar Dr, Killeen, Tx 76542 3410 Castleton Dr, Killeen, Tx 76542 5010 James Loop, Killeen, Tx 76542 2902 Bastion Loop, Killeen, Tx 76542 4906 Sunrise St, Killeen, Tx 76542 4919 Teal Dr, Killeen, Tx 76542 5006 Topsey Dr, Killeen, Tx 76542 3706 Crosscut Loop, Killeen, Tx 76542 5306 Barkey Ct, Killeen, Tx 76542 5121 Birmingham Cir, Killeen, Tx 76542 4101 Paintbrush Dr, Killen, Tx 76542 4904 Greenlee Dr, Killeen, Tx 76542 5210 Lyra Dr, Killeen, Tx 76542 6807 Deorsam Loop, Killen, Tx 76542 4903 Birmingham Cir, Killeen, Tx 76542 709 Atlas Ave, Killeen, Tx 76542 5302 Lyra Dr, Killeen, Tx 76542 4507 Derik Dr, Killeen, Tx 76542 5007 Wind Song Dr, Killeen, Tx 76542 5719 Birmingham Cir, Killeen, Tx 76542 6804 Rosita Oak Dr, Killeen, Tx 76542 9013 Dunblane Dr, Killeen, Tx 76542 210 Rowdy Dr, Killeen, Tx 76542 3201 Levy Ln, Killeen, Tx 76542 9107 Ashlyn Dr, Killeen, Tx 76542 4401 Chantz Dr, Killeen, Tx 76542 5904 Sulfur Spring Dr, Killeen, Tx 76542 4908 Leaning Oak Dr, Killeen, Tx 76542 108200 159000 133950 125000 69000 196000 134900 239900 119000 179900 153900 155900 234900 175000 295900 155900 298105 255765 187500 176500 209000 195000 128900 114900 86900 104900 115000 115000 169900 156000 154900 104900 159000 169900 239900 149500 154900 97650 115900 116000 145900 199900 163000 101300 169900 109500 135000 124900 313 Owen Ct, Killeen, Tx 76542 305 Sandra Sue Dr, Killeen, Tx 765542 5408 Mesa Dr, Killeen, Tx 76542 305 Carly Dr, Killeen, Tx 76542 6309 Morganite Ln, Killeen, Tx 76542 6209 Suellen Ln, Killeen, Tx 76542 198000 153000 149000 75900 302950 170000 You are consulting for a large real estate firm. You have been asked to construct a model that can predict listin 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)? 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 inpu sure to check the box entitled \"Labels\". (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 pr (d) Check the coefficients in your summary output. What is the regression equation relating square footage to (e) Test the significance of the slope. What is your t-value for the slope? Do you conclude that there is no sign 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 ho Single Family Homes Square Foot Bedrooms 1280 2319 2412 2412 2291 2207 1690 1501 2744 1656 3273 2589 2403 3026 1565 1887 1423 2900 2190 1986 2398 2072 3338 2217 2170 2176 1260 2027 1619 1960 1403 1720 1543 3246 1375 1924 3072 2286 2412 2742 2412 2970 1928 1807 2256 3416 3 4 4 4 4 4 4 3 4 3 5 4 4 3 3 4 3 4 3 4 4 4 6 4 3 4 3 3 3 4 3 4 3 5 3 4 5 4 4 5 4 5 4 3 4 6 1334 1845 2094 1540 1642 2010 1599 2145 1684 2227 1536 2249 3323 1968 2418 1667 3575 2522 2006 1892 2505 2735 1609 1282 1718 1380 1492 1374 2403 1770 1863 1442 2125 2004 3296 1870 1848 1509 1857 2658 1434 2864 1848 1378 4065 1556 1512 1400 3 3 5 4 4 4 4 3 4 4 3 3 4 4 4 4 4 4 4 4 4 4 4 3 4 3 4 3 4 3 3 3 4 5 5 4 3 3 4 3 4 5 4 4 6 3 4 3 1904 1657 2403 1474 3084 2112 4 4 3 3 4 4 nstruct a model that can predict listing prices based on square footages for homes in the city you've been researching. ent variable (y)? left). o be strong or weak? cluding your two headings) and input the correct columns into Input Y Range and Input X Range, respectively. Make ng price? r to #2 above? Why or why not? tion in the square footage? What proportion of the variation in listing price is due to other factors? equation relating square footage to listing price? Do you conclude that there is no significant relationship between the two variables or do you conclude that there is a t is the predicted sales price for a house of 2100 square feet? en researching. ctively. Make that there is a