Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

1259307417, 978-1260153132, 1260153134, 978-1259307416

Students also viewed these Accounting questions