Economic 1 paper sheet Help

I need help in number 1, 2 and 5 can someone help me with what equations i need to used ?

The chart only has until number 22 but in total there are 200 people so can some one demonstrate a small example on how they are work. Also box Element are another question that I think I can solve after an example, I will really appreciate the help !!!!!!!

All data used in this project are from the American Communities Survey (ACS). Each student will receive data for 2000 people. All individuals in your data set are 35 years old. Below is a short description of the variables you will be using for Project 6: Column A Gender (female or male) Column B Race/Ethnicity to keep things simple and avoid small data for some groups, all people are coded as Black, White, Hispanic, or Other. The convention in social science is to categorize someone as Hispanic if they report Hispanic combined with race reported as either Black or White. Note that groups are mutually exclusive by design each person is in only one category. Column C Educational Attainment (11 is high school dropout, 12 is high school graduate, 13 is some college, 14 is an Associate Degree, 16 is an Undergraduate Degree, and 17 is an Advanced/Professional Degree). Column D Employment Status: NILF (not in the labor force, not working), unemployed (want a job, but not working), employed (working) Column E Annual Earnings from employment A B C D E F G H K Race/ Educational Employment Annual 1 Gender Ethnicity Attainment Status Earnings Employed Unemployed NILF Earnings 2 female White 17 employed 120000 Gender 3 male Other 16 employed 73000 Female 4 female White 14 employed 30000 Male 5 male White 12 NILF 6 female White 12 employed 24000 Race/Ethnicity 7 male Other 17 employed 230000 Black 8 male Hispanic 16 employed 85000 Hispanic 9 female Hispanic 11 employed 21000 Other 10 female White 16 employed 41300 White 11 male White 12 employed 62000 12 female Hispanic 14 employed 30000 Education 13 female White 12 NILF HS Graduate or less (11 or 12) 14 male White 12 employed 45000 Some College (13 or 14) 15 male White 11 employed 5000 BA or more (16 or 17) 16 male Hispanic 12 employed 25000 17 male White 14 employed 55000 Element 8 18 female Hispanic 13 NILF Element 9 19 female Black 12 employed 33000 female Hispanic 17 employed 82000 -O 21 male White 14 employed 90000 22 female White 12 employed 40000Your primary two tasks in the project are to create a table summarizing employment and eamings for individuals from different groups and then create scatter plots showing the relationship between education and eamings for employed men and women. (1) Sort your data in columns A-E using Gender. You will need the data to be sorted in order to draw the scatterplots later in this project. (2) Use the COUNTIES command to calculate the fraction of females who are employed. Report this in cell H3. Similarly calculate the fraction of females who are unemployed and the fraction not in the labor force (N1LF). Report these in 13 and J3, respectively. Make the same calculations for males and report these in H4-J4. Round to 2 decimal places. (3) Use the COUNTIFS command to calculate the fraction people in each of the specied RacefEthnicity groups that fall into each of the Employed, Unemployed, NILF groups. Report these in HT-J l 0. Round to 2 decimal places. (4) Use the COUNTIFS command to calculate the fraction people in each of the specied Education groups that fall into each of the Employed, Unemployed, NILF groups. Report these in H13-J15. Round to 2 decimal places. [5) Use the AVERAGEIFS command to calculate the average {mean} annual earnings for employed individuals in each of the groUps listed in eolurmi G. Report these aVerages in cells K3-K15. Round to the nearest whole number (I! decimal places)