In: Accounting
We would like to understand by department whether there is a
significant pay difference between men and women in 2017 (average
gross salary by gender per pay period).
The gender is coming from the employee_info as 'M' and 'F'
AND the gross salary is coming from the payroll_register.
What would be the query?
calculation of gross salary for gender per pay period
from pay-roll registry salary of two genders M ,F shall be taken into two separate considerations.
Gross salary of that specific group can be obtained by multiplying salaries to employees worked ( if they are under common amount of pay scale) other wise compounding can be used for different pay- scales.
By above method total gross salary of separate gender can be obtained.
average salary employee per pay period
average salary
average salary of such specific group can be caluculated by dividing total gross salary to number of employed o that group.
[Total gross salary ÷no. of employees]
average salary per employee per pay period
average salary per employee per period can be obtained by dividing average salary to pay period.
=( average salary ÷ pay period)
NOTE: pay period may be monthly or yearly basis as may be followed
Deviation in pay scale can be obtained by comparing both the amounts of average gross salary per employee per pay period.
with regards
Thank you
Please do like the answer if it is satisfactory.