Here is the spreadsheet with the data needed to solve the question:
Excel File Edit View Insert Format Tools Data Window Help M 34% Sat 3:53 PM :8: AutoSave OFF housing (4) Update Apple ID Settings Home Insert Draw Page Layout Formulas Data Review View Tell me Some account services will not be View available until you sign in again. In Calibri v 12 A A = ap Wrap Text v General Ex Delete v Cell BIUVE Merge & Center v $ ~ % " Sort & Find & Analyze Sensitivity Paste OvAv Conditional Format Formatting as Table Styles Format v 1 v Filter Select Data A1 X V fx Credit score C F G H K M N O P B D E Credit score Probability of default 610 16.7 W N 645 9.1 685 4.8 705 3.2 540 28 580 23 620 16 660 9 700 4.4 36 37 38 20 Default vs credit score Mortgage vs income Home value vs income Equity vs FICO Debt to income ratio + - + 100% Ready 9 MAY 52 15 9 tv ...a (5) Fred &Rosemary West And X I u Course Here x I @ Announcements - MAT-ZAO-JE X zy Section 2.3 - MAT 240: Applier x + o (- 9 C i learn.zybooks.com/zybook/SNHUMAT240Master1/chapter/Z/section/3 Update \"Wle "3 semngs a Some account services will not be View available until you sign in again. E zyBooks My library > MAT 240: Applied Statistics home > 2.3: Least squares method | zyBooks cathgwerprmqc-WW CHALLENGE ' I \"my." I 23.1: Excel: Income and house prices U Click this link to download the spreadsheet for use in this activity Jump to level 1 1 U 2 Create scatterplots using the data in the spreadsheet linked above and display the equation for the regression line. What is the equation for the regression line that predicts home equity using credit score as the explanatory variable? Y=Ex:1.234 w+(Ex:1,234 ) What is the interpretation of the slope? Q Pick Decrease in credit score as home equity increases w Decrease in home equity as credit score increases Increase in credit score as home equity increases Increase in home equity as credit score increases No practical interpretation a (5) Fred &Rosemary West And X I u Course Here x I @ Announcements - MAT-ZAO-JE X zy Section 2.3 - MAT 240: Applier x + Update Apple ID Settings (- 9 C i learn.zybooks.com/zybook/SNHUMAT240Master1/chapter/Z/section/3 a Some account services will not be View available until you sign in again. E zyBooks My library > MAT 240: Applied Statistics home > 2.3: Least squares method | zyBooks catmogveWQc-cmvry-naW CHALLENGE . I \"my." I 23.1: Excel: Income and house prices U Click this link to download the spreadsheet for use in this activity' Jump to level 1 1 U 2 Create scatterplots using the data in the spreadsheet linked above and display the equation for the regression line. What is the equation for the regression line that predicts home equity using credit score as the explanatory variable? Y: Ex:1.234 'a:+(Ex:1,234 ) What is the interpretation of the slope? Pick V What is the interpretation of the intercept? v Pick Credit score when home equity is 0 Home equity when credit score is 0 No practical interpretation
