You are a new hire at Laurel Woods Real Estate, which specializes in selling foreclosed homes vla public auction. Your boss has asked you to use the following data (mortgage balance, monthly payments, payments made before default, and final auction price) on a random sample of recent sales in order to estimate what the actual auction price will be. Add a new variable that describes the potential Interaction between the loan amount and the number of payments made. Payments Made Lean $ 85, 605 110,284 109,719 120.811 97,600 104,400 112.800 116.400 100.000 92.800 105,200 105.900 94.700 105,600 104.100 85,700 112, 600 119, 400 90.600 104,500 Monthly Payments $1,069.BO 998.BE 741.28 977.19 B36.5a 982.27 1.075.54 1.007.16 900.01 683.11 915.24 909.67 810.70 891.32 Auction Price $52, 775 46, 450 46.150 16.600 40.700 62.100 72,600 72.300 5B 100 37,100 52.600 51.900 43, 200 52.600 42,700 22, 200 77.000 69,000 35,600 62,000 1,074.78 871.61 1,021.23 26.46 1,056.37 22 Click here for the Excel Data File Determine the regression equation. (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.) Auction Price = Loan + Monthly Payment Payments Made+ x1x3 Complete the following table. (Round your answers to 3 decimal places. Leave no cells blank - be certain to enter "0" wherever required. Negative amounts should be Indicated by a minus sign.) Coefficient SE Coefficient p-value Predictor Constant Loan Monthly Payment Payments Made (Loan)(Payments Made) Compute the t-value corresponding to the Interaction term. (Round your answer to 2 decimal places. Negative amount should be Indicated by a minus sign.) t-value You are a new hire at Laurel Woods Real Estate, which specializes in selling foreclosed homes vla public auction. Your boss has asked you to use the following data (mortgage balance, monthly payments, payments made before default, and final auction price) on a random sample of recent sales in order to estimate what the actual auction price will be. Add a new variable that describes the potential Interaction between the loan amount and the number of payments made. Payments Made Lean $ 85, 605 110,284 109,719 120.811 97,600 104,400 112.800 116.400 100.000 92.800 105,200 105.900 94.700 105,600 104.100 85,700 112, 600 119, 400 90.600 104,500 Monthly Payments $1,069.BO 998.BE 741.28 977.19 B36.5a 982.27 1.075.54 1.007.16 900.01 683.11 915.24 909.67 810.70 891.32 Auction Price $52, 775 46, 450 46.150 16.600 40.700 62.100 72,600 72.300 5B 100 37,100 52.600 51.900 43, 200 52.600 42,700 22, 200 77.000 69,000 35,600 62,000 1,074.78 871.61 1,021.23 26.46 1,056.37 22 Click here for the Excel Data File Determine the regression equation. (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.) Auction Price = Loan + Monthly Payment Payments Made+ x1x3 Complete the following table. (Round your answers to 3 decimal places. Leave no cells blank - be certain to enter "0" wherever required. Negative amounts should be Indicated by a minus sign.) Coefficient SE Coefficient p-value Predictor Constant Loan Monthly Payment Payments Made (Loan)(Payments Made) Compute the t-value corresponding to the Interaction term. (Round your answer to 2 decimal places. Negative amount should be Indicated by a minus sign.) t-value
