PLEASE SHOW EXCEL FUNCTION WITH THE PIVOT TABLE USED

A B D F G H 1 Part V (15 points) 2 Create a pivot table in this spreadsheet showing the number of observations for each race and sex combination (5 points) 3 Create a pivot table in this spreadsheet showing the average yearly earnings by different education (yrs), and group education (yrs) in bands 4 Usual Hours Education (yrs) Race Sex State 5 Worked 6 40 13 Ohio Male Female 7 35 12 Ohio 8 70 11 White White White White White Male Ohio 9 40 16 Ohio 10 38 12 Male Male Female Ohio 11 60 18 White Ohio 12 40 13 White Black Female Male Ohio Ohio 13 50 8 14 40 11 Black Male Ohio 15 50 16 White Male Ohio 16 45 12 White Male Ohio 17 50 16 White Male Male Ohio Ohio 18 50 11 White 19 40 12 White Male Ohio 20 40 13 White Ohio Yearly Earnings $ 44,000 $ 12,000 $ 54,000 $ 48,200 $ 24,000 $ 62,000 $ 17,000 $ 25,000 $ 10,000 $ 65,000 $ 30,000 $ 306,731 $ 37,000 $ 34,000 $ 25,000 $ 42,000 $ 68,000 $ 70,000 $ 25,000 $ 15,400 $ 56,426 $ 21,087 $ 50,000 $ 11,500 $ 40,000 $ 70,000 $ 62,000 $ 30,000 $ 20,000 $ 17,360 $ 32,000 $ 60,000 21 40 12 White Ohio 22 40 16 Male Male Male Male Female 23 50 White White White White 13 Ohio Ohio Ohio 24 40 12 25 35 13 Female Ohio 26 40 13 White Male 27 40 12 White Male Ohio Ohio Ohio Ohio 28 40 13 White Black 29 49 12 30 60 12 White Ohio 31 60 18 White Ohio Male Female Male Female Male Male Female Female 32 45 18 White Ohio 33 40 12 Ohio Ohio 34 40 White Black White 16 35 12 Ohio 72 50 36 12 White Male Ohio 37 60 16 White Male Ohio A B D F G H 1 Part V (15 points) 2 Create a pivot table in this spreadsheet showing the number of observations for each race and sex combination (5 points) 3 Create a pivot table in this spreadsheet showing the average yearly earnings by different education (yrs), and group education (yrs) in bands 4 Usual Hours Education (yrs) Race Sex State 5 Worked 6 40 13 Ohio Male Female 7 35 12 Ohio 8 70 11 White White White White White Male Ohio 9 40 16 Ohio 10 38 12 Male Male Female Ohio 11 60 18 White Ohio 12 40 13 White Black Female Male Ohio Ohio 13 50 8 14 40 11 Black Male Ohio 15 50 16 White Male Ohio 16 45 12 White Male Ohio 17 50 16 White Male Male Ohio Ohio 18 50 11 White 19 40 12 White Male Ohio 20 40 13 White Ohio Yearly Earnings $ 44,000 $ 12,000 $ 54,000 $ 48,200 $ 24,000 $ 62,000 $ 17,000 $ 25,000 $ 10,000 $ 65,000 $ 30,000 $ 306,731 $ 37,000 $ 34,000 $ 25,000 $ 42,000 $ 68,000 $ 70,000 $ 25,000 $ 15,400 $ 56,426 $ 21,087 $ 50,000 $ 11,500 $ 40,000 $ 70,000 $ 62,000 $ 30,000 $ 20,000 $ 17,360 $ 32,000 $ 60,000 21 40 12 White Ohio 22 40 16 Male Male Male Male Female 23 50 White White White White 13 Ohio Ohio Ohio 24 40 12 25 35 13 Female Ohio 26 40 13 White Male 27 40 12 White Male Ohio Ohio Ohio Ohio 28 40 13 White Black 29 49 12 30 60 12 White Ohio 31 60 18 White Ohio Male Female Male Female Male Male Female Female 32 45 18 White Ohio 33 40 12 Ohio Ohio 34 40 White Black White 16 35 12 Ohio 72 50 36 12 White Male Ohio 37 60 16 White Male Ohio