performance measurement and sample size

/in /by

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?

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.