GB 513 RANK Imagine Your Future /gb513rank.com GB 513 RANK Imagine Your Future /gb513rank.com | Page 10

75
45
65
Relationship with supervisor
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).
Bond Rate Prime Interest Rate
5% 16% 12 6 98
15 4 77
===============================================
GB 513 Unit 5 Assignment
FOR MORE CLASSES VISIT
www.gb513rank.com
Question 1
Determine the error for each of the following forecasts. Compute MAD and MSE.
Period Value Forecast Error
1
2