Please answer both parts Thank you 2:34 OODUUG 96%cityhomes (1)fxABDEFH1Single family Population2403,000498044'Population' by 'Single family'331,000208,000829,000342540343026051426000450,000250998518,000257,0007653115181883184,00049191810292,00027060001210,000261,00011145862128498113890,000744955Millions14297,00043412Single family15172,0001868116162,00021685317228,00028740118298,0009625219613,0004831920246,000232600021122,00065061822170,0001381832368,43816442224330,000392890134,000535,0002537804264853227333,000644644281,640,00088830529209,0001584000311,000440,000308724983112189032407,000215,0001337623314870003435363738394041424344454647484950515253545556575859Sheet1Sheet2+ CHALLENGE ACTIVITY3.3.3: Excel: Using regression to make predictions.Click this link to download the spreadsheet for use in this activity. Use the Regression function in the Data Analysis ToolPak.Specify the data range for the response variable in 'Input Y Range" and the data range for the explanatory variable in "Input XRange".Jump to level 1A researcher is analyzing the relationship between various variables in housing data for 32 cities: median listprices of single family homes, condominium or co-ops, all homes, median household income, unemployment rate,and population.What is the correlation coefficient R for the model that predicts the list price of single family homes usingpopulation as an explanatory variable?R = Ex: 1.234What is the interpretation of this correlation coefficient in context?A Pickmoderatestrongweakcorrelation exists between the list price of single family homes and population.1CheckNextFeedback?

Answered: Image /qna-images/answer/06bfecc1-2859-41a0-a886-413ccdebe751.jpg

A researcher is analyzing the relationship between various variables in housing data for 32 cities: median list prices of single family homes, condominium or co-ops, all homes, median household income, unemployment rate, and population. What is the correlation coefficient R for the model that predicts the list price of single family homes using population as an explanatory variable? R= Ex: 1.234 What is the interpretation of this correlation coefficient in context? A Pick moderate strong weak correlation exists between the list price of single family homes and population.