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
icon
Related questions
Question

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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman