QA - Descriptive Statistics and variable relationships HW1
mrfamo01
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 |