Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

- Write a formula in E4 (hint: use some Mixed Addressing) that can be filled down and to the right to cells E4:F19. Use the

- Write a formula in E4 (hint: use some Mixed Addressing) that can be filled down and to the right to cells E4:F19. Use the percentages in Columns B & C and the total number of employees in Column D to calculate in Columns E & F, respectively, the number of female and number of male employees at each company.

-Select non-adjacent ranges A3:A19 and E3:F19. Insert a horizontal Stacked Bar Chart.

-Sort by number of employees (Column D) in ascending or descending order to make the chart readable.

-Add an informative Chart Title. If it is not clear from your Chart Title that the x-axis units are counts of employees, insert a Horizontal Axis Title.

-Use data labels or a legend (located near the top of the chart) to identify the gender groups represented by segments of the bars on your chart.

image text in transcribed

Diversity in Tech: Employee breakdown by gender for key technology companies (2017) number of Company Male workforce Female workforce 32% number of female employees number of male employees 68% Apple Cisco Dell 24% 76% 28% 72% 38% 35% 62% 65% 69% 31% 44% 56% eBay Facebook Google Groupon HP Ingram Micro Intel LinkedIn 37% employees 123,000 72,790 145,000 12,600 25,105 85,050 10,000 49,000 33,000 102,700 11,800 131,300 11,528 25,178 12,000 8,600 63% 69% 74% 58% 31% 26% 42% 74% 26% 17% 83% Microsoft Nvidia Salesforce Uber 31% 69% 64% 36% Yahoo! 37% 63% Diversity in Tech: Employee breakdown by gender for key technology companies (2017) number of Company Male workforce Female workforce 32% number of female employees number of male employees 68% Apple Cisco Dell 24% 76% 28% 72% 38% 35% 62% 65% 69% 31% 44% 56% eBay Facebook Google Groupon HP Ingram Micro Intel LinkedIn 37% employees 123,000 72,790 145,000 12,600 25,105 85,050 10,000 49,000 33,000 102,700 11,800 131,300 11,528 25,178 12,000 8,600 63% 69% 74% 58% 31% 26% 42% 74% 26% 17% 83% Microsoft Nvidia Salesforce Uber 31% 69% 64% 36% Yahoo! 37% 63%

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

Intermediate Financial Management

Authors: Eugene F Brigham, Phillip R Daves

14th Edition

0357516664, 978-0357516669

More Books

Students also viewed these Finance questions

Question

a. Did you express your anger verbally? Physically?

Answered: 1 week ago