Question
- 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.
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
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