Employee Performance Measurement Analysis

/in /by

Employee Performance Measurement Analysis

To do a correlation in excel, use the formula =correl(array1, array2). An array is simply the rows you will include. So, for the first question the formula will be =correl(F100:F110,M100,M110).

1. What is the correlation between Distance from Home and Performance Rating for the employees 100-110 inclusive (i.e. with ID numbers 100 through 110)?

Please round to 2 decimal points (e.g. .25)

2. What is the correlation between Distance from Home and Performance Rating for the employees 300-310 inclusive (i.e. with ID numbers 300 through 310)?

Please round to 2 decimal points (e.g. .25)

3. What is the correlation between Distance from Home and Performance Rating for the employees 400-410 inclusive (i.e. with ID numbers 400 through 410)?

Please round to 2 decimal points (e.g. .25)

4. What is the correlation between Distance from Home and Performance Rating for the employees 500-510 inclusive (i.e. with ID numbers 500 through 510)?

Please round to 2 decimal points (e.g. .25)

5. What is the correlation between Distance from Home and Performance Rating for the employees 900-910 inclusive (i.e. with ID numbers 900 through 910)?

Please round to 2 decimal points (e.g. .25)

6. What is the correlation between Distance from Home and Performance Rating for the entire sample set?

Please round to 2 decimal points (e.g. .25)

7. What can you conclude about the data if you only take samples of 10 people at a time?