Regression and Corellation Questions

Remember to show how you got your results in the appropriate cells. For questions using functions, show the input range when asked.

1. Create a correlation table using Compa-ratio and the other interval level variables, except for Salary. Suggestion, place data in columns T - Y.

What range was placed in the Correlation input range box:

b. What are the statistically significant correlations related to Compa-ratio?

c. Are there any surprises - correlations you though would be significant and are not, or non significant correlations you thought would be?

d. Why does or does not this information help answer our equal pay question?

2. Perform a regression analysis using compa as the dependent variable and the variables used in Q1 along with including the dummy variables. Show the result, and interpret your findings by answering the following questions. Suggestion: Place the dummy variables values to the right of column Y.

What range was placed in the Regression input range box:

3. What does regression analysis show us about analyzing complex measures?

4. Between the lecture results and your results, what else would you like to know before answering our question on equal pay? Why?

5. Between the lecture results and your results, what is your answer to the question of equal pay for equal work for males and females? Why?

Attachment:- Assignment File.rar