Question
Description : A downloadable spreadsheet named CV of r was provided in the assessment instructions for you to use for this question. In some workplaces,
Description: A downloadable spreadsheet namedCV of rwas 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 linearcorrelation coefficientr, and thep-valueand thecritical valueof r using alpha = 0.05. Determine whether there is sufficient evidence to support the claim oflinear correlationbetween age and salary.
*I have most of the problem completed but need help with thecritical value, please.
** I find it odd every time this question is asked, there is a different answer.
- please show your work
Here is what I have so far.
Correlation coefficient r= 0.518
p-value = 0.0001
critical value = ???
There is a correlation; it's just a weak positive correlation.
The Excel document link is below
https://docs.google.com/spreadsheets/d/1fnTXuxlz7oc4M-MLwTtOYECTAN1F-FrC/edit?usp=share_link&ouid=110977271033317131640&rtpof=true&sd=true