5) A Human Resources manager is studying the earnings of workers. The manager takes a sample of 100 workers and records there earnings along with descriptive variables: Industry (1 = Manufacturing, 2 = Construction, 0 = other), Occupation (1 = Management, 2 = Sales, 3 = Clerical, 4 = Service, 5 = Profession, 0 = other), Education (in years), Female (1 = Yes, 0 = No), Experience (work experience in years), Married (1 = Yes, 0 = No), Age (in years), Union (1 = Yes, 0 = No). The data appears in the Earnings worksheet in Chp 12 HW Problems data workbook on Moodle. a) State the hypothesis to determine if the proportion of female workers depends on occupation. b) Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 2 = No). c) Test the hypothesis using a = 0.05. d) What is the p-value for the hypothesis test. e) Use the multiple comparison procedure with a = 0.05 to determine which occupations have a different proportion of female workers than occupation 0. Specifically, make 5 comparisons: 0 to 1, 0 to 2, 0 to 3, 0 to 4, and 0 to 5.
5) A Human Resources manager is studying the earnings of workers. The manager takes a sample of 100 workers and records there earnings along with descriptive variables: Industry (1 = Manufacturing, 2 = Construction, 0 = other), Occupation (1 = Management, 2 = Sales, 3 = Clerical, 4 = Service, 5 = Profession, 0 = other), Education (in years), Female (1 = Yes, 0 = No), Experience (work experience in years), Married (1 = Yes, 0 = No), Age (in years), Union (1 = Yes, 0 = No). The data appears in the Earnings worksheet in Chp 12 HW Problems data workbook on Moodle. a) State the hypothesis to determine if the proportion of female workers depends on occupation. b) Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 2 = No). c) Test the hypothesis using a = 0.05. d) What is the p-value for the hypothesis test. e) Use the multiple comparison procedure with a = 0.05 to determine which occupations have a different proportion of female workers than occupation 0. Specifically, make 5 comparisons: 0 to 1, 0 to 2, 0 to 3, 0 to 4, and 0 to 5.
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
5) A Human Resources manager is studying the earnings of workers. The manager takes a sample of 100 workers and records there earnings along with descriptive variables: Industry (1 = Manufacturing, 2 = Construction, 0 = other), Occupation (1 = Management, 2 = Sales, 3 = Clerical, 4 = Service, 5 = Profession, 0 = other), Education (in years), Female (1 = Yes, 0 = No), Experience (work experience in years), Married (1 = Yes, 0 = No), Age (in years), Union (1 = Yes, 0 = No). The data appears in the Earnings worksheet in Chp 12 HW Problems data workbook on Moodle. a) State the hypothesis to determine if the proportion of female workers depends on occupation. b) Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 2 = No). c) Test the hypothesis using a = 0.05. d) What is the p-value for the hypothesis test. e) Use the multiple comparison procedure with a = 0.05 to determine which occupations have a different proportion of female workers than occupation 0. Specifically, make 5 comparisons: 0 to 1, 0 to 2, 0 to 3, 0 to 4, and 0 to 5.
Transcribed Image Text:1 Worker Earnings Industry Occupatio Ed
2
1
3
2
4
3
4
5
5
6
7
8
9
8
10
9
11
10
12 11
13 12
14 13
15 14
16
15
17 16
18 17
19 18
20 19
21 20
22
21
23
24
6
7
25
26
25
27
26
28 27
29 28
30 29
31 30
32 31
33 32
34 33
35
36
37
38
39
40
41
42
22
23
24
34
35
36
37
38
39
40
41
42
43
44
46
45
47
46
48 47
49 48
43
44
45
52
53
50 49
51 50
<
51
52
Ready
19388
49898
28219
83601
29736
50235
45976
33411
21716
37664
26820
29977
33959
11780
10997
17626
22133
21994
29390
32138
30006
68573
17694
26795
19981
14476
19452
28168
19306
13318
25166
18121
13162
32094
16667
50171
31691
36178
15234
16817
22485
30308
11702
11186
12285
19284
11451
57623
25670
83443
49974
46646
1
2
0
36°F
Cloudy
0
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
0
1
0
1
1
0
0
0
1
0
0
0
0
0
0
0
0
1
1
0
0
0
1
2
Cosmo
Accessibility: Good to go
0
0
3
5
4
0
2
2
5
5
5
4
5
2
4
3
5
1
0
4
3
5
4
0
4
5
4
0
5
0
4
3
0
3
3
5
0
3
1
3
3
4
2
0
1
4
0
1
3
5
1
0
6
12
12
17
8
16
12
12
12
18
18
16
17
11
14
12
16
12
13
14
16
16
8
7
4
12
13
13
9
11
12
12
12
12
12
12
12
12
12
12
12
12
14
12
12
16
12
15
13
17
16
5
Lottery
Female Experience Married Age
1
0
0
0
0
0
0
0
0
0
0
1
1
0
1
1
1
0
0
1
0
1
0
0
0
1
1
0
1
0
0
0
1
1
1
0
0
1
0
0
0
1
1
0
0
Cola
45
33
12
18
47
12
43
20
11
19
33
6
26
33
0
45
10
24
18
22
27
14
38
44
54
3
3
17
34
25
10
18
6
14
4
39
13
40
4
26
22
10
6
0
42
3
8
31
8
5
26
44
Noodles
1
1
1
1
1
1
0
0
1
1
1
0
1
0
1
1
1
1
1
1
1
1
0
0
1
1
0
0
1
0
1
0
1
0
0
0
1
0
0
1
1
0
0
57
51
30
41
61
34
61
38
29
43
57
28
49
50
20
1
1
63
32
42
37
42
49
36
52
57
64
21
22
36
18
60
25
26
52
27
28
48
55
Earnings
49
42
28
36
24
32
22
57
31
58
22
44
40
28
26
Union
H
0
1
0
0
1
0
1
0
0
0
1
0
1
0
0
0
1
0
0
1
0
1
0
0
0
0
0
0
1
1
0
0
1
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
+
Q Search
4
■
⠀
O
ENG
+ 70%
2:33 PM
2/11/2024
Transcribed Image Text:49
50
51
52
53 52
54 53
55 54
56 55
57 56
58 57
59 58
60 59
61
60
62
61
63 62
64 63
65 64
66
65
67
66
68
67
68
A
48
49
50
51
69
70 69
71
70
72 71
73 72
74 73
75 74
76 75
77 76
78 77
79 78
80
79
81
80
82
81
83
84
85
86
87
88
97
98
99
82
83
84
85
86
87
88
89
90
89
90
91
92 91
93 92
94 93
95 94
96
95
96
97
98
100 99
101 100
<
Ready
B
57623
25670
83443
49974
46646
31702
13312
44543
15013
33389
60626
24509
20852
30133
31799
16796
20793
29407
29191
15957
34484
35185
26614
41780
55777
15160
66738
33351
33498
29809
15193
23027
75165
18752
83569
32235
20852
13787
34746
17690
52762
60152
33461
13481
9879
16789
31304
37771
50187
39888
19227
32786
28440
с
36°F
Cloudy
0
0
0
1
2
0
0
0
0
0
0
0
1
2
0
0
0
0
0
0
0
1
1
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
D
0
Cosmo
Accessibility: Good to go
T
3
5
0
3
4
2
4
1
5
5
0
0
3
4
0
4
0
2
3
3
0
0
1
4
0
5
1
4
0
4
1
4
1
3
0
4
3
5
5
1
4
3
3
1
5
3
3
3
0
4
E
Lottery
15
13
17
16
5
12
12
18
16
14
18
14
12
10
12
12
12
10
12
12
13
14
12
12
14
8
9
16
10
8
12
14
15
11
18
12
12
11
14
12
18
16
16
12
12
13
16
15
12
12
12
11
12
F
U
1
1
0
0
1
1
0
0
0
0
1
1
0
1
1
1
0
0
1
1
1
1
0
0
1
0
1
0
1
1
0
0
1
0
1
0
0
1
0
0
0
0
0
1
1
1
0
1
0
1
0
1
Cola
G
31
8
5
26
44
39
9
10
21
22
7
15
38
27
25
14
6
19
9
10
28
12
19
9
21
45
29
4
20
29
15
34
12
45
29
38
1
4
15
14
7
38
7
7
28
6
26
5
24
5
15
37
24
Noodles
H
T
0
0
1
1
1
1
1
1
0
1
0
1
1
0
1
0
0
0
0
0
1
1
1
1
0
1
1
1
0
0
1
1
0
1
1
0
1
1
1
1
1
1
0
1
1
1
0
1
0
1
1
1
I
52
27
28
48
55
57
27
34
43
42
31
35
56
43
43
32
24
35
27
28
47
32
37
27
41
59
44
26
36
43
33
54
33
62
53
56
19
21
35
32
31
60
29
25
46
25
48
26
42
23
33
54
42
Earnings
J
U
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
1
0
K
+
Q Search
M
N
O
P
■
Q
R
S
T
A
U
V
W
X
Y
Z
AA
>
AB
AC
ENG
AD
AE
AF
2:34 PM
2/11/2024
AG
70%
►
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step 1: Write the given information.
VIEWStep 2: State the hypothesis to determine if the proportion of female workers depends on occupation.
VIEWStep 3: Construct two-way pivot table for number of workers for each combination of Occupation and female.
VIEWStep 4: Perform the hypothesis test at significance level of 0.05.
VIEWStep 5: Determine the P-value of hypothesis test.
VIEWStep 6: Perform hypothesis test to compare the proportions of different occupations(0 to 1 and 0 to 2).
VIEWStep 7: Perform hypothesis test to compare the proportions of different occupations(0 to 3 and 0 to 4).
VIEWStep 8: Perform hypothesis test to compare the proportions of different occupations(0 to 5).
VIEWSolution
VIEW
Step by step
Solved in 9 steps with 7 images
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