Excel file:https://docs.google.com/spreadsheets/d/1KTBfuZE-7XBWlyfnhadOf_ru2okzWVE6/edit?usp=sharing&ouid=111846680843393654433&rtpof=true&sd=true

Exam 3 %] = The file P02_35.xIsx contains data from a survey of 500 randomly selected households. For this problem, use Monthly Payment as the dependent variable in several regressions, as explained below. a. Beginning with Family Size, iteratively add one explanatory variable and estimate the resulting regression equation to explain the variation in Monthly Payment. If adding any explanatory variable causes the adjusted R? measure to fall, do not include that variable in subsequent versions of the regression model. Otherwise, include the variable and consider adding the next variable in the set. Which variables are included in the final version of your regression model? (Add dummies for Location in a single step, and use Total Income rather than First Income and Second Income separately.) Family Size, Total Income, Debt, Utilities, Locationl, Location2, Location4 Family Size, Ownership, Monthly Payment, Utilities, Location1, Location2, Location3 Family Size, Ownership, Total Income, Debt, Locationl, Location2, Location3 . Family Size, Ownership, Total Income, Monthly Payment, Location1, Location2, Location3 e %) b. Build the final estimated regression equation using the same order of the variables as listed in part a, and naming the seven variables in your model X1 to X7. apow Round your answers to three decimal places, if necessary. If your answer is negative number, enter "minus" sign. Y= 0+ X1+ X2+ X3+ 0X4+ X5+ X6+ 6X7 Enter the standard error of estimate se , RZ, and the adjusted R? for the final estimated model. Round your answers to one decimal place, if necessary. Standard error estimate 242.3 0 R-Square 53.2 \\'0 % Adjusted R-Square 52.4 0 %