Description: A downloadable spreadsheet named CV of r was provided in the assessment instructions for you to use for this question. In some workplaces, the longer someone has been working within an organization, the better the pay is. Although seniority provides a way to reward long-serving employees, critics argue that it hinders recruitment. Jane, the CPO, wants to know if XYZ has a seniority pay system.

Question: Based on the salary and age data in the spreadsheet, find the value of the linear correlation coefficient r, and the p-value and the critical value of r using alpha = 0.05. Determine whether there is sufficient evidence to support the claim of linear correlation between age and salary.

link

/Users/grisel/Downloads/HR_Sample_Data.xlsx