In reading this table, the marginal tax rate for taxable income less than $$11,000$ is $10$ percent. If the taxable income is between $$11,000$ and $$44,725,$ the tax bill is $$1,100$ plus the marginal taxes. The marginal taxes are calculated as the taxable income minus $$11,000$ times the marginal tax rate of $12$ percent.

Below, we have the tax table that was applicable for married individuals filing jointly in $2023.$

Taxable income $$225,000$

"Taxable

income is

greater than

or equal

to$...."$ "But

less

than or

equal to$..."$ Tax rate

$$-$ $$22,00010\%$

$22,00089,45012\%$

$89,450190,75022\%$

$190,750364,20024\%$

$364,200462,50032\%$

$462,500693,75035\%$

$693,75037\%$

a$.$ Create a tax table in Excel for a couple filing jointly similar to the individual tax table shown above. Your spreadsheet should then calculate the marginal tax rate, the average tax rate, and the tax bill for any level of taxable income input by a user.

b$.$ For a taxable income of $$245,000,$ what is the marginal tax rate?

c$.$ For a taxable income of $$245,000,$ what is the total tax bill?

d$.$ For a taxable income of $$245,000,$ what is the average tax rate?