The CEO at ABC Company wanted to know if there was a linear relationship between the years of service at the company and the score earned on the latest performance review.

Look at the Excel below and address the following:

1. How do you know there is not a perfect linear relationship between the variables?

2. Is there a relationship between years of service and the rating on the performance review? Using the information in the chapter, how can we determine this?

3. What is the equation of the trendline? Identify the slope and y-intercept.

4. Let's say that we were confident that the trendline was a fairly good representation of the relationship between years of service and performance rating.

According to the equation of the trendline, what performance rating would a person likely earn if they worked there for 11 years?

Q15 v X Vfx S A B C D E F G H I J K L M AWN Week 8 Employee Years at the company Performance rating (10 = high) W N 4 12 GREWNEGO 15 Employee Longevity and Performance 10 Latest Performance Review y = 0.2729x + 4.9516 R= = 0.5457 & CO CO LD W 29 0 2 6 8 10 12 14 16 30 Years at the Company 31 32 33