Untitled Spreadsheet TP Diversity Report Job TitleLast name, First nameGenderEthnicity Cohort 1-Business Analyst MaleWhite or Caucasian Cohort 1-Business Analyst FemaleWhite or Caucasian Cohort...

1 answer below ยป
create diversity infographic. one pie chart of male/female, and treetop of ethnicities. include a filter by job title


Untitled Spreadsheet TP Diversity Report Job TitleLast name, First nameGenderEthnicity Cohort 1-Business AnalystMaleWhite or Caucasian Cohort 1-Business AnalystFemaleWhite or Caucasian Cohort 1-Business AnalystMaleWhite or Caucasian Cohort 1-Business AnalystFemaleWhite or Caucasian Cohort 1-Business AnalystMaleWhite or Caucasian Cohort 1-Business AnalystMaleAsian or Pacific Islander Cohort 1-Business AnalystFemaleAsian or Pacific Islander Cohort 1-Business AnalystMaleAsian or Pacific Islander Cohort 1-Business AnalystMaleAsian or Pacific Islander Cohort 1-Business AnalystMaleAsian or Pacific Islander Cohort 1-Business AnalystFemaleAsian or Pacific Islander Cohort 2-Business AnalystMaleMultiracial or Biracial Cohort 2-Business AnalystMaleHispanic or Latino Cohort 2-Business AnalystMaleHispanic or Latino Cohort 2-Business AnalystMaleMultiracial or Biracial Cohort 2-Business AnalystMaleHispanic or Latino Cohort 2-Business AnalystFemaleBlack or African American Cohort 2-Business AnalystMaleHispanic or Latino Cohort 2-Business AnalystMaleAsian or Pacific Islander Cohort 2-Business AnalystMaleAsian or Pacific Islander Cohort 2-Business AnalystFemaleHispanic or Latino Cohort 2-Business AnalystMaleWhite or Caucasian Cohort 2-Business AnalystMaleWhite or Caucasian Cohort 2-Business AnalystFemaleWhite or Caucasian Cohort 2-Business AnalystFemaleWhite or Caucasian Cohort 3-Software EngineerMaleWhite or Caucasian Cohort 3-Software EngineerMaleMultiracial or Biracial Cohort 3-Software EngineerMaleWhite or Caucasian Cohort 3-Software EngineerMaleHispanic or Latino Cohort 3-Software EngineerFemaleAsian or Pacific Islander Cohort 3-Software EngineerMaleMultiracial or Biracial Cohort 3-Software EngineerMaleAsian or Pacific Islander Cohort 3-Software EngineerMaleWhite or Caucasian Cohort 3-Software EngineerMaleMultiracial or Biracial Cohort 3-Software EngineerMaleWhite or Caucasian Cohort 3-Software EngineerFemaleAsian or Pacific Islander Cohort 3-Software EngineerMaleWhite or Caucasian Cohort 3-Software EngineerMaleWhite or Caucasian Cohort 3-Software EngineerMaleWhite or Caucasian Cohort 4-Business AnalystMaleWhite or Caucasian Cohort 4-Business AnalystFemaleMultiracial or Biracial Cohort 4-Business AnalystFemaleWhite or Caucasian Cohort 4-Business AnalystMaleAsian or Pacific Islander Cohort 4-Business AnalystMaleMultiracial or Biracial Cohort 4-Business AnalystFemaleBlack or African American Cohort 4-Business AnalystMaleWhite or Caucasian Cohort 4-Business AnalystFemaleBlack or African American Cohort 4-Business AnalystMaleHispanic or Latino Cohort 4-Business AnalystMaleHispanic or Latino Cohort 4-Business AnalystMaleAsian or Pacific Islander Cohort 4-Business AnalystMaleMultiracial or Biracial Cohort 4-Business AnalystMaleAsian or Pacific Islander Cohort 4-Business AnalystFemaleBlack or African American Cohort 4-Business AnalystFemaleBlack or African American Cohort 4-Business AnalystMaleAsian or Pacific Islander Cohort 4-Business AnalystMaleAsian or Pacific Islander Cohort 5-Business AnalystFemaleBlack or African American Cohort 5-Business AnalystMaleWhite or Caucasian Cohort 5-Business AnalystMaleAsian or Pacific Islander Cohort 5-Business AnalystFemaleBlack or African American Cohort 5-Business AnalystFemaleAsian or Pacific Islander Cohort 5-Business AnalystMaleAsian or Pacific Islander Cohort 5-Business AnalystFemaleAsian or Pacific Islander Cohort 5-Business AnalystMaleBlack or African American Cohort 5-Business AnalystMaleWhite or Caucasian Cohort 5-Business AnalystFemaleMultiracial or Biracial Cohort 5-Business AnalystMaleWhite or Caucasian Cohort 5-Business AnalystFemaleBlack or African American Cohort 5-Business AnalystFemaleAsian or Pacific Islander Cohort 5-Business AnalystMaleAsian or Pacific Islander Cohort 5-Business AnalystMaleHispanic or Latino Cohort 6-Full Stack EngineerMaleWhite or Caucasian Cohort 6-Full Stack EngineerMaleHispanic or Latino Cohort 6-Full Stack EngineerMaleHispanic or Latino Cohort 6-Full Stack EngineerMaleAsian or Pacific Islander Cohort 6-Full Stack EngineerMaleWhite or Caucasian Cohort 6-Full Stack EngineerMaleHispanic or Latino Cohort 6-Full Stack EngineerFemaleAsian or Pacific Islander Cohort 6-Full Stack EngineerMaleWhite or Caucasian Cohort 6-Full Stack EngineerMaleWhite or Caucasian Cohort 6-Full Stack EngineerMaleWhite or Caucasian Cohort 6-Full Stack EngineerMaleWhite or Caucasian Cohort 6-Full Stack EngineerMaleBlack or African American Cohort 7-Full Stack EngineerMaleHispanic or Latino Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerFemaleBlack or African American Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerMaleAsian or Pacific Islander Cohort 7-Full Stack EngineerFemaleBlack or African American Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerMaleAsian or Pacific Islander Cohort 7-Full Stack EngineerMaleHispanic or Latino Cohort 7-Full Stack EngineerMaleHispanic or Latino Cohort 7-Full Stack EngineerMaleAsian or Pacific Islander Cohort 7-Full Stack EngineerMaleWhite or Caucasian Cohort 7-Full Stack EngineerFemaleWhite or Caucasian Cohort 7-Full Stack EngineerMaleBlack or African American Cohort 7-Full Stack EngineerMaleBlack or African American Cohort 7-Full Stack EngineerMaleAsian or Pacific Islander Cohort 8-Business Systems AnalystMaleWhite or Caucasian Cohort 8-Business Systems AnalystMaleWhite or Caucasian Cohort 8-Business Systems AnalystMaleBlack or African American Cohort 8-Business Systems AnalystMaleBlack or African American Cohort 8-Business Systems AnalystMaleWhite or Caucasian Cohort 8-Business Systems AnalystMaleHispanic or Latino Cohort 8-Business Systems AnalystFemaleHispanic or Latino Cohort 8-Business Systems AnalystFemaleAsian or Pacific Islander Cohort 8-Business Systems AnalystMaleAsian or Pacific Islander Cohort 8-Business Systems AnalystMaleAsian or Pacific Islander Cohort 8-Business Systems AnalystMaleAsian or Pacific Islander Cohort 8-Business Systems AnalystFemaleHispanic or Latino Cohort 8-Business Systems AnalystMaleMultiracial or Biracial Cohort 8-Business Systems AnalystFemaleMultiracial or Biracial Cohort 8-Business Systems AnalystMaleAsian or Pacific Islander Cohort 8-Business Systems AnalystFemaleBlack or African American Cohort 8-Business Systems AnalystFemaleAsian or Pacific Islander Cohort 8-Business Systems AnalystFemaleMultiracial or Biracial Cohort 8-Business Systems AnalystMaleWhite or Caucasian Cohort 9-Business Systems AnalystMaleBlack or African American Cohort 9-Business Systems AnalystMaleBlack or African American Cohort 9-Business Systems AnalystMaleWhite or Caucasian Cohort 9-Business Systems AnalystFemaleMultiracial or Biracial Cohort 9-Business Systems AnalystFemaleBlack or African American Cohort 9-Business Systems AnalystMaleAsian or Pacific Islander Cohort 9-Business Systems AnalystMaleHispanic or Latino Cohort 9-Business Systems AnalystMaleWhite or Caucasian Cohort 9-Business Systems AnalystFemaleBlack or African American Cohort 9-Business Systems AnalystMaleWhite or Caucasian Cohort 9-Business Systems AnalystFemaleWhite or Caucasian Cohort 9-Business Systems AnalystMaleWhite or Caucasian Cohort 9-Full Stack Software EngineerMaleHispanic or Latino Cohort 9-Full Stack Software EngineerMaleWhite or Caucasian Cohort 9-Full Stack Software EngineerFemaleMultiracial or Biracial Cohort 9-Full Stack Software EngineerMaleBlack or African American Cohort 9-Full Stack Software EngineerMaleWhite or Caucasian Cohort 9-Full Stack Software EngineerMaleWhite or Caucasian Cohort 9-Full Stack Software EngineerFemaleWhite or Caucasian Cohort 9-Full Stack Software EngineerFemaleWhite or Caucasian Cohort 10-Business Systems Analyst-CAMaleAsian or Pacific Islander Cohort 10-Business Systems Analyst-CAMaleAsian or Pacific Islander Cohort 10-Business Systems Analyst-CAMaleAsian or Pacific Islander Cohort 10-Business Systems Analyst-CAFemaleAsian or Pacific Islander Cohort 10-Business Systems Analyst-CAMaleAsian or Pacific Islander Cohort 10-Business Systems Analyst-CAMaleHispanic or Latino Cohort 10-Business Systems Analyst-CAMaleWhite or Caucasian Cohort 10-Business Systems Analyst-CAFemaleAsian or Pacific Islander Cohort 10-Business Systems Analyst-WIMaleWhite or Caucasian Cohort 10-Business Systems Analyst-WIMaleWhite or Caucasian Cohort 11-Full Stack Engineer-DCMaleWhite or Caucasian Cohort 11-Full Stack Engineer-DCMaleWhite or Caucasian Cohort 11-Full Stack Engineer-DCMaleWhite or Caucasian Cohort 11-Full Stack Engineer-DCMaleAsian or Pacific Islander Cohort 11-Full Stack Engineer-DCFemaleAsian or Pacific Islander Cohort 11-Full Stack Engineer-HOUMaleWhite or Caucasian Cohort 11-Full Stack Engineer-HOUMaleAsian or Pacific Islander Cohort 11-Full Stack Engineer-HOUFemaleHispanic or Latino Cohort 11-Full Stack Engineer-HOUMaleWhite or Caucasian Cohort 11-Full Stack Engineer-HOUMaleMultiracial or Biracial Cohort 12-Full Stack Engineer-ATLMaleHispanic or Latino Cohort 12-Full Stack Engineer-ATLMaleWhite or Caucasian Cohort 12-Full Stack Engineer-ATLMaleAsian or Pacific Islander Cohort 12-Full Stack Engineer-ATLMaleWhite or Caucasian Cohort 12-Full Stack Engineer-ATLMaleWhite or Caucasian Cohort 12-Full Stack Engineer-ATLMaleBlack or African American Cohort 12-Full Stack Engineer-ATLMaleWhite or Caucasian Cohort 12-Full Stack Engineer-DCFemaleBlack or African American Cohort 12-Full Stack Engineer-DCMaleHispanic or Latino Cohort 12-Full Stack Engineer-DCMaleWhite or Caucasian Cohort 12-Full Stack Engineer-DCMaleAsian or Pacific Islander Cohort 12-Full Stack Engineer-DCMaleWhite or Caucasian Cohort 12-Full Stack Engineer-DCFemaleBlack or African American Cohort 12-Full Stack Engineer-DCFemaleAsian or Pacific Islander Cohort 13-Data Analyst-ATLMaleBlack or African American Cohort 13-Data Analyst-ATLFemaleWhite or Caucasian Cohort 13-Data Analyst-ATLMaleAsian or Pacific Islander Cohort 13-Data Analyst-ATLMaleWhite or Caucasian Cohort 13-Data Analyst-ATLMaleWhite or Caucasian Cohort 13-Data Analyst-ATLMaleWhite or Caucasian Cohort 13-Data Analyst-ATLFemaleWhite or Caucasian Cohort 13-Data Analyst-ATLMaleAsian or Pacific Islander Cohort 13-Data Analyst-ATLMaleWhite or Caucasian Cohort 13-Data Analyst-ATLMaleHispanic or Latino Cohort 13-Data Analyst-DCMaleAsian or Pacific Islander Cohort 13-Data Analyst-DCMaleWhite or Caucasian Cohort 13-Data Analyst-DCMaleWhite or Caucasian Cohort 13-Data Analyst-DCMaleWhite or Caucasian Cohort 13-Data Analyst-DCMaleAsian or Pacific Islander Cohort 13-Data Analyst-DCMaleBlack or African American Cohort 13-Data Analyst-DCFemaleAsian or Pacific Islander Cohort 13-Data Analyst-DCMaleBlack or African American Cohort 13-Data Analyst-HOUMaleAsian or Pacific Islander Cohort 13-Data Analyst-HOUFemaleAsian or Pacific Islander Cohort 13-Data Analyst-HOUMaleAsian or Pacific Islander Cohort 13-Data Analyst-HOUMaleHispanic or Latino Cohort 13-Data Analyst-HOUMaleHispanic or Latino Cohort 13-Data Analyst-HOUMaleAsian or Pacific Islander Cohort 15.1-Azure Data EngineerMaleBlack or African American Cohort 15.1-Azure Data EngineerMaleWhite or Caucasian Cohort 15.1-Azure Data EngineerMaleWhite or Caucasian Cohort 15.1-Azure Data EngineerMaleBlack or African American Cohort 15.1-Azure Data EngineerMaleAsian or Pacific Islander Cohort 15.1-Azure Data EngineerMaleAsian or Pacific Islander Cohort 15.1-Azure Data EngineerMaleHispanic or Latino Cohort 15-Azure Data Engineer-COGFemaleAsian or Pacific Islander Cohort 15-Azure Data Engineer-COGMaleAsian or Pacific Islander Cohort 15-Azure Data Engineer-COGMaleWhite or Caucasian Cohort 15-Azure Data Engineer-COGMaleWhite or Caucasian Cohort 15-Azure Data Engineer-COGMaleWhite or Caucasian Cohort 15-Azure Data Engineer-COGMaleAsian or Pacific Islander Cohort 15-Azure Data Engineer-COGMaleWhite or Caucasian Cohort 15-Azure Data Engineer-COGMaleWhite or Caucasian Cohort 15-Azure Data Engineer-COGBlack or African American Cohort 16-AWS Data Engineer-COGMaleWhite or Caucasian Cohort 16-AWS Data Engineer-COGMaleWhite or Caucasian Cohort 16-AWS Data Engineer-COGFemaleBlack or African American Cohort 16-AWS Data Engineer-COGMaleBlack or African American Cohort 16-AWS Data Engineer-COGWhite or Caucasian Cohort 16-AWS Data Engineer-COGMaleWhite or Caucasian Cohort 16-AWS Data Engineer-COGMaleAsian or Pacific Islander Cohort 16-AWS Data Engineer-COGAsian or Pacific Islander Cohort 16-AWS Data Engineer-COGFemaleWhite or Caucasian Cohort 16-AWS Data Engineer-COGAsian or Pacific Islander Cohort 16-AWS Data Engineer-COGMaleWhite or Caucasian Cohort 19-Data Science Analytics-D1MaleHispanic or Latino Cohort 19-Data Science Analytics-D1FemaleWhite or Caucasian Cohort 19-Data Science Analytics-D1MaleHispanic or Latino Cohort 19-Data Science Analytics-D1FemaleAsian or Pacific Islander Cohort 20-UX Engineer-D4MaleHispanic or Latino Cohort 20-UX Engineer-D4FemaleWhite or Caucasian Cohort 20-UX Engineer-D4MaleWhite or Caucasian Cohort 20-UX Engineer-D4MaleHispanic or Latino Cohort 20-UX Engineer-D4MaleMultiracial or Biracial Cohort 20-UX Engineer-D4FemaleAsian or Pacific Islander Cohort 21-UX Designer-D5FemaleHispanic or Latino Cohort 21-UX Designer-D5FemaleWhite or Caucasian Cohort 21-UX Designer-D5FemaleBlack or African American Cohort 21-UX Designer-D5FemaleHispanic or Latino Cohort 21-UX Designer-D5FemaleWhite or Caucasian
Answered Same DayOct 19, 2021

