Cenin
New Member
- Joined
- Jan 30, 2023
- Messages
- 23
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
It would be better if you could include all the relevant circumstances & expected results when you first ask the question.One more thing required
France Exec Gender Gap Analysis.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Gender | PC | Total Average on PC. | Average on PC, Male & Female. | Expected | Expected | ||
2 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
3 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
4 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
5 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
6 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
7 | F | 57 | 94997 | 96447 | 1,70% | 1,53% | ||
8 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
9 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
10 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
11 | M | 57 | 94997 | 94836 | 1,70% | 1,53% | ||
12 | M | 58 | 143171 | 143171 | 0,00% | 0,00% | ||
13 | M | 58 | 143171 | 143171 | 0,00% | 0,00% | ||
14 | F | 59 | 134378 | 118521 | -13,50% | -11,80% | ||
15 | M | 59 | 134378 | 137021 | -13,50% | -11,80% | ||
16 | M | 59 | 134378 | 137021 | -13,50% | -11,80% | ||
17 | M | 59 | 134378 | 137021 | -13,50% | -11,80% | ||
18 | M | 59 | 134378 | 137021 | -13,50% | -11,80% | ||
19 | M | 59 | 134378 | 137021 | -13,50% | -11,80% | ||
20 | M | 59 | 134378 | 137021 | -13,50% | -11,80% | ||
21 | F | 60 | 143173 | 143173 | 0,00% | 0,00% | ||
22 | F | 60 | 143173 | 143173 | 0,00% | 0,00% | ||
France Gender Gap bw M&F 1 |
Surely the possibilities are always that a PC group might contain ...The requirement changes frequently that's why i am unable to give all the circumstances at once.
Cenin.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Gender | PC | Total Average on PC. | Average on PC, Male & Female. | Expected | Expected | ||
2 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
3 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
4 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
5 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
6 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
7 | F | 57 | 94997 | 96447 | 1.70% | 1.53% | ||
8 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
9 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
10 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
11 | M | 57 | 94997 | 94836 | 1.70% | 1.53% | ||
12 | M | 58 | 143171 | 143171 | 0.00% | 0.00% | ||
13 | M | 58 | 143171 | 143171 | 0.00% | 0.00% | ||
14 | F | 59 | 134378 | 118521 | -13.50% | -11.80% | ||
15 | M | 59 | 134378 | 137021 | -13.50% | -11.80% | ||
16 | M | 59 | 134378 | 137021 | -13.50% | -11.80% | ||
17 | M | 59 | 134378 | 137021 | -13.50% | -11.80% | ||
18 | M | 59 | 134378 | 137021 | -13.50% | -11.80% | ||
19 | M | 59 | 134378 | 137021 | -13.50% | -11.80% | ||
20 | M | 59 | 134378 | 137021 | -13.50% | -11.80% | ||
21 | F | 60 | 143173 | 143173 | 0.00% | 0.00% | ||
22 | F | 60 | 143173 | 143173 | 0.00% | 0.00% | ||
Sheet4 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2:E22 | E2 | =IF(ROWS(UNIQUE(FILTER(A$2:A$22,B$2:B$22=B2)))=1,0,MAXIFS(D$2:D$22,B$2:B$22,B2,A$2:A$22,"F")/MAXIFS(D$2:D$22,B$2:B$22,B2,A$2:A$22,"M")-1) |
F2:F22 | F2 | =IF(E2=0,0,MAXIFS(D$2:D$22,B$2:B$22,B2,A$2:A$22,"F")/C2-1) |
Eviosys Gender GAP - Copie.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Gender | Country/Region | PC | FEMALE AVG ON MALE | Expected result | ||
2 | F | Belgium | 49 | 5,80% | 2,97% | ||
3 | F | Belgium | 52 | 0,14% | 2,97% | ||
4 | F | Belgium | 52 | 0,14% | 2,97% | ||
5 | M | Belgium | 49 | 5,80% | 2,97% | ||
6 | M | Belgium | 52 | 0,14% | 2,97% | ||
7 | F | UK | 49 | 5,00% | 5,50% | ||
8 | F | UK | 52 | 5,00% | 5,50% | ||
9 | F | UK | 52 | 5,00% | 5,50% | ||
10 | M | UK | 49 | 6,00% | 5,50% | ||
11 | M | UK | 52 | 6,00% | 5,50% | ||
Sheet3 |
Surely the possibilities are always that aPCCountry group might contain ...
.. so any sample data should also contain each of those possibilities.
- Both M and F entries
- Only F entries
- Only M entries