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?
Correct Answer:
Verified
a.
b. Year 1 has a decreasing trend a...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
b. Year 1 has a decreasing trend a...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q8: A chart that is recommended as an
Q17: Making visual comparisons between categorical variables is
Q41: A two-dimensional graph representing the data using
Q54: Growth is the primary focus for all
Q55: Deleting the grid lines in the table
Q56: The regional manager of a company wishes
Q57: The data on the ranks assigned to
Q58: In designing an effective table,<br>A) avoid the
Q59: To summarize and analyze data with both
Q61: The data on the scores obtained by