Ashford BUS308 2020 September Week 3 Assignment Latest

BUS308 Statistics for Managers

Week 3 Assignment   

ID            Salary    Compa  Midpoint             Age        Performance Rating        Service Gender                Raise     Degree Gender1                Grade

1              60.2        1.056     57           34           85           8              0              5.7          0              M            E

2              27.7        0.893     31           52           80           7              0              3.9          0              M            B

3              35.5        1.145     31           30           75           5              1              3.6          1              F              B

4              56.1        0.985     57           42           100         16           0              5.5          1              M            E

5              48.9        1.018     48           36           90           16           0              5.7          1              M            D

6              74.1        1.106     67           36           70           12           0              4.5          1              M            F

Do not manipuilate Data set on this page, copy to another page to make changes                                                                            

The ongoing question that the weekly assignments will focus on is:  Are males and females paid the same for equal work (under the Equal Pay Act)?                                                                                                         

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                                  Salary – Salary in thousands                                                       

Age – Age in years                                           Performance Rating - Appraisal rating (employee evaluation score)                                                        

Service – Years of service (rounded)                                       Gender – 0 = male, 1 = female                                                  

Midpoint – salary grade midpoint                                             Raise – percent of last raise                                                        

Grade – job/pay grade                                  Degree (0= BS\BA 1 = MS)                                                          

Gender1 (Male or Female)                                          Compa-ratio - salary divided by midpoint             

Week 3: Identifying Significant Differences - part 2                          

To Ensure full credit for each question, you need to show how you got your results.  This involves either showing where the data you used is located                                                                                      

or showing the excel formula in each cell.                                             Be sure to copy the appropriate data columns from the data tab to the right for your use this week.                                                                 

1              A good pay program will have different average salaries by grade.  Is this the case for our company?                                                                                                                                      

                a              What is the data input ranged used for this question:                                                                     Use Cell K08 for the Excel test outcome location.                      

                Note: assume equal variances for each grade, even though this may not be accurate, for purposes of this question.                                                                                                                               

                b.    Step 1:          Ho:                                                                                                                                                                                                                                                                                                                                                                                                                        

What is your conclusion about the means in the population for grade salaries?                                                                                  

2              If the null hypothesis in question 1 was rejected, which pairs of means differ?                                                                                                                                                                  

                (Use the values from the ANOVA table to complete the follow table.)                                                                   

                                                                                                                                                                               

3              One issue in salary is the grade an employee is in - higher grades have higher salaries.                                                                                                                                                   

                This suggests that one question to ask is if males and females are distributed in a similar pattern across the salary grades?                                                                                                                               

                a              What is the data input ranged used for this question:                                                                     Use Cell K54 for the Excel test outcome location.                      

                b.    Step 1:          Ho:                                                                                                                                                                                                                                        

                                Ha:                                                                                                                                                                                        

                                                                                                                               

4              What implications do this week's analysis have for our equal pay question?                                                                                         Your findings:                                                                                                                                                                                                   

                The lecture's related findings:                                                                                                                                                                   

                Overall conclusion:                                                                                                                                                                                                          Why - what statistical results support this conclusion?