Week 4: Identifying relationships - correlations and regressionTo Ensure full credit for each question, you need to show how you got your results. This involves either showing whor showing the excel formula in each cell.Be sure to copy the appropriate data columns from the data t1What is the correlation between and among the interval/ratio level variables with salary? (Do not include ca. Create the correlation table.i.What is the data input ranged used for this question: A1:G51ii. Create a correlation table in cell K08.b. Technically, we should perform a hypothesis testing on each correlation to determineif it is significant or not. However, we can be faithful to the process and save sometime 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 apositive or negative direction) can be considered statistically significant.i. What is the t-value 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?compa ratio,age,performance,servicd. Are there any surprises - correlations you though would be significant and are not, or non significant core. Why does or does not this information help answer our equal pay question?2Perform a regression analysis using salary as the dependent variable and the variables used in Q1 ...
To Order an Original Plagiarism Free Paper on the Same Topic Click Here
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.