JAIPURIA INSTITUTE OF MANAGEMENT, NOIDA

GRADUATE DIPLOMA IN MANAGEMENT

Name
Roll No

FIRST TRIMESTER (Batch 2019-2021)

MAKE-UP ASSIGNMENT SECTION A

Course Data Analysis Using Spreadsheets

Name (DAUS)
Max.
40 less 8 = 32
Marks

Instructions:
1. All questions are compulsory
2. All answers and explanations must be written in the sheets given
3. The final date and time of submission is Saturday, Sep 7, 11.30 PM. There will be no extension beyond this.
4. The data must include the number part of your roll no, e.g. PGDA1901 will use 1901, as specified in each sheet
each sheet
First Name Last Name DOB Age (in years) Segment
Alka Jain 9/23/1978
Animesh Bezbaruah 2/14/1967
Abhimanyu Sahai 6/6/1990
Bhuvanesh Jangid 5/30/1983
Katrina Sangal 12/23/1998
Sandeep Banerjee 7/24/1973
Kamardeep Aulakh 6/12/1952
Jayesh Patel 8/22/1958
Heramb Rai 10/23/1996
Eswaran Narasimhan 5/22/1959

Question: Compute the age in years using the current date in column D
Using VLOOKUP, label each person as New Voter, Young Voter, Mature Voter, and Senior Citizen

Please enter the appropriate formulae in each cell with a yellow background in columns D and E
 Age Label
18 New Voter
25 Young Voter
35 Mature Voter
60 Senior Citizen

ung Voter, Mature Voter, and Senior Citizen

a yellow background in columns D and E

 Last two digits
Order no. Date Driver's name Item of numeric
part of roll no
100001 2/1/2013 John May TV
100002 2/1/2013 Peter White washing machine
100003 2/2/2013 Carl Nowak washing machine
100004 2/3/2013 Peter White TV
100005 2/3/2013 George Ramsay refrigerator
100006 2/3/2013 Carl Nowak washing machine
100007 2/3/2013 John May refrigerator
100008 2/4/2013 Carl Nowak refrigerator
100009 2/4/2013 Peter White TV
100010 2/4/2013 George Ramsay refrigerator
100011 2/4/2013 Mertl Pavel microwave
100012 2/4/2013 John May washing machine
100013 2/5/2013 John May washing machine
100014 2/5/2013 Carl Nowak TV
100015 2/5/2013 George Ramsay microwave
100016 2/5/2013 Peter White TV
100017 2/6/2013 John May microwave
100018 2/7/2013 John May TV
100019 2/8/2013 George Ramsay washing machine
100020 2/8/2013 Peter White refrigerator
100021 2/8/2013 Carl Nowak microwave
100022 2/8/2013 Peter White washing machine
100023 2/8/2013 John May microwave
100024 2/9/2013 George Ramsay washing machine

Question a. Enter the last two digits of the numeric part of your roll no, e.g. 01 for 1901 and so on in column D. Add
b. Please enter the result below, using COUNTIF, SUMIF, COUNTIFS, SUMIFS, etcetera, in the cells with a

number of orders in Boston :

number of microwave orders :
number of journeys with truck 3:
number of Peter White journeys:
how many times are no. of items less than

sum of refrigerator items:

sum of washing machine items:
sum of items transported by truck 4:
sum of items transported by trucks:

number of microvawe orders in Boston

 Raw number of Total number
Transport Destination
items of items (E + F)

25 truck 4 Boston
30 truck 3 NY
15 truck 3 Philadelphia
32 truck 4 NY
25 truck 3 Boston
18 truck 1 Baltimore
15 truck 2 Philadelphia
25 truck 3 Baltimore
30 truck 1 Pittsburgh
15 truck 2 NY
25 truck 3 Philadelphia
14 truck 4 NY
25 airplane Baltimore
30 truck 4 Philadelphia
15 truck 3 Boston
15 truck 1 Pittsburgh
25 truck 1 NY
30 truck 4 Philadelphia
13 truck 3 Baltimore
25 truck 2 Philadelphia
30 truck 1 Pittsburgh
15 airplane NY
25 truck 4 Boston
34 truck 3 Baltimore

01 for 1901 and so on in column D. Add the value in D to raw number of items in F and fill the cells in column G
S, SUMIFS, etcetera, in the cells with a yellow-background

