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?

Write a 2- to 3-paragraph analysis of your one-way ANOVA results for your research question. Do not forget to evaluate if the assumptions of the test are met. Include any post-hoc tests with an analysis of the strength of any relationship found (effect size). Also, in your analysis, display the data for the output. Based on your results, provide an explanation of what the implications of social change might be.