Problem Set Week Four\u00a0\tThis week we get to answer our equal pay for equal work question by looking at relationships between and among the different variables.\tThe first question this week looks at correlations and the creation of a correlation table for our variables.\u00a0 The second question asks for a regression equation showing how the different variables impact the compa-ratio measure. The third questions asks you to discuss the benefits of using a regression equation approach over the single variable tests we have been doing.\tThe forth question asks for what other information you would have liked to have analyzed in our research. The fifth question asks for your answer to the equal pay for equal work question of: Is the company paying fairly or not?\u00a0 If not, who benefits and why?\tRegression and Corellation\tRemember to show how you got your results in the appropriate cells.\u00a0 For questions using functions, show the input range when asked.\t1. Create a correlation table using Compa-ratio and the other interval level variables, except for Salary.\tSuggestion, place data in columns T – Y\ta What range was placed in the Correlation input range box: Place C9 in output box.\tb What are the statistically significant correlations related to Compa-ratio? T = Significant r =\tc Are there any surprises – correlations you though would be significant and are not, or non significant correlations you thought would be?\td Why does or does not this information help answer our equal pay question?\t2 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: Note: be sure to include the appropriate hypothesis statements.\tRegression hypotheses\tHo:\tHa:\tCoefficient hyhpotheses (one to stand for all the separate variables)\tHo:\tHa:\tPlace B36 in output box.\tInterpretation: For the Regression as a whole:\tWhat is the value of the F statistic:\tWhat is the p-value associated with this value:\tIs the p-value < 0.05?\tWhat is your decision:\tREJ or NOT reject the null?\tWhat does this decision mean?\tFor each of the coefficients: Midpoint Age Perf. Rat. Service Gender Degree\tWhat is the coefficient's p-value for each of the variables: Is the p-value < 0.05?\tDo you reject or not reject each null hypothesis:\tWhat are the coefficients for the significant variables?\tUsing the intercept coefficient and only the significant variables, what is the equation?\tCompa-ratio =\tIs gender a significant factor in compa-ratio?\tRegardless of statistical significance, who gets paid more with all other things being equal?\tHow do we know?\t3 What does regression analysis show us about analyzing complex measures?\t4 Between the lecture results and your results, what else would you like to know before answering our question on equal pay? Why?\t5 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?\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Problem Set Week Four\u00a0 This week we get to answer our equal pay for equal work question by looking at relationships between and among the different variables. The first question this week looks at correlations and the creation of a Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-204476","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/204476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=204476"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/204476\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=204476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=204476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=204476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}