DAME$-01$STAT

Question

Not complete

Marked out of $5\mathrm{.}00$

Flag question

Preparing an Excel Map Visualization of Sales Tax Across States

For this exercise, download the following Excel file obtained from the United States Census Bureau website: Table $3$: State Tax Collections by State and Type of Tax $2021.$ For this exercise, we extract data for sales and gr receipts taxes by state for the first quarter of $2021.$ We then convert the data to a U$.$S$.$ map chart and analyze the results.

Required

Download the following Excel file: U$.$S$.$ Gensus Bureau

Prepare a table by extracting from the U$.$S$.$ Census Bureau file: General Sales and Gross Receipts Taxes by state for $2021$ Q$1.$ You will only be using the General Sales and Gross Receipts data in your analysis. Do not incluo Washington, D$.$C$.$ in your table. Hint: Eliminate unnecessary data. Then use the Transpose function Nou may want to unmerge cells before transposing the data. After the transposition, you can line up the amounts with the states.$)$ Convert the data to a Table as the final step.

List the total of the amounts in your table. $($Leave the amounts in thousands.$)$

Using the table as a reference, list the states with no tax. $$

What is the top and bottom end of the legend automatically prepared for the chart?

Top end of the legend: $

Bottom end of the legend:

$7.$ Answer the following questions using the map visualization: