Gender analysis: Is there a statistically significant difference between the genders? Use Excel’s t-test function to test for differences in each of the 9 variables. This will be a two-tailed hypothesis test: Ho: Wf - Wm = 0; Ha: Wf – Wm ≠ 0. In case you’ve forgotten how to use the Excel function, there’s an illustration below. Discuss your results. Work, pay, supervision, co-workers, opportunites are independent variables. Engagement, commitment, overall are dependent. DATA: Gender Age Education Level Work Pay Supervisor Coworker Opportunity Engagement Commitment Overall M 30 B N 2.5 3.75 2.5 2.25 3 3.75 2.5 6 F 28 A H 2.25 3 3 4 2.25 2.25 2.25 4 M 40 B MM 4.25 3.75 3.5 3.25 3 4.25 4 8 F 41 G LM 4.75 4 3.75 3.25 3 5 4 9 M 45 B EM 4 3.5 4.75 4.5 3.5 4.25 3.5 8 F 36 B N 3.25 3.5 2 2.75 3 2.75 1.75 4 F 34 B MM 3.75 4 3.5 3.25 3.75 4 3.5 7 M 24 H H 2.5 4 3.5 4 3 2.5 2.75 6 M 27 H H 2.5 2.75 2.25 4 3.25 2.75 3 6 M 55 G MM 4.75 4.5 4.75 4 3.5 5 4.75 8 F 28 A H 2.25 3 3 4 2.25 2.25 2.25 4 M 43 B LM 4.25 3.75 3.5 3.25 3 4.25 4 8 F 41 G MM 4.75 4 3.75 3.25 3 5 4 8 F 45 B EM 4 3.5 4.75 4.5 3.5 4.25 3.5 8 M 30 B N 2.5 3.75 2.5 2.25 3 3.75 2.5 6 M 28 A H 2.25 3 3 4 2.25 2.25 2.25 4 M 37 B MM 4.25 3.75 3.5 3.25 3 4.25 4 7 M 41 G MM 4.75 4 3.75 3.25 3 5 4 9 F 61 B EM 4 3.5 4.75 4.5 3.5 4.25 3.5 8 F 36 B N 3.25 3.5 2 2.75 3 2.75 1.75 4 M 34 B LM 3.75 4 3.5 3.25 3.75 4 3.5 7 M 25 H H 2.5 4 3.5 4 3 2.5 2.75 8 M 32 H H 2.5 2.75 2.25 4 3.25 2.75 3 6 M 55 G MM 4.75 4.5 4.75 4 3.5 5 4.75 8
Gender analysis: Is there a statistically significant difference between the genders? Use Excel’s t-test function to test for differences in each of the 9 variables. This will be a two-tailed hypothesis test: Ho: Wf - Wm = 0; Ha: Wf – Wm ≠ 0. In case you’ve forgotten how to use the Excel function, there’s an illustration below. Discuss your results. Work, pay, supervision, co-workers, opportunites are independent variables. Engagement, commitment, overall are dependent. DATA: Gender Age Education Level Work Pay Supervisor Coworker Opportunity Engagement Commitment Overall M 30 B N 2.5 3.75 2.5 2.25 3 3.75 2.5 6 F 28 A H 2.25 3 3 4 2.25 2.25 2.25 4 M 40 B MM 4.25 3.75 3.5 3.25 3 4.25 4 8 F 41 G LM 4.75 4 3.75 3.25 3 5 4 9 M 45 B EM 4 3.5 4.75 4.5 3.5 4.25 3.5 8 F 36 B N 3.25 3.5 2 2.75 3 2.75 1.75 4 F 34 B MM 3.75 4 3.5 3.25 3.75 4 3.5 7 M 24 H H 2.5 4 3.5 4 3 2.5 2.75 6 M 27 H H 2.5 2.75 2.25 4 3.25 2.75 3 6 M 55 G MM 4.75 4.5 4.75 4 3.5 5 4.75 8 F 28 A H 2.25 3 3 4 2.25 2.25 2.25 4 M 43 B LM 4.25 3.75 3.5 3.25 3 4.25 4 8 F 41 G MM 4.75 4 3.75 3.25 3 5 4 8 F 45 B EM 4 3.5 4.75 4.5 3.5 4.25 3.5 8 M 30 B N 2.5 3.75 2.5 2.25 3 3.75 2.5 6 M 28 A H 2.25 3 3 4 2.25 2.25 2.25 4 M 37 B MM 4.25 3.75 3.5 3.25 3 4.25 4 7 M 41 G MM 4.75 4 3.75 3.25 3 5 4 9 F 61 B EM 4 3.5 4.75 4.5 3.5 4.25 3.5 8 F 36 B N 3.25 3.5 2 2.75 3 2.75 1.75 4 M 34 B LM 3.75 4 3.5 3.25 3.75 4 3.5 7 M 25 H H 2.5 4 3.5 4 3 2.5 2.75 8 M 32 H H 2.5 2.75 2.25 4 3.25 2.75 3 6 M 55 G MM 4.75 4.5 4.75 4 3.5 5 4.75 8
College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter8: Sequences, Series, And Probability
Section8.7: Probability
Problem 57E: What is an experiment? Give two examples.
Related questions
Question
Gender analysis: Is there a statistically significant difference between the genders? Use Excel’s t-test
Work, pay, supervision, co-workers, opportunites are independent variables. Engagement, commitment, overall are dependent.
DATA:
| Gender | Age | Education | Level | Work | Pay | Supervisor | Coworker | Opportunity | Engagement | Commitment | Overall |
| M | 30 | B | N | 2.5 | 3.75 | 2.5 | 2.25 | 3 | 3.75 | 2.5 | 6 |
| F | 28 | A | H | 2.25 | 3 | 3 | 4 | 2.25 | 2.25 | 2.25 | 4 |
| M | 40 | B | MM | 4.25 | 3.75 | 3.5 | 3.25 | 3 | 4.25 | 4 | 8 |
| F | 41 | G | LM | 4.75 | 4 | 3.75 | 3.25 | 3 | 5 | 4 | 9 |
| M | 45 | B | EM | 4 | 3.5 | 4.75 | 4.5 | 3.5 | 4.25 | 3.5 | 8 |
| F | 36 | B | N | 3.25 | 3.5 | 2 | 2.75 | 3 | 2.75 | 1.75 | 4 |
| F | 34 | B | MM | 3.75 | 4 | 3.5 | 3.25 | 3.75 | 4 | 3.5 | 7 |
| M | 24 | H | H | 2.5 | 4 | 3.5 | 4 | 3 | 2.5 | 2.75 | 6 |
| M | 27 | H | H | 2.5 | 2.75 | 2.25 | 4 | 3.25 | 2.75 | 3 | 6 |
| M | 55 | G | MM | 4.75 | 4.5 | 4.75 | 4 | 3.5 | 5 | 4.75 | 8 |
| F | 28 | A | H | 2.25 | 3 | 3 | 4 | 2.25 | 2.25 | 2.25 | 4 |
| M | 43 | B | LM | 4.25 | 3.75 | 3.5 | 3.25 | 3 | 4.25 | 4 | 8 |
| F | 41 | G | MM | 4.75 | 4 | 3.75 | 3.25 | 3 | 5 | 4 | 8 |
| F | 45 | B | EM | 4 | 3.5 | 4.75 | 4.5 | 3.5 | 4.25 | 3.5 | 8 |
| M | 30 | B | N | 2.5 | 3.75 | 2.5 | 2.25 | 3 | 3.75 | 2.5 | 6 |
| M | 28 | A | H | 2.25 | 3 | 3 | 4 | 2.25 | 2.25 | 2.25 | 4 |
| M | 37 | B | MM | 4.25 | 3.75 | 3.5 | 3.25 | 3 | 4.25 | 4 | 7 |
| M | 41 | G | MM | 4.75 | 4 | 3.75 | 3.25 | 3 | 5 | 4 | 9 |
| F | 61 | B | EM | 4 | 3.5 | 4.75 | 4.5 | 3.5 | 4.25 | 3.5 | 8 |
| F | 36 | B | N | 3.25 | 3.5 | 2 | 2.75 | 3 | 2.75 | 1.75 | 4 |
| M | 34 | B | LM | 3.75 | 4 | 3.5 | 3.25 | 3.75 | 4 | 3.5 | 7 |
| M | 25 | H | H | 2.5 | 4 | 3.5 | 4 | 3 | 2.5 | 2.75 | 8 |
| M | 32 | H | H | 2.5 | 2.75 | 2.25 | 4 | 3.25 | 2.75 | 3 | 6 |
| M | 55 | G | MM | 4.75 | 4.5 | 4.75 | 4 | 3.5 | 5 | 4.75 | 8 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Recommended textbooks for you
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning