Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 4

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