Nov 23, 2024
HEP 456 Module 6 Section 14 Communication and Dissemination of The Findings Arizona State University
HEP 456 Module 6 Section 14 Communication and Dissemination of The Findings HEP 456: Health Promotion Program ā¦
Week 3: Identifying Significant Differences - part 2
To Ensure full credit for each question, you need to show how you got your results. This invo or showing the excel formula in each cell. Be sure to copy t
1 A good pay program will have different average salaries by grade. Is this the case
a What is the data input ranged used for this question: Columns AD
Note: assume equal variances for each grade, even though this may not be accurate, for p
b. Step 1: Ho:All salary means are the same.
Ha:At less one salary mean is different
Step 2:Significance (Alpha): 0.05
Step 3:Test Statistic and test: Anova single factor
Why this test?comparing multible means
Step 4: Decision rule: p<0.05
Step 5:Conduct the test - place test function in cell K08
Step 6:Conclusion and Interpretation
What is the p-value: 0
What is your decision: REJ or NOT reject the null?reject
Why?At less one or more is differ
What is your conclusion about the means in the population for grade salaries?Signifily different between g
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.)
Groups
Compared Mean Diff. T value used +/- Term
A-B 7.74 2.015 2.13
A-C 17.85 2.015 2.41
A-D 26.41 2.015 2.41
A-E 37.68 2.015 1.81
A-F 51.5 2.015 2.25
B-C 10.11 2.015 2.73
B-D 18.67 2.015 2.73
B-E 29.94 2.015 2.22
B-E 43.76 2.015 2.59
C-D 8.56 2.015 2.95
C-E 19.83 2.015 2.48
C-F 33.65 2.015 2.82
D-E 11.27 2.015 2.48
D-F 25.09 2.015 2.82
E-F 13.83 2.015 2.33
3 One issue in salary is the grade an employee is in - higher grades have higher salar
This suggests that one question to ask is if males and females are distributed in a si a What is the data input ranged used for this question:
b. Step 1: Ho:males and females are distributed evenly
Ha:Males and females are not distributed eve
Step 2:Significance (Alpha): 0.05
Step 3:Test Statistic and test: Chisq.test Why this test?
Step 4: Decision rule: p<0.05
Step 5:Conduct the test - place test function in cell K54
Step 6:Conclusion and Interpretation
What is the p-value:0.04
What is your decision: REJ or NOT reject the null?reject
Why? p<alpha
What is your conclusion about the means in the population for male and female salaries?Males and females are not d
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?
olves either showing where the data you used is located
the appropriate data columns from the data tab to the right for your use this week.
for our company? Yes
D & AE, and data input table in Column U Use Cell K08 for the Excel test outcome loc purposes of this question. Anova: Single Factor
SUMMARY
Groups Count Sum Average
A 15 354.5 23.63
B 7 219.6 31.37
C 5 207.4 41.48
D 5 250.2 50.04
E 12 735.7 61.31
F 6 450.8 75.13
rent ANOVA
grades Between G 16956.57 5 3391.31
Within Grou 235.75 44 5.36
Total 17192.32 49
Difference
Low to High Significant? Why?
5.6 9.87 yes Interval does not contain zero
15.44 20.26 yes Interval does not contain zero
24 28.82 yes Interval does not contain zero 35.87 39.48 yes Interval does not contain zero 49.25 53.75 yes Interval does not contain zero
7.38 12.84 yes Interval does not contain zero 15.94 21.4 yes Interval does not contain zero 27.72 32.16 yes Interval does not contain zero 41.17 46.36 yes Interval does not contain zero
5.61 11.51 yes Interval does not contain zero 17.35 22.31 yes Interval does not contain zero
30.83 36.48 yes Interval does not contain zero
8.79 13.75 yes Interval does not contain zero 22.27 27.92 yes Interval does not contain zero
11.49 16.16 yes Interval does not contain zero
ries. imilar pattern across the salary grades?
Columns AG & AH Use Cell K54 for the Excel test outcome loc #NAME? across the grade. enly across the grade.
Place the actual distribution in the table be
A B C
3 3 3
12 4 2
Male
Female
Sum: 15 7 5
Place the expected distribution in the table
A B C
7.5 3.5 2.5
7.5 3.5 2.5
Male
Female
Sum: 15 7 5 distributed evenly across the grade.
After breaking down the data into the tables and running the different test we can see that there are a lot this still does not answer the question of equal pay for equal work. We need to look into a Male and Fem that females are significaly underpaid compared to their male counter parts.
cation.
elow.
D E F Sum
2 10 4
3 2 2
5 12 6
e below.
D E F
2.5 6 3
2.5 6 3
25
25
50
25
25
5 12 6 50
more females in the lower salary grades than males. But I feel male doing the same job. But the data does show for this company
Salary Range Groups Salary Grade
B C D E F
23.6 A
28 41.6 48.7 58 75.4 22.5 A
33.8 41.4 51.4 64.8 73.8 24.1 A
34.9 44.7 48.6 58.3 73.5 23.2 A
33.4 39.2 48.6 63.8 75.8 22.5 A
27.5 40.5 52.9 58 76.3 24.9 A
27 60.8 76 25.1 A
35 63.1 24.4 A
59.1 24.3 A
62.6 23.4 A
67.4 23 A
58.4 23 A
61.4 23.6 A
24.3 A
22.6 A
28 B
33.8 B
34.9 B
33.4 B
27.5 B
27 B
35 B
41.6 C
41.4 C
44.7 C
39.2 C
40.5 C
48.7 D
51.4 D
48.6 D
48.6 D
52.9 D
58 E
64.8 E
58.3 E
63.8 E
58 E
60.8 E
63.1 E
59.1 E
62.6 E
67.4 E
58.4 E
61.4 E
75.4 F
73.8 F
73.5 F
75.8 F
76.3 F
76 F
Gender1 Grade
F A
F A
F A
F A
F A
F A
F A
F A
F A
F A
F A
F A
M A
M A
M A
F B
F B
F B
F B
M B
M B
M B
F C
F C
M C
M C
M C
F D
F D
F D
M D
M D
F E
F E
M E
M E
M E
M E
M E
M E
M E
M E
M E
M E
F F
F F
M F
M F
M F
M F
Week 3: Identifying Significant Differences - part 2
To Ensure full credit for each question, you need to show how you got your results. This invo or showing the excel formula in each cell. Be sure to copy t
1 A good pay program will have different average salaries by grade. Is this the case
a What is the data input ranged used for this question: Columns AD
Note: assume equal variances for each grade, even though this may not be accurate, for p
b. Step 1: Ho:All salary means are the same.
Ha:At less one salary mean is different
Step 2:Significance (Alpha): 0.05
Step 3:Test Statistic and test: Anova single factor
Why this test?comparing multible means
Step 4: Decision rule: p<0.05
Step 5:Conduct the test - place test function in cell K08
Step 6:Conclusion and Interpretation
What is the p-value: 0
What is your decision: REJ or NOT reject the null?reject
Why?At less one or more is differ
What is your conclusion about the means in the population for grade salaries?Signifily different between g
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.)
Groups
Compared Mean Diff. T value used +/- Term
A-B 7.74 2.015 2.13
A-C 17.85 2.015 2.41
A-D 26.41 2.015 2.41
A-E 37.68 2.015 1.81
A-F 51.5 2.015 2.25
B-C 10.11 2.015 2.73
B-D 18.67 2.015 2.73
B-E 29.94 2.015 2.22
B-E 43.76 2.015 2.59
C-D 8.56 2.015 2.95
C-E 19.83 2.015 2.48
C-F 33.65 2.015 2.82
D-E 11.27 2.015 2.48
D-F 25.09 2.015 2.82
E-F 13.83 2.015 2.33
3 One issue in salary is the grade an employee is in - higher grades have higher salar
This suggests that one question to ask is if males and females are distributed in a si a What is the data input ranged used for this question:
b. Step 1: Ho:males and females are distributed evenly
Ha:Males and females are not distributed eve
Step 2:Significance (Alpha): 0.05
Step 3:Test Statistic and test: Chisq.test Why this test?
Step 4: Decision rule: p<0.05
Step 5:Conduct the test - place test function in cell K54
Step 6:Conclusion and Interpretation
What is the p-value:0.04
What is your decision: REJ or NOT reject the null?reject
Why? p<alpha
What is your conclusion about the means in the population for male and female salaries?Males and females are not d
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?
olves either showing where the data you used is located
the appropriate data columns from the data tab to the right for your use this week.
for our company? Yes
D & AE, and data input table in Column U Use Cell K08 for the Excel test outcome loc purposes of this question. Anova: Single Factor
SUMMARY
Groups Count Sum Average
A 15 354.5 23.63
B 7 219.6 31.37
C 5 207.4 41.48
D 5 250.2 50.04
E 12 735.7 61.31
F 6 450.8 75.13
rent ANOVA
grades Between G 16956.57 5 3391.31
Within Grou 235.75 44 5.36
Total 17192.32 49
Difference
Low to High Significant? Why?
5.6 9.87 yes Interval does not contain zero
15.44 20.26 yes Interval does not contain zero
24 28.82 yes Interval does not contain zero 35.87 39.48 yes Interval does not contain zero 49.25 53.75 yes Interval does not contain zero
7.38 12.84 yes Interval does not contain zero 15.94 21.4 yes Interval does not contain zero 27.72 32.16 yes Interval does not contain zero 41.17 46.36 yes Interval does not contain zero
5.61 11.51 yes Interval does not contain zero 17.35 22.31 yes Interval does not contain zero
30.83 36.48 yes Interval does not contain zero
8.79 13.75 yes Interval does not contain zero 22.27 27.92 yes Interval does not contain zero
11.49 16.16 yes Interval does not contain zero
ries. imilar pattern across the salary grades?
Columns AG & AH Use Cell K54 for the Excel test outcome loc #NAME? across the grade. enly across the grade.
Place the actual distribution in the table be
A B C
3 3 3
12 4 2
Male
Female
Sum: 15 7 5
Place the expected distribution in the table
A B C
7.5 3.5 2.5
7.5 3.5 2.5
Male
Female
Sum: 15 7 5 distributed evenly across the grade.
After breaking down the data into the tables and running the different test we can see that there are a lot this still does not answer the question of equal pay for equal work. We need to look into a Male and Fem that females are significaly underpaid compared to their male counter parts.
cation.
elow.
D E F Sum
2 10 4
3 2 2
5 12 6
e below.
D E F
2.5 6 3
2.5 6 3
25
25
50
25
25
5 12 6 50
more females in the lower salary grades than males. But I feel male doing the same job. But the data does show for this company
Salary Range Groups Salary Grade
B C D E F
23.6 A
28 41.6 48.7 58 75.4 22.5 A
33.8 41.4 51.4 64.8 73.8 24.1 A
34.9 44.7 48.6 58.3 73.5 23.2 A
33.4 39.2 48.6 63.8 75.8 22.5 A
27.5 40.5 52.9 58 76.3 24.9 A
27 60.8 76 25.1 A
35 63.1 24.4 A
59.1 24.3 A
62.6 23.4 A
67.4 23 A
58.4 23 A
61.4 23.6 A
24.3 A
22.6 A
28 B
33.8 B
34.9 B
33.4 B
27.5 B
27 B
35 B
41.6 C
41.4 C
44.7 C
39.2 C
40.5 C
48.7 D
51.4 D
48.6 D
48.6 D
52.9 D
58 E
64.8 E
58.3 E
63.8 E
58 E
60.8 E
63.1 E
59.1 E
62.6 E
67.4 E
58.4 E
61.4 E
75.4 F
73.8 F
73.5 F
75.8 F
76.3 F
76 F
Gender1 Grade
F A
F A
F A
F A
F A
F A
F A
F A
F A
F A
F A
F A
M A
M A
M A
F B
F B
F B
F B
M B
M B
M B
F C
F C
M C
M C
M C
F D
F D
F D
M D
M D
F E
F E
M E
M E
M E
M E
M E
M E
M E
M E
M E
M E
F F
F F
M F
M F
M F
M F
