Regression- Interest on Bond rates

Investment analysts generally believe the interest rate on bonds is inversely related to the prime interest rate for loans; that is, bonds perform well when lending rates are down and perform poorly when interest rates are up.

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 Trend line, and select options to show these metrics).

Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $11/Page
Order Now

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