The following table shows the average monthly distance travelled (in Billion Miles) by vehicles on urban highways for five different years. $$\text { Urban Highways - Average Monthly Distance Travelled by Vehicles (Billion Miles) }$$
$\begin{array}{|l|l|l|l|l|l|l|l|l|l|l|l|}
\text { Years } & \text { Jan } & \text { Feb } & \text { Mar } & \text { Apr } & \text { May } &\text {jun }&\text {july }&\text {aug }&\text {sep }&\text { oct}&\text {nov }&\text { dec}&\
\hline \text { Year 1}& 4.22 & 5.32 & 5.21 & 5.12 & 4.92 & 4.49 & 4.55 & 4.49 & 4.44 & 4.39 & 4.37&4 .35 \
\text { Year 2}&4.31 & 5.44 & 5.34 & 5.24 & 4.98 & 4.59 & 4.68 & 4.65 & 4.61 & 4.68 & 4.74&4 .79 \
\text { Year 3}&4.38 & 5.51 & 5.41 & 5.36 & 4.98 & 4.63 & 4.71 & 4.78 & 4.82 & 4.88 & 4.85&4 .89 \
\text { Year 4}&4.45 & 5.59 & 5.5 & 5.41 & 5.01 & 4.72 & 4.78 & 4.79 & 4.82 & 4.92 & 5.06 & 5.11 \
\text { Year 5}&4.51 & 5.65 & 5.62 & 5.49 & 5.12 & 4.8 & 4.88 & 4.82 & 4.95 & 5.12 & 5.22&5 .44 \
\hline
\end{array}$
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?

Question

The following table shows the average monthly distance travelled (in Billion Miles) by vehicles on urban highways for five different years. $$\text { Urban Highways - Average Monthly Distance Travelled by Vehicles (Billion Miles) }$$
$\begin{array}{|l|l|l|l|l|l|l|l|l|l|l|l|}
\text { Years } & \text { Jan } & \text { Feb } & \text { Mar } & \text { Apr } & \text { May } &\text {jun }&\text {july }&\text {aug }&\text {sep }&\text { oct}&\text {nov }&\text { dec}&\
\hline \text { Year 1}& 4.22 & 5.32 & 5.21 & 5.12 & 4.92 & 4.49 & 4.55 & 4.49 & 4.44 & 4.39 & 4.37&4 .35 \
\text { Year 2}&4.31 & 5.44 & 5.34 & 5.24 & 4.98 & 4.59 & 4.68 & 4.65 & 4.61 & 4.68 & 4.74&4 .79 \
\text { Year 3}&4.38 & 5.51 & 5.41 & 5.36 & 4.98 & 4.63 & 4.71 & 4.78 & 4.82 & 4.88 & 4.85&4 .89 \
\text { Year 4}&4.45 & 5.59 & 5.5 & 5.41 & 5.01 & 4.72 & 4.78 & 4.79 & 4.82 & 4.92 & 5.06 & 5.11 \
\text { Year 5}&4.51 & 5.65 & 5.62 & 5.49 & 5.12 & 4.8 & 4.88 & 4.82 & 4.95 & 5.12 & 5.22&5 .44 \
\hline
\end{array}$ 
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?

Quizplus · Accepted Answer

The Answer of The following table shows the average monthly distance travelled (in Billion Miles) by vehicles on urban highways for five different years. $$\text { Urban Highways - Average Monthly Distance Travelled by Vehicles (Billion Miles) }$$
$\begin{array}{|l|l|l|l|l|l|l|l|l|l|l|l|}
\text { Years } & \text { Jan } & \text { Feb } & \text { Mar } & \text { Apr } & \text { May } &\text {jun }&\text {july }&\text {aug }&\text {sep }&\text { oct}&\text {nov }&\text { dec}&\
\hline \text { Year 1}& 4.22 & 5.32 & 5.21 & 5.12 & 4.92 & 4.49 & 4.55 & 4.49 & 4.44 & 4.39 & 4.37&4 .35 \
\text { Year 2}&4.31 & 5.44 & 5.34 & 5.24 & 4.98 & 4.59 & 4.68 & 4.65 & 4.61 & 4.68 & 4.74&4 .79 \
\text { Year 3}&4.38 & 5.51 & 5.41 & 5.36 & 4.98 & 4.63 & 4.71 & 4.78 & 4.82 & 4.88 & 4.85&4 .89 \
\text { Year 4}&4.45 & 5.59 & 5.5 & 5.41 & 5.01 & 4.72 & 4.78 & 4.79 & 4.82 & 4.92 & 5.06 & 5.11 \
\text { Year 5}&4.51 & 5.65 & 5.62 & 5.49 & 5.12 & 4.8 & 4.88 & 4.82 & 4.95 & 5.12 & 5.22&5 .44 \
\hline
\end{array}$ 
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?