Question seems simple but I can not get working formula, already desperate.
I have to calculate gender pay gap. And for it need following:
Imagine column B =gender of employees (male/female), colum C – total remuneration. Need to calculate average and median total remuneration of only male employees in quartile 1 of data. (And then in Q2, Q3, Q4).
By googling I have found some formulas that contain References to values of Q1, Q2, Q3, Q4 – it’s not correct statistically, as, e.g.employees from Q2 can have same total remuneration as employees in Q1…