QA - Descriptive Statistics and variable relationships HW2
mrfamo01
HW_021.xlsx
Sheet1
| Employee | Gender | Age | Prior Experience | Education | Annual Salary |
| 1 | 1 | 49 | 5 | 2 | 45900 |
| 2 | 0 | 28 | 10 | 6 | 79300 |
| 3 | 1 | 44 | 20 | 6 | 108600 |
| 4 | 1 | 48 | 0 | 6 | 68200 |
| 5 | 0 | 50 | 0 | 2 | 65200 |
| 6 | 1 | 48 | 12 | 4 | 95600 |
| 7 | 1 | 30 | 16 | 4 | 103100 |
| 8 | 1 | 41 | 20 | 4 | 143500 |
| 9 | 0 | 35 | 11 | 4 | 78200 |
| 10 | 1 | 28 | 3 | 4 | 40200 |
| 11 | 1 | 33 | 8 | 4 | 60500 |
| 12 | 1 | 61 | 0 | 4 | 40500 |
| 13 | 1 | 53 | 10 | 4 | 73800 |
| 14 | 1 | 48 | 4 | 4 | 45300 |
| 15 | 0 | 47 | 9 | 4 | 61400 |
| 16 | 1 | 48 | 4 | 6 | 64800 |
| 17 | 1 | 55 | 11 | 6 | 75600 |
| 18 | 0 | 32 | 1 | 6 | 95800 |
| 19 | 0 | 60 | 11 | 8 | 126700 |
| 20 | 0 | 50 | 10 | 4 | 67000 |
| 21 | 1 | 49 | 16 | 4 | 102600 |
| 22 | 0 | 22 | 4 | 4 | 52000 |
| 23 | 1 | 51 | 9 | 4 | 76000 |
| 24 | 1 | 22 | 0 | 8 | 83000 |
| 25 | 1 | 47 | 8 | 4 | 80800 |
| 26 | 1 | 41 | 10 | 6 | 91100 |
| 27 | 0 | 24 | 3 | 0 | 30100 |
| 28 | 1 | 64 | 5 | 4 | 55700 |
| 29 | 1 | 43 | 0 | 4 | 51400 |
| 30 | 0 | 22 | 3 | 4 | 43800 |
| 31 | 1 | 59 | 0 | 4 | 25000 |
| 32 | 0 | 32 | 10 | 2 | 80600 |
| 33 | 1 | 45 | 8 | 2 | 39600 |
| 34 | 0 | 47 | 0 | 2 | 13400 |
| 35 | 1 | 29 | 6 | 4 | 88200 |
| 36 | 0 | 61 | 9 | 6 | 109100 |
| 37 | 1 | 57 | 3 | 4 | 34200 |
| 38 | 1 | 65 | 4 | 4 | 57800 |
| 39 | 0 | 34 | 6 | 4 | 68100 |
| 40 | 0 | 54 | 6 | 6 | 94900 |
| 41 | 1 | 30 | 5 | 6 | 63200 |
| 42 | 1 | 39 | 6 | 4 | 82700 |
| 43 | 0 | 32 | 7 | 6 | 85600 |
| 44 | 1 | 24 | 2 | 2 | 27100 |
| 45 | 0 | 40 | 10 | 4 | 69800 |
| 46 | 0 | 52 | 13 | 4 | 81300 |
| 47 | 0 | 28 | 11 | 4 | 78400 |
| 48 | 0 | 53 | 20 | 6 | 127300 |
| 49 | 0 | 43 | 0 | 4 | 93700 |
| 50 | 0 | 30 | 5 | 6 | 74400 |
| 51 | 0 | 46 | 3 | 4 | 48300 |
| 52 | 1 | 38 | 10 | 6 | 98900 |
| 53 | 0 | 28 | 0 | 4 | 73300 |
| 54 | 1 | 46 | 11 | 6 | 117300 |
| 55 | 1 | 30 | 5 | 0 | 37800 |
| 56 | 1 | 43 | 6 | 4 | 77400 |
| 57 | 1 | 29 | 11 | 8 | 111200 |
| 58 | 0 | 48 | 11 | 4 | 75300 |
| 59 | 0 | 42 | 7 | 4 | 96900 |
| 60 | 0 | 18 | 10 | 6 | 123600 |
| 61 | 0 | 35 | 6 | 4 | 55200 |
| 62 | 1 | 22 | 0 | 0 | 12400 |
| 63 | 1 | 44 | 4 | 4 | 73900 |
| 64 | 1 | 47 | 20 | 4 | 94100 |
| 65 | 1 | 34 | 10 | 4 | 74300 |
| 66 | 1 | 37 | 11 | 4 | 66900 |
| 67 | 1 | 49 | 0 | 2 | 12500 |
| 68 | 0 | 32 | 0 | 6 | 90200 |
| 69 | 1 | 37 | 5 | 4 | 59000 |
| 70 | 1 | 29 | 10 | 6 | 114700 |
| 71 | 0 | 24 | 7 | 2 | 71700 |
| 72 | 0 | 43 | 20 | 0 | 125500 |
| 73 | 1 | 54 | 11 | 4 | 100200 |
| 74 | 1 | 26 | 0 | 6 | 45400 |
| 75 | 0 | 47 | 10 | 4 | 72200 |
| 76 | 1 | 31 | 5 | 4 | 69500 |
| 77 | 0 | 33 | 11 | 4 | 67900 |
| 78 | 0 | 42 | 2 | 6 | 67500 |
| 79 | 1 | 34 | 2 | 4 | 31800 |
| 80 | 1 | 59 | 0 | 2 | 27800 |
| 81 | 1 | 43 | 5 | 6 | 60200 |
| 82 | 1 | 30 | 2 | 4 | 34500 |
| 83 | 1 | 45 | 7 | 6 | 87000 |
| 84 | 1 | 50 | 0 | 2 | 12500 |
| 85 | 0 | 23 | 0 | 8 | 122700 |
| 86 | 1 | 44 | 5 | 4 | 56200 |
| 87 | 0 | 48 | 10 | 2 | 56900 |
| 88 | 1 | 47 | 4 | 4 | 66000 |
| 89 | 0 | 20 | 11 | 4 | 76000 |
| 90 | 1 | 31 | 0 | 2 | 44100 |
| 91 | 0 | 30 | 0 | 4 | 78500 |
| 92 | 1 | 42 | 5 | 4 | 71800 |
| 93 | 1 | 25 | 9 | 6 | 80700 |
| 94 | 1 | 24 | 2 | 2 | 47800 |
| 95 | 0 | 36 | 13 | 4 | 105000 |
| 96 | 0 | 32 | 6 | 6 | 100700 |
| 97 | 1 | 27 | 2 | 0 | 18300 |
| 98 | 0 | 55 | 12 | 6 | 110600 |
| 99 | 0 | 36 | 0 | 4 | 36800 |
| 100 | 1 | 22 | 0 | 6 | 45500 |
| 101 | 1 | 25 | 0 | 6 | 71400 |
| 102 | 1 | 47 | 5 | 4 | 74300 |
| 103 | 0 | 43 | 16 | 8 | 160600 |
| 104 | 1 | 53 | 0 | 6 | 52500 |
| 105 | 0 | 38 | 5 | 4 | 65000 |
| 106 | 0 | 39 | 12 | 4 | 104500 |
| 107 | 1 | 35 | 5 | 4 | 85000 |
| 108 | 1 | 23 | 3 | 8 | 110200 |
| 109 | 0 | 43 | 10 | 4 | 80100 |
| 110 | 1 | 33 | 3 | 4 | 40000 |
| 111 | 1 | 44 | 10 | 4 | 55900 |
| 112 | 1 | 33 | 0 | 4 | 64600 |
| 113 | 1 | 31 | 0 | 6 | 68600 |
| 114 | 1 | 36 | 7 | 4 | 65100 |
| 115 | 1 | 45 | 13 | 4 | 111700 |
| 116 | 1 | 45 | 12 | 4 | 62000 |
| 117 | 0 | 39 | 2 | 4 | 55800 |
| 118 | 0 | 45 | 5 | 2 | 54600 |
| 119 | 0 | 25 | 1 | 4 | 37600 |
| 120 | 1 | 34 | 0 | 4 | 41200 |
| 121 | 1 | 53 | 0 | 6 | 49900 |
| 122 | 0 | 35 | 4 | 4 | 59400 |
| 123 | 1 | 52 | 3 | 4 | 65500 |
| 124 | 1 | 33 | 10 | 6 | 73200 |
| 125 | 1 | 49 | 0 | 4 | 30500 |
| 126 | 1 | 59 | 6 | 4 | 84800 |
| 127 | 1 | 35 | 16 | 4 | 95200 |
| 128 | 1 | 44 | 11 | 4 | 84900 |
| 129 | 1 | 61 | 11 | 4 | 102600 |
| 130 | 1 | 43 | 11 | 4 | 59000 |
| 131 | 0 | 30 | 0 | 4 | 44800 |
| 132 | 0 | 32 | 11 | 4 | 70500 |
| 133 | 0 | 57 | 10 | 6 | 83700 |
| 134 | 1 | 44 | 10 | 4 | 100000 |
| 135 | 1 | 44 | 2 | 4 | 39300 |
| 136 | 1 | 45 | 0 | 2 | 20400 |
| 137 | 0 | 43 | 0 | 6 | 74300 |
| 138 | 0 | 33 | 11 | 4 | 114500 |
| 139 | 1 | 39 | 5 | 4 | 57700 |
| 140 | 0 | 44 | 12 | 6 | 76400 |
| 141 | 0 | 24 | 0 | 4 | 44000 |
| 142 | 1 | 25 | 2 | 4 | 41600 |
| 143 | 0 | 56 | 5 | 8 | 163900 |
| 144 | 1 | 41 | 9 | 4 | 72700 |
| 145 | 1 | 33 | 6 | 6 | 60300 |
| 146 | 0 | 37 | 11 | 4 | 63500 |
| 147 | 1 | 51 | 12 | 6 | 131200 |
| 148 | 0 | 23 | 0 | 4 | 39200 |
| 149 | 0 | 31 | 5 | 6 | 62900 |
| 150 | 1 | 27 | 0 | 0 | 26200 |
