Business Statistic Assignment

...

(ii) Table 3a(ii)

Gender

Count of Gender

Males (0)

32.7%

Females (1)

67.3%

Grand Total

100.0%

- These three pivot tables (Exhibits 1, 2 and 3) are different because:

- The first Exhibit is the percentage of row total.

- The second Exhibit is the percentage of column total.

- The last Exhibit is the percentage of grand total.

-

(i) Table 3c(i)

Gender

Average of Salary

Males (0)

$65,505.4

Females (1)

$57,209.9

Grand Total

$59,921.9

Table 3c(ii)

Count of Employee

Gender

EducLev

0(Males)

1(Females)

Grand Total

1

1.4%

15.9%

17.3%

2

2.9%

13.9%

16.8%

3

9.6%

20.7%

30.3%

4

1.4%

2.4%

3.8%

5

17.3%

14.4%

31.7%

Grand Total

32.7%

67.3%

100.0%

(ii)

According to table 3b(i), it is obviously that the average of Salary of Females is lower than Males, which is $57,209.9 compared to $65,505.4. Although, the percentage of Females is working at the bank is 67.3% out of 208 people, according to table 3a(ii), however, the average of Salary of Females is still lower than the average of Salary of Males. Furthermore, look up table 3b(ii), most of the percentage of educational levels of Females are also higher than the percentage of educational levels of Males. For instance, the percentage of Females who obtained a bachelor’s degree is 20.7% which is double the percentage of Males who obtained a bachelor’s degree – 9.8%. However, females are getting pay less than males, due to the average of Salary in table 3b(i).

Therefore, we can conclude that, there is existing a discrimination which against females in terms of salary paid.

- (i) Table 3d(i)

Average of Salary

Gender

JobGrade

0(Males)

1(Females)

Grand Total

1

$51,079.2

$52,649.2

$52,335.2

2

$54,216.9

$54,865.2

$54,664.5

3

$59,328.6

$58,535.6

$58,664.7

4

$63,845.5

$64,350.6

$64,152.1

5

$69,750.0

$71,100.0

$70,328.6

6

$90,923.1

$50,000.0

$88,000.0

Grand Total

$65,505.4

$57,209.9

$59,921.9

According to table 3d(i), the higher of job grade that Males get, the higher the average of salary. However, it is a reverse for Females in grade 6. So, from grade 1 to grade 5, the higher of job grade that Females get, the higher the average of salary, but in grade 6, Males will get $90.923.1 in average compare to Females - $50,000. There is more than $40,000 in different.

Table 3d(ii)

Average of Salary

Gender

EducLev

0(Males)

1(Females)

Grand Total

1

$59,933.3

$55,176.1

$55,572.5

2

$51,970.0

$55,131.0