performance management
otokola 
AnalyticsExercise11.pptxIn a blank cell, enter the equal symbol (=) followed by the CORREL function, followed by a beginning parenthesis.
Enter the range of cell values that corresponds to the array of numeric values that fall below the Job Satisfaction variable name, which in this case is B2:B51
Enter a comma (,)
Enter the range of cell values that corresponds to the array of numeric values that fall below the Customer Satisfactin Rating variable name, which in this case is C2:C52. Enter an ending parenthesis, and click ENTER.
Remember, correlation coefficients can range from -1.00 to 1.00, where -1.00 indicates a perfect negative (inverse) linear association, 1.00 indicates a perfect positive linear association, and .00 indicates no association.
In this case the correlation coefficient is 0.48
Regarding the sign, the correlation coefficient is a medium, positive, association. In other words, there is a correlation between job satisfaction and customer satisfaction.
< .10 (negligible)
.10 - .29 (small)
.30 - .49 (medium)
.50 - 1.00 (large)
| Employee ID | Years of experience | Customer Satisfaction |
| 1 | 3.00 | 3.91 |
| 2 | 3.33 | 5.43 |
| 3 | 2.67 | 3.98 |
| 4 | 2.67 | 5.23 |
| 5 | 3.33 | 4.57 |
| 6 | 3.67 | 4.62 |
| 7 | 3.00 | 4.07 |
| 8 | 2.00 | 2.69 |
| 9 | 3.67 | 7.00 |
| 10 | 3.67 | 3.49 |
| 11 | 4.00 | 5.96 |
| 12 | 3.00 | 3.84 |
| 13 | 3.67 | 6.83 |
| 14 | 3.00 | 2.58 |
| 15 | 4.67 | 5.50 |
| 16 | 2.00 | 6.12 |
| 17 | 4.67 | 7.00 |
| 18 | 4.67 | 6.42 |
| 19 | 3.33 | 4.53 |
| 20 | 3.33 | 3.17 |
| 21 | 3.33 | 4.48 |
| 22 | 3.33 | 5.72 |
| 23 | 3.67 | 6.11 |
| 24 | 3.67 | 6.11 |
| 25 | 4.33 | 4.26 |
Now you try it!
Put these numbers into an Excel spreadsheet, calculate the correlation (if any) and explain what the results mean.
