Question: Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 0

Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 0 = No).

Worker Earnings Industry Occupation Ed Female Experience Married Age Union
1 19388 1 0 6 0 45 1 57 0
2 49898 2 0 12 0 33 1 51 1
3 28219 0 3 12 0 12 1 30 0
4 83601 0 5 17 0 18 1 41 0
5 29736 0 4 8 0 47 1 61 1
6 50235 1 0 16 0 12 1 34 0
7 45976 0 2 12 0 43 1 61 1
8 33411 1 2 12 0 20 1 38 0
9 21716 0 5 12 1 11 0 29 0
10 37664 0 5 18 0 19 1 43 0
11 26820 0 5 18 0 33 0 57 1
12 29977 0 4 16 1 6 1 28 0
13 33959 0 5 17 1 26 1 49 1
14 11780 0 2 11 1 33 1 50 0
15 10997 0 4 14 0 0 0 20 0
16 17626 0 3 12 1 45 1 63 0
17 22133 0 5 16 1 10 0 32 1
18 21994 0 1 12 1 24 1 42 0
19 29390 0 0 13 0 18 1 37 0
20 32138 0 4 14 0 22 1 42 1
21 30006 1 3 16 1 27 1 49 0
22 68573 0 5 16 0 14 1 36 1
23 17694 0 4 8 1 38 1 52 0
24 26795 0 0 7 0 44 1 57 0
25 19981 0 4 4 0 54 1 64 0
26 14476 0 5 12 1 3 1 21 0
27 19452 0 4 13 0 3 0 22 0
28 28168 1 0 13 0 17 0 36 0
29 19306 0 5 9 1 34 1 49 1
30 13318 1 0 11 1 25 1 42 1
31 25166 0 4 12 1 10 0 28 0
32 18121 1 3 12 1 18 1 36 0
33 13162 1 0 12 0 6 0 24 1
34 32094 0 3 12 1 14 1 32 0
35 16667 0 3 12 0 4 0 22 0
36 50171 0 5 12 0 39 1 57 1
37 31691 1 0 12 0 13 0 31 0
38 36178 0 3 12 1 40 1 58 0
39 15234 0 1 12 1 4 0 22 0
40 16817 0 3 12 1 26 0 44 0
41 22485 0 3 12 0 22 0 40 0
42 30308 0 4 12 0 10 1 28 0
43 11702 0 2 14 1 6 1 26 0
44 11186 0 0 12 0 0 0 18 0
45 12285 0 1 12 1 42 1 60 0
46 19284 1 4 16 0 3 0 25 0
47 11451 1 0 12 1 8 1 26 0
48 57623 0 1 15 0 31 1 52 0
49 25670 0 3 13 1 8 0 27 1
50 83443 0 5 17 1 5 0 28 0
51 49974 1 1 16 0 26 1 48 1
52 46646 2 0 5 0 44 1 55 0
53 31702 0 3 12 1 39 1 57 0
54 13312 0 4 12 1 9 1 27 0
55 44543 0 2 18 0 10 1 34 0
56 15013 0 4 16 0 21 1 43 0
57 33389 0 1 14 0 22 0 42 0
58 60626 0 5 18 0 7 1 31 0
59 24509 0 5 14 1 15 0 35 0
60 20852 1 0 12 1 38 1 56 0
61 30133 2 0 10 0 27 1 43 0
62 31799 0 3 12 1 25 0 43 0
63 16796 0 4 12 1 14 1 32 0
64 20793 0 0 12 1 6 0 24 0
65 29407 0 4 10 0 19 0 35 0
66 29191 0 0 12 0 9 0 27 0
67 15957 0 2 12 1 10 0 28 0
68 34484 0 3 13 1 28 0 47 0
69 35185 1 3 14 1 12 1 32 0
70 26614 1 0 12 1 19 1 37 0
71 41780 0 0 12 0 9 1 27 0
72 55777 0 1 14 0 21 1 41 0
73 15160 0 4 8 1 45 0 59 0
74 66738 0 0 9 0 29 1 44 0
75 33351 0 5 16 1 4 1 26 0
76 33498 0 1 10 0 20 1 36 0
77 29809 0 4 8 1 29 0 43 0
78 15193 1 0 12 1 15 0 33 0
79 23027 0 4 14 0 34 1 54 1
80 75165 0 1 15 0 12 1 33 0
81 18752 0 4 11 1 45 0 62 1
82 83569 0 1 18 0 29 1 53 0
83 32235 0 3 12 1 38 1 56 0
84 20852 0 0 12 0 1 0 19 0
85 13787 0 4 11 0 4 1 21 0
86 34746 0 3 14 1 15 1 35 0
87 17690 0 1 12 0 14 1 32 0
88 52762 0 5 18 0 7 1 31 0
89 60152 0 5 16 0 38 1 60 0
90 33461 0 1 16 0 7 1 29 1
91 13481 0 4 12 0 7 0 25 0
92 9879 0 3 12 1 28 1 46 0
93 16789 0 3 13 1 6 1 25 0
94 31304 0 1 16 1 26 1 48 0
95 37771 0 5 15 0 5 0 26 0
96 50187 0 3 12 1 24 1 42 0
97 39888 0 3 12 0 5 0 23 0
98 19227 0 3 12 1 15 1 33 0
99 32786 1 0 11 0 37 1 54 1
100 28440 0 4 12 1 24 1 42 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

4) 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...

Q:

Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 0 = No).

Q:

Use Excel to construct a two-way pivot table showing the number of workers for each combination of Occupation and Female (1 = Yes and 0 = No).

Q:

Hi Please help me solve this simple excel take home test. I will give positive feedback for your help thansk! Below is simple question and the data for the company R3000. DATA: ID Ticker ID Ticker ID...

Q:

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

Q:

Hello, Any help on the assignment below will be appreciated. Question 1: SAMPLING (Part A) Suppose you wish to evaluate the prices ( rent asked, per week ) of 1to3bedroom rental properties. Your...

Q:

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

Q:

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

Q:

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 7th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, seventh edition, 2012. Prepared by John Kammeyer-Mueller...

Q:

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

Q:

You are the lead manager of a large mutual fund. You have become aware that several equity analysts who have recently joined your management team are interested in understanding the differences...

Q:

1. What factors determine the balance between centralization and decentralization, and between standardization and mutual adjustment? Why do you think this is so? 2. Assume that you are the CAO, CEO...

Q:

Unit costs of the weight average and FIFO methods will differ significantly when direct materials or conversion cost per unit vary greatly and physical inventory levels of work in process are large...

Q:

is this right? 4) Listen A product has three components. The first two are independent and have reliability of 0.81 and 0.90. The third component is prone to failure. As a result, it has two...

Q:

Engage everyone in the dialogue

Q:

1. Given your basic mental state, i.e. the state you often return to. Give this state a name that you recognize and that is easy to remember, such as irritability, frustration, joy, etc. Also give...

Q:

5. The next time a negative event occurs, or a negative memory occurs, think about how you need to perform to make this a success story.