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:

Partial Pressure

The pressure that each gas in a mixture would exert if it alone occupied the entire volume of the mixture at the same temperature.

Dissociation Curve

A graphical representation showing the fraction of a compound in a bound versus unbound state across a range of concentrations or conditions.

Chloride Ions

Negatively charged ions (Cl-) that are critical for maintaining fluid balance, nerve transmission, and muscle function in the body.

Employee Productivity

The measure of an employee's output and efficiency within a specified period.