Answered step by step
Verified Expert Solution
Question
1 Approved Answer
F G H 1 2 Company 3 Blue Sky Media 4 Innovate Technologies 5 Timmler Company 6 Accelerate, Inc. 7 Allen and Davis, LLC 8
F G H 1 2 Company 3 Blue Sky Media 4 Innovate Technologies 5 Timmler Company 6 Accelerate, Inc. 7 Allen and Davis, LLC 8 Smith Ventures 9 10 11 12 13 14 15 Jan Feb 8995 9285 18250 16870 8480 7650 28325 27580 4580 6420 17500 16850 D E Revenue (S) Mar Apr 11555 9530 19580 17260 7023 6540 23450 22500 6780 7520 20185 18950 May 11230 18290 5700 20800 8370 17520 13600 16250 4930 19800 10100 18580 4. The dataset 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 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 ap for the revenue of the six companies. Do you find the heat map or 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