A good pay program will have different average salaries by grade
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.
1A good pay program will have different average salaries by grade. Is this the case for our company?
aWhat 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:
Ha:
Step 2:Significance (Alpha):
Step 3:Test Statistic and test:
Why this test?
Step 4:Decision rule:
Step 5:Conduct the test - place test function in cell K08
Step 6:Conclusion and Interpretation
What is the p-value:
What is your decision: REJ or NOT reject the null?
Why?
What is your conclusion about the means in the population for grade salaries?
2If 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.)
Groups ComparedMean Diff.T value used+/- TermLowto HighDifference Significant?Why?
A-B
A-C
A-D
A-E
A-F
B-C
B-D
B-E
B-E
C-D
C-E
C-F
D-E
D-F
E-F
3One 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?
aWhat is the data input ranged used for this question:
Use Cell K54 for the Excel test outcome location.
b. Step 1:Ho:
Ha:
Step 2:Significance (Alpha):
Step 3:Test Statistic and test:
Place the actual distribution in the table below.
Why this test?ABCDEF
Step 4:Decision rule:Male
Step 5:Conduct the test - place test function in cell K54Female
Step 6:Conclusion and Interpretation
Place the expected distribution in the table below.
What is the p-value:ABCDEF
What is your decision: REJ or NOT reject the null?
Male
Why?Female
What is your conclusion about the means in the population for male and female salaries?
4What implications do this week's analysis have for our equal pay question?
Why - what statistical results support this conclusion?
Hint
Businessb. Step 1:Ho: there is no significant difference in the average performance rating for all the grades Ha: the average performance rating is different for at-least one of grades Step 2: Significance (Alpha): 0.05 Step 3: Test Statistic and test: one way ANOVA, F = MSR/MSTWhy
this test? the significant difference in the average salaries between 6
types of grade namely A...
Ho: there is no significant difference in the average performance rating for all the grades
Ha: the average performance rating is different for at-least one of grades
Step 2:Significance (Alpha):0.05
Step 3:Test Statistic and test: one way ANOVA, F = MSR/MST
Why
this test? the significant difference in the average salaries between 6
types of grade namely A,B,C,D,E,F is to be tested. One way anova is
applied to test for significant difference between more than 2 groups.
Step 4:Reject Ho if p<5%
Step 6:
1.4168E-37
REJECT Ho
Since p<5%
the average performance rating for population is different for at least one of grades.