1) Use the following data to construct a scatter graph and then fit a regression line to the data. Report the regression formula and the r-squared values from the chart (right click on the data points, select Add Trendline, and select options to show these metrics).

2) Do you think the bond rate can be predicted by the prime interest rate? Justify your answer using the relevant metrics.

Prime Interest rate Bond rate

5.0% 28.0%

12.0% 48.0%

9.0% 32.0%

1.5% 4.0%

0.4% 7.0%

11.0% 36.0%

6.0% 28.0%

2.0% 10.5%