The Following Table Shows the Average Monthly Distance Travelled (In

question 60

Essay

The following table shows the average monthly distance travelled (in Billion Miles) by vehicles on urban highways for five different years.

a. Use Excel to create sparklines for the average monthly vehicle distance travelled each year.
b. Which year has decreasing trend of the average distance travelled? Which year has increasing trend of the average distance travelled?
c. Use Excel to create a heat map for the average distance travelled by vehicles. Do you find the heat map or the sparklines to be better at communicating the trend of the average vehicle distance travelled over different years? Why?

---

Definitions:

IRS

The Internal Revenue Service, a U.S. government agency responsible for tax collection and tax law enforcement.

Tax Tables

Charts used to determine the amount of tax owed based on income levels, provided by tax authorities for calculating liabilities.

Tax Rate Schedules

Charts or tables provided by tax authorities that outline the tax rates applicable to different income levels.

Tax Liability

The total amount of tax owed to a taxing authority by an individual, organization, or corporation.