please describe the steps in excel

some of the sample data for the excel practice. problem

Question 2) Suppose you are interested in finding the average taxes paid by different people according to the following schedule: Basic Tax Rate -25% of salaried annual income (above $20000; 0 otherwise) & 10% of annual income from other sources (in excess of $5000; 5% otherwise). The following tax rebates are also applicable - Tax rebates for working women - $500 if annual salary income is below $ 35000. $0 otherwise. Senior Citizens Discount - $500 if 60 years or above; $250 is 55 or above, $0 otherwise, Calculate Total tax collected by the county The total taxes paid by each demographic (broken as a 2 way matrix based on Gender and Age). Question 3) Suppose the following classification system is applied to segregate various groups based on educational attainment - 16 years or more = College & Beyond 13 to 16 years = Some College 11 to 12 years = High School Completed 10 years or less = Others A sociologist is interested in identifying if the extent of college education plays a part in the total yearly income earned by people. Use your knowledge of Excel (including if statements, and pivot tables) to address this question. Question 2) Suppose you are interested in finding the average taxes paid by different people according to the following schedule: Basic Tax Rate - 25% of salaried annual income (above $20000; 0 otherwise) & 10% of annual income from other sources (in excess of $5000; 5% otherwise). The following tax rebates are also applicable - Tax rebates for working women - $500 if annual salary income is below $ 35000. $0 otherwise. Senior Citizens Discount - $500 if 60 years or above; $250 is 55 or above, $0 otherwise Calculate Total tax collected by the county The total taxes paid by each demographic (broken as a 2 way matrix based on Gender and Age). Usual Hours Worked Education 57 Total Income 45621 20719 55670 55244 32846 67193 26738 percent of total income that comes from other sources 3.55% 4208 3.00% 12.75% 26.93% 12 7.73% 13 30631 13574 36.42% 18.33% 26.33 0.31% 24.58% 1875 65199 13 13 Yearly Yearly Earnings Earnings From Other 44000 1621.4 White Male 12000 8718.6 White Female 540001 1669.8 White Male 4820017044,4 White Male 24000 8846,2 White Male 620001 5 193.1 White Female 17000 9738.3 White Female 25000 5 631 Black Male 10000l 3574 Black Male 65000 199.1 White Male 9830.7 White Male 3067311 5830 White I Male 370001 6603.8lWhite I Male 34000 7 866.1 White Male 25000 9747.1 White Male 42000 4766.3 l White I Male 68000 7818.8 White Male 70000 1700.6 White Male 25000 4746.5 White Female 15400 5 693.6 White Female 564261 1607.1 White I Male 21087 127.6 White Male 50000 1 254 White Male 11500 3 894 Back Female 4001,8 White Male 70000 7929.9 White Female 62000 3 188.9 White Male 30000 6689.1 White Male 20000 2107 Black Female 173601 4412.1 White Female 320001 2439.8 White Male 60000 9351.1 White Male 9500 642.4 White Female 9000 2203.3 White Male 0 8989.2 White Mele 38000 334.4 White I Male 45000 7333.7 White Female 16000 4354.9 White Male 30000 5 969.6 White Male 29530 118.8 White Female 8274 9699.8White Male 3542 White Female 21000 9 234.5 White Male 2818.2 White Male 30000 7 474.5 White Female 6246.9 White Female 36400 3 873.1 White Male 29000 7288.6 White Female 18000 5395.5 White Female 65000 9304.9 White Male 15000| 6197.4 White Female 30000 9 584.3 White Male 72000 9 423.7 White Male 42000 7 604.3 White Female 144499 4613,4 White Male 30000 2323.2 White Male 312561 43509 41866 34747 46765 75819 71701 29747 21094 58033 21215 51254 15394 44002 77930 65189 36689 22107 21772 34440 69351 10142 11203 8989 18.79% 28.05% 10.19% 10.31% 237 15.96% 26.99% 2.77% 0.50% 2.45% 25 30% 9.09% 10.18% 4899 18 23% 9.53% 20.265 7,08% 13.48% 181 18| 26 20 45 35 12 16 50 30 121 121 42 19.67% 100 OON 21 14 015 52334 20355 35969 29649 17974 46 28 59 16/ 28 31 32 32 30235 27318 37475 36247 40273 36289 23395 74305 21197 39584 81424 49504 149112 32323 41408 45552 16.59% 0.40% 5397 24.03% 30.54% 10.32% 19.95% 17.23% 9.62% 20.09% 23.06% 12.52% 29.24% 24 21% 11.57% 15 33% 3.09% 7.19% 15.47% 23. 17 slalu 13 35000 e Male 35000 10552.3 White Male Question 2) Suppose you are interested in finding the average taxes paid by different people according to the following schedule: Basic Tax Rate -25% of salaried annual income (above $20000; 0 otherwise) & 10% of annual income from other sources (in excess of $5000; 5% otherwise). The following tax rebates are also applicable - Tax rebates for working women - $500 if annual salary income is below $ 35000. $0 otherwise. Senior Citizens Discount - $500 if 60 years or above; $250 is 55 or above, $0 otherwise, Calculate Total tax collected by the county The total taxes paid by each demographic (broken as a 2 way matrix based on Gender and Age). Question 3) Suppose the following classification system is applied to segregate various groups based on educational attainment - 16 years or more = College & Beyond 13 to 16 years = Some College 11 to 12 years = High School Completed 10 years or less = Others A sociologist is interested in identifying if the extent of college education plays a part in the total yearly income earned by people. Use your knowledge of Excel (including if statements, and pivot tables) to address this question. Question 2) Suppose you are interested in finding the average taxes paid by different people according to the following schedule: Basic Tax Rate - 25% of salaried annual income (above $20000; 0 otherwise) & 10% of annual income from other sources (in excess of $5000; 5% otherwise). The following tax rebates are also applicable - Tax rebates for working women - $500 if annual salary income is below $ 35000. $0 otherwise. Senior Citizens Discount - $500 if 60 years or above; $250 is 55 or above, $0 otherwise Calculate Total tax collected by the county The total taxes paid by each demographic (broken as a 2 way matrix based on Gender and Age). Usual Hours Worked Education 57 Total Income 45621 20719 55670 55244 32846 67193 26738 percent of total income that comes from other sources 3.55% 4208 3.00% 12.75% 26.93% 12 7.73% 13 30631 13574 36.42% 18.33% 26.33 0.31% 24.58% 1875 65199 13 13 Yearly Yearly Earnings Earnings From Other 44000 1621.4 White Male 12000 8718.6 White Female 540001 1669.8 White Male 4820017044,4 White Male 24000 8846,2 White Male 620001 5 193.1 White Female 17000 9738.3 White Female 25000 5 631 Black Male 10000l 3574 Black Male 65000 199.1 White Male 9830.7 White Male 3067311 5830 White I Male 370001 6603.8lWhite I Male 34000 7 866.1 White Male 25000 9747.1 White Male 42000 4766.3 l White I Male 68000 7818.8 White Male 70000 1700.6 White Male 25000 4746.5 White Female 15400 5 693.6 White Female 564261 1607.1 White I Male 21087 127.6 White Male 50000 1 254 White Male 11500 3 894 Back Female 4001,8 White Male 70000 7929.9 White Female 62000 3 188.9 White Male 30000 6689.1 White Male 20000 2107 Black Female 173601 4412.1 White Female 320001 2439.8 White Male 60000 9351.1 White Male 9500 642.4 White Female 9000 2203.3 White Male 0 8989.2 White Mele 38000 334.4 White I Male 45000 7333.7 White Female 16000 4354.9 White Male 30000 5 969.6 White Male 29530 118.8 White Female 8274 9699.8White Male 3542 White Female 21000 9 234.5 White Male 2818.2 White Male 30000 7 474.5 White Female 6246.9 White Female 36400 3 873.1 White Male 29000 7288.6 White Female 18000 5395.5 White Female 65000 9304.9 White Male 15000| 6197.4 White Female 30000 9 584.3 White Male 72000 9 423.7 White Male 42000 7 604.3 White Female 144499 4613,4 White Male 30000 2323.2 White Male 312561 43509 41866 34747 46765 75819 71701 29747 21094 58033 21215 51254 15394 44002 77930 65189 36689 22107 21772 34440 69351 10142 11203 8989 18.79% 28.05% 10.19% 10.31% 237 15.96% 26.99% 2.77% 0.50% 2.45% 25 30% 9.09% 10.18% 4899 18 23% 9.53% 20.265 7,08% 13.48% 181 18| 26 20 45 35 12 16 50 30 121 121 42 19.67% 100 OON 21 14 015 52334 20355 35969 29649 17974 46 28 59 16/ 28 31 32 32 30235 27318 37475 36247 40273 36289 23395 74305 21197 39584 81424 49504 149112 32323 41408 45552 16.59% 0.40% 5397 24.03% 30.54% 10.32% 19.95% 17.23% 9.62% 20.09% 23.06% 12.52% 29.24% 24 21% 11.57% 15 33% 3.09% 7.19% 15.47% 23. 17 slalu 13 35000 e Male 35000 10552.3 White Male