Untitled
Untitled
Untitled
Corporate $28,623,948
Manufacturing $27,882,219
Research & Development $25,760,257
Speciality Products $30,950,941
Business Unit Age Sum of Age Total
Corporate 10522 70
25 50
60
26 104
27 243 50
28 308
40
29 174
30 120 30
31 217
32 192 20
33 165 10
34 102
36 0
288 Corporate Manufacturing Research & Development Speciality Pr
37 148
38 190
39 273
40 240
41 369
42 210
43 86
44 176
45 810
46 368
47 329
48 432
49 245
50 250
51 357
52 416
53 265
54 216
55 605
56 224
57 399
58 174
59 236
60 540
61 244
62 248
63 252
64 192
65 65
Manufacturing 11977
25 225
26 104
27 108
28 140
29 261
30 240
31 155
32 192
33 297
34 272
35 315
36 360
37 259
38 114
39 117
40 280
41 164
42 378
43 215
44 264
45 675
46 414
47 235
48 240
49 343
50 450
51 255
52 208
53 265
54 378
55 825
56 280
57 285
58 232
59 177
60 420
61 244
62 186
63 567
64 448
65 390
Research & Development 10363
25 100
26 78
27 189
28 112
29 174
30 300
31 124
32 32
33 132
34 170
35 105
36 216
37 407
38 38
39 156
40 280
41 205
42 378
43 215
44 88
45 675
46 322
47 94
48 432
49 245
50 200
51 357
52 520
53 265
54 324
55 825
56 168
57 171
58 406
59 354
60 180
61 244
62 310
63 126
64 256
65 390
Speciality Products 11520
25 175
26 156
27 162
28 252
29 174
30 210
31 310
32 224
33 264
34 238
35 210
36 216
37 222
38 342
39 195
40 240
41 328
42 84
43 344
44 220
45 1080
46 230
47 329
48 384
49 196
50 150
51 255
52 416
53 371
54 432
55 495
56 224
57 228
58 58
59 354
60 180
61 366
62 248
63 252
64 576
65 130
Total Result 44382
Total
Age
10000000
5000000
0
Accounting Engineering Finance Human IT
Resources
l Salary*Bonus % by Department
Tota
1200
1000
800
600
400
200
Female
Male
Female
Male
Female
Male
Corporate Corpo- Manufacturing Manu- Research & De-
rate facturing velopment
Result Result
Speciality Products
Manufacturing
Corporate
Corporate
Sales 33 400
Research & Development 229 200
Accounting 18 0
Finance
Finance
Engineering
Sales
Engineering
Human Resources
IT
IT
Human Resources
Accounting
Marketing
Accounting
Engineering 43
Finance 25
Human Resources 28
IT 55
Marketing 27 Corporate Manufacturin
Sales 33
Speciality Products 265
Accounting 29
Engineering 47
Finance 28
Human Resources 36
IT 52
Marketing 32
Sales 41
Total Result 1000
Tot
45.5
43.5
43
42.5
Corporate Manufacturing Research &
Development
Bonus %
45%
40%
35%
30%
25%
20%
15%
10%
5%
0%
9/1/1992 9/1/1995 9/1/1998 9/1/2001 9/1/2004 9/1/2007 9/1/2010 9/1/2013 9/1/2016
11. Generate a graph of the Average bonus vs Business Unit.
Average of Bonus % by
Speciality Products
Manufacturing
Corporate
0 0.0
0.08
7%
0.06
5%
0.04
0.02
0
Accounting Engineering Finance Human IT
Resources
13. Generate a graph of the Average bonus vs Job Title.
8
Total
12
Engineering 10
455%
Finance 748%
Human Resources 8
707%
IT 584%
Marketing 652%
6
Sales 623%
Male 4,412%
4
Accounting 384%
Engineering 677%
2
Finance 591%
Human Resources 634%
0
IT 737%
Female Male
Marketing 839%
Sales 550%
Total Result 8,866%
15. Create a Pie chart, Bar graph and a density graph for comparing count of ethnicity against department.
Ethnicity Department Count of Ethnicity
Asian Accounting 41
Human Resources 50
Finance 51 100
Marketing 55 90
80
Engineering 56 70
Sales 58 60
50
IT 93 40
30
Black Accounting 3 20
Engineering 7 10
0
Marketing 8
Finance
Finance
Human Resources
Engineering
Sales
IT
Accounting
Marketing
Accounting
Engineering
Marketing
Finance 9
Sales 13
Human Resources 14
IT 20
Asian Black
Caucasian Finance 27
Human Resources 28
Accounting 32
Sales 32
Marketing 33
Engineering 44
IT 75
Latino Accounting 20
Marketing 24
Finance 33
Human Resources 33
Sales 37
Engineering 51
IT 53
Chongqing 65 100
Columbus 113 80
Manaus 42 60
Miami 112 40
Phoenix 109 20
Rio de Janerio 44 0
n g du go ng s s
Sao Paulo 53 sti jin ng qi bu au
Au Be
i
e ica g m an M
Seattle 118 Ch Ch on lu M
Ch Co
Shanghai 52
Male
52%
Annual Salary*Bonus %
Mean 113217
Standard Error 1693
Median 96557
Mode 146140
Standard Deviation 53546
Sample Variance 2867172579
Kurtosis 0
Skewness 1
Range 218435
Minimum 40063
Maximum 258498
Sum 113217365
Count 1000
70000000
60000000
50000000
40000000
30000000
20000000
10000000
0
Brazil China United States
Total
Male
Female
Male
lary*Bonus % by
ss Unit
Corporate
IT
Marketing
Sales
Accounting
Engineering
Finance
Human Resources
IT
Manufacturing
Marketing
Sales
000 20000000 30000000 40000000
Accounting
Engineering
Finance
Human Resources
velopment
IT
Total
Accounting
Engineering
Finance
Human Resources
IT
Marketing
Sales
t
R
ul
ta
es
Speciality Products To
Count of Business Unit
Total
Average of Age
0.08864628820960
arch & Development 7
Manufacturing 0.07040892193308
56
0.10236286919831
Corporate
2
f Bonus % by Department
12%
11%
11%
8%
5%
Total
Finance
Marketing
Asian
Engineering
Sales
IT
Male
Accounting
nst department.
Engineering
Marketing
Total
Finance
Black
Sales
Human Resources
IT
Finance
Human Resources
Accounting
Sales
Total
Marketing
Caucasian
Total Result
Engineering
IT
Accounting
Marketing
Finance
Human Resources
Department
Latino
Sales
Engineering
IT
Count of Ethnicity
Total
ce es IT ng le
s
an urc eti Sa
i n so rk
F a
Re M
an
m
Hu
Total
Count of Country
o s s i ix ai
ag ng bu au m en rio ul
o
ttl
e
g qi m an ia o ne Pa a ngh
on lu M M Ph J a o Se a
Ch Co de Sa Sh
R io
Total
Total
Female
Male 48%
52%
Total
Mean 44.382
Standard Error 0.355661
Median 45
Mode 45
Standard Deviation 11.24698
Sample Variance 126.4946
Kurtosis -1.081123
Skewness 0.022987
Range 40
Minimum 25
Maximum 65
Sum 44382
Count 1000
4. Display the graph of Annual salary vs Gender.
58000000
57000000
56000000
55000000
54000000
53000000
Female
nual Salary*Bonus % by Gender
ale Male