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)

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 solution written from scratch with No plagiarism and No AI?

WHY CHOOSE US?

We deliver quality original papers

Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay