Data in our study include information about 112 employees. The following variables are used in the Excel file:

CSAL: Salary at the time of study

HSAL: Salary at the time of hiring

GNDR: Male & Female

RANK: Seniority in months at time of hiring at company

AGE: Age (in months) at the time of hiring

XPRN: Months of work experience

EDUC: High School, College, University

Question: Management recognizes the disparities in the salaries between males and females working for the institution. But management claims that female salaries are catching up to males and that at the time of the study no more than 50 percent of the female employees had incomes below the average HSAL for the company as a whole. Test the validity of the claim and comment on the statement that female salaries are catching up to males.

CSAL HSAL GNDR

9000 5100 Female

12480 6300 Male

11760 5700 Female

13920 6600 Male

13020 5400 Female

9240 4380 Female

8340 4500 Female

8160 4500 Female

13320 6000 Female

14460 5700 Male

7860 4380 Female

12600 7500 Female

13560 6300 Male

15120 6600 Male

11760 6300 Male

8880 6600 Female

12120 6600 Female

14220 5340 Female

9060 4500 Female

14280 6900 Female

9360 4500 Female

13260 6600 Male

10980 5880 Male

10920 4500 Female

7860 4500 Female

10560 4200 Female

13416 6300 Male

10440 4620 Female

13020 7200 Female

11100 6600 Male

11100 7800 Female

9240 4500 Female

9060 4500 Female

11940 6300 Male

8700 4500 Female

11340 6000 Male

11760 6600 Female

13560 6600 Male

9180 4200 Female

13800 4860 Female

11040 6000 Male

8160 4500 Female

8280 4500 Female

11400 4500 Female

11520 7200 Male

9300 5700 Male

11400 4200 Female

8520 4500 Female

8640 4800 Female

9360 5400 Female

10200 4800 Female

11940 6300 Male

10860 6600 Male

11280 5100 Female

10680 4620 Female

11160 4980 Female

11160 5400 Female

14640 7200 Female

15420 6600 Female

9840 5400 Female

12660 6300 Male

11220 6000 Male

9660 4620 Female

9960 4500 Female

9780 4980 Female

9180 5580 Female

11520 5580 Female

7260 4380 Female

11700 4620 Female

12240 4980 Female

12120 6300 Male

12660 5700 Male

8940 4500 Female

10200 4800 Female

9600 4500 Female

10080 5580 Female

9360 4500 Female

9120 4500 Female

13020 5700 Male

9900 4380 Female

9300 6300 Female

13140 7800 Female

13800 6900 Female

10980 6300 Male

12108 6300 Male

9720 4380 Female

12540 4440 Female

14820 7200 Female

8340 5400 Female

8040 4500 Female

9780 4800 Female

13200 7200 Female

15960 6300 Male

32000 6300 Male

9120 4500 Female

8820 4380 Female

10620 6000 Male

16800 6000 Male

17364 6300 Male

10800 6000 Male

11040 4560 Female

13560 6600 Male

11664 6000 Female

10560 5400 Female

11760 6120 Female

9540 5100 Female

15660 6300 Male

9000 6600 Male

10140 6300 Male

8580 5100 Female

9660 5400 Female

8580 5100 Female