Explanation
The data set
2400 employees. Pie: Sales 25% · Tech 40% · HR 10% · Ops 25%. Table: females in each department: Sales 40% · Tech 30% · HR 60% · Ops 30%.
Every question in this level uses it.
Pie (departments) + table (female %) side by side
Mixed charts give you two layers. The pie splits the total; the table splits each slice further.
Pie (departments) + table (female %) side by side
Department sizes
First turn the pie into numbers: sales six hundred, tech nine sixty, HR two forty, operations six hundred.
Department sizes: 600, 960, 240, 600
Females
Then apply each department's female percentage: two forty, two eighty-eight, one forty-four, one eighty.
Females: 240, 288, 144, 180
Total females = 852
Add them for the total: eight hundred fifty-two women.
Total females = 852
HR female
Ratios inside one department: HR has one forty-four women and ninety-six men: three to two.
HR female : male = 144 : 96 = 3 : 2
Worked example
Male employees in Tech = 960 − 288 = 672.