Question 3 The Data Set Webdevelop Shows Monthly Revenue For Six Different Web Development Companies A Use Excel To C 1 (22.33 KiB) Viewed 26 times
Question 3 The Data Set Webdevelop Shows Monthly Revenue For Six Different Web Development Companies A Use Excel To C 2 (34.84 KiB) Viewed 26 times
Question 3 The Data Set Webdevelop Shows Monthly Revenue For Six Different Web Development Companies A Use Excel To C 3 (36.12 KiB) Viewed 26 times
Question 3. The data set webdevelop 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 com- pany 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 sparklines to better communicate the trend of revenues over the six months for each company? Why?
1 Company Blue Sky Media Innovate Technologies Timmler Company Accelerate, Inc. Allen and Davis, LLC Smith Ventures Jan 8995 18250 8480 28325 4580 17500 Feb 9285 16870 7650 27580 6420 16850 Revenue ($) Mar Apr 11555 9530 19580 17260 7023 6540 23450 22500 6780 7520 20185 18950 2 1
пу a ologies any Jan 8995 18250 8480 28325 4580 17500 Feb 9285 16870 7650 27580 6420 16850 Revenue ($) Mar Apr 11555 9530 19580 17260 7023 6540 23450 22500 6780 7520 20185 18950 May 11230 18290 5700 20800 8370 17520 Jun 13600 16250 4930 19800 10100 18580 S, LLC
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!