Comparing Increase in Salary of Males and Females - Desklib

BUSINESS INFORMATION ANALYSIS
STUDENT ID:
[Pick the date]

PART 3
Question 9
The objective is to compare the increase in salary of males and females based on the given
sample data and to examine the issue as to whether the increase in salary of females has been
lesser in comparison to salaries of males.
a) The requisite new columns have been created. The requisite formulas that have been used
are highlighted as shown below.
Length Empl = 2014 – Start Yr
Increase in Salary = Current Salary – Start Salary
Avg Incr = (Increase in Salary/Length Empl)
b) The relevant histogram of the requisite variable is shown below.
From the above histogram, it is apparent that the shape is asymmetric since there is a long tail
on the right side. In case of the histogram being symmetric, the tail on both sides is almost
equal in size. Further, there is presence of right skew or positive skew since there are a
number of values present which seem to be outliers on the higher side. Thus, this clearly

highlights that there are certain employees which tend to have a very high average increase in
salary on an annual basis resulting in asymmetry of distribution (Hillier, 2016).
c) The requisite side by side boxplot summarises the relevant data for average increase in
salaries of males and females indicated below.
The requisite boxplot is shown below.
From the boxplot highlighted above, it is apparent that average salary increase for females is
clearly lesser than the male counterparts. This is apparent in each of the give parameters used
to construct the box plot. For instance, 50% of the female employees have had an average
annual salary increase of $ 1,393 or less in comparison to the corresponding figure for $
1,474 in case of males. This trend is visible for other aspects such as 75th percentile along
with the maximum value which are both lesser for female employees as compared to the
males (Eriksson and Kovalainen, 2015).