Answered step by step
Verified Expert Solution
Question
1 Approved Answer
20. The following table shows monthly revenue for six different web development companies. Company Blue Sky Media Innovate Technologies Timmler Company Accelerate, Inc. Allen and
20. The following table shows monthly revenue for six different web development companies. Company Blue Sky Media Innovate Technologies Timmler Company Accelerate, Inc. Allen and Davis, LLC Smith Ventures Jan 8,995 18,250 8,480 28,325 4,580 17,500 Feb 9,285 16,870 7,650 27.580 6,420 16,850 Revenue ($) Mar Apr May 11,555 9,530, 11,230 19,580 17,260 18,290 7,023 6,540 5,700 23,450 22,500 20,800 7.520 8,370 20,185 18,950 17,520 Jun 13,600 16,250 4,930 19,800 10,100 18,580 6.780 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 com- panies 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started