The following table shows monthly revenue for six different web development companies.

a. Use Excel to create sparklines for sales at each company.
b. Which companies have generally decreasing revenues over the six months? Which company has exhibited the most consistent growth over the six months? Which companies have revenues that are both increasing and decreasing over the six months?
c. Use Excel to create a heat map for the revenue of the six companies. Do you find the heat map or the sparklines to be better at communicating the trend of revenues over the six months for each company? Why?

Transcribed Image Text:

Revenue ($) Feb 9,285 1,555 7,650 6,420 May Company Blue Sky Media Innovate Technologies Timmler Company Accelerate, Inc Allen and Davis, LLC Smith Ventures Mar Apr 9.530 3013,600 an un 8,995 8,480 4,580 18,250 6,870 19,580 17,260 18,290 16,250 7,023 6,540 5,700 4,930 28,325 27,580 23,450 22,500 20,800 19,800 6,780 7,520 17,500 16,850 20,185 18,950 17,520 18,580 8,370 10.100