explain how to do this and write the formulas so i could solve this on excel please! thank you!

Federal Income Tax Rates and Brackets for Individual and Joint Returns (Due By April 15, 2019) (Excel) Using the individual tax rate schedule shown in table 1.2, perform the following: a. Calculate the tax-liability, after-tax earnings, the average tax rates for the following levels of a partnership earnings before taxes: $10,000;$80,000;$300,000;$500,000,$1 Million; \$1.5 Million; and \$2 Million. b. Plot the average tax rates (measured on the y-axis) against the pretax income levels (measured on the x-axis). What generalization can be made concerning the relationship between these variables? Federal Income Tax Rates and Brackets for Individual and Joint Returns (Due By April 15, 2019) (Excel) Using the individual tax rate schedule shown in table 1.2, perform the following: a. Calculate the tax-liability, after-tax earnings, the average tax rates for the following levels of a partnership earnings before taxes: $10,000;$80,000;$300,000;$500,000,$1 Million; \$1.5 Million; and \$2 Million. b. Plot the average tax rates (measured on the y-axis) against the pretax income levels (measured on the x-axis). What generalization can be made concerning the relationship between these variables