Question: What is the correlation between and among the interval/ratio level variables withsalary? (D a. Create the correlation table. i. What is the data input ranged

What is the correlation between and among the interval/ratio level variables withsalary? (D a. Create the correlation table. i. What is the data input ranged used for this question: ii. Create a correlation table in cell K08. b. Technically, we should perform a hypothesis testing on each correlation to determine if it is significant or not. However, we can be faithful to the process and save some time by finding the minimum correlation that would result in a two tail rejection of the null. We can then compare each correlation to this value, and those exceeding it (in either a positive or negative direction) can be considered statistically significant. i. What is the tValue we would use to cut off the two tails? T = ii. What is the associated correlation value related to this t-Value? r = c. What variable(s) is(are) significantly correlated to salary? d. Are there any surprises - correlations you though would be significant and are not, or non e. Why does or does not this information help answer our equal pay
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
