1. Conduct a full hypothesis test (all the steps from Week 6) at the 0.05 level of significance to determine if there is evidence of a linear relationship between the years of service and performance review rating.The calculations are in the spreedsheet.

2. Use the r value to comment on the strength of the linear relationship. Does this support your hypothesis test findings?

3. Would you apply this regression line equation to an employee who had worked at the company for 45 years? Why or why not?

Employee Years at the company Performance rating (10 = high) 3 A 2 7 Employee Longevity and Performance 10 Latest Performance Review y = 0.2729x + 4.9516 R = 0.5457 2. 4 6 8 10 12 14 Years at the Company W 4SUMMARY OUTPUT Regression Statistics Multiple R 0.738747374 R Square 0.545747682 Adjusted R Square 0.52411662 Standard Error 1.128455253 Observations 23 ANOVA MS F Significance F Regression 1 32.12792878 32.12792878 25.229814 5.67799E-05 Residual 21 26.74163644 1.273411259 Total 22 58.86956522 Coefficients Standard Error t Stat P-value Lower 956 Upper 95% Lower 95.0% Upper 95.09% Intercept 4.951632406 0.419430195 11.8056174 9.835E-11 4.079379566 5.82388525 4.07937957 5.823885247 X Variable 1 0.272873841 0.054325644 5.022928794 5.678E-05 0.15989748 0.3858502 0.15989748 0.385850202