H11.Account Complete the following table. (Leave no cells blank - be certain to enter "0" wherever required. Negative amounts should beindicated by a minus sign. Round your answers to 3 decimal places.)PredictorConstantLoanMonthly PaymentPayments MadeX1X3E-valueCoefficient.SE CoefficientCompute the I-value corresponding to the interaction term. (Negative amount should be indicated by a minus sign. Round youranswer to 2 decimal places.)AThis isp-valueDo a test of the null hypothesis to check if the interaction is significant. (Use the 0.05 significance level)so we conclude that there is You are a new hire at Laurel Woods Real Estate, which specializes in selling foreclosed homes via public auction. Your boss has askedyou to use the following data (mortgage balance, monthly payments, payments made before default, and final auction price) on arandom sample of recent sales to estimate what the actual auction price will be.Loan$ 85,603112,811110,169107,69397,600104,400113,000116,400100,00092,500105,200105,00094,700105,600104,10085,700113,600119,40090,600104,500MonthlyPayments$1,075.55Auction Price974.97739.20811.84908.16983.271,075.541,087.16900.01683.11915.24905.67810.70891.33864,381,074.73871.611,021.23836.461,056.37PaymentsMade138111024132235333634382520730245-8322Auction Price$71,17563,95045,65016,60040,70063,10072,60072,30058,10037,10052,60051,90043,20052,60042,70022,20077,00069,00035,60063,000Add a new variable that describes the potential interaction between the loan amount and the number of payments made. Then do atest of hypothesis to check if the interaction is significant.Click here for the Excel Data FileDetermine the regression equation (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimalplaces.)LoanMonthly PaymentPayments MadeX1X

The regression is used to predict the variable. It has only one dependent variable. The number of…

Complete the following table. (Leave no cells blank - be certain to enter "0" wherever required. Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) Predictor Constant Loan Monthly Payment Payments Made XqXz t-value Coefficient SE Coefficient Compute the value corresponding to the interaction term. (Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places.) This is p-value Do a test of the null hypothesis to check if the interaction is significant. (Use the 0.05 significance level) so we conclude that there is