result

number of orders in Boston :

number of microwave orders :
number of journeys with truck 3:
number of Peter White journeys:
w many times are no. of items less than 20:

sum of refrigerator items:

sum of washing machine items:
sum of items transported by truck 4:
sum of items transported by trucks:

number of microvawe orders in Boston :

mber of Peter White journeys with truck 1:
umber of orders in Boston after 2/3/2013:
er of orders between 2/3/2013 and 2/6/2013:

sum of microwaves transported to NY:

of items transported to Pittsburgh by truck 1:
tems ordered between 2/3/2013 and 2/6/2013:

ms transported to NY, Baltimore and Philadelphia:

Footballer Salary p.m. Goals
Wayne Rooney £85,000 28
Robin van Persie £87,500 14
Lionel Messi £92,300 38
Cristiano Ronaldo £98,600 35
Fernando Torres £74,500 17
Gareth Bale £38,000 13
David Silva £46,400 15
Frank Lampard £64,500 24
Carlos Tevez £78,300 22
Didier Drogba £66,350 25

Question

If the number of
goals is greater
than or equal to 10,
then the bonus
is 10% of their
salary;

Rules

If the number of
goals is greater
than or equal to 20,
then the bonus
is 20% of their
salary;

If the number of
goals is greater
than 30, then the
bonus awarded is
50%.
 Penalty Cards Bonus Deduction
2
1
2
6
1
1
1
2
9
2

If the number of
penalty cards is
greater than 0 and
less than or equal to
5, then 2% of the
salary is deducted

If the player has

received more than
5 penalty cards but
less than or equal to
10, then a flat 25%
of the salary is
deducted

If the player has

received more than
10 penalty cards,
then a flat 50% of
the salary is
deducted
 Roll No Impact Final Salary

Create a
nested =IF formula in
cell E2 to compute the
bonus plus penalty plus
roll no impact and the
final salary

Sum the first two digits and

the last two digits of your roll
number. If the sum is less than
50, then roll no impact is 0; if
the sum is between 50 and 99,
the roll no impact is a bonus of
1%, and if the sum is above
100, then the roll no impact is
a deduction of 1%

Example: Consider 1901. Sum

is 19+01 = 20; hence impact is
0
If roll no is 1940, then sum is
19+40 = 59, hence roll no
impact is +1%
If roll no is 1987, then sum is
19+87 = 106, hence roll no
impact is -1%
 Data
