Bus308 Statistics Assignment

User Generated

orgunal1973

Other

Unformatted Attachment Preview

Problem Set Week Four Let’s look at some other factors that might influence pay. Complete the problems included in the resources below and submit your work in an Excel document. Be sure to show all of your work and clearly label all calculations. All statistical calculations will use the Employee Salary Data Set and the Week 4 assignment sheet. 1. Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment. Score: Week 4 Confidence Intervals and Chi Square (Chs 11 - 12) For questions 3 and 4 below, be sure to list the null and alternate hypothesis statements. Use .05 for your s For full credit, you need to also show the statistical outcomes - either the Excel test result or the calculation Using our sample data, construct a 95% confidence interval for the population's me Interpret the results. How do they compare with the findings in the week 2 one sam Mean St error t value Low Males Females interval for the mean salary difference between the genders in the population. question 2? to High esult (2 sampe t-test)? nterval) a better choice than using 2 one-sample techniques when comparing two samples? he population do not impact compa rates. enly across the grades and genders. of degrees by grade? be large enough to perform this test, ignore this limitation for this exercise.) ions manually. grade level Total If desired, you can do manual calculations per cell here. A B C D E F M Grad Fem Grad Male Und Female Und Sum = For this exercise - ignore the requirement for a correction factor for cells with expected values less than 5. ales and females are distributed across grades in a similar pattern Do manual calculations per cell here (if desired) A B C D E F M F Sum = F See comments at the right of the data set. ID Salary Compa Midpoint Age 8 10 11 14 15 23 26 31 35 36 37 42 3 18 20 39 7 13 22 24 45 17 48 28 43 19 25 40 2 32 34 16 27 41 5 30 1 4 12 33 38 23 22 23 24 24 23 24 24 24 23 22 24 34 36 34 35 41 42 57 50 55 69 65 75 77 24 24 25 27 28 28 47 40 43 47 49 58 66 60 64 56 1.000 0.956 1.000 1.043 1.043 1.000 1.043 1.043 1.043 1.000 0.956 1.043 1.096 1.161 1.096 1.129 1.025 1.050 1.187 1.041 1.145 1.210 1.140 1.119 1.149 1.043 1.043 1.086 0.870 0.903 0.903 1.175 1.000 1.075 0.979 1.020 1.017 1.157 1.052 1.122 0.982 23 23 23 23 23 23 23 23 23 23 23 23 31 31 31 31 40 40 48 48 48 57 57 67 67 23 23 23 31 31 31 40 40 40 48 48 57 57 57 57 57 32 30 41 32 32 36 22 29 23 27 22 32 30 31 44 27 32 30 48 30 36 27 34 44 42 32 41 24 52 25 26 44 35 25 36 45 34 42 52 35 45 Performance Service Gender Raise Degree Gender1 Rating 90 9 1 5.8 0 F 80 7 1 4.7 0 F 100 19 1 4.8 0 F 90 12 1 6 0 F 80 8 1 4.9 0 F 65 6 1 3.3 1 F 95 2 1 6.2 1 F 60 4 1 3.9 0 F 90 4 1 5.3 1 F 75 3 1 4.3 1 F 95 2 1 6.2 1 F 100 8 1 5.7 0 F 75 5 1 3.6 0 F 80 11 1 5.6 1 F 70 16 1 4.8 1 F 90 6 1 5.5 1 F 100 8 1 5.7 0 F 100 2 1 4.7 1 F 65 6 1 3.8 0 F 75 9 1 3.8 1 F 95 8 1 5.2 0 F 55 3 1 3 0 F 90 11 1 5.3 1 F 95 9 1 4.4 1 F 95 20 1 5.5 1 F 85 1 0 4.6 1 M 70 4 0 4 0 M 90 2 0 6.3 0 M 80 7 0 3.9 0 M 95 4 0 5.6 0 M 80 2 0 4.9 1 M 90 4 0 5.7 0 M 80 7 0 3.9 1 M 80 5 0 4.3 0 M 90 16 0 5.7 1 M 90 18 0 4.3 0 M 85 8 0 5.7 0 M 100 16 0 5.5 1 M 95 22 0 4.5 0 M 90 9 0 5.5 1 M 95 11 0 4.5 0 M 44 46 47 49 50 6 9 21 29 60 65 62 60 66 76 77 76 72 1.052 1.140 1.087 1.052 1.157 1.134 1.149 1.134 1.074 57 57 57 57 57 67 67 67 67 45 39 37 41 38 36 49 43 52 90 75 95 95 80 70 100 95 95 16 20 5 21 12 12 10 13 5 0 0 0 0 0 0 0 0 0 5.2 3.9 5.5 6.6 4.6 4.5 4 6.3 5.4 1 1 1 0 0 1 1 1 0 M M M M M M M M M Grade A A A A A A A A A A A A B B B B C C D D D E E F F A A A B B B C C C D D E E E E E The ongoing question that the weekly assignments will focus on is: Are males and females paid the same 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 Age – Age in years Service – Years of service (rounded) Midpoint – salary grade midpoint Grade – job/pay grade Gender1 (Male or Female) Salary – Salary in thousands Performance Rating – Appraisal rating (Employee evaluat Gender: 0 = male, 1 = female Raise – percent of last raise Degree (0= BS\BA 1 = MS) Compa - salary divided by midpoint E E E E E F F F F es and females paid the same for equal work (under the Equal Pay Act)?
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.

Explanation & Answer


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4