Exercise 14-32 (Algo) (LO14-1, LO14-6, LO14-8) You are a new hire at Laurel Woods Real Estate, which specializes in selling foreclosed homes via 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 to estimate what the actual auction price will be. Loan Monthly Payments Payments Made Auction Price $ 85,604 $ 1,021.30 1 $ 19,100 111,339 969.04 33 22,650 105,557 740.28 11 44,700 119,161 889.42 11 16,600 97,600 942.40 18 40,700 104,400 983.27 21 63,100 113,800 1,075.54 22 72,600 116,400 1,087.16 35 72,300 100,000 900.01 33 58,100 92,800 683.11 36 37,100 105,200 915.24 34 52,600 105,900 905.67 38 51,900 94,700 810.70 25 43,200 105,600 891.33 20 52,600 104,100 864.38 7 42,700 85,700 1,074.73 30 22,200 113,600 871.61 24 77,000 119,400 1,021.23 58 69,000 90,600 836.46 3 35,600 104,500 1,056.37 22 63,000 Add a new variable that describes the potential interaction between the loan amount and the number of payments made. Then do a test of hypothesis to check if the interaction is significant. Click here for the Excel Data File Determine the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) 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.) Compute the t-value corresponding to the interaction term. (Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places.) Do a test of the null hypothesis to check if the interaction is significant. (Use the 0.05 significance level.)