Sample data of full-time workers in five North-Central States in USA, in 1999
Variables
Usual Usual
Hours Education Yearly Weekly
Worked (yrs) Earnings Race Gender Earnings State
40 13 $ 44,000 White Male $ 858 Ohio
35 12 $ 12,000 White Female . Ohio
70 11 $ 54,000 White Male . Ohio
40 16 $ 48,200 White Male . Ohio
38 12 $ 24,000 White Male . Ohio
60 18 $ 62,000 White Female . Ohio
40 13 $ 17,000 White Female . Ohio
50 8 $ 25,000 Black Male . Ohio
40 11 $ 10,000 Black Male . Ohio
50 16 $ 65,000 White Male . Ohio
45 12 $ 30,000 White Male . Ohio
50 16 $ 306,731 White Male . Ohio
50 11 $ 37,000 White Male $ 643 Ohio
40 12 $ 34,000 White Male $ 600 Ohio
40 13 $ 25,000 White Male $ 520 Ohio
40 12 $ 42,000 White Male $ 680 Ohio
40 16 $ 68,000 White Male . Ohio
50 13 $ 70,000 White Male . Ohio
40 12 $ 25,000 White Female . Ohio
35 13 $ 15,400 White Female . Ohio
40 13 $ 56,426 White Male . Ohio
40 12 $ 21,087 White Male . Ohio
40 13 $ 50,000 White Male . Ohio
49 12 $ 11,500 Black Female $ 173 Ohio
60 12 $ 40,000 White Male . Ohio
60 18 $ 70,000 White Female . Ohio
45 18 $ 62,000 White Male . Ohio
40 12 $ 30,000 White Male . Ohio
40 16 $ 20,000 Black Female . Ohio
72 12 $ 17,360 White Female $ 224 Ohio
50 12 $ 32,000 White Male . Ohio
60 16 $ 60,000 White Male . Ohio
40 11 $ 9,500 White Female . Ohio
40 11 $ 9,000 White Male . Ohio
40 12 $ - White Male . Ohio
60 11.5 $ 38,000 White Male . Ohio
52 11 $ 45,000 White Female . Ohio
45 12 $ 16,000 White Male . Ohio
40 12 $ 30,000 White Male . Ohio
40 18 $ 29,530 White Female . Ohio
38 12 $ 8,274 White Male . Ohio
40 12 $ 11,200 White Female . Ohio
45 12 $ 21,000 White Male . Ohio
45 12 $ 24,500 White Male . Ohio
40 16 $ 30,000 White Female . Ohio
40 12 $ 30,000 White Female $ 522 Ohio
40 16 $ 36,400 White Male $ 765 Ohio
50 16 $ 29,000 White Female $ 635 Ohio
45 13 $ 18,000 White Female . Ohio
40 12 $ 65,000 White Male . Ohio
40 12 $ 15,000 White Female . Ohio
40 12 $ 30,000 White Male . Ohio
40 13 $ 72,000 White Male . Ohio
40 12 $ 42,000 White Female . Ohio
40 16 $ 144,499 White Male . Ohio
40 13 $ 30,000 White Male $ 480 Ohio
40 12 $ 35,000 White Male $ 1,280 Ohio
35 10 $ 35,000 White Male . Ohio
40 12 $ 11,000 White Male . Ohio
35 11 $ 8,000 White Female . Ohio
40 16 $ 25,000 White Male $ 625 Ohio
40 16 $ 12,340 White Female $ 237 Ohio
48 12 $ 29,484 White Female . Ohio
40 12 $ 13,000 White Male . Ohio
40 12 $ 13,650 White Female . Ohio
40 14 $ 28,000 White Male . Ohio
40 12 $ 50,000 White Male . Ohio
40 12 $ 43,000 White Male . Ohio
40 13 $ 59,314 White Male . Ohio
40 16 $ - White Male . Ohio
40 13 $ - White Female . Ohio
45 13 $ 32,000 White Male . Ohio
40 13 $ 24,000 White Male . Ohio
35 13 $ 11,000 White Female . Ohio
58 12 $ 26,471 White Male . Ohio
40 13 $ 23,933 White Female . Ohio
40 14 $ 20,800 White Female $ 380 Ohio
40 18 $ 306,731 White Male . Ohio
40 18 $ 30,000 White Female $ 577 Ohio
40 12 $ 46,000 White Male . Ohio
70 18 $ 306,731 White Male . Ohio
40 12 $ 57,000 White Male . Ohio
50 11 $ - White Male . Ohio
0 12 $ 47,800 White Male . Ohio
40 13 $ 16,281 White Female . Ohio
40 12 $ 20,000 White Male . Ohio
60 18 $ - White Male . Ohio
50 10 $ 45,000 White Male . Ohio
60 13 $ 43,000 White Male $ 930 Ohio
40 13 $ 19,000 White Female $ 300 Ohio
40 12 $ 31,434 White Female $ 470 Ohio
40 16 $ 38,000 White Female . Ohio
50 14 $ 41,000 White Male . Ohio
40 13 $ 26,000 White Female . Ohio
40 14 $ 20,000 White Female . Ohio
50 12 $ 46,000 White Male . Ohio
40 12 $ 30,500 Black Male . Ohio
40 12 $ 34,000 Black Female . Ohio
35 13 $ 12,000 White Female . Ohio
50 12 $ 50,000 White Male $ 962 Ohio
40 12 $ 23,000 White Female $ 442 Ohio
45 13 $ 22,000 Black Male . Ohio
40 11 $ 24,000 White Male . Ohio
45 12 $ 23,000 White Female . Ohio
45 12 $ 23,000 White Male . Ohio
55 18 $ 24,000 Black Male . Ohio
47 18 $ 55,000 White Female . Ohio
40 13 $ 17,000 White Female . Ohio
40 13 $ 52,000 White Female . Ohio
45 13 $ 50,000 White Male . Ohio
40 12 $ 45,000 White Male . Ohio
36 18 $ 57,000 White Male . Ohio
60 13 $ - White Male . Ohio
40 16 $ 26,700 White Female $ 560 Ohio
60 12 $ 21,500 White Male . Ohio
45 11 $ 38,600 White Male . Ohio
40 18 $ 27,000 White Female $ 519 Ohio
0 13 $ 46,000 White Female . Ohio
35 13 $ - White Female . Ohio
43 18 $ 28,000 White Male $ 538 Ohio
40 16 $ - White Male . Ohio
40 12 $ 36,000 White Female . Ohio
38 12 $ 16,475 White Female . Ohio
35 12 $ 12,200 Black Female $ 263 Ohio
40 12 $ 7,800 White Female . Ohio
40 14 $ 19,000 White Male . Ohio
45 12 $ 40,000 White Male . Ohio
50 12 $ - White Female . Ohio
40 12 $ 4,753 White Male . Ohio
50 16 $ 60,000 White Female . Ohio
36 13 $ 25,236 White Female $ 468 Ohio
40 12 $ 60,000 White Male . Ohio
40 12 $ 35,000 White Female . Ohio
40 16 $ 30,000 White Male . Ohio
50 12 $ 42,000 White Male . Ohio
48 12 $ 36,000 White Female . Ohio
80 12 $ 29,000 White Male . Ohio
40 12 $ 26,000 White Female . Ohio
50 12 $ 70,000 White Male . Ohio
40 11 $ 15,000 White Female . Ohio
50 16 $ 60,000 White Male . Ohio
40 13 $ 50,000 White Male . Ohio
40 11 $ 20,000 White Male . Ohio
40 13 $ 10,452 White Female . Ohio
0 13 $ 80,000 White Male . Ohio
40 12 $ 15,000 White Male $ 516 Ohio
40 12 $ 16,112 White Female $ 325 Ohio
40 18 $ 52,000 White Female . Ohio
45 16 $ 35,000 White Male . Ohio
50 16 $ 28,000 White Female . Ohio
40 18 $ 50,000 White Male . Ohio
45 18 $ 29,190 White Male . Ohio
44 12 $ 38,000 White Female $ 577 Ohio
50 13 $ 10,000 White Female $ 150 Ohio
45 12 $ 25,500 White Female $ 510 Ohio
40 12 $ 23,000 White Female $ 356 Ohio
50 12 $ 50,000 White Male . Ohio
0 13 $ - White Male . Ohio
35 12 $ - White Female . Ohio
40 16 $ 25,000 White Female . Ohio
40 12 $ 24,000 White Male . Ohio
40 12 $ 12,000 White Male . Ohio
40 12 $ 27,949 White Female . Ohio
40 16 $ 40,000 White Male . Ohio
35 14 $ 34,000 White Female . Ohio
40 12 $ 17,000 White Female . Ohio
60 13 $ - White Male . Ohio
60 12 $ 13,920 White Male $ 240 Ohio
40 12 $ 10,280 White Female $ 290 Ohio
45 12 $ 60,000 White Female . Ohio
40 13 $ 50,000 White Male . Ohio
40 12 $ 15,000 AsianPI Female . Ohio
40 16 $ 31,000 White Female . Ohio
40 16 $ 19,200 White Male . Ohio
40 16 $ 30,000 White Female . Ohio
65 18 $ 65,000 White Male . Ohio
35 12 $ 52,000 White Male . Ohio
40 12 $ 41,600 White Male . Ohio
40 13 $ 30,000 White Female $ 300 Ohio
60 16 $ 25,000 White Male . Ohio
40 16 $ 25,000 White Female . Ohio
40 16 $ 23,000 White Male . Ohio
35 16 $ 25,500 White Female . Ohio
50 12 $ 31,000 White Male . Ohio
40 13 $ 24,000 Black Female . Ohio
40 12 $ 50,000 Black Male . Ohio
40 16 $ 36,000 White Female . Ohio
40 13 $ 28,000 White Female . Ohio
40 12 $ 36,000 White Female . Ohio
40 13 $ 50,000 White Male . Ohio
48 13 $ 12,000 White Male . Ohio
40 18 $ 83,500 Black Female . Ohio
40 18 $ 30,000 White Male . Ohio
40 18 $ 31,000 AsianPI Female . Ohio
0 12 $ 28,800 White Male $ 283 Ohio
50 16 $ 57,000 White Male . Ohio
45 16 $ 28,000 White Female . Ohio
40 12 $ 19,000 White Female . Ohio
40 16 $ 100,406 White Male $ 1,538 Ohio
40 13 $ 42,000 White Female $ 461 Ohio
40 12 $ 27,000 White Male $ 1,923 Ohio
40 11 $ 10,920 White Female . Ohio
40 12 $ 20,000 White Male . Ohio
40 12 $ 20,000 White Female . Ohio
70 16 $ 306,731 White Male . Ohio
50 16 $ 19,400 White Female . Ohio
55 16 $ 65,000 White Male . Ohio
45 13 $ 50,000 White Female . Ohio
40 18 $ 37,000 White Female . Ohio
40 12 $ 58,000 White Male $ 505 Ohio
40 12 $ 58,000 White Female $ 200 Ohio
36 12 $ - White Male . Ohio
40 12 $ 27,500 White Male . Ohio
40 13 $ 10,000 White Male . Ohio
60 18 $ 69,000 White Male . Ohio
52 12 $ 18,720 Black Male . Ohio
40 16 $ 6,400 White Male . Ohio
40 12 $ 44,196 White Male . Ohio
40 12 $ 12,000 White Female . Ohio
36 12 $ 6,000 White Male . Ohio
60 16 $ 60,000 White Male . Ohio
40 14 $ 30,000 White Female . Ohio
40 13 $ 60,000 White Male . Ohio
59 16 $ 105,001 White Male . Ohio
40 13 $ 20,722 White Female . Ohio
55 16 $ 82,198 White Male . Ohio
50 13 $ 40,000 White Female $ 769 Ohio
40 12 $ 24,568 White Female $ 900 Ohio
40 13 $ - White Male $ 360 Ohio
53 12 $ 18,000 White Female . Ohio
40 12 $ 73,771 White Male $ 750 Ohio
60 16 $ 30,000 White Male . Ohio
35 13 $ 16,400 White Female . Ohio
50 16 $ - Black Female . Ohio
40 12 $ 53,900 Black Male . Ohio
40 12 $ 40,000 White Male . Ohio
40 12 $ 22,000 White Female . Ohio
40 16 $ 20,000 White Male . Ohio
46 16 $ 20,000 White Female . Ohio
50 12 $ 97,000 White Male $ 1,827 Ohio
50 14 $ 26,000 White Female $ 500 Ohio
60 18 $ 44,000 White Female . Ohio
48 13 $ 60,000 White Male . Ohio
40 13 $ 25,000 White Female . Ohio
40 12 $ 25,000 White Female $ 480 Ohio
45 18 $ 53,000 White Female $ 1,041 Ohio
40 13 $ 61,000 White Female . Ohio
45 18 $ 83,000 White Male . Ohio
44 13 $ 12,000 White Female . Ohio
43 13 $ 22,000 White Male . Ohio
40 18 $ 81,000 White Male . Ohio
0 16 $ 56,000 White Male . Ohio
40 16 $ 30,000 AsianPI Male . Ohio
40 16 $ 30,000 AsianPI Female . Ohio
40 16 $ 36,000 AsianPI Male . Ohio
35 8 $ 13,000 White Female . Ohio
40 10 $ 28,000 White Male . Ohio
40 8 $ 19,000 White Female . Ohio
40 16 $ 5,000 White Female $ 280 Ohio
40 18 $ 49,000 White Male $ 942 Ohio
40 16 $ 35,300 White Male $ 1,370 Ohio
40 12 $ 15,000 White Female $ 300 Ohio
40 10 $ 12,999 White Male . Ohio
42 18 $ 36,000 Black Female . Ohio
40 12 $ 30,000 White Male . Ohio
50 12 $ 49,800 White Male . Ohio
40 12 $ 26,700 White Female . Ohio
40 12 $ 14,560 White Male $ 280 Ohio
40 12 $ 40,000 White Male $ 865 Ohio
38 13 $ 33,000 White Female $ 802 Ohio
0 13 $ 29,000 White Female $ 380 Ohio
35 16 $ 25,000 White Male . Ohio
55 16 $ 45,000 White Male . Ohio
55 13 $ 29,000 White Female . Ohio
45 12 $ 30,701 White Male $ 1,559 Ohio
35 12 $ - White Female . Ohio
40 14 $ 30,000 White Female . Ohio
40 12 $ 8,000 White Female $ 350 Ohio
40 13 $ 14,750 White Male . Ohio
40 12 $ 20,840 White Female . Ohio
40 12 $ 53,000 White Male . Ohio
40 13 $ 30,493 White Female . Ohio
50 12 $ 7,000 White Female . Ohio
50 12 $ 24,000 White Male . Ohio
40 12 $ 27,949 White Female . Ohio
40 12 $ 84,000 White Male . Ohio
90 13 $ 34,700 White Male $ 653 Ohio
60 18 $ 83,000 White Male . Ohio
60 18 $ 38,000 White Male . Ohio
45 18 $ 58,000 White Female . Ohio
37 14 $ 47,000 White Male $ 904 Ohio
55 9 $ 45,000 White Male . Ohio
50 18 $ 45,600 White Female . Ohio
45 16 $ 64,000 White Male . Ohio
80 16 $ 8,000 White Female . Ohio
50 16 $ 48,000 White Male . Ohio
75 13 $ 84,925 White Male . Ohio
40 12 $ 15,000 Black Male $ 880 Ohio
40 12 $ 34,000 Black Female $ 423 Ohio
40 12 $ 11,520 White Female $ 480 Ohio
40 13 $ 30,748 White Male . Ohio
0 13 $ 29,690 White Female . Ohio
40 18 $ 70,000 White Male . Ohio
60 16 $ 48,000 White Female $ 962 Ohio
0 12 $ 33,000 Black Male . Ohio
0 13 $ 40,000 Black Female . Ohio
40 16 $ 55,000 White Male . Ohio
40 18 $ 60,000 White Female . Ohio
40 11 $ 26,000 White Female . Ohio
62 16 $ 20,000 Black Female . Ohio
40 16 $ 40,000 White Male . Ohio
45 16 $ 28,000 White Male . Ohio
40 12 $ 2,000 White Female . Ohio
40 12 $ 25,000 White Male . Ohio
45 12 $ 41,000 White Male . Ohio
42 18 $ 49,580 White Female . Ohio
40 12 $ 27,000 White Male $ 480 Ohio
40 10 $ 20,000 White Female $ 300 Ohio
64 12 $ 35,000 White Female $ 699 Ohio
40 8 $ 5,000 White Male $ 324 Ohio
0 12 $ 51,000 White Male . Ohio
0 12 $ 27,000 White Female . Ohio
45 13 $ 49,000 White Male . Ohio
40 12 $ 20,000 White Female . Ohio
40 18 $ 55,000 White Male . Ohio
40 16 $ 30,000 White Female . Ohio
40 16 $ 28,000 White Female $ 480 Ohio
45 16 $ 60,000 White Female . Ohio
40 16 $ 50,000 White Male . Ohio
52 12 $ 13,000 Black Male . Ohio
40 11 $ 18,000 White Female $ 320 Ohio
53 14 $ 59,000 White Male . Ohio
60 16 $ 75,000 White Male $ 1,346 Ohio
45 18 $ 48,802 White Female $ 939 Ohio
50 18 $ 43,000 White Male . Ohio
50 16 $ 26,500 White Female . Ohio
40 16 $ 25,000 Black Male . Ohio
40 16 $ 24,000 Black Female . Ohio
35 13 $ 7,612 Black Male . Ohio
40 13 $ 25,000 White Male . Ohio
48 13 $ 20,000 White Female . Ohio
40 12 $ 48,818 White Male . Ohio
40 16 $ 44,000 Black Male $ 740 Ohio
40 13 $ 27,500 Black Female $ 360 Ohio
35 12 $ 21,000 White Female . Ohio
50 16 $ 64,100 Black Female . Ohio
42 13 $ 22,500 White Female . Ohio
40 10 $ 17,900 White Female . Ohio
45 18 $ 36,000 White Male . Ohio
40 16 $ 32,000 White Female . Ohio
50 16 $ 26,000 Black Male $ 346 Ohio
40 16 $ 26,000 White Female $ 519 Ohio
1. Create a new PivotTable showing Average Usual Hours Worked by Gender (with Gender as the Row variable)

2. Create a pivot table with the average of Usual Hours Worked for Females and for Usual Hours Worked For Mal
3. Create a PivotTable which shows Average Yearly Earnings with Education in the Rows and Gender in the Colu
4. What does the table tell you about the relationship between gender, education, and Average Yearly Earnings?
Gender as the Row variable).

sual Hours Worked For Males in the table.

ows and Gender in the Columns.
Average Yearly Earnings?