Answer To: Untitled Spreadsheet TP Diversity Report Job TitleLast name, First nameGenderEthnicity Cohort...

Mohd answered on Oct 20 2021
113 Votes
Untitled Spreadsheet
Bar Chart of Ethnicities
Count of Ethnicities
Total    
Asian or Pacific Islander    Black or African American    Hispanic or Latino    Multiracial or Biracial    White or Caucasian    66    34    34    16    92    
Sheet2
    Job Title    (All)
    Row Labels    Count of Ethnicity
    Asian or Pacific Islander    66
    Black or African American    34
    Hispanic or Latino    34
    Multiracial or Biracial    16
    White or Caucasian    92
    Grand Total    242
Pie Chart
Gender Representation
Total    
Female    Male    0.26
890756302521007    0.73109243697478987    
Sheet4
    Row Labels    Count of Gender
    Female    26.89%
    Male    73.11%
    Grand Total    100.00%
Sheet5
    Row Labels    Count of Ethnicity
    Asian or Pacific Islander    66
    Black or African American    34
    Hispanic or Latino    34
    Multiracial or Biracial    16
    White or Caucasian    92
    Grand Total    242
TP Diversity Report
    Job Title    Last name, First name    Gender    Gender_    Ethnicity
    Cohort 1-Business Analyst        Male    0    White or Caucasian
    Cohort 1-Business Analyst        Female    1    White or Caucasian
    Cohort 1-Business Analyst        Male    0    White or Caucasian
    Cohort 1-Business Analyst        Female    1    White or Caucasian
    Cohort 1-Business Analyst        Male    0    White or Caucasian
    Cohort 1-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 1-Business Analyst        Female    1    Asian or Pacific Islander
    Cohort 1-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 1-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 1-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 1-Business Analyst        Female    1    Asian or Pacific Islander
    Cohort 2-Business Analyst        Male    0    Multiracial or Biracial
    Cohort 2-Business Analyst        Male    0    Hispanic or Latino
    Cohort 2-Business Analyst        Male    0    Hispanic or Latino
    Cohort 2-Business Analyst        Male    0    Multiracial or Biracial
    Cohort 2-Business Analyst        Male    0    Hispanic or Latino
    Cohort 2-Business Analyst        Female    1    Black or African American
    Cohort 2-Business Analyst        Male    0    Hispanic or Latino
    Cohort 2-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 2-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 2-Business Analyst        Female    1    Hispanic or Latino
    Cohort 2-Business Analyst        Male    0    White or Caucasian
    Cohort 2-Business Analyst        Male    0    White or Caucasian
    Cohort 2-Business Analyst        Female    1    White or Caucasian
    Cohort 2-Business Analyst        Female    1    White or Caucasian
    Cohort 3-Software Engineer        Male    0    White or Caucasian
    Cohort 3-Software Engineer        Male    0    Multiracial or Biracial
    Cohort 3-Software Engineer        Male    0    White or Caucasian
    Cohort 3-Software Engineer        Male    0    Hispanic or Latino
    Cohort 3-Software Engineer        Female    1    Asian or Pacific Islander
    Cohort 3-Software Engineer        Male    0    Multiracial or Biracial
    Cohort 3-Software Engineer        Male    0    Asian or Pacific Islander
    Cohort 3-Software Engineer        Male    0    White or Caucasian
    Cohort 3-Software Engineer        Male    0    Multiracial or Biracial
    Cohort 3-Software Engineer        Male    0    White or Caucasian
    Cohort 3-Software Engineer        Female    1    Asian or Pacific Islander
    Cohort 3-Software Engineer        Male    0    White or Caucasian
    Cohort 3-Software Engineer        Male    0    White or Caucasian
    Cohort 3-Software Engineer        Male    0    White or Caucasian
    Cohort 4-Business Analyst        Male    0    White or Caucasian
    Cohort 4-Business Analyst        Female    1    Multiracial or Biracial
    Cohort 4-Business Analyst        Female    1    White or Caucasian
    Cohort 4-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 4-Business Analyst        Male    0    Multiracial or Biracial
    Cohort 4-Business Analyst        Female    1    Black or African American
    Cohort 4-Business Analyst        Male    0    White or Caucasian
    Cohort 4-Business Analyst        Female    1    Black or African American
    Cohort 4-Business Analyst        Male    0    Hispanic or Latino
    Cohort 4-Business Analyst        Male    0    Hispanic or Latino
    Cohort 4-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 4-Business Analyst        Male    0    Multiracial or Biracial
    Cohort 4-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 4-Business Analyst        Female    1    Black or African American
    Cohort 4-Business Analyst        Female    1    Black or African American
    Cohort 4-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 4-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 5-Business Analyst        Female    1    Black or African American
    Cohort 5-Business Analyst        Male    0    White or Caucasian
    Cohort 5-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 5-Business Analyst        Female    1    Black or African American
    Cohort 5-Business Analyst        Female    1    Asian or Pacific Islander
    Cohort 5-Business Analyst        Male    0    Asian or Pacific Islander
    Cohort 5-Business Analyst        Female    1    Asian or Pacific Islander
    Cohort 5-Business Analyst        Male    0    Black or African American
    Cohort 5-Business Analyst        Male    0    White or Caucasian
    Cohort 5-Business Analyst        Female    1    Multiracial or Biracial
    Cohort...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here