# Bus 308

User Generated

pnyvebpxfzr

Other

### Description

I need statistics help. The class is BUS 308: Statistics for Managers... I need help with the week 5 assignment. I have it in an excel spreadsheet with the data tables. Here are the questions:

1. Create a correlation table for the variables in our  equal_pay___student_rev_4_3__1_-2.xlsx. (Use analysis ToolPak or the StatPlus:mac LE software function Correlation.)
1. Interpret the results. What variables seem to be important in seeing if we pay males and females equally for equal work?
2. Below is a regression analysis for salary being predicted/explained by the other variables in our sample  (Mid, age, ees, sr, raise, and deg variables.)
Note: since salary and compa are different ways of expressing an employee’s salary, we do not want to have both used in the same regression.
3. Perform a regression analysis using compa as the dependent variable and the same independent variables as used in question 2.  Show the result, and interpret your findings by answering the same questions.
Note: be sure to include the appropriate hypothesis statements.
4. Based on all of your results to date, is gender a factor in the pay practices of this company?  Why or why not? Which is the best variable to use in analyzing pay practices - salary or compa? Why?
5. Why did the single factor tests and analysis (such as t and single factor ANOVA tests on salary equality) not provide a complete answer to our salary equality question? What outcomes in your life or work might benefit from a multiple regression examination rather than a simpler one variable test?

### Unformatted Attachment Preview

ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Sal 58 27 34 66 47 76 41 23 77 22 23 60 42 24 24 47 69 36 24 34 76 57 23 50 24 24 40 75 72 49 24 28 64 28 24 23 22 56 35 25 43 Compa 1.017 0.870 1.096 1.157 0.979 1.134 1.025 1.000 1.149 0.956 1.000 1.052 1.050 1.043 1.043 1.175 1.210 1.161 1.043 1.096 1.134 1.187 1.000 1.041 1.043 1.043 1.000 1.119 1.074 1.020 1.043 0.903 1.122 0.903 1.043 1.000 0.956 0.982 1.129 1.086 1.075 Mid 57 31 31 57 48 67 40 23 67 23 23 57 40 23 23 40 57 31 23 31 67 48 23 48 23 23 40 67 67 48 23 31 57 31 23 23 23 57 31 23 40 Age 34 52 30 42 36 36 32 32 49 30 41 52 30 32 32 44 27 31 32 44 43 48 36 30 41 22 35 44 52 45 29 25 35 26 23 27 22 45 27 24 25 EES 85 80 75 100 90 70 100 90 100 80 100 95 100 90 80 90 55 80 85 70 95 65 65 75 70 95 80 95 95 90 60 95 90 80 90 75 95 95 90 90 80 SER 8 7 5 16 16 12 8 9 10 7 19 22 2 12 8 4 3 11 1 16 13 6 6 9 4 2 7 9 5 18 4 4 9 2 4 3 2 11 6 2 5 G 0 0 1 0 0 0 1 1 0 1 1 0 1 1 1 0 1 1 0 1 0 1 1 1 0 1 0 1 0 0 1 0 0 0 1 1 1 0 1 0 0 Raise 5.7 3.9 3.6 5.5 5.7 4.5 5.7 5.8 4 4.7 4.8 4.5 4.7 6 4.9 5.7 3 5.6 4.6 4.8 6.3 3.8 3.3 3.8 4 6.2 3.9 4.4 5.4 4.3 3.9 5.6 5.5 4.9 5.3 4.3 6.2 4.5 5.5 6.3 4.3 Deg 0 0 1 1 1 1 1 1 1 1 1 0 0 1 1 0 1 0 1 0 1 1 0 0 0 0 1 0 0 0 1 0 1 1 0 0 0 0 0 0 0 Gen1 M M F M M M F F M F F M F F F M F F M F M F F F M F M F M M F M M M F F F M F M M Gr E B B E D F C A F A A E C A A C E B A B F D A D A A C F F D A B E B A A A E B A C 42 43 44 45 46 47 48 49 50 24 77 60 55 65 62 65 60 66 1.043 1.149 1.052 1.145 1.140 1.087 1.140 1.052 1.157 23 67 57 48 57 57 57 57 57 32 42 45 36 39 37 34 41 38 100 95 90 95 75 95 90 95 80 8 20 16 8 20 5 11 21 12 1 1 0 1 0 0 1 0 0 5.7 5.5 5.2 5.2 3.9 5.5 5.3 6.6 4.6 1 0 1 1 1 1 1 0 0 F F M F M M F M M A F E D E E E E E The ongoing question that the weekly assignments will focus on is: Are males and females paid the same for equa Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work. The column labels in the table mean: ID – Employee sample number Sal – Salary in thousands Age – Age in years EES – Appraisal rating (Employee evaluation score) SER – Years of service G – Gender (0 = male, 1 = female) Mid – salary grade midpoint Raise – percent of last raise Grade – job/pay grade Deg (0= BS\BA 1 = MS) Gen1 (Male or Female) Compa - salary divided by midpoint, a measure of salary that removes th This data should be treated as a sample of employees taken from a company that has about 1,000 employees using a random sampling approach. Mac Users: The homework in this course assumes students have Windows Excel, and can load the Analysis ToolPak into their version of Excel. The analysis tool pak has been removed from Excel for Windows, but a free third-party tool that can be used (found on an answers Microsoft site) is: http://www.analystsoft.com/en/products/statplusmacle Like the Microsoft site, I make cannot guarantee the program, but do know that Statplus is a respected statistical package. You may use other approaches or tools as desired to complete the assignments. nd females paid the same for equal work (under the Equal Pay Act)? Week 1. Describing the data.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.