performance measurement and sample size asking to take 6 separate correlations then answer a question about what you find

/in /by

Questions:

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)

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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?

Guidelines: Please the data provided. 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).

The analysis contain a correlation formula that includes the header row of the data. Header/text rows are never part of the math. Please adjust the formula accordingly.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"