The following table shows monthly revenue for six different web development companies.

Revenue $($$$)$

Company Jan Feb Mar Apr May Jun

Blue Sky Media $8,9959,28511,5559,53011,23013,600$

Innovate Technologies $18,25016,87019,58017,26018,29016,250$

Timmler Company $8,4807,6507,0236,5405,7004,930$

Accelerate, Inc. $28,32527,58023,45022,50020,80019,800$

Allen and Davis, LLC $4,5806,4206,7807,5208,37010,100$

Smith Ventures $17,50016,85020,18518,95017,52018,580$

Click on the datafile logo to reference the data.

$($a$)$ Use Excel to create sparklines for sales at each company.

Choose the correct sparklines below.

$($i$)$

Revenue $($$$)$

Company Jan Feb Mar Apr May Jun

Blue Sky Media $8,9959,28511,5559,53011,23013,600$

Innovate Technologies $18,25016,87019,58017,26018,29016,250$

Timmler Company $8,4807,6507,0236,5405,7004,930$

Accelerate, Inc. $28,32527,58023,45022,50020,80019,800$

Allen and Davis, LLC $4,5806,4206,7807,5208,37010,100$

Smith Ventures $17,50016,85020,18518,95017,52018,580$

$($ii$)$

Revenue $($$$)$

Company Jan Feb Mar Apr May Jun

Blue Sky Media $8,9959,28511,5559,53011,23013,600$

Innovate Technologies $18,25016,87019,58017,26018,29016,250$

Timmler Company $8,4807,6507,0236,5405,7004,930$

Accelerate, Inc. $28,32527,58023,45022,50020,80019,800$

Allen and Davis, LLC $4,5806,4206,7807,5208,37010,100$

Smith Ventures $17,50016,85020,18518,95017,52018,580$

$($iii$)$

Revenue $($$$)$

Company Jan Feb Mar Apr May Jun

Blue Sky Media $8,9959,28511,5559,53011,23013,600$

Innovate Technologies $18,25016,87019,58017,26018,29016,250$

Timmler Company $8,4807,6507,0236,5405,7004,930$

Accelerate, Inc. $28,32527,58023,45022,50020,80019,800$

Allen and Davis, LLC $4,5806,4206,7807,5208,37010,100$

Smith Ventures $17,50016,85020,18518,95017,52018,580$

$($iv$)$

Revenue $($$$)$

Company Jan Feb Mar Apr May Jun

Blue Sky Media $8,9959,28511,5559,53011,23013,600$

Innovate Technologies $18,25016,87019,58017,26018,29016,250$

Timmler Company $8,4807,6507,0236,5405,7004,930$

Accelerate, Inc. $28,32527,58023,45022,50020,80019,800$

Allen and Davis, LLC $4,5806,4206,7807,5208,37010,100$

Smith Ventures $17,50016,85020,18518,95017,52018,580$

$-$ Select your answer $-$

$($b$)$ Choose the correct options below.

Revenue $($$$)$

Company Jan Feb Mar Apr May Jun

$-$ Select your answer $-$

Blue Sky Media $8,9959,28511,5559,53011,23013,600$

$-$ Select your answer $-$

Innovate Technologies $18,25016,87019,58017,26018,29016,250$

$-$ Select your answer $-$

Timmler Company $8,4807,6507,0236,5405,7004,930$

$-$ Select your answer $-$

Accelerate, Inc. $28,32527,58023,45022,50020,80019,800$

$-$ Select your answer $-$

Allen and Davis, LLC $4,5806,4206,7807,5208,37010,100$

$-$ Select your answer $-$

Smith Ventures $17,50016,85020,18518,95017,52018,580$

$($c$)$ Use Excel to create a heat map for the revenue of the six companies.

Choose the correct heat map below.

$($i$)$

Revenue $($$$)$

Company Jan Feb Mar Apr May Jun

Blue Sky Media $8,99 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 Recommended Textbook for Social Media Management Authors: Ben Shields 1st Edition 019029633X, 978-0190296339 More Books Students also viewed these General Management questions Question ★★★★★ What does Descartes' rule of signs tell you about the number of positive real zeros and the number of negative real zeros of each of the following polynomial functions? a. f (x) = 2x6 - 7x3 + x2 - x... Answered: 1 week ago Question ★★★★★ What are services? p-963 Answered: 1 week ago Question ★★★★★ =+a) Would Kendalls t or Pearson correlation be the more appropriate summary? Explain. Answered: 1 week ago Question ★★★★★ Tobin Supplies Company expects sales next year to be $500,000. Inventory and accounts receivable will increase $90,000 to accommodate this sales level. The company has a steady profit margin of 12... Answered: 1 week ago Question ★★★★★ 12. Hart Enterprises recently paid a dividend of $2.25. It expects to have a dividend growth rate of 12% for the first 3 years followed by a constant rate of 6% thereafter. The firms required return... Answered: 1 week ago Question ★★★★★ 19. Which one of the statements below is false: A. The average beta across all stocks in a diversified index is l B. The beta of a firm is likely to change if the firm changes its industry. C. As... Answered: 1 week ago Question ★★★★★ Becton Labs produces a variety of chemical compounds for industrial uses. The standard mix for February's production of 80,000 litres of Product "X" and the budgeted costs, are as follows: Liquid... Answered: 1 week ago Question ★★★★★ Q2) A jute packaging unit has planned production of 4950 kg of jute to be sold six months later. The spot price is 1940 per kg while six months futures are trading at 1880. The firm expects the price... Answered: 1 week ago Question ★★★★★ Scare-2-B-U (S2BU) specializes in costumes for all occasions. The average price of each of its costumes is $310. For each occasion, S2BU receives a 30 percent deposit two months before the occasion,... Answered: 1 week ago Question ★★★★★ The VIF for Engine Size found for the Full Model is 6.5147. This VIF is calculated based on an R-squared value from another model. This R-squared value is 0.846501. The resulting VIF is1/(1-0.846501)... Answered: 1 week ago Question ★★★★★ Quick Stop Fashion House produces "fast fashion" clothes that represent the current fad. In the foreign environment, this type of product is considered highly sensitive. O sensitive. O insensitive. O... Answered: 1 week ago Question ★★★★★ find out more about computer assisted qualitative data analysis software in relation to your project objectives; Answered: 1 week ago Question ★★★★★ undertake a thematic analysis of your data; Answered: 1 week ago Question ★★★★★ identify the main components of discourse analysis and evaluate its use to analyse qualitative data; Answered: 1 week ago Previous Question Next Question View Answer in SolutionInn App Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Secure Payment Download Our App © 2024 SolutionInn. All Rights Reserved $