faculty <- read.csv("C:/Users/Hallie/Dropbox/GEOG 5023 - Spring 2013/Data/faculty.csv",
sep = ",", header = T)
names(faculty)
## [1] "AYSALARY" "R1" "R2" "R7" "PRIOREXP" "YRBG"
## [7] "YRRANK" "TERMDEG" "YRDG" "EMINENT" "FEMALE"
faculty
## AYSALARY R1 R2 R7 PRIOREXP YRBG YRRANK TERMDEG YRDG EMINENT FEMALE
## 1 29500 0 0 1 0 0 0 0 0 0 0
## 2 38362 0 1 0 0 14 2 1 14 0 1
## 3 68906 1 0 0 2 29 20 1 31 0 0
## 4 55979 1 0 0 0 14 3 1 14 0 0
## 5 61008 0 0 0 0 3 3 1 2 0 0
## 6 42977 0 1 0 5 7 1 1 12 0 0
## 7 51640 1 0 0 4 13 5 1 17 0 1
## 8 42034 0 1 0 1 8 4 1 9 0 1
## 9 31000 0 0 0 0 0 0 1 0 0 0
## 10 45584 0 1 0 0 25 5 1 23 0 0
## 11 35782 0 0 0 0 2 1 1 1 0 0
## 12 63167 0 1 0 0 26 17 1 22 0 0
## 13 66032 1 0 0 0 29 16 1 27 0 0
## 14 48168 0 1 0 2 16 11 1 18 0 0
## 15 51462 0 1 0 0 24 19 1 24 0 0
## 16 38935 0 0 0 15 3 3 1 18 0 1
## 17 75353 1 0 0 0 25 12 1 21 0 0
## 18 64795 1 0 0 0 21 11 1 20 0 0
## 19 25271 0 0 1 10 4 3 0 14 0 1
## 20 79002 1 0 0 1 30 24 1 31 0 0
## 21 63155 0 1 0 0 6 0 1 6 0 0
## 22 54701 0 1 0 19 2 1 1 21 0 0
## 23 30000 0 0 0 0 0 0 1 0 0 0
## 24 44319 0 1 0 4 26 22 1 30 0 0
## 25 50151 0 1 0 4 25 19 1 29 0 0
## 26 30001 0 0 0 5 3 3 1 8 0 1
## 27 54464 1 0 0 0 10 1 1 10 0 0
## 28 33056 0 0 1 0 20 20 0 7 0 1
## 29 47344 0 0 0 0 3 3 1 3 0 1
## 30 53456 0 1 0 0 22 18 1 22 0 1
## 31 65704 1 0 0 1 21 11 1 22 0 0
## 32 48681 0 1 0 0 19 12 1 19 0 1
## 33 53248 1 0 0 0 23 13 1 22 0 0
## 34 39461 0 0 0 3 2 2 1 5 0 1
## 35 43958 0 1 0 4 12 6 1 16 0 1
## 36 96156 1 0 0 20 12 12 1 32 0 0
## 37 37000 0 1 0 7 7 4 1 14 0 0
## 38 41563 0 0 0 7 2 2 1 9 0 0
## 39 32000 0 0 0 2 0 0 1 2 0 1
## 40 46292 0 0 0 0 2 2 1 2 0 1
## 41 37000 0 0 0 3 0 0 1 3 0 0
## 42 68894 1 0 0 16 7 7 1 23 0 0
## 43 54075 0 1 0 0 27 20 1 24 0 0
## 44 53103 0 1 0 3 10 10 1 13 0 0
## 45 56289 1 0 0 5 21 15 1 26 0 0
## 46 53187 1 0 0 19 7 6 1 26 0 1
## 47 33680 0 0 0 1 3 3 1 4 0 0
## 48 28256 0 0 1 0 4 4 0 4 0 1
## 49 52996 0 1 0 5 8 8 1 13 0 0
## 50 55978 0 1 0 7 8 8 1 15 0 0
## 51 36869 0 1 0 0 7 1 1 6 0 1
## 52 37242 0 1 0 8 4 1 1 12 0 0
## 53 56252 0 1 0 0 17 14 1 17 0 0
## 54 31000 0 0 1 17 0 0 0 17 0 0
## 55 52430 0 1 0 0 30 18 0 18 0 1
## 56 39900 0 0 1 9 0 0 0 9 0 1
## 57 24192 0 0 1 1 4 4 0 5 0 1
## 58 59835 1 0 0 1 24 9 1 25 0 0
## 59 56419 1 0 0 0 23 18 1 23 0 0
## 60 66746 1 0 0 1 25 16 1 26 0 0
## 61 24152 0 0 1 0 4 4 0 4 0 1
## 62 45669 0 1 0 2 18 5 1 20 0 1
## 63 36833 0 0 0 8 2 2 1 10 0 1
## 64 30927 0 0 0 1 6 6 1 7 0 0
## 65 54296 1 0 0 7 17 4 1 24 0 0
## 66 43695 0 0 0 17 4 4 0 21 0 0
## 67 48065 0 0 0 0 13 13 1 13 0 1
## 68 57965 1 0 0 12 13 13 1 25 0 0
## 69 30000 0 0 0 3 0 0 0 3 0 0
## 70 52009 1 0 0 0 23 1 1 21 0 1
## 71 55227 0 0 0 0 3 3 1 2 0 0
## 72 53665 1 0 0 0 25 12 1 23 0 0
## 73 61514 0 1 0 0 13 7 1 9 0 0
## 74 54423 1 0 0 13 24 18 1 37 0 0
## 75 36833 0 0 0 0 3 3 1 3 0 1
## 76 61812 1 0 0 6 19 8 1 25 0 0
## 77 30000 0 0 1 1 0 0 1 1 0 1
## 78 33680 0 0 0 0 2 1 1 1 0 1
## 79 40356 0 1 0 0 4 0 1 4 0 1
## 80 37359 0 0 0 6 3 3 1 9 0 1
## 81 75365 1 0 0 0 25 17 1 24 0 0
## 82 27373 0 0 1 2 1 1 0 3 0 1
## 83 49134 0 1 0 0 20 15 1 20 0 0
## 84 40465 0 1 0 4 5 0 1 9 0 0
## 85 38410 0 1 0 10 1 1 1 11 0 1
## 86 51199 1 0 0 0 21 10 1 19 0 0
## 87 52034 0 1 0 0 24 15 1 22 0 0
## 88 36515 0 1 0 2 7 1 1 9 0 1
## 89 56687 1 0 0 0 21 10 1 20 0 0
## 90 34000 0 1 0 1 9 3 1 10 0 0
## 91 33680 0 0 0 0 2 1 1 1 0 0
## 92 35257 0 0 0 3 4 4 1 7 0 0
## 93 50729 1 0 0 0 20 7 1 19 0 1
## 94 40957 0 0 0 0 14 13 1 13 0 0
## 95 30000 0 0 1 19 0 0 0 19 0 0
## 96 24229 0 0 1 3 4 1 0 7 0 1
## 97 61218 1 0 0 0 27 18 1 27 0 0
## 98 70102 1 0 0 0 23 16 1 22 0 0
## 99 44463 0 1 0 5 6 3 1 11 0 0
## 100 30000 0 0 0 0 0 0 1 0 0 1
## 101 32628 0 0 0 2 5 5 1 7 0 1
## 102 36308 0 0 0 0 1 0 1 1 0 1
## 103 62276 1 0 0 6 23 11 1 29 0 0
## 104 23800 0 0 1 0 0 0 0 0 0 1
## 105 56055 1 0 0 0 18 6 1 18 0 0
## 106 34468 0 0 0 0 3 3 1 3 0 0
## 107 48473 0 1 0 0 19 15 1 19 0 0
## 108 40512 0 0 0 4 1 1 1 5 0 0
## 109 49252 0 1 0 0 22 17 1 22 0 0
## 110 26000 0 0 1 6 0 0 0 6 0 0
## 111 40066 0 0 0 0 4 4 1 4 0 0
## 112 60892 1 0 0 12 14 11 1 26 0 0
## 113 51126 1 0 0 0 27 0 1 25 0 0
## 114 40512 0 0 0 0 3 3 1 3 0 0
## 115 53010 1 0 0 2 16 8 1 18 0 0
## 116 51943 1 0 0 19 0 0 1 19 0 0
## 117 41045 0 1 0 21 5 5 1 26 0 0
## 118 61453 0 1 0 0 15 0 1 15 0 0
## 119 67339 1 0 0 0 28 15 1 24 0 0
## 120 56000 0 0 0 1 0 0 1 1 0 0
## 121 44813 0 1 0 0 8 2 1 8 0 0
## 122 55923 1 0 0 0 26 9 1 26 0 0
## 123 29500 0 0 0 6 0 0 1 6 0 0
## 124 34731 0 0 0 0 2 2 1 2 0 0
## 125 33680 0 0 0 0 1 1 1 1 0 1
## 126 63357 1 0 0 3 26 17 1 29 0 0
## 127 47596 0 1 0 0 32 22 1 22 0 1
## 128 62173 1 0 0 1 24 4 1 25 0 0
## 129 45032 1 0 0 0 13 0 1 13 0 0
## 130 39771 0 1 0 0 11 5 1 9 0 0
## 131 53003 0 1 0 5 29 24 0 34 0 0
## 132 45284 0 0 0 5 29 25 0 34 0 0
## 133 31577 0 0 1 0 1 1 0 1 0 0
## 134 35317 0 0 0 0 7 7 1 6 0 0
## 135 33154 0 0 0 2 2 2 1 4 0 0
## 136 45831 0 1 0 0 20 7 1 13 0 0
## 137 48023 0 1 0 0 26 21 1 26 0 0
## 138 58949 0 1 0 0 12 6 1 10 0 0
## 139 55039 1 0 0 0 25 9 1 22 0 0
## 140 34206 0 0 0 1 4 4 1 5 0 1
## 141 48531 1 0 0 0 13 0 1 13 0 1
## 142 61988 0 1 0 0 11 3 1 11 0 0
## 143 39587 0 0 1 0 1 1 1 1 0 0
## 144 54686 1 0 0 0 28 7 1 23 0 0
## 145 64918 1 0 0 0 27 16 1 27 0 0
## 146 37615 0 0 0 4 7 7 1 11 0 1
## 147 57779 0 1 0 0 13 7 1 11 0 0
## 148 30000 0 0 0 4 1 1 1 5 0 1
## 149 43653 0 0 0 0 23 16 1 17 0 0
## 150 29000 0 0 0 6 0 0 0 6 0 0
## 151 30200 0 0 1 7 0 0 0 7 0 0
## 152 29000 0 0 0 0 0 0 1 0 0 0
## 153 39924 0 1 0 6 5 2 1 11 0 0
## 154 67368 1 0 0 0 32 23 1 32 0 0
## 155 37500 0 1 0 0 7 1 1 5 0 0
## 156 51954 1 0 0 0 27 18 1 27 0 0
## 157 36833 0 0 0 2 3 3 1 5 0 0
## 158 44225 0 0 0 13 8 8 1 21 0 0
## 159 41037 0 0 0 2 1 1 1 3 0 0
## 160 37733 0 1 0 0 8 0 1 8 0 1
## 161 74246 1 0 0 0 28 21 1 28 0 0
## 162 27899 0 0 1 0 1 1 0 1 0 1
## 163 63500 0 1 0 10 0 0 1 10 0 1
## 164 58000 0 0 0 1 0 0 1 1 0 0
## 165 48921 0 1 0 8 2 2 1 10 0 0
## 166 46019 0 1 0 1 17 13 1 18 0 0
## 167 43641 0 1 0 0 8 3 1 8 0 0
## 168 27500 0 0 1 19 0 0 0 19 0 0
## 169 62091 1 0 0 0 23 14 1 23 0 0
## 170 66166 1 0 0 4 13 3 1 17 0 0
## 171 55121 0 0 0 2 1 1 1 3 0 0
## 172 35980 0 0 0 2 4 4 1 6 0 0
## 173 38580 0 0 0 0 26 20 0 26 0 1
## 174 44190 0 1 0 19 4 4 1 23 0 0
## 175 61008 0 0 0 0 2 2 1 1 0 0
## 176 48099 0 1 0 1 21 15 1 22 0 0
## 177 70546 0 1 0 0 14 8 1 11 0 0
## 178 46981 0 1 0 10 27 27 1 37 0 0
## 179 48941 1 0 0 0 12 0 1 12 0 0
## 180 48219 0 1 0 2 25 18 1 27 0 0
## 181 34206 0 0 0 1 5 5 1 6 0 1
## 182 38810 0 1 0 0 10 5 1 8 0 0
## 183 38600 0 0 0 1 3 1 1 4 0 0
## 184 41106 0 1 0 8 9 9 1 17 0 0
## 185 61486 1 0 0 1 24 11 1 25 0 0
## 186 54177 0 1 0 0 20 5 1 18 0 0
## 187 46416 0 0 0 1 15 15 1 16 0 1
## 188 59000 0 0 0 0 0 0 1 0 0 1
## 189 34157 0 0 0 0 5 5 1 5 0 0
## 190 49667 0 1 0 0 12 4 1 11 0 0
## 191 34206 0 0 0 2 4 4 1 6 0 1
## 192 37410 0 0 0 0 4 3 1 3 0 0
## 193 24229 0 0 1 1 4 1 0 5 0 1
## 194 56436 1 0 0 4 16 5 1 20 0 0
## 195 46551 0 1 0 1 17 12 1 18 0 0
## 196 52760 0 1 0 1 23 18 1 24 0 0
## 197 45229 1 0 0 0 27 0 1 26 0 0
## 198 35682 0 1 0 4 7 1 1 11 0 0
## 199 38265 0 1 0 2 4 1 1 6 0 0
## 200 36583 0 0 0 0 4 4 1 4 0 1
## 201 48311 0 1 0 0 25 15 1 21 0 0
## 202 80760 1 0 0 13 7 7 1 20 0 0
## 203 60726 0 1 0 2 11 2 1 13 0 0
## 204 48000 0 0 0 3 0 0 1 3 0 0
## 205 54222 1 0 0 4 20 5 1 24 0 0
## 206 62165 1 0 0 21 3 3 1 24 0 0
## 207 38000 0 0 0 4 0 0 1 4 0 0
## 208 50683 0 1 0 0 17 11 1 17 0 1
## 209 58876 1 0 0 20 4 4 1 24 0 0
## 210 63231 1 0 0 0 29 15 1 22 0 0
## 211 64161 1 0 0 20 2 2 1 22 0 0
## 212 33680 0 0 0 3 1 1 1 4 0 1
## 213 46574 1 0 0 0 16 3 1 15 0 0
## 214 60402 1 0 0 6 19 7 1 25 0 1
## 215 41019 0 0 0 0 24 20 0 24 0 0
## 216 58530 1 0 0 0 19 9 1 19 0 1
## 217 64109 1 0 0 0 41 28 1 37 0 0
## 218 45838 0 1 0 0 15 10 1 15 0 1
## 219 64854 1 0 0 0 22 12 1 22 0 0
## 220 39574 0 1 0 1 15 9 1 16 0 1
## 221 34941 0 0 1 1 1 1 0 2 0 0
## 222 33680 0 0 0 2 1 1 1 3 0 1
## 223 42088 0 1 0 6 1 1 1 7 0 0
## 224 43277 0 1 0 2 13 9 1 15 0 0
## 225 37363 0 0 0 2 4 4 1 6 0 0
## 226 48378 0 1 0 3 6 0 1 9 0 0
## 227 60653 1 0 0 8 14 12 1 22 0 0
## 228 23800 0 0 1 0 1 1 1 1 0 0
## 229 60421 0 1 0 3 23 21 1 26 0 0
## 230 46843 0 1 0 0 23 13 1 23 0 1
## 231 56884 1 0 0 1 23 14 1 24 0 0
## 232 54721 0 1 0 0 24 19 1 24 0 0
## 233 43531 0 0 1 17 20 20 0 37 0 1
## 234 82508 1 0 0 0 32 23 1 31 0 0
## 235 34206 0 0 0 1 2 2 1 3 0 1
## 236 49923 1 0 0 0 15 2 1 15 0 0
## 237 56933 1 0 0 7 14 11 1 21 0 0
## 238 23800 0 0 1 0 0 0 0 0 0 1
## 239 31577 0 0 0 0 3 2 1 3 0 1
## 240 78660 1 0 0 8 17 15 1 25 0 0
## 241 39669 0 0 0 7 18 18 1 25 0 0
## 242 69374 1 0 0 0 26 15 1 23 0 0
## 243 47483 0 1 0 2 20 13 1 22 0 1
## 244 91405 1 0 0 0 23 14 1 23 0 0
## 245 46292 0 0 0 1 2 2 1 3 0 0
## 246 96744 1 0 0 25 2 2 1 27 1 0
## 247 28000 0 0 1 16 0 0 0 16 0 1
## 248 54000 1 0 0 3 13 6 1 16 0 0
## 249 36000 0 1 0 0 11 5 1 11 0 0
## 250 42747 0 1 0 3 11 8 1 14 0 1
## 251 26000 0 0 1 1 0 0 0 1 0 1
## 252 23800 0 0 1 0 2 0 1 1 0 1
## 253 40459 0 1 0 7 10 2 1 17 0 0
## 254 44678 0 1 0 0 8 3 1 8 0 0
## 255 33680 0 0 0 1 1 1 1 2 0 0
## 256 57573 1 0 0 0 23 10 1 23 0 0
## 257 36308 0 0 0 0 2 1 1 1 0 0
## 258 63691 0 1 0 0 24 18 1 23 0 0
## 259 48765 1 0 0 10 11 4 1 21 0 1
## 260 25000 0 0 1 0 0 0 0 0 0 1
## 261 29200 0 0 1 5 0 0 0 5 0 1
## 262 26000 0 0 1 3 0 0 0 3 0 1
## 263 28424 0 0 1 8 3 3 0 11 0 0
## 264 65533 1 0 0 0 24 1 1 24 0 0
## 265 82878 1 0 0 0 29 21 1 28 0 0
## 266 46520 0 1 0 0 15 8 1 15 0 0
## 267 65837 1 0 0 0 25 14 1 25 0 0
## 268 62211 1 0 0 0 21 11 1 21 0 0
## 269 56433 1 0 0 0 24 12 1 23 0 0
## 270 39986 0 0 0 1 3 3 1 4 0 0
## 271 90082 1 0 0 10 22 22 1 32 0 0
## 272 42388 0 1 0 6 11 8 1 17 0 0
## 273 44454 0 1 0 5 16 10 1 21 0 0
## 274 25271 0 0 1 1 4 3 0 5 0 0
## 275 44268 0 1 0 4 28 23 1 32 0 0
## 276 34914 0 1 0 1 7 0 1 8 0 0
## 277 23800 0 0 1 0 3 2 0 3 0 1
## 278 37905 0 1 0 0 10 5 1 4 0 0
## 279 44539 0 1 0 0 15 8 1 15 0 0
## 280 67971 1 0 0 0 38 21 1 37 0 1
## 281 66570 1 0 0 0 20 9 1 19 0 0
## 282 47148 1 0 0 3 19 7 1 22 0 0
## 283 49826 0 1 0 5 12 9 1 17 0 0
## 284 63997 1 0 0 0 28 15 1 28 0 0
## 285 34731 0 0 0 6 3 3 1 9 0 0
## 286 44411 0 1 0 7 12 10 1 19 0 1
## 287 47820 0 1 0 0 18 10 1 14 0 0
## 288 53543 0 1 0 9 4 4 1 13 0 0
## 289 61008 0 0 0 0 2 2 1 2 0 0
## 290 32116 0 0 1 13 7 1 0 20 0 1
## 291 41073 1 0 0 0 11 0 1 11 0 0
## 292 56000 0 0 0 1 0 0 1 1 0 1
## 293 28000 0 0 1 1 0 0 1 1 0 1
## 294 69709 1 0 0 3 28 21 1 31 0 0
## 295 41121 0 1 0 0 9 5 1 9 0 0
## 296 26931 0 0 1 2 4 4 0 6 0 0
## 297 74265 1 0 0 22 2 2 1 24 0 0
## 298 55550 1 0 0 0 23 2 1 21 0 0
## 299 65852 1 0 0 0 26 18 1 25 0 0
## 300 34731 0 0 0 0 2 1 1 1 0 1
## 301 63144 1 0 0 14 27 20 1 41 0 0
## 302 69828 1 0 0 0 30 21 1 30 0 0
## 303 52446 1 0 0 5 14 6 1 19 0 1
## 304 54238 1 0 0 0 15 4 1 15 0 0
## 305 44045 0 1 0 10 6 6 1 16 0 1
## 306 47396 0 1 0 5 11 7 1 16 0 1
## 307 36487 0 1 0 1 5 1 1 6 0 1
## 308 71573 1 0 0 8 22 20 1 30 0 0
## 309 68651 1 0 0 0 23 12 1 23 0 0
## 310 44195 0 0 0 7 18 15 0 25 0 1
## 311 26931 0 0 1 3 4 4 0 7 0 1
## 312 25500 0 0 1 0 0 0 0 0 0 0
## 313 41089 0 0 0 3 23 8 0 26 0 1
## 314 59110 0 0 0 0 4 4 1 4 0 0
## 315 27396 0 0 1 12 2 1 0 14 0 1
## 316 53274 1 0 0 0 22 10 1 22 0 0
## 317 39156 0 1 0 0 8 2 1 8 0 0
## 318 39024 0 1 0 2 7 0 1 9 0 0
## 319 44413 0 1 0 3 21 13 1 24 0 0
## 320 39000 0 0 0 4 0 0 1 4 0 0
## 321 27899 0 0 1 0 2 2 0 1 0 1
## 322 60153 0 0 0 3 15 13 1 18 0 0
## 323 33680 0 0 0 0 3 3 1 3 0 1
## 324 42614 0 0 0 0 2 2 1 2 0 0
## 325 61210 1 0 0 0 24 16 1 23 0 0
## 326 49499 0 1 0 2 10 4 1 12 0 1
## 327 45121 0 1 0 0 25 22 1 25 0 0
## 328 48534 0 1 0 0 29 25 1 29 0 0
## 329 47573 0 1 0 0 15 11 1 15 0 0
## 330 58118 0 0 0 0 5 5 1 5 0 0
## 331 41425 0 1 0 5 6 3 1 11 0 0
## 332 39611 0 1 0 6 6 0 1 12 0 1
## 333 41915 0 1 0 0 10 4 1 8 0 1
## 334 72533 1 0 0 15 21 21 1 36 0 0
## 335 40615 0 1 0 4 6 2 1 10 0 0
## 336 32000 0 0 0 1 5 5 1 6 0 0
## 337 69654 0 1 0 0 17 12 1 17 0 1
## 338 71142 0 1 0 1 20 16 1 21 0 0
## 339 41015 0 0 0 0 10 10 1 10 0 1
## 340 45506 0 1 0 0 20 13 1 20 0 0
## 341 76098 1 0 0 0 18 10 1 17 0 0
## 342 48543 0 1 0 0 25 17 1 23 0 0
## 343 42228 0 0 0 0 23 14 0 23 0 1
## 344 40636 0 0 0 0 12 11 1 11 0 1
## 345 41639 0 1 0 1 6 0 1 7 0 0
## 346 34731 0 0 0 1 1 1 1 2 0 0
## 347 56182 0 1 0 0 7 1 1 6 0 1
## 348 71118 1 0 0 2 28 21 1 30 0 0
## 349 40071 0 1 0 0 27 16 1 25 0 0
## 350 45906 0 1 0 6 17 11 1 23 0 1
## 351 50280 0 1 0 0 22 15 1 21 0 1
## 352 52071 0 1 0 0 24 14 1 24 0 0
## 353 48666 1 0 0 0 22 1 1 15 0 1
## 354 73620 1 0 0 15 3 3 1 18 0 0
## 355 23800 0 0 1 4 5 0 0 9 0 0
## 356 65432 1 0 0 0 23 12 1 23 0 0
## 357 52464 0 1 0 0 17 9 1 17 0 0
## 358 70167 1 0 0 14 13 13 1 27 0 0
## 359 41655 0 0 0 1 22 22 1 23 0 1
## 360 30000 0 0 0 1 0 0 0 1 0 0
## 361 35206 0 0 0 0 3 2 1 3 0 0
## 362 61439 0 1 0 0 7 2 1 6 0 0
## 363 60190 1 0 0 11 5 5 1 16 0 0
## 364 66334 1 0 0 0 35 23 1 30 0 0
## 365 59403 1 0 0 22 2 2 1 24 0 0
## 366 33604 0 0 1 0 4 0 1 4 0 1
## 367 72152 1 0 0 0 33 22 1 33 0 0
## 368 34997 0 1 0 0 18 12 1 17 0 1
## 369 38572 0 1 0 0 12 9 1 12 0 1
## 370 62899 0 1 0 9 9 9 1 18 0 0
## 371 55826 1 0 0 4 24 12 1 28 0 0
## 372 56542 1 0 0 8 20 10 1 28 0 1
## 373 70514 1 0 0 0 25 17 1 25 0 0
## 374 52090 0 1 0 0 30 24 1 28 0 0
## 375 32000 0 0 0 3 0 0 1 3 0 0
## 376 25518 0 0 1 8 1 1 0 9 0 1
## 377 64046 1 0 0 0 25 13 1 22 0 0
## 378 28214 0 0 1 1 1 1 0 2 0 0
## 379 62801 1 0 0 0 28 15 1 28 0 0
## 380 30000 0 0 0 22 1 0 1 23 0 0
## 381 68133 1 0 0 4 23 17 1 27 0 0
## 382 65212 1 0 0 23 3 3 1 26 0 0
## 383 91489 1 0 0 21 4 4 1 25 1 0
## 384 68140 1 0 0 13 22 22 0 35 0 0
## 385 33010 0 0 0 3 8 8 1 11 0 1
## 386 58134 1 0 0 0 26 16 1 26 0 0
## 387 68445 1 0 0 7 10 4 1 17 0 0
## 388 29000 0 0 0 5 1 0 0 6 0 1
## 389 40945 0 1 0 0 11 5 1 10 0 0
## 390 43921 0 1 0 0 17 11 1 17 0 1
## 391 51565 1 0 0 0 20 4 1 18 0 0
## 392 42563 0 1 0 0 9 3 1 9 0 0
## 393 56574 1 0 0 0 26 1 1 24 0 0
## 394 55210 0 0 0 1 5 5 1 6 0 1
## 395 58982 1 0 0 1 20 5 1 21 0 0
## 396 45837 1 0 0 4 18 3 1 22 0 0
## 397 48456 0 1 0 1 24 16 1 25 0 0
## 398 35257 0 0 0 4 3 3 1 7 0 1
## 399 24220 0 0 1 0 3 3 0 3 0 1
## 400 44204 0 0 0 9 6 6 1 15 0 0
## 401 73349 0 1 0 1 22 18 1 23 0 0
## 402 44063 0 0 0 14 20 10 0 34 0 1
## 403 28000 0 0 1 11 0 0 0 11 0 1
## 404 37000 0 0 0 3 0 0 1 3 0 0
## 405 49768 1 0 0 0 26 7 1 22 0 0
## 406 33000 0 0 1 0 0 0 1 0 0 0
## 407 43500 0 0 0 6 0 0 0 6 0 1
## 408 58149 0 1 0 3 18 10 1 21 0 0
## 409 30001 0 0 0 4 3 3 1 7 0 0
## 410 50838 0 1 0 10 6 6 1 16 0 0
## 411 47821 0 1 0 1 15 3 1 16 0 1
## 412 41682 0 1 0 1 7 1 1 8 0 0
## 413 42603 0 1 0 1 9 2 1 10 0 1
## 414 37037 0 1 0 0 13 4 1 12 0 1
## 415 43245 0 1 0 4 23 16 1 27 0 0
## 416 59005 0 1 0 0 17 12 1 16 0 0
## 417 38935 0 0 0 6 2 2 1 8 0 0
## 418 23904 0 0 1 0 4 4 0 4 0 0
## 419 41037 0 0 0 5 2 1 1 7 0 0
## 420 27373 0 0 1 3 3 3 0 6 0 1
## 421 34000 0 0 0 0 3 3 1 2 0 0
## 422 55158 0 1 0 1 8 3 1 9 0 0
## 423 51698 1 0 0 8 23 1 1 31 0 0
## 424 46601 1 0 0 0 21 2 1 18 0 0
## 425 52627 1 0 0 0 20 10 1 19 0 0
## 426 54850 1 0 0 0 24 9 1 23 0 0
## 427 66668 1 0 0 5 23 20 1 28 0 0
## 428 31000 0 0 0 0 3 2 1 2 0 1
## 429 75650 1 0 0 0 26 16 1 25 0 0
## 430 33680 0 0 0 0 1 1 1 1 0 1
## 431 83192 1 0 0 11 19 19 1 30 0 0
## 432 35000 0 0 0 1 0 0 1 1 0 1
## 433 39777 0 1 0 10 17 10 1 27 0 0
## 434 31000 0 0 0 0 0 0 1 0 0 1
## 435 29475 0 0 1 0 4 4 1 4 0 1
## 436 61316 1 0 0 0 22 13 1 22 0 0
## 437 45004 0 1 0 0 19 13 1 19 0 0
## 438 55000 0 0 0 0 0 0 1 0 0 0
## 439 63512 1 0 0 0 28 19 1 28 0 0
## 440 48078 0 1 0 0 11 5 1 11 0 0
## 441 48210 0 0 0 10 4 4 1 14 0 0
## 442 52240 0 1 0 0 23 13 1 23 0 0
## 443 41614 0 1 0 4 23 11 1 27 0 0
## 444 60345 1 0 0 4 24 4 1 28 0 0
## 445 35782 0 0 0 1 2 2 1 3 0 0
## 446 62587 1 0 0 20 8 8 1 28 0 0
## 447 37884 0 0 0 4 2 2 1 6 0 0
## 448 39120 0 0 0 10 11 11 0 21 0 1
## 449 66537 1 0 0 6 10 1 1 16 0 0
## 450 45047 0 0 0 0 20 20 1 20 0 1
## 451 63827 1 0 0 0 24 12 1 22 0 0
## 452 32944 0 0 0 0 6 5 1 6 0 1
## 453 23800 0 0 1 1 0 0 0 1 0 1
## 454 59564 0 1 0 0 19 14 1 17 0 0
## 455 34206 0 0 0 3 3 3 1 6 0 1
## 456 48364 0 1 0 0 25 13 0 25 0 0
## 457 66483 1 0 0 3 21 15 1 24 0 0
## 458 54211 1 0 0 2 14 5 1 16 0 0
## 459 52773 0 1 0 0 28 14 1 16 0 1
## 460 25271 0 0 1 2 3 3 1 5 0 0
## 461 60056 1 0 0 0 18 8 1 18 0 0
## 462 47661 1 0 0 4 12 3 1 16 0 1
## 463 64713 1 0 0 0 22 12 1 22 0 0
## 464 31000 0 0 0 0 0 0 1 0 0 0
## 465 46975 0 1 0 0 7 2 1 7 0 0
## 466 40000 0 0 0 0 3 3 1 3 0 1
## 467 65212 0 1 0 7 3 3 1 10 0 0
## 468 62523 1 0 0 5 28 22 1 33 0 0
## 469 58498 1 0 0 0 23 2 1 15 0 0
## 470 33800 0 0 0 0 0 0 1 0 0 1
## 471 64770 1 0 0 0 25 15 1 23 0 1
## 472 45933 0 0 0 0 30 24 0 30 0 1
## 473 23800 0 0 1 0 2 2 1 1 0 1
## 474 35257 0 0 0 0 2 2 1 2 0 0
## 475 57612 0 1 0 0 12 5 1 10 0 1
## 476 46811 0 1 0 3 7 4 1 10 0 1
## 477 23800 0 0 1 0 0 0 0 0 0 1
## 478 42813 0 1 0 6 10 7 1 16 0 1
## 479 59432 1 0 0 0 30 19 1 27 0 0
## 480 75614 1 0 0 0 29 22 1 29 0 0
## 481 71605 1 0 0 1 17 9 1 18 0 0
## 482 55189 0 1 0 0 26 21 1 24 0 0
## 483 34603 0 0 0 0 6 4 1 4 0 1
## 484 35756 0 1 0 0 8 2 1 8 0 0
## 485 30662 0 0 0 0 4 3 1 3 0 1
## 486 50235 1 0 0 0 21 1 1 20 0 0
## 487 38936 0 0 0 2 2 2 1 4 0 0
## 488 32000 0 0 0 13 0 0 1 13 0 1
## 489 52580 1 0 0 2 22 9 1 24 0 0
## 490 54274 1 0 0 0 22 12 1 22 0 0
## 491 61179 1 0 0 2 25 16 1 27 0 0
## 492 59535 1 0 0 0 24 10 1 22 0 0
## 493 38410 0 0 0 12 3 3 1 15 0 0
## 494 36308 0 0 0 3 2 2 1 5 0 0
## 495 42088 0 0 0 1 3 3 1 4 0 0
## 496 55608 0 1 0 1 25 21 1 26 0 0
## 497 62059 0 0 0 0 3 3 1 3 0 0
## 498 68299 0 1 0 0 28 24 1 26 0 0
## 499 53376 0 1 0 0 6 0 1 6 0 0
## 500 25000 0 0 1 0 0 0 1 0 0 1
## 501 64073 1 0 0 0 11 0 1 10 0 0
## 502 41483 0 1 0 1 5 2 1 6 0 0
## 503 48122 1 0 0 0 13 4 1 13 0 0
## 504 56278 0 0 0 3 5 5 1 8 0 0
## 505 67062 1 0 0 0 25 15 1 23 0 0
## 506 58767 1 0 0 0 23 12 1 23 0 1
## 507 47029 1 0 0 7 11 1 1 18 0 0
## 508 53000 0 0 0 0 0 0 1 0 0 0
## 509 28424 0 0 1 2 2 2 0 4 0 1
## 510 33049 0 0 1 0 6 1 0 5 0 1
## 511 52395 1 0 0 5 19 7 1 24 0 1
## 512 63800 1 0 0 0 25 14 1 25 0 0
## 513 70434 1 0 0 7 15 10 1 22 0 0
## 514 63661 1 0 0 17 1 1 1 18 0 1
## 515 52894 1 0 0 0 24 8 1 23 0 0
## 516 58698 1 0 0 0 22 5 1 22 0 0
## 517 103041 1 0 0 22 5 5 1 27 1 0
## 518 56288 0 1 0 2 28 20 1 30 0 0
## 519 58946 0 1 0 0 12 3 1 10 0 1
## 520 80137 1 0 0 5 21 20 1 26 0 0
## 521 30000 0 0 0 0 0 0 1 0 0 0
## 522 60852 0 1 0 0 24 18 1 24 0 0
## 523 63073 1 0 0 2 30 16 1 32 0 0
## 524 52054 1 0 0 13 1 1 1 14 0 0
## 525 53057 0 1 0 0 25 18 1 25 0 0
## 526 39754 0 0 0 0 1 0 1 1 0 0
## 527 69976 1 0 0 0 30 14 1 28 0 0
## 528 58645 1 0 0 0 26 14 1 21 0 0
## 529 42537 0 1 0 0 13 8 1 12 0 0
## 530 39871 0 1 0 0 6 0 1 6 0 1
## 531 38069 0 0 0 0 7 6 1 6 0 1
## 532 58930 0 1 0 0 6 0 1 4 0 0
## 533 25000 0 0 1 2 0 0 0 2 0 1
## 534 51775 1 0 0 0 27 13 1 26 0 0
## 535 49439 1 0 0 0 16 8 1 9 0 0
## 536 39986 0 0 0 0 2 0 1 1 0 0
## 537 42954 1 0 0 6 9 0 1 15 0 0
## 538 66115 1 0 0 2 26 18 1 28 0 0
## 539 66790 1 0 0 0 24 12 1 21 0 0
## 540 44769 0 1 0 1 14 9 1 15 0 1
## 541 31577 0 0 0 2 1 1 1 3 0 0
## 542 58471 1 0 0 0 24 13 1 21 0 0
## 543 62350 1 0 0 5 19 14 1 24 0 0
## 544 62059 1 0 0 15 1 1 1 16 0 1
## 545 36000 0 0 0 1 0 0 1 1 0 1
## 546 41974 0 1 0 0 6 0 1 6 0 0
## 547 63337 1 0 0 0 27 20 1 27 0 0
## 548 29579 0 0 1 5 0 0 0 5 0 1
## 549 31000 0 0 0 0 0 0 1 0 0 1
## 550 33680 0 0 0 0 3 3 1 3 0 0
## 551 32200 0 0 1 4 0 0 0 4 0 0
## 552 40000 0 1 0 3 7 2 1 10 0 0
## 553 71812 1 0 0 2 21 14 1 23 0 0
## 554 25500 0 0 1 0 0 0 0 0 0 1
## 555 48766 0 1 0 0 24 20 1 24 0 0
## 556 27899 0 0 1 0 2 2 0 1 0 1
## 557 56571 1 0 0 0 25 11 1 24 0 0
## 558 39660 0 1 0 0 9 4 1 9 0 1
## 559 48152 0 0 0 0 29 25 0 29 0 1
## 560 41563 0 1 0 1 8 1 1 9 0 1
## 561 50096 0 1 0 3 7 4 1 10 0 0
## 562 52579 1 0 0 4 25 11 1 29 0 0
## 563 33787 0 0 0 0 4 2 1 2 0 1
## 564 33680 0 0 0 0 3 1 1 2 0 0
## 565 37726 0 0 0 0 19 19 1 19 0 0
## 566 60911 1 0 0 1 34 21 1 35 0 0
## 567 51729 1 0 0 5 9 3 1 14 0 0
## 568 67199 1 0 0 0 28 16 1 27 0 0
## 569 40512 0 0 0 8 1 1 1 9 0 0
## 570 71543 1 0 0 13 7 7 1 20 0 0
## 571 36308 0 0 0 16 5 5 1 21 0 1
## 572 26584 0 0 1 0 3 3 0 3 0 0
## 573 49357 1 0 0 3 13 3 1 16 0 0
## 574 38818 0 1 0 2 8 2 1 10 0 1
## 575 46728 0 1 0 5 10 4 1 15 0 0
## 576 48289 1 0 0 2 13 1 1 15 0 0
## 577 45763 0 1 0 3 7 2 1 10 0 1
## 578 60423 0 0 0 0 5 5 1 5 0 0
## 579 80103 1 0 0 2 29 22 1 31 0 0
## 580 53000 0 0 0 4 0 0 0 4 0 0
## 581 38333 0 1 0 0 7 2 1 7 0 0
## 582 60681 1 0 0 0 17 9 1 17 0 0
## 583 52173 1 0 0 0 22 8 1 22 0 0
## 584 52667 0 1 0 0 24 16 1 20 0 0
## 585 36833 0 0 0 0 1 1 1 1 0 1
## 586 46488 0 1 0 2 14 6 0 16 0 0
## 587 61255 1 0 0 7 21 15 1 28 0 0
## 588 50062 0 1 0 0 26 20 1 26 0 1
## 589 52662 1 0 0 13 25 11 1 38 0 1
## 590 39461 0 1 0 0 7 1 1 6 0 1
## 591 56350 1 0 0 0 25 14 1 25 0 0
## 592 56030 1 0 0 0 26 15 1 24 0 0
## 593 55752 0 1 0 3 23 21 1 26 0 0
## 594 33680 0 0 0 7 3 3 1 10 0 0
## 595 43209 0 1 0 0 16 10 1 16 0 1
## 596 67647 1 0 0 0 20 10 1 20 0 0
## 597 89789 1 0 0 11 22 21 1 33 0 0
## 598 71835 1 0 0 0 28 19 1 27 0 0
## 599 55406 0 1 0 0 10 3 1 8 0 0
## 600 47999 1 0 0 0 15 1 1 15 0 0
## 601 54822 1 0 0 0 25 10 1 23 0 0
## 602 27373 0 0 1 0 1 1 0 1 0 1
## 603 32158 0 0 1 0 6 1 0 6 0 1
## 604 60000 0 1 0 5 0 0 1 5 0 1
## 605 52172 1 0 0 6 15 11 1 21 0 0
## 606 37500 0 1 0 0 6 0 1 6 0 0
## 607 60678 1 0 0 5 13 0 1 18 0 1
## 608 37254 0 0 0 2 15 14 1 17 0 1
## 609 43188 1 0 0 1 13 1 1 14 0 0
## 610 66310 0 1 0 0 28 24 1 28 0 0
## 611 33680 0 0 0 0 2 2 1 2 0 1
## 612 42891 0 0 0 0 18 18 1 18 0 0
## 613 64073 1 0 0 3 28 14 1 31 0 0
## 614 35000 0 0 0 0 3 0 1 0 0 1
## 615 40986 0 1 0 0 14 6 1 14 0 0
## 616 42482 0 1 0 0 9 4 1 9 0 0
## 617 42129 0 1 0 5 4 2 1 9 0 1
## 618 55227 0 0 0 0 3 3 1 2 0 0
## 619 78182 1 0 0 2 33 22 1 35 0 0
## 620 40356 0 0 0 0 5 4 1 4 0 1
## 621 30000 0 0 0 0 0 0 1 0 0 0
## 622 73155 1 0 0 12 25 25 1 37 0 0
## 623 35574 0 0 0 0 4 4 1 4 0 1
## 624 55035 1 0 0 3 20 12 1 23 0 0
## 625 64863 1 0 0 0 23 14 1 23 0 0
## 626 34316 0 0 1 2 26 26 0 28 0 0
## 627 23800 0 0 1 2 0 0 1 2 0 1
## 628 60717 1 0 0 1 21 11 1 22 0 0
## 629 41259 0 1 0 6 8 2 1 14 0 1
## 630 25271 0 0 1 1 3 3 0 4 0 0
## 631 23800 0 0 1 2 3 2 0 5 0 1
## 632 27899 0 0 1 13 3 1 0 16 0 1
## 633 46292 0 0 0 0 2 2 1 2 0 0
## 634 37359 0 0 0 0 1 1 1 1 0 1
## 635 73669 1 0 0 0 23 14 1 22 0 0
## 636 45287 0 1 0 0 22 16 1 22 0 0
## 637 35972 0 0 0 0 24 20 0 24 0 1
## 638 53042 0 1 0 0 20 15 1 20 0 0
## 639 60498 1 0 0 4 24 13 1 28 0 0
## 640 45000 0 1 0 20 0 0 1 20 0 0
## 641 40000 0 0 0 4 0 0 1 4 0 0
## 642 31577 0 0 1 3 1 1 1 4 0 1
## 643 39986 0 0 0 1 4 4 1 5 0 0
## 644 45482 0 1 0 0 26 20 1 26 0 0
## 645 55090 0 1 0 2 21 18 1 23 0 0
## 646 55047 0 1 0 0 24 13 1 21 0 0
## 647 45963 0 1 0 8 22 17 0 30 0 0
## 648 59880 0 1 0 0 6 0 1 6 0 0
## 649 61123 1 0 0 5 19 13 1 24 0 0
## 650 56109 0 1 0 0 25 21 1 25 0 0
## 651 55411 1 0 0 0 22 8 1 22 0 0
## 652 41723 0 1 0 7 7 4 1 14 0 0
## 653 55752 0 0 0 0 2 2 1 2 0 1
## 654 32843 0 0 0 2 18 13 0 20 0 1
## 655 63409 0 1 0 0 22 17 1 21 0 0
## 656 62623 1 0 0 0 26 15 1 23 0 0
## 657 33703 0 1 0 1 6 1 1 7 0 1
## 658 57246 1 0 0 0 17 4 1 16 0 0
## 659 60006 1 0 0 0 24 2 1 20 0 0
## 660 50008 0 1 0 0 18 10 1 16 0 1
## 661 51745 0 1 0 0 18 15 1 18 0 0
## 662 59472 0 1 0 5 15 15 1 20 0 0
## 663 52739 1 0 0 2 26 6 1 28 0 0
## 664 35000 0 0 0 0 1 1 1 1 0 1
## 665 42718 0 1 0 0 10 5 1 10 0 0
## 666 34206 0 0 0 1 4 4 1 5 0 1
## 667 31700 0 0 1 1 0 0 0 1 0 0
## 668 41063 0 0 0 1 18 18 1 19 0 1
## 669 33787 0 1 0 7 5 1 1 12 0 0
## 670 53686 1 0 0 0 31 17 1 26 0 0
## 671 70563 1 0 0 7 26 21 1 33 0 0
## 672 37067 0 1 0 6 6 2 1 12 0 1
## 673 47349 0 1 0 0 20 9 1 13 0 0
## 674 64687 1 0 0 5 16 8 1 21 0 0
## 675 51285 0 1 0 7 25 12 0 32 0 1
## 676 35782 0 0 0 0 2 1 1 2 0 1
## 677 35558 0 0 0 1 19 18 1 20 0 0
## 678 55847 0 1 0 2 12 5 1 14 0 0
## 679 48327 0 1 0 25 2 2 1 27 0 0
## 680 57192 1 0 0 0 27 13 1 25 0 0
## 681 32000 0 0 0 7 0 0 1 7 0 1
## 682 45500 0 0 0 0 0 0 1 0 0 0
## 683 54003 1 0 0 0 20 5 1 20 0 0
## 684 55524 1 0 0 13 15 10 1 28 0 0
## 685 53611 0 0 0 0 24 24 0 24 0 1
## 686 57973 1 0 0 4 17 9 1 21 0 0
## 687 29000 0 0 0 0 0 0 1 0 0 0
## 688 48395 0 0 0 0 3 3 1 3 0 0
## 689 34731 0 0 0 0 1 1 1 1 0 1
## 690 33680 0 0 0 4 1 1 1 5 0 0
## 691 44301 0 0 0 6 10 10 1 16 0 0
## 692 27902 0 0 1 23 4 0 0 27 0 1
## 693 45985 0 1 0 2 18 10 1 20 0 0
## 694 24220 0 0 1 2 3 3 0 5 0 1
## 695 66685 0 1 0 15 5 5 1 20 0 0
## 696 28173 0 0 0 0 2 0 1 1 0 0
## 697 48581 0 1 0 0 23 11 1 17 0 0
## 698 46615 0 0 0 0 9 2 0 8 0 0
## 699 27373 0 0 1 8 2 2 0 10 0 1
## 700 47021 0 0 0 0 23 16 0 23 0 1
## 701 31000 0 0 0 9 0 0 1 9 0 1
## 702 56906 0 1 0 4 20 15 0 24 0 0
## 703 40512 0 0 1 0 11 1 0 2 0 1
## 704 31052 0 0 0 0 1 1 1 1 0 0
## 705 35782 0 0 1 2 9 1 0 11 0 0
## 706 39302 0 0 0 0 17 8 1 9 0 1
## 707 26000 0 0 1 3 0 0 0 3 0 0
## 708 34567 0 0 1 4 8 1 0 12 0 1
## 709 24220 0 0 1 2 3 3 0 5 0 0
## 710 41898 0 1 0 3 9 4 1 12 0 0
## 711 44743 1 0 0 4 13 3 1 17 0 0
## 712 25271 0 0 1 1 2 2 0 3 0 0
## 713 40000 0 0 0 7 0 0 1 7 0 0
## 714 46094 0 1 0 1 22 17 1 23 0 0
## 715 35782 0 0 1 2 3 3 0 5 0 0
## 716 41709 0 1 0 1 9 4 1 10 0 0
## 717 52308 0 1 0 0 23 14 1 18 0 0
## 718 54173 1 0 0 0 26 7 1 22 0 0
## 719 34468 0 0 1 0 2 2 1 1 0 0
## 720 50062 0 1 0 0 23 12 1 17 0 0
## 721 39795 0 0 0 3 1 1 1 4 0 0
## 722 55411 1 0 0 0 23 10 1 19 0 0
## 723 51632 0 1 0 7 20 14 1 27 0 0
## 724 38551 0 0 0 1 12 6 1 13 0 0
## 725 40928 0 1 0 0 12 4 1 11 0 0
# 1. The column names are: AYSALARY, R1, R2, R7, PRIOREXP, YRBG, YRRANK, TERMDEG, YRDG, EMINENT, FEMALE # 1. There are 725 observations. # 1. There are 11 variables.
hist(faculty$AYSALARY, col = "blue", xlab = "Annual Salary", ylab = "Faculty",
main = "Distribution of Faculty Annual Salary")
# 2. Annual salary is not normally distributed; it is positively skewed.
female <- faculty[faculty$FEMALE == "1", ]
male <- faculty[faculty$FEMALE == "0", ]
summary(female$AYSALARY)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 23800 31700 37300 39100 45900 69700
summary(male$AYSALARY)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 23800 41000 52100 51500 61000 103000
# 3. Male faculty members earn more in terms of annual salary than female faculty members.
par(mfrow = c(1, 1))
plot(faculty$AYSALARY, faculty$YRBG, xlab = "Annual Salary", ylab = "Years Employed",
pch = 2, col = "red")
# 4. Yes, there appears to be a positive relationship between salary and the number of years of employment.
rank1 <- faculty[faculty$R1 == "1", ]
rank2 <- faculty[faculty$R2 == "1", ]
rank7 <- faculty[faculty$R7 == "1", ]
# insert line or two lines here changing 1s in rank2 and rank7 into 2s and 7s respectively # code below ONLY a POSSIBILITY – not yet correct and sure rank <- faculty[faculty$rank1==“1” & faculty$rank2==“2” $ faculty$rank7==“3”,] # 5. Hmm…working on bonus, but can't quite figure it out. If I could figure out how to change the 1s in rank2 and rank7 into 2s and 7s respectively, I could then combine all three ranks into one “rank” column of categorical rank.