GB 513 Course Great Wisdom / tutorialrank.com GB 513 Course Great Wisdom / tutorialrank.com | Page 12

Overall quality of work environment
Total hours worked per week
Opportunities for advancement
Question 3
27 65 12 13 40 79 35 53 29 43 42 62 22 18 34 75 50 84 33 68
40 72 510 37 64 42 82 31 46 47 95 36 82 20 42 32 73
50 42 60 28 45 7 65 48 40 32 50 41 75 18 40 32 45 48 60 11
55 33 50 21 45 42 40 46 60 48 55 30 70 39 40 22 55 12

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. Can the bond rate
be predicted by the prime interest rate?

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 value from the chart (right click on
the line, select “Add Trendline” and select options to show
these metrics).