Excel IT sample data of various ethnicity

excel example

1. Excel Functions for HR Data Analysis Using COUNT, COUNTIF, and COUNTIFS to analyze employee demographics by Beatrice Martey

2. Counting Ethnic Groups 1 COUNTIF Function Count employees by ethnicity 2 Formula Structure =COUNTIF(range,"criteria") 3 Application Count Asians, Blacks, Latinos, Caucasians

3. Filtering by Multiple Criteria Asian Females in IT COUNTIFS with ethnicity and department criteria Formula Structure =COUNTIFS(range1,"criteria1",range2,"criteria2") Application Count where ethnicity="Asian" AND department="IT"

4. Calculating Percentages Caucasians in IT COUNTIFS divided by department total Formula =COUNTIFS/COUNT*100 Application Percentage of IT employees who are Caucasian

5. Gender Distribution Analysis Female Percentage Female count divided by total employees Formula =COUNTIF/COUNT*100 Visualization Present as percentage or pie chart

6. Geographic Analysis 1 Identify Data Locate residence column 2 Apply COUNTIFS Filter for US residents in IT department 3 Calculate Count where residence="US" AND department="IT"

7. Complex Filtering Multiple Criteria Combine ethnicity, location, department COUNTIFS Function Three conditions in one formula Result Black US residents in Finance

8. Excel Function Summary COUNT Total number in a range COUNTIF Count with one condition COUNTIFS Count with multiple conditions Percentage Calculation Count/Total*100