Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transportation A Global Supply Chain Perspective

Authors: John J. Coyle, Robert A. Novak, Brian Gibson, Edward J. Bard

8th edition

9781305445352, 1133592961, 130544535X, 978-1133592969

More Books

Students also viewed these Mathematics questions