Name	% of Minorities	% of Women	% of Boomers or Older	% of People with Disabilities	% of LGBT	Industry	HQ Location
Stryker	0.26	0.35	0.13	0.02	0.01	Manufacturing & Production	Kalamazoo, MI
Cisco	0.48	0.28	0.16	0.05	0.03	Information Technology	San Jose, CA
Progressive Insurance			0.13	0.11	0.06	Financial Services & Insurance	Mayfield Village, OH
Accenture	0.51	0.378		0.043		Professional Services	New York, NY
Synchrony	0.45	0.62	0.18	0.16	0.07	Financial Services & Insurance	Stamford, CT
Mohegan Sun	0.49	0.48	0.29	0.13	0.04	Hospitality	Uncasville, CT
Workday	0.45	0.42	0.1	0.04	0.04	Information Technology	Pleasanton, CA
Adobe	0.39	0.36	0.1	0.05	0.05	Information Technology	San Jose, CA
Ultimate Software	0.46	0.49	0.12	0.05	0.05	Information Technology	Weston, FL
Marriott International, Inc.	0.66	0.55	0.25	0.05	0.06	Hospitality	Bethesda, MD
Pricewaterhouse- Coopers LLP	0.34	0.46	0.06	0.04	0.04	Professional Services	New York, NY
HP Inc.	0.29	0.32	0.31	0.05	0.03	Information Technology	Palo Alto, CA
Accor	0.7	0.47	0.39	0.04	0.06	Hospitality	National Harbor, MD
Hulu	0.53	0.55	0.01	0.08	0.12	Media	Santa Monica, CA
Hilton	0.69	0.53	0.27	0.04	0.06	Hospitality	McLean, VA
KPMG LLP	0.33	0.45	0.1	0.05	0.03	Professional Services	New York, NY
Ernst & Young LLP	0.38	0.45	0.07	0.06	0.04	Professional Services	New York, NY
AbbVie	0.32	0.52	0.21	0.05	0.02	Biotechnology & Pharmaceuticals	North Chicago, IL
American Savings Bank	0.87	0.72	0.24	0.05	0.03	Financial Services & Insurance	Honolulu, HI
Kaiser Permanente	0.65	0.75	0.24	0.07	0.06	Health Care	Oakland, CA
Hyatt Hotels Corporation	0.64	0.53	0.24	0.06	0.06	Hospitality	Chicago, IL
American Express			0.16	0.06	0.05	Financial Services & Insurance	New York, NY
Publix Super Markets Inc.	0.44	0.49	0.21	0.09	0.05	Retail	Lakeland, FL
Kimpton Hotels & Restaurants	0.63	0.47	0.11	0.05	0.1	Hospitality	San Francisco, CA
Salesforce	0.36	0.35		0.06	0.06	Information Technology	San Francisco, CA

You are interested in getting a job in technology. You would like to work for a company that is inclusive. One measure of inclusivity is gender balance in the workforce. Create a visualization of these tech data on gender. Discuss what it says to you. Instructions: Click here to view the Excel. There are two parts to this problem. Use Excel to perform the following: a. Calculate Create a stacked column chart showing the makeup of the workforce for each company. Change the color scheme monochromatic and label the female bars. b. Discuss the pattern that you see in these data. How can disclosure of diversity information make an impact