QA - Descriptive Statistics and variable relationships HW1

profilemrfamo01
HW_012.xlsx

Sheet1

Employee Gender Age Working Experience Salary
1 1 Middle-aged 8 $122,748
2 0 Middle-aged 15 $41,967
3 0 Middle-aged 20 $63,642
4 1 Young 5 $97,785
5 1 Middle-aged 1 $82,218
6 1 Middle-aged 16 $127,638
7 1 Middle-aged 2 $55,958
8 0 Middle-aged 12 $73,629
9 1 Middle-aged 7 $127,108
10 0 Middle-aged 1 $91,767
11 0 Elderly 13 $80,366
12 1 Middle-aged 15 $109,183
13 1 Middle-aged 6 $80,445
14 0 Elderly 5 $30,020
15 1 Young 22 $37,255
16 1 Middle-aged 1 $96,180
17 1 Middle-aged 1 $45,424
18 0 Elderly 16 $85,526
19 1 Elderly 7 $67,073
20 0 Young 14 $127,725
21 1 Elderly 3 $61,803
22 1 Elderly 7 $34,199
23 0 Elderly 21 $85,906
24 1 Middle-aged 13 $79,877
25 1 Middle-aged 2 $71,281
26 1 Middle-aged 5 $55,269
27 0 Middle-aged 6 $26,600
28 1 Elderly 12 $102,900
29 1 Young 3 $84,837
30 1 Middle-aged 5 $106,185
31 1 Middle-aged 13 $48,213
32 1 Young 18 $71,679
33 0 Young 1 $74,707
34 1 Elderly 1 $80,440
35 1 Elderly 13 $92,094
36 0 Young 7 $54,291
37 0 Middle-aged 3 $85,534
38 0 Middle-aged 1 $71,370
39 1 Middle-aged 8 $39,733
40 0 Young 9 $59,892
41 1 Middle-aged 4 $38,097
42 1 Middle-aged 5 $144,884
43 1 Middle-aged 1 $48,251
44 1 Middle-aged 19 $91,778
45 0 Middle-aged 23 $96,961
46 1 Middle-aged 6 $83,939
47 1 Middle-aged 23 $41,734
48 0 Middle-aged 11 $148,408
49 1 Young 2 $79,709
50 0 Middle-aged 5 $86,896
51 1 Young 13 $86,913
52 0 Middle-aged 21 $43,267
53 1 Middle-aged 14 $88,636
54 0 Elderly 12 $111,391
55 1 Middle-aged 23 $85,110
56 1 Young 5 $132,182
57 0 Middle-aged 3 $101,475
58 0 Middle-aged 5 $72,888
59 1 Elderly 7 $140,022
60 1 Elderly 8 $144,335
61 0 Middle-aged 4 $77,506
62 1 Middle-aged 1 $106,139
63 0 Young 7 $93,790
64 0 Young 3 $98,341
65 0 Middle-aged 19 $133,741
66 0 Young 4 $88,427
67 0 Middle-aged 2 $144,518
68 0 Elderly 12 $72,239
69 0 Middle-aged 3 $74,438
70 1 Middle-aged 10 $59,629
71 0 Elderly 3 $79,122
72 1 Middle-aged 13 $75,892
73 1 Elderly 10 $127,032
74 1 Middle-aged 1 $65,626
75 1 Young 7 $103,667
76 0 Young 11 $131,312
77 0 Middle-aged 1 $109,677
78 0 Elderly 1 $111,921
79 0 Elderly 15 $83,914
80 1 Young 5 $69,622
81 1 Middle-aged 1 $52,163
82 1 Middle-aged 18 $96,274
83 1 Elderly 15 $54,784
84 1 Middle-aged 1 $97,814
85 1 Middle-aged 9 $77,804
86 0 Middle-aged 7 $103,419
87 1 Middle-aged 13 $91,844
88 1 Young 5 $84,163
89 0 Elderly 16 $46,015
90 0 Young 8 $64,443
91 1 Middle-aged 7 $90,218
92 1 Young 3 $110,627
93 0 Middle-aged 4 $58,608
94 1 Middle-aged 5 $115,555
95 0 Elderly 9 $44,155
96 0 Young 24 $60,375
97 1 Middle-aged 6 $115,659
98 1 Middle-aged 3 $77,152
99 1 Middle-aged 13 $132,176
100 1 Middle-aged 16 $53,306
101 1 Young 19 $41,978
102 1 Elderly 5 $72,423
103 0 Middle-aged 14 $49,165
104 1 Middle-aged 1 $92,888
105 0 Middle-aged 4 $108,552
106 1 Middle-aged 17 $111,796
107 0 Middle-aged 19 $51,612
108 1 Middle-aged 2 $81,099
109 0 Middle-aged 1 $74,219
110 1 Elderly 15 $57,217
111 1 Middle-aged 4 $43,824
112 1 Middle-aged 8 $64,658
113 0 Middle-aged 4 $92,025
114 0 Middle-aged 4 $51,169
115 1 Middle-aged 18 $124,005
116 0 Middle-aged 8 $82,101
117 0 Young 19 $111,213
118 1 Elderly 15 $71,078
119 1 Elderly 18 $124,798
120 1 Middle-aged 17 $36,564
121 0 Elderly 4 $82,327
122 1 Middle-aged 4 $119,992
123 0 Elderly 12 $160,134
124 0 Middle-aged 1 $92,538
125 1 Middle-aged 7 $46,243
126 1 Middle-aged 1 $104,772
127 0 Middle-aged 10 $85,603
128 1 Elderly 4 $75,997
129 1 Elderly 2 $84,313
130 1 Young 12 $98,889
131 1 Elderly 4 $28,124
132 1 Young 15 $79,212
133 1 Middle-aged 7 $85,301
134 1 Middle-aged 6 $59,157
135 0 Middle-aged 12 $70,989
136 0 Middle-aged 4 $65,992
137 0 Elderly 16 $46,848
138 1 Young 18 $45,950
139 1 Middle-aged 13 $78,500
140 0 Middle-aged 7 $88,561
141 1 Middle-aged 15 $121,206
142 1 Elderly 13 $109,315
143 1 Middle-aged 15 $85,732
144 1 Elderly 1 $41,774
145 1 Elderly 12 $80,193
146 1 Middle-aged 2 $76,193
147 1 Elderly 4 $57,429
148 1 Middle-aged 14 $37,929
149 0 Young 14 $65,563