I do not understand this regression lab spreadsheet need help with two questions in the attached spreadsheet. The first question is; Use your equation from step 5 to fill in the pink table to the right. You must use a formula and cell referencing.Then question 8 is answer the following; 1. Why does your Trendline have a negative slope? 2. Explain why the interest rate and median home price have this kind of relationship. 3. Do the results in the pink table below make sense in context of the situation described? Explain why or why not.       

Mortgage interest rates and home prices Directions for Lab: 1. Click on the "Data" tab 2. Select the cells B15 to C31. 2. Click on Insert and Scatter. A scatter chart will be generated. 3. On the scatter chart, right click on any point in the chart. 4. Choose "Add Trend Line." 5. Select "Linear," "Display Equation on Chart" and "R-Squared Value on Chart." 6. Resize and move the graph to the fit the box to the right 7. Use your equation from step 5 to fill in the pink table to the right. You must use a formula and cell referencing 8. Answer the questions at the bottom. Year 1988 1989 1990 1991 1992 1993 1994 X VARIABLE 30-year mortgage interest rate (%) 10.30 10.30 10.10 9.30 8.40 7.30 8.40 Y VARIABLE Median home price $183,800 $183,200 $174,900 $173,500 $172,900 $173,200 $173,200 1995 1996 1997 1998 1999 2000 2001 2002 2003 Average 7.90 7.60 7.60 6.90 7.40 8.10 7.00 6.50 5.80 7.75 $169,700 $174,500 $177,900 $188,100 $203,200 $230,200 $258,200 $309,800 $329,800 $180,550 Interest Rate 1 2 4 8 16 20 Median Home Price Questions: 1. Why does your Trendline have a negative slope? 2. Explain why the interest rate and median home price 3. Do the results in the pink table below make sense in Explain why or why not. ces ula and cell referencing. Median home price $350,000 $300,000 $250,000 f(x) = 23409.4481014965 x + 393348.616267681 R = 0.384595153205197 $200,000 Move Graph Here $150,000 $100,000 $50,000 $0 5.00 ve a negative slope? e and median home price have this kind of relationship. able below make sense in context of the situation described? 6.00 7.00 8.00 9.00 10.00 1 9.00 10.00 11.00