The Pay and Employment Equity Analysis Tool (PEEAT) suite has been developed to assist organisations assess the impact of gender on the pay and participation of women using quantitative HR and Payroll data. The PEEAT user guide leads you through the process of collecting the data, preparing a gender profile and analysing the data.

The suite comprises an Excel workbook, Excel 2003 and 2007, and the R statistical regression programme. PEEAT works by the organisation collating personal, job and remuneration information and entering the data into the PEEAT workbook, which then analyses factors associated with pay and employment outcomes for women and men. It then allows users to obtain a breakdown of human resources information by gender, and allows for an analysis of the distribution of earnings for men and women.

The tables and charts produced by PEEAT show, for both men and women:

1. Distribution of Employees by Job Classification
2. Distribution of Employees by Grade
3. Average Annual Full Time Equivalent Remuneration by Job Classification
4. Average Annual Full Time Equivalent Remuneration by Job Grade
5. Proportion of Employees in Bands of Hours
6. Percentage of Employees in Each Level
7. Term of Employment
8. Percentage of those Receiving and Not Receiving Bonuses
9. Composition of Full Time Equivalent Annual Remuneration
10. Employees in Red-Circled or Market-Rated Jobs
11. Job Size by Full Time Equivalent Remuneration
12. Employees by Grade by Average Hourly Remuneration by Average Job Size
13. Ratio of Hourly Pay by Occupation
14. Occupation by Starting Rate

Although these charts and tables provide examples of analysis that has been found most useful in other pay and employment equity reviews, they are not exclusive of any other analyses you may find relevant.

More advanced analysis using ‘R’ regression analysis is also available, and scatter plots and box-and-whisker plots can be used, to identify and depict how remuneration relates to the other variables collected in the data.