The middle question gives 2 options 1) a decrease and 2) an increase
ACTIVITY Excel: Using regression to make predictions. City Single family Condo or co- All homes Household in Unemploymentlation Atlanta, GA 403,000 298,000 317,000 55,279 8.5 498044 Minneapolis, 331,000 291,000 323,000 58,993 7.5 425403 Click this link to download the spreadsheet for use in this activity. Use the Cincinatti, Ol 208,000 211,000 191,000 38,545 10.1 302605 San Diego, C 829,000 536,000 75,456 8.8 Regression function in the Data Analysis ToolPak. Specify the data range for 725,000 1426000 Reno, NV 450,000 247,000 441,000 54,916 6.9 250998 the response variable in "Input Y Range" and the data range for the Portland, OR 518,000 411,000 514,000 65,740 8.9 653115 Sheet1|A1:G33 explanatory variable in "Input X Range". 8 Sioux Falls, $ 257,000 175,000 248,000 59,017 3.4 181883 Kansas City, 184,000 219,000 187,000 52,405 7.5 491918 10 Chicago, IL 292,000 357,000 297,000 55 ,198 13.8 2706000 11 Savannah, G 210,000 206,000 203,000 41,093 8.8 Jump to level 1 145862 12 Bloomington 261,000 188,000 248,000 34,435 4.7 84981 13 Seattle, WA 890,000 573,000 837,00 85,562 6.6 744955 A researcher is analyzing the relationship between various variables in housin 4 Concord, NH 297,000 178,000 284,000 62,967 5.2 43412 5 Augusta, ME 172,000 130,000 176,000 40,340 5.4 18681 prices of single family homes, condominium or co-ops, all homes, median hot 16 Des Moines, 162,000 186,000 165,000 52,251 6.4 216853 and population. 17 Lincoln, NB 228,000 186,000 225,000 55,224 3.2 287401 18 Nampa, ID 298,000 258,000 305,000 44,691 6.4 96252 19 Draper, UT 613,000 418,000 599,000 115,618 4.8 48319 What is the regression equation for the model that predicts the list price of sir 20 Houston , TX 246,000 177,000 209,000 51,140 9.8 2326000 household income as an explanatory variable? Memphis, TM 122,000 170,000 112,000 39,108 12.1 650618 Waco, TX 170,000 127,000 164,000 37,735 7.0 138183 Jackson, MS 68,438 121,000 48,579 37,563 9.3 164422 Y = Ex: 1.234 X + (EX: 1.234 E ) Tampa, FL 330,000 245,000 289,000 50,90 6.9 392890 Atlantic City, 134,000 112,000 123,000 27,786 15.8 37804 What is the interpretation of the slope? Bozeman, M 535,000 343,000 499,000 51 ,896 3.9 48532 7 Las Vegas, N 333,000 183,000 318,000 54,694 !4.1 644644 Pick in the list price of single family homes as median houser 28 s San Francisc 1,640,000 1,280,000 1,490,000 104,552 8.4 888305 Philadelphia, 209,000 335,000 216,000 43,744 1.7 1584000 30 Charlotte, NO 311,000 234,000 280,000 60,886 8.1 872498 What is the interpretation of the intercept? 31 Ann Arbor, M 440,000 282,000 412,000 63,956 5.0 21890 32 Charleston, S 407,000 303,000 364,000 64,599 4.8 133762 Pick 33 San Antonio, 215,000 165,000 213,000 46,317 8.0 1487000 List price of single family homes when median household income is 0 34 35 Median household income when list price of single family homes is o No practical interpretation 37 38 Check Next Sheet1 + Feedback? Ready 100% esc F3 F5 F6 F7 F12 Ca o 5 6 dele Q W E R T ab Y U P A S D F ck G H K
