Statistical functions power advanced analytics: salary variance for pay equity, percentiles for performance benchmarking, standard deviation for quality control, median for outlier-resistant averages.

HR Compensation Analysis

Analyze salary distribution and variance for pay equity

HR Compensation Analysis

SELECT department, AVG(salary), STDDEV(salary), PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary) AS median FROM employees GROUP BY department;

HR identifies departments with high salary variance indicating potential pay equity issues. Median provides outlier-resistant comparison.

All