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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman