I need help with this please!!!

Part 2 - . Access the data set House Price. Select two comparable college towns (DO NOT USE AMES IOWA) and: . Develop a model that predicts the sale price of a house in college city 1. . Develop a model that predicts the sale price of a house in college city 2. . Develop a model that predicts the sale price of a house using both college city 1 and 2 data. Compare and contrast your models and their results. . Which model is the best predictor and why? Be as specific as possible. (Hint) See case study completed on page 254-255 of the text for assistance Data Set for part 2 Your analysis should be between 3 and 4 pages, not including the title page or reference page or appendices. Proper APA formatt assignment submission box. E 212 20 214 2015 226 Nm BOLS 16988.4 187108 270072 217 235400 229000 265000 331000 393000 290305 318000 310000 460000 409000 462500 525000 21 O 354000 263900 G08000 205000 40000 265000 374500 299000 299900 2000 220000 200000 181000 747000 148000 2010 2000 200000 44100 335000 320500 310000 313000 234000 9218 30 219 23220 22 221 23 222 34 223 35224 226 225 227 226 226 227 229 220 230 229 231 230 232 231 233 232 234 233 235 234 136235 2372 238 237 25231 240 239 241 2410 242 M3 243342 244 245 34 340 M 267 246 246 247 24 33029 251 250 250 251 4/20/2016 2 4/4/2016 3 7/6/2016 3 5/31/2016 4 1/23/2016 5 4/8/2016 4 7/8/2016 4 6/7/2016 3 2/3/2016 4 5/2/2015 3 5/18/2016 4 4/25/2016 4 4/26/2016 3 2/13/2016 3 3/23/2016 3 6/1/2016 16 7/15/2016 3 3/24/2015 4 6/3/2016 3 4/26/2016 5/2/2016 4 3/23/2015 3 3/25/2016 2 4/11/2016 4 2/26/2016 5 2/22/2016 1 5/7/2016 6 3/1/2016 3 6/24/2016 12 5/20/2016 3 1/21/2016 4 6/27/2016 3 1/11/2016 4 2/2/2016 4 5/20/2016 4 4/22/2016 3 3/11/2016 4 4/29/2016 4 5/4/2016 18 S/2016 4 1 2 2 2 25 2.5 2 3 2.5 2 25 25 1 15 2 2.5 1 2.5 2.5 2 LIS 2 1 1 1.5 1 2.5 2 1 1.5 2 25 3.5 2.5 3 2 1456 1612 1546 2100 2500 1934 17102 1910 2700 2093 2918 2000 1094 936 1002 2005 14 2220 1646 1209 214 1283 909 1312 220072 200376 3260 35283.6 29185.2 26136 23958 603 30927.6 20508 558212 381A 23086 120324 19002 2000 161172 Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family siyle Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family 1950 1962 1955 1972 1975 1972 1920 1963 19 1954 1936 1999 1250 149 1923 1905 1900 1960 1880 1953 1900 1966 19 1880 Ambon, MA University of Massachusettsamhet Amherst, MA University of March Amherst Amherst, MA University of Massachusetts Amherst Amherst, MA Like4ly / Maria fun Hy Lp Amherst, MA University of Manachusetts Amhart Amherst, MA University of Massachusetts Amhers Ames, MA university of Massachusetts Ahant Amherst, MA University of Massachus Arhent Aisher, MA University of Massachant Amherst, MA University of Manchest Amherst, MA Phim 14 4 aviatra III views Anhent, MA University of Mats Anhet Amherst, MA Univery of Massachusetts het Aest, MA PHUTH Of MHaihuot. m Amherst, MA University of Mathers Amherst, MA Unity of Massachusetts Amenit Amherst, MA University of Massachusetts AMA invenity of Manchette Anders Anhen, MA Liity of Macets Anhen Amherst, MA University of Mass A Amherst, MA university of Manaus Arhent Amherst, MA Only of Massachusetts Ashers Amhart, MA Liversity of Machusetts Amherst, MA University of Man Art Amherst, MA Lenty of Massachuse ht, MA Uity of Man Anh A MA ity of Man AMA vesity of Me Amherst, MA Liversity of Art Anthon, MA Univery of Mechat Archet, of March AMA Livng v hot nh Amherst MA of the Am, MA Unity of Massanes A, MA university of the ALMA March hen, MA het of March AMA Machent Amherst, MA y essay when AMA wyl AMA nully at Mesh 1520 10N 3501 2192 1900 11 1850 2953 1996 1056 15 2114 2040 2035 1900 10 115 13 2155 15616 6000 474004 270022 126324 257004 23958 315412 200326 27S 1 117612 121 4512 2010 437 19 19 1902 1993 1/2016 Single Single Family Single Family Single Family plean Single Family 25 2 15 2 VO 5000 2000 13 Sheet OCTOBER NOVEME E DOS O + + . MAY JUNE APRIL -- JULY AUGUST SEPTEMBER . . . . ... M NON MARCH 2003 JANUARY FEBRUARY - LES -10 . ... MMMMM BEM SRL E ENE D . 276 27 277 278 278 277 279 228 200279 2910 202 203 283 282 204783 209284 3 5 3 4 4 3 2 1863 254 3132 1531 Single Family Sangley 2 4 3.5 2 2 2 1 15 250000 362000 150000 201000 2.500 311500 15000 100000 151900 198100 145000 15245 165533 27001.2 5 9583 2014 Apus 1961 1956 1982 1965 1966 1992 SEE 1600 241 1930 1348 VW USGEE EST 12024 12296.8 8276 1955 1945 1964 14 HD SC 1982 WEB DOCORE 4 3 3 3 4 3 3 1550 1420 ET CISE 7405 417 7005 292000 180000 760000 220000 216000 20726 288252 289 28 290 29 299 200 292 291 200290 291293 29524 200 29726 296 297 1 15 2 15 2 15 3 3 1 2 1 1 2.5 4/10/2016 4/27/2016 5/20/2016 6/1/2015 5/4/2016 5/20/2016 5/21/2016 5/2016 5/5/2016 4/29/2015 5/20/2016 6/10/2016 4/23/2016 1/11/2016 5/15/2016 6/14/2016 1/11/2016 5/22/2016 5/31/2016 5/2016 5/21/2016 4/12/2010 50/2016 6/10/2016 4/6/2010 4/1/2010 4/1/2016 /23/2016 6/11/2010 4/39/2013 UW/2016 SVI/2016 4/23/2016 14/2016 3/11/2016 4/2016 1/29/2016 E Sing For Side Family Single Family Single Family any Single Single Family Sangler Single Family Sandaly Se family Sergey Single Family Single Family Singlefly Single Furnity Samily Single Family Say Fay 1050 2200 1200 5005 1000 1006 1144 BOG LINIE MODE Ann Arbor, Ann Arbor, MI Arbor, My Ann Arbor, MM Ann Arbor, University of Man Ann Arbor, Museo Ann Arbor, Mersity of Arbok och Arnhem Arrivacy Ann ArborMY ANOM Arrow Arbor, ME An Art, ARADO, MI Arbor Ann Arbor Me Are My ARAM Anh Uw Arrow AR AM Arab, Arbor AM ME OM M AM Arbor 1903 1500 131 1990 100 1970 1956 70 000 240000 32000 127100 545000 COGE who 1 1101 IM 199 21542 GOWE 1 1 3 2 1 2 4 4 4 5 4 4 1 4 0 4 2277 2013 450000 0000 3 3.5 25 45 2 1 35 SET CI 100 3010 10101 2000 19 2003 WE PE M 525.000 3190 WWW PO COE DIOT Saglamly Sangay Singel Singer wy Single Parily Single 304 3 000 EP E VOEGDE SORE DOREET OSZE 1 IN Ahor 06 300 M 43300 4 10000 ORDET any SON WA ME ws AMI Art OOS 1 20 1500 1 IM 4 4 1 4 5 3 4 4 3 25 4 2 13 23 2 2 GROTE OTETIE 23 single 16 hy AMMA CHES M 312 311 IMMER Tay M06 WEN/2016 SH /2016 BOGE 314 113 31 316 311 PORT Query TOR NOVEMBER Part 2 - . Access the data set House Price. Select two comparable college towns (DO NOT USE AMES IOWA) and: . Develop a model that predicts the sale price of a house in college city 1. . Develop a model that predicts the sale price of a house in college city 2. . Develop a model that predicts the sale price of a house using both college city 1 and 2 data. Compare and contrast your models and their results. . Which model is the best predictor and why? Be as specific as possible. (Hint) See case study completed on page 254-255 of the text for assistance Data Set for part 2 Your analysis should be between 3 and 4 pages, not including the title page or reference page or appendices. Proper APA formatt assignment submission box. E 212 20 214 2015 226 Nm BOLS 16988.4 187108 270072 217 235400 229000 265000 331000 393000 290305 318000 310000 460000 409000 462500 525000 21 O 354000 263900 G08000 205000 40000 265000 374500 299000 299900 2000 220000 200000 181000 747000 148000 2010 2000 200000 44100 335000 320500 310000 313000 234000 9218 30 219 23220 22 221 23 222 34 223 35224 226 225 227 226 226 227 229 220 230 229 231 230 232 231 233 232 234 233 235 234 136235 2372 238 237 25231 240 239 241 2410 242 M3 243342 244 245 34 340 M 267 246 246 247 24 33029 251 250 250 251 4/20/2016 2 4/4/2016 3 7/6/2016 3 5/31/2016 4 1/23/2016 5 4/8/2016 4 7/8/2016 4 6/7/2016 3 2/3/2016 4 5/2/2015 3 5/18/2016 4 4/25/2016 4 4/26/2016 3 2/13/2016 3 3/23/2016 3 6/1/2016 16 7/15/2016 3 3/24/2015 4 6/3/2016 3 4/26/2016 5/2/2016 4 3/23/2015 3 3/25/2016 2 4/11/2016 4 2/26/2016 5 2/22/2016 1 5/7/2016 6 3/1/2016 3 6/24/2016 12 5/20/2016 3 1/21/2016 4 6/27/2016 3 1/11/2016 4 2/2/2016 4 5/20/2016 4 4/22/2016 3 3/11/2016 4 4/29/2016 4 5/4/2016 18 S/2016 4 1 2 2 2 25 2.5 2 3 2.5 2 25 25 1 15 2 2.5 1 2.5 2.5 2 LIS 2 1 1 1.5 1 2.5 2 1 1.5 2 25 3.5 2.5 3 2 1456 1612 1546 2100 2500 1934 17102 1910 2700 2093 2918 2000 1094 936 1002 2005 14 2220 1646 1209 214 1283 909 1312 220072 200376 3260 35283.6 29185.2 26136 23958 603 30927.6 20508 558212 381A 23086 120324 19002 2000 161172 Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family siyle Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single family Single Family Single Family Single Family Single Family Single Family Single Family Single Family Single Family 1950 1962 1955 1972 1975 1972 1920 1963 19 1954 1936 1999 1250 149 1923 1905 1900 1960 1880 1953 1900 1966 19 1880 Ambon, MA University of Massachusettsamhet Amherst, MA University of March Amherst Amherst, MA University of Massachusetts Amherst Amherst, MA Like4ly / Maria fun Hy Lp Amherst, MA University of Manachusetts Amhart Amherst, MA University of Massachusetts Amhers Ames, MA university of Massachusetts Ahant Amherst, MA University of Massachus Arhent Aisher, MA University of Massachant Amherst, MA University of Manchest Amherst, MA Phim 14 4 aviatra III views Anhent, MA University of Mats Anhet Amherst, MA Univery of Massachusetts het Aest, MA PHUTH Of MHaihuot. m Amherst, MA University of Mathers Amherst, MA Unity of Massachusetts Amenit Amherst, MA University of Massachusetts AMA invenity of Manchette Anders Anhen, MA Liity of Macets Anhen Amherst, MA University of Mass A Amherst, MA university of Manaus Arhent Amherst, MA Only of Massachusetts Ashers Amhart, MA Liversity of Machusetts Amherst, MA University of Man Art Amherst, MA Lenty of Massachuse ht, MA Uity of Man Anh A MA ity of Man AMA vesity of Me Amherst, MA Liversity of Art Anthon, MA Univery of Mechat Archet, of March AMA Livng v hot nh Amherst MA of the Am, MA Unity of Massanes A, MA university of the ALMA March hen, MA het of March AMA Machent Amherst, MA y essay when AMA wyl AMA nully at Mesh 1520 10N 3501 2192 1900 11 1850 2953 1996 1056 15 2114 2040 2035 1900 10 115 13 2155 15616 6000 474004 270022 126324 257004 23958 315412 200326 27S 1 117612 121 4512 2010 437 19 19 1902 1993 1/2016 Single Single Family Single Family Single Family plean Single Family 25 2 15 2 VO 5000 2000 13 Sheet OCTOBER NOVEME E DOS O + + . MAY JUNE APRIL -- JULY AUGUST SEPTEMBER . . . . ... M NON MARCH 2003 JANUARY FEBRUARY - LES -10 . ... MMMMM BEM SRL E ENE D . 276 27 277 278 278 277 279 228 200279 2910 202 203 283 282 204783 209284 3 5 3 4 4 3 2 1863 254 3132 1531 Single Family Sangley 2 4 3.5 2 2 2 1 15 250000 362000 150000 201000 2.500 311500 15000 100000 151900 198100 145000 15245 165533 27001.2 5 9583 2014 Apus 1961 1956 1982 1965 1966 1992 SEE 1600 241 1930 1348 VW USGEE EST 12024 12296.8 8276 1955 1945 1964 14 HD SC 1982 WEB DOCORE 4 3 3 3 4 3 3 1550 1420 ET CISE 7405 417 7005 292000 180000 760000 220000 216000 20726 288252 289 28 290 29 299 200 292 291 200290 291293 29524 200 29726 296 297 1 15 2 15 2 15 3 3 1 2 1 1 2.5 4/10/2016 4/27/2016 5/20/2016 6/1/2015 5/4/2016 5/20/2016 5/21/2016 5/2016 5/5/2016 4/29/2015 5/20/2016 6/10/2016 4/23/2016 1/11/2016 5/15/2016 6/14/2016 1/11/2016 5/22/2016 5/31/2016 5/2016 5/21/2016 4/12/2010 50/2016 6/10/2016 4/6/2010 4/1/2010 4/1/2016 /23/2016 6/11/2010 4/39/2013 UW/2016 SVI/2016 4/23/2016 14/2016 3/11/2016 4/2016 1/29/2016 E Sing For Side Family Single Family Single Family any Single Single Family Sangler Single Family Sandaly Se family Sergey Single Family Single Family Singlefly Single Furnity Samily Single Family Say Fay 1050 2200 1200 5005 1000 1006 1144 BOG LINIE MODE Ann Arbor, Ann Arbor, MI Arbor, My Ann Arbor, MM Ann Arbor, University of Man Ann Arbor, Museo Ann Arbor, Mersity of Arbok och Arnhem Arrivacy Ann ArborMY ANOM Arrow Arbor, ME An Art, ARADO, MI Arbor Ann Arbor Me Are My ARAM Anh Uw Arrow AR AM Arab, Arbor AM ME OM M AM Arbor 1903 1500 131 1990 100 1970 1956 70 000 240000 32000 127100 545000 COGE who 1 1101 IM 199 21542 GOWE 1 1 3 2 1 2 4 4 4 5 4 4 1 4 0 4 2277 2013 450000 0000 3 3.5 25 45 2 1 35 SET CI 100 3010 10101 2000 19 2003 WE PE M 525.000 3190 WWW PO COE DIOT Saglamly Sangay Singel Singer wy Single Parily Single 304 3 000 EP E VOEGDE SORE DOREET OSZE 1 IN Ahor 06 300 M 43300 4 10000 ORDET any SON WA ME ws AMI Art OOS 1 20 1500 1 IM 4 4 1 4 5 3 4 4 3 25 4 2 13 23 2 2 GROTE OTETIE 23 single 16 hy AMMA CHES M 312 311 IMMER Tay M06 WEN/2016 SH /2016 BOGE 314 113 31 316 311 PORT Query TOR NOVEMBER