getwd()## [1] "C:/Users/Emahayz_Pro/Desktop"setwd("C:/Users/Emahayz_Pro/Desktop/CUNY_Bridge/R_Class")
Salaries <- read.csv("Salaries.csv", sep = ",")
Salaries## X rank discipline yrs.since.phd yrs.service sex salary
## 1 1 Prof B 19 18 Male 139750
## 2 2 Prof B 20 16 Male 173200
## 3 3 AsstProf B 4 3 Male 79750
## 4 4 Prof B 45 39 Male 115000
## 5 5 Prof B 40 41 Male 141500
## 6 6 AssocProf B 6 6 Male 97000
## 7 7 Prof B 30 23 Male 175000
## 8 8 Prof B 45 45 Male 147765
## 9 9 Prof B 21 20 Male 119250
## 10 10 Prof B 18 18 Female 129000
## 11 11 AssocProf B 12 8 Male 119800
## 12 12 AsstProf B 7 2 Male 79800
## 13 13 AsstProf B 1 1 Male 77700
## 14 14 AsstProf B 2 0 Male 78000
## 15 15 Prof B 20 18 Male 104800
## 16 16 Prof B 12 3 Male 117150
## 17 17 Prof B 19 20 Male 101000
## 18 18 Prof A 38 34 Male 103450
## 19 19 Prof A 37 23 Male 124750
## 20 20 Prof A 39 36 Female 137000
## 21 21 Prof A 31 26 Male 89565
## 22 22 Prof A 36 31 Male 102580
## 23 23 Prof A 34 30 Male 93904
## 24 24 Prof A 24 19 Male 113068
## 25 25 AssocProf A 13 8 Female 74830
## 26 26 Prof A 21 8 Male 106294
## 27 27 Prof A 35 23 Male 134885
## 28 28 AsstProf B 5 3 Male 82379
## 29 29 AsstProf B 11 0 Male 77000
## 30 30 Prof B 12 8 Male 118223
## 31 31 Prof B 20 4 Male 132261
## 32 32 AsstProf B 7 2 Male 79916
## 33 33 Prof B 13 9 Male 117256
## 34 34 AsstProf B 4 2 Male 80225
## 35 35 AsstProf B 4 2 Female 80225
## 36 36 AsstProf B 5 0 Female 77000
## 37 37 Prof B 22 21 Male 155750
## 38 38 AsstProf B 7 4 Male 86373
## 39 39 Prof B 41 31 Male 125196
## 40 40 AssocProf B 9 9 Male 100938
## 41 41 Prof B 23 2 Male 146500
## 42 42 AssocProf B 23 23 Male 93418
## 43 43 Prof B 40 27 Male 101299
## 44 44 Prof B 38 38 Male 231545
## 45 45 Prof B 19 19 Male 94384
## 46 46 Prof B 25 15 Male 114778
## 47 47 Prof B 40 28 Male 98193
## 48 48 Prof B 23 19 Female 151768
## 49 49 Prof B 25 25 Female 140096
## 50 50 AsstProf B 1 1 Male 70768
## 51 51 Prof B 28 28 Male 126621
## 52 52 Prof B 12 11 Male 108875
## 53 53 AsstProf B 11 3 Female 74692
## 54 54 Prof B 16 9 Male 106639
## 55 55 AssocProf B 12 11 Male 103760
## 56 56 AssocProf B 14 5 Male 83900
## 57 57 Prof B 23 21 Male 117704
## 58 58 AssocProf B 9 8 Male 90215
## 59 59 AssocProf B 10 9 Male 100135
## 60 60 AsstProf B 8 3 Male 75044
## 61 61 AssocProf B 9 8 Male 90304
## 62 62 AsstProf B 3 2 Male 75243
## 63 63 Prof B 33 31 Male 109785
## 64 64 AssocProf B 11 11 Female 103613
## 65 65 AsstProf B 4 3 Male 68404
## 66 66 AssocProf B 9 8 Male 100522
## 67 67 Prof B 22 12 Male 101000
## 68 68 Prof B 35 31 Male 99418
## 69 69 Prof B 17 17 Female 111512
## 70 70 Prof B 28 36 Male 91412
## 71 71 Prof B 17 2 Male 126320
## 72 72 Prof B 45 45 Male 146856
## 73 73 Prof B 29 19 Male 100131
## 74 74 Prof B 35 34 Male 92391
## 75 75 Prof B 28 23 Male 113398
## 76 76 AsstProf B 8 3 Male 73266
## 77 77 Prof B 17 3 Male 150480
## 78 78 Prof B 26 19 Male 193000
## 79 79 AsstProf B 3 1 Male 86100
## 80 80 AsstProf B 6 2 Male 84240
## 81 81 Prof B 43 28 Male 150743
## 82 82 Prof B 17 16 Male 135585
## 83 83 Prof B 22 20 Male 144640
## 84 84 AsstProf B 6 2 Male 88825
## 85 85 Prof B 17 18 Female 122960
## 86 86 Prof B 15 14 Male 132825
## 87 87 Prof B 37 37 Male 152708
## 88 88 AsstProf B 2 2 Male 88400
## 89 89 Prof B 25 25 Male 172272
## 90 90 AssocProf B 9 7 Male 107008
## 91 91 AsstProf B 10 5 Female 97032
## 92 92 AssocProf B 10 7 Male 105128
## 93 93 AssocProf B 10 7 Male 105631
## 94 94 Prof B 38 38 Male 166024
## 95 95 Prof B 21 20 Male 123683
## 96 96 AsstProf B 4 0 Male 84000
## 97 97 AssocProf B 17 12 Male 95611
## 98 98 Prof B 13 7 Male 129676
## 99 99 Prof B 30 14 Male 102235
## 100 100 Prof B 41 26 Male 106689
## 101 101 Prof B 42 25 Male 133217
## 102 102 Prof B 28 23 Male 126933
## 103 103 Prof B 16 5 Male 153303
## 104 104 Prof B 20 14 Female 127512
## 105 105 AssocProf A 18 10 Male 83850
## 106 106 Prof A 31 28 Male 113543
## 107 107 AssocProf A 11 8 Male 82099
## 108 108 AssocProf A 10 8 Male 82600
## 109 109 AssocProf A 15 8 Male 81500
## 110 110 Prof A 40 31 Male 131205
## 111 111 Prof A 20 16 Male 112429
## 112 112 AssocProf A 19 16 Male 82100
## 113 113 AsstProf A 3 1 Male 72500
## 114 114 Prof A 37 37 Male 104279
## 115 115 Prof A 12 0 Female 105000
## 116 116 Prof A 21 9 Male 120806
## 117 117 Prof A 30 29 Male 148500
## 118 118 Prof A 39 36 Male 117515
## 119 119 AsstProf A 4 1 Male 72500
## 120 120 AsstProf A 5 3 Female 73500
## 121 121 Prof A 14 14 Male 115313
## 122 122 Prof A 32 32 Male 124309
## 123 123 Prof A 24 22 Male 97262
## 124 124 AssocProf A 25 22 Female 62884
## 125 125 Prof A 24 22 Male 96614
## 126 126 Prof A 54 49 Male 78162
## 127 127 Prof A 28 26 Male 155500
## 128 128 AsstProf A 2 0 Female 72500
## 129 129 Prof A 32 30 Male 113278
## 130 130 AsstProf A 4 2 Male 73000
## 131 131 AssocProf A 11 9 Male 83001
## 132 132 Prof A 56 57 Male 76840
## 133 133 AssocProf A 10 8 Female 77500
## 134 134 AsstProf A 3 1 Female 72500
## 135 135 Prof A 35 25 Male 168635
## 136 136 Prof A 20 18 Male 136000
## 137 137 Prof A 16 14 Male 108262
## 138 138 Prof A 17 14 Male 105668
## 139 139 AssocProf A 10 7 Male 73877
## 140 140 Prof A 21 18 Male 152664
## 141 141 AssocProf A 14 8 Male 100102
## 142 142 AssocProf A 15 10 Male 81500
## 143 143 Prof A 19 11 Male 106608
## 144 144 AsstProf B 3 3 Male 89942
## 145 145 Prof B 27 27 Male 112696
## 146 146 Prof B 28 28 Male 119015
## 147 147 AsstProf B 4 4 Male 92000
## 148 148 Prof B 27 27 Male 156938
## 149 149 Prof B 36 26 Female 144651
## 150 150 AsstProf B 4 3 Male 95079
## 151 151 Prof B 14 12 Male 128148
## 152 152 AsstProf B 4 4 Male 92000
## 153 153 Prof B 21 9 Male 111168
## 154 154 AssocProf B 12 10 Female 103994
## 155 155 AsstProf B 4 0 Male 92000
## 156 156 Prof B 21 21 Male 118971
## 157 157 AssocProf B 12 18 Male 113341
## 158 158 AsstProf B 1 0 Male 88000
## 159 159 AssocProf B 6 6 Male 95408
## 160 160 Prof B 15 16 Male 137167
## 161 161 AsstProf B 2 2 Male 89516
## 162 162 Prof B 26 19 Male 176500
## 163 163 AssocProf B 22 7 Male 98510
## 164 164 AsstProf B 3 3 Male 89942
## 165 165 AsstProf B 1 0 Male 88795
## 166 166 Prof B 21 8 Male 105890
## 167 167 Prof B 16 16 Male 167284
## 168 168 Prof B 18 19 Male 130664
## 169 169 AssocProf B 8 6 Male 101210
## 170 170 Prof B 25 18 Male 181257
## 171 171 AsstProf B 5 5 Male 91227
## 172 172 Prof B 19 19 Male 151575
## 173 173 Prof B 37 24 Male 93164
## 174 174 Prof B 20 20 Male 134185
## 175 175 AssocProf B 17 6 Male 105000
## 176 176 Prof B 28 25 Male 111751
## 177 177 AssocProf B 10 7 Male 95436
## 178 178 AssocProf B 13 9 Male 100944
## 179 179 Prof B 27 14 Male 147349
## 180 180 AsstProf B 3 3 Female 92000
## 181 181 Prof B 11 11 Male 142467
## 182 182 Prof B 18 5 Male 141136
## 183 183 AssocProf B 8 8 Male 100000
## 184 184 Prof B 26 22 Male 150000
## 185 185 Prof B 23 23 Male 101000
## 186 186 Prof B 33 30 Male 134000
## 187 187 AssocProf B 13 10 Female 103750
## 188 188 Prof B 18 10 Male 107500
## 189 189 AssocProf B 28 28 Male 106300
## 190 190 Prof B 25 19 Male 153750
## 191 191 Prof B 22 9 Male 180000
## 192 192 Prof B 43 22 Male 133700
## 193 193 Prof B 19 18 Male 122100
## 194 194 AssocProf B 19 19 Male 86250
## 195 195 AssocProf B 48 53 Male 90000
## 196 196 AssocProf B 9 7 Male 113600
## 197 197 AsstProf B 4 4 Male 92700
## 198 198 AsstProf B 4 4 Male 92000
## 199 199 Prof B 34 33 Male 189409
## 200 200 Prof B 38 22 Male 114500
## 201 201 AsstProf B 4 4 Male 92700
## 202 202 Prof B 40 40 Male 119700
## 203 203 Prof B 28 17 Male 160400
## 204 204 Prof B 17 17 Male 152500
## 205 205 Prof B 19 5 Male 165000
## 206 206 Prof B 21 2 Male 96545
## 207 207 Prof B 35 33 Male 162200
## 208 208 Prof B 18 18 Male 120000
## 209 209 AsstProf B 7 2 Male 91300
## 210 210 Prof B 20 20 Male 163200
## 211 211 AsstProf B 4 3 Male 91000
## 212 212 Prof B 39 39 Male 111350
## 213 213 Prof B 15 7 Male 128400
## 214 214 Prof B 26 19 Male 126200
## 215 215 AssocProf B 11 1 Male 118700
## 216 216 Prof B 16 11 Male 145350
## 217 217 Prof B 15 11 Male 146000
## 218 218 AssocProf B 29 22 Male 105350
## 219 219 AssocProf B 14 7 Female 109650
## 220 220 Prof B 13 11 Male 119500
## 221 221 Prof B 21 21 Male 170000
## 222 222 Prof B 23 10 Male 145200
## 223 223 AssocProf B 13 6 Male 107150
## 224 224 Prof B 34 20 Male 129600
## 225 225 Prof A 38 35 Male 87800
## 226 226 Prof A 20 20 Male 122400
## 227 227 AsstProf A 3 1 Male 63900
## 228 228 AssocProf A 9 7 Male 70000
## 229 229 Prof A 16 11 Male 88175
## 230 230 Prof A 39 38 Male 133900
## 231 231 Prof A 29 27 Female 91000
## 232 232 AssocProf A 26 24 Female 73300
## 233 233 Prof A 38 19 Male 148750
## 234 234 Prof A 36 19 Female 117555
## 235 235 AsstProf A 8 3 Male 69700
## 236 236 Prof A 28 17 Male 81700
## 237 237 Prof A 25 25 Male 114000
## 238 238 AsstProf A 7 6 Female 63100
## 239 239 Prof A 46 40 Male 77202
## 240 240 Prof A 19 6 Male 96200
## 241 241 AsstProf A 5 3 Male 69200
## 242 242 Prof A 31 30 Male 122875
## 243 243 Prof A 38 37 Male 102600
## 244 244 Prof A 23 23 Male 108200
## 245 245 Prof A 19 23 Male 84273
## 246 246 Prof A 17 11 Female 90450
## 247 247 Prof A 30 23 Male 91100
## 248 248 Prof A 21 18 Male 101100
## 249 249 Prof A 28 23 Male 128800
## 250 250 Prof A 29 7 Male 204000
## 251 251 Prof A 39 39 Male 109000
## 252 252 Prof A 20 8 Male 102000
## 253 253 Prof A 31 12 Male 132000
## 254 254 AsstProf A 4 2 Female 77500
## 255 255 Prof A 28 7 Female 116450
## 256 256 AssocProf A 12 8 Male 83000
## 257 257 Prof A 22 22 Male 140300
## 258 258 AssocProf A 30 23 Male 74000
## 259 259 AsstProf A 9 3 Male 73800
## 260 260 Prof A 32 30 Male 92550
## 261 261 AssocProf A 41 33 Male 88600
## 262 262 Prof A 45 45 Male 107550
## 263 263 Prof A 31 26 Male 121200
## 264 264 Prof A 31 31 Male 126000
## 265 265 Prof A 37 35 Male 99000
## 266 266 Prof A 36 30 Male 134800
## 267 267 Prof A 43 43 Male 143940
## 268 268 Prof A 14 10 Male 104350
## 269 269 Prof A 47 44 Male 89650
## 270 270 Prof A 13 7 Male 103700
## 271 271 Prof A 42 40 Male 143250
## 272 272 Prof A 42 18 Male 194800
## 273 273 AsstProf A 4 1 Male 73000
## 274 274 AsstProf A 8 4 Male 74000
## 275 275 AsstProf A 8 3 Female 78500
## 276 276 Prof A 12 6 Male 93000
## 277 277 Prof A 52 48 Male 107200
## 278 278 Prof A 31 27 Male 163200
## 279 279 Prof A 24 18 Male 107100
## 280 280 Prof A 46 46 Male 100600
## 281 281 Prof A 39 38 Male 136500
## 282 282 Prof A 37 27 Male 103600
## 283 283 Prof A 51 51 Male 57800
## 284 284 Prof A 45 43 Male 155865
## 285 285 AssocProf A 8 6 Male 88650
## 286 286 AssocProf A 49 49 Male 81800
## 287 287 Prof A 28 27 Male 115800
## 288 288 AsstProf A 2 0 Male 85000
## 289 289 Prof A 29 27 Male 150500
## 290 290 AsstProf A 8 5 Male 74000
## 291 291 Prof A 33 7 Male 174500
## 292 292 Prof A 32 28 Male 168500
## 293 293 Prof A 39 9 Male 183800
## 294 294 AssocProf A 11 1 Male 104800
## 295 295 Prof A 19 7 Male 107300
## 296 296 Prof A 40 36 Male 97150
## 297 297 Prof A 18 18 Male 126300
## 298 298 Prof A 17 11 Male 148800
## 299 299 Prof A 49 43 Male 72300
## 300 300 AssocProf A 45 39 Male 70700
## 301 301 Prof A 39 36 Male 88600
## 302 302 Prof A 27 16 Male 127100
## 303 303 Prof A 28 13 Male 170500
## 304 304 Prof A 14 4 Male 105260
## 305 305 Prof A 46 44 Male 144050
## 306 306 Prof A 33 31 Male 111350
## 307 307 AsstProf A 7 4 Male 74500
## 308 308 Prof A 31 28 Male 122500
## 309 309 AsstProf A 5 0 Male 74000
## 310 310 Prof A 22 15 Male 166800
## 311 311 Prof A 20 7 Male 92050
## 312 312 Prof A 14 9 Male 108100
## 313 313 Prof A 29 19 Male 94350
## 314 314 Prof A 35 35 Male 100351
## 315 315 Prof A 22 6 Male 146800
## 316 316 AsstProf B 6 3 Male 84716
## 317 317 AssocProf B 12 9 Female 71065
## 318 318 Prof B 46 45 Male 67559
## 319 319 Prof B 16 16 Male 134550
## 320 320 Prof B 16 15 Male 135027
## 321 321 Prof B 24 23 Male 104428
## 322 322 AssocProf B 9 9 Male 95642
## 323 323 AssocProf B 13 11 Male 126431
## 324 324 Prof B 24 15 Female 161101
## 325 325 Prof B 30 31 Male 162221
## 326 326 AsstProf B 8 4 Male 84500
## 327 327 Prof B 23 15 Male 124714
## 328 328 Prof B 37 37 Male 151650
## 329 329 AssocProf B 10 10 Male 99247
## 330 330 Prof B 23 23 Male 134778
## 331 331 Prof B 49 60 Male 192253
## 332 332 Prof B 20 9 Male 116518
## 333 333 Prof B 18 10 Female 105450
## 334 334 Prof B 33 19 Male 145098
## 335 335 AssocProf B 19 6 Female 104542
## 336 336 Prof B 36 38 Male 151445
## 337 337 Prof B 35 23 Male 98053
## 338 338 Prof B 13 12 Male 145000
## 339 339 Prof B 32 25 Male 128464
## 340 340 Prof B 37 15 Male 137317
## 341 341 Prof B 13 11 Male 106231
## 342 342 Prof B 17 17 Female 124312
## 343 343 Prof B 38 38 Male 114596
## 344 344 Prof B 31 31 Male 162150
## 345 345 Prof B 32 35 Male 150376
## 346 346 Prof B 15 10 Male 107986
## 347 347 Prof B 41 27 Male 142023
## 348 348 Prof B 39 33 Male 128250
## 349 349 AsstProf B 4 3 Male 80139
## 350 350 Prof B 27 28 Male 144309
## 351 351 Prof B 56 49 Male 186960
## 352 352 Prof B 38 38 Male 93519
## 353 353 Prof B 26 27 Male 142500
## 354 354 Prof B 22 20 Male 138000
## 355 355 AsstProf B 8 1 Male 83600
## 356 356 Prof B 25 21 Male 145028
## 357 357 Prof A 49 40 Male 88709
## 358 358 Prof A 39 35 Male 107309
## 359 359 Prof A 28 14 Female 109954
## 360 360 AsstProf A 11 4 Male 78785
## 361 361 Prof A 14 11 Male 121946
## 362 362 Prof A 23 15 Female 109646
## 363 363 Prof A 30 30 Male 138771
## 364 364 AssocProf A 20 17 Male 81285
## 365 365 Prof A 43 43 Male 205500
## 366 366 Prof A 43 40 Male 101036
## 367 367 Prof A 15 10 Male 115435
## 368 368 AssocProf A 10 1 Male 108413
## 369 369 Prof A 35 30 Male 131950
## 370 370 Prof A 33 31 Male 134690
## 371 371 AssocProf A 13 8 Male 78182
## 372 372 Prof A 23 20 Male 110515
## 373 373 Prof A 12 7 Male 109707
## 374 374 Prof A 30 26 Male 136660
## 375 375 Prof A 27 19 Male 103275
## 376 376 Prof A 28 26 Male 103649
## 377 377 AsstProf A 4 1 Male 74856
## 378 378 AsstProf A 6 3 Male 77081
## 379 379 Prof A 38 38 Male 150680
## 380 380 AssocProf A 11 8 Male 104121
## 381 381 AsstProf A 8 3 Male 75996
## 382 382 Prof A 27 23 Male 172505
## 383 383 AssocProf A 8 5 Male 86895
## 384 384 Prof A 44 44 Male 105000
## 385 385 Prof A 27 21 Male 125192
## 386 386 Prof A 15 9 Male 114330
## 387 387 Prof A 29 27 Male 139219
## 388 388 Prof A 29 15 Male 109305
## 389 389 Prof A 38 36 Male 119450
## 390 390 Prof A 33 18 Male 186023
## 391 391 Prof A 40 19 Male 166605
## 392 392 Prof A 30 19 Male 151292
## 393 393 Prof A 33 30 Male 103106
## 394 394 Prof A 31 19 Male 150564
## 395 395 Prof A 42 25 Male 101738
## 396 396 Prof A 25 15 Male 95329
## 397 397 AsstProf A 8 4 Male 81035summary(Salaries)## X rank discipline yrs.since.phd yrs.service
## Min. : 1 AssocProf: 64 A:181 Min. : 1.00 Min. : 0.00
## 1st Qu.:100 AsstProf : 67 B:216 1st Qu.:12.00 1st Qu.: 7.00
## Median :199 Prof :266 Median :21.00 Median :16.00
## Mean :199 Mean :22.31 Mean :17.61
## 3rd Qu.:298 3rd Qu.:32.00 3rd Qu.:27.00
## Max. :397 Max. :56.00 Max. :60.00
## sex salary
## Female: 39 Min. : 57800
## Male :358 1st Qu.: 91000
## Median :107300
## Mean :113706
## 3rd Qu.:134185
## Max. :231545mean(Salaries$salary)# The mean salary is $113,706.50## [1] 113706.5median(Salaries$salary)# The median salary is $107,300## [1] 107300mean(Salaries$yrs.service)# The average year of service is 17.6 corresponding to 17 years and 6 months.## [1] 17.61461median(Salaries$yrs.service) # The median year of service is 16 years## [1] 16Salaries_Service_Years <- subset(Salaries, yrs.service >2)
Salaries_Service_Years # New data frame with years of service greater than 2.## X rank discipline yrs.since.phd yrs.service sex salary
## 1 1 Prof B 19 18 Male 139750
## 2 2 Prof B 20 16 Male 173200
## 3 3 AsstProf B 4 3 Male 79750
## 4 4 Prof B 45 39 Male 115000
## 5 5 Prof B 40 41 Male 141500
## 6 6 AssocProf B 6 6 Male 97000
## 7 7 Prof B 30 23 Male 175000
## 8 8 Prof B 45 45 Male 147765
## 9 9 Prof B 21 20 Male 119250
## 10 10 Prof B 18 18 Female 129000
## 11 11 AssocProf B 12 8 Male 119800
## 15 15 Prof B 20 18 Male 104800
## 16 16 Prof B 12 3 Male 117150
## 17 17 Prof B 19 20 Male 101000
## 18 18 Prof A 38 34 Male 103450
## 19 19 Prof A 37 23 Male 124750
## 20 20 Prof A 39 36 Female 137000
## 21 21 Prof A 31 26 Male 89565
## 22 22 Prof A 36 31 Male 102580
## 23 23 Prof A 34 30 Male 93904
## 24 24 Prof A 24 19 Male 113068
## 25 25 AssocProf A 13 8 Female 74830
## 26 26 Prof A 21 8 Male 106294
## 27 27 Prof A 35 23 Male 134885
## 28 28 AsstProf B 5 3 Male 82379
## 30 30 Prof B 12 8 Male 118223
## 31 31 Prof B 20 4 Male 132261
## 33 33 Prof B 13 9 Male 117256
## 37 37 Prof B 22 21 Male 155750
## 38 38 AsstProf B 7 4 Male 86373
## 39 39 Prof B 41 31 Male 125196
## 40 40 AssocProf B 9 9 Male 100938
## 42 42 AssocProf B 23 23 Male 93418
## 43 43 Prof B 40 27 Male 101299
## 44 44 Prof B 38 38 Male 231545
## 45 45 Prof B 19 19 Male 94384
## 46 46 Prof B 25 15 Male 114778
## 47 47 Prof B 40 28 Male 98193
## 48 48 Prof B 23 19 Female 151768
## 49 49 Prof B 25 25 Female 140096
## 51 51 Prof B 28 28 Male 126621
## 52 52 Prof B 12 11 Male 108875
## 53 53 AsstProf B 11 3 Female 74692
## 54 54 Prof B 16 9 Male 106639
## 55 55 AssocProf B 12 11 Male 103760
## 56 56 AssocProf B 14 5 Male 83900
## 57 57 Prof B 23 21 Male 117704
## 58 58 AssocProf B 9 8 Male 90215
## 59 59 AssocProf B 10 9 Male 100135
## 60 60 AsstProf B 8 3 Male 75044
## 61 61 AssocProf B 9 8 Male 90304
## 63 63 Prof B 33 31 Male 109785
## 64 64 AssocProf B 11 11 Female 103613
## 65 65 AsstProf B 4 3 Male 68404
## 66 66 AssocProf B 9 8 Male 100522
## 67 67 Prof B 22 12 Male 101000
## 68 68 Prof B 35 31 Male 99418
## 69 69 Prof B 17 17 Female 111512
## 70 70 Prof B 28 36 Male 91412
## 72 72 Prof B 45 45 Male 146856
## 73 73 Prof B 29 19 Male 100131
## 74 74 Prof B 35 34 Male 92391
## 75 75 Prof B 28 23 Male 113398
## 76 76 AsstProf B 8 3 Male 73266
## 77 77 Prof B 17 3 Male 150480
## 78 78 Prof B 26 19 Male 193000
## 81 81 Prof B 43 28 Male 150743
## 82 82 Prof B 17 16 Male 135585
## 83 83 Prof B 22 20 Male 144640
## 85 85 Prof B 17 18 Female 122960
## 86 86 Prof B 15 14 Male 132825
## 87 87 Prof B 37 37 Male 152708
## 89 89 Prof B 25 25 Male 172272
## 90 90 AssocProf B 9 7 Male 107008
## 91 91 AsstProf B 10 5 Female 97032
## 92 92 AssocProf B 10 7 Male 105128
## 93 93 AssocProf B 10 7 Male 105631
## 94 94 Prof B 38 38 Male 166024
## 95 95 Prof B 21 20 Male 123683
## 97 97 AssocProf B 17 12 Male 95611
## 98 98 Prof B 13 7 Male 129676
## 99 99 Prof B 30 14 Male 102235
## 100 100 Prof B 41 26 Male 106689
## 101 101 Prof B 42 25 Male 133217
## 102 102 Prof B 28 23 Male 126933
## 103 103 Prof B 16 5 Male 153303
## 104 104 Prof B 20 14 Female 127512
## 105 105 AssocProf A 18 10 Male 83850
## 106 106 Prof A 31 28 Male 113543
## 107 107 AssocProf A 11 8 Male 82099
## 108 108 AssocProf A 10 8 Male 82600
## 109 109 AssocProf A 15 8 Male 81500
## 110 110 Prof A 40 31 Male 131205
## 111 111 Prof A 20 16 Male 112429
## 112 112 AssocProf A 19 16 Male 82100
## 114 114 Prof A 37 37 Male 104279
## 116 116 Prof A 21 9 Male 120806
## 117 117 Prof A 30 29 Male 148500
## 118 118 Prof A 39 36 Male 117515
## 120 120 AsstProf A 5 3 Female 73500
## 121 121 Prof A 14 14 Male 115313
## 122 122 Prof A 32 32 Male 124309
## 123 123 Prof A 24 22 Male 97262
## 124 124 AssocProf A 25 22 Female 62884
## 125 125 Prof A 24 22 Male 96614
## 126 126 Prof A 54 49 Male 78162
## 127 127 Prof A 28 26 Male 155500
## 129 129 Prof A 32 30 Male 113278
## 131 131 AssocProf A 11 9 Male 83001
## 132 132 Prof A 56 57 Male 76840
## 133 133 AssocProf A 10 8 Female 77500
## 135 135 Prof A 35 25 Male 168635
## 136 136 Prof A 20 18 Male 136000
## 137 137 Prof A 16 14 Male 108262
## 138 138 Prof A 17 14 Male 105668
## 139 139 AssocProf A 10 7 Male 73877
## 140 140 Prof A 21 18 Male 152664
## 141 141 AssocProf A 14 8 Male 100102
## 142 142 AssocProf A 15 10 Male 81500
## 143 143 Prof A 19 11 Male 106608
## 144 144 AsstProf B 3 3 Male 89942
## 145 145 Prof B 27 27 Male 112696
## 146 146 Prof B 28 28 Male 119015
## 147 147 AsstProf B 4 4 Male 92000
## 148 148 Prof B 27 27 Male 156938
## 149 149 Prof B 36 26 Female 144651
## 150 150 AsstProf B 4 3 Male 95079
## 151 151 Prof B 14 12 Male 128148
## 152 152 AsstProf B 4 4 Male 92000
## 153 153 Prof B 21 9 Male 111168
## 154 154 AssocProf B 12 10 Female 103994
## 156 156 Prof B 21 21 Male 118971
## 157 157 AssocProf B 12 18 Male 113341
## 159 159 AssocProf B 6 6 Male 95408
## 160 160 Prof B 15 16 Male 137167
## 162 162 Prof B 26 19 Male 176500
## 163 163 AssocProf B 22 7 Male 98510
## 164 164 AsstProf B 3 3 Male 89942
## 166 166 Prof B 21 8 Male 105890
## 167 167 Prof B 16 16 Male 167284
## 168 168 Prof B 18 19 Male 130664
## 169 169 AssocProf B 8 6 Male 101210
## 170 170 Prof B 25 18 Male 181257
## 171 171 AsstProf B 5 5 Male 91227
## 172 172 Prof B 19 19 Male 151575
## 173 173 Prof B 37 24 Male 93164
## 174 174 Prof B 20 20 Male 134185
## 175 175 AssocProf B 17 6 Male 105000
## 176 176 Prof B 28 25 Male 111751
## 177 177 AssocProf B 10 7 Male 95436
## 178 178 AssocProf B 13 9 Male 100944
## 179 179 Prof B 27 14 Male 147349
## 180 180 AsstProf B 3 3 Female 92000
## 181 181 Prof B 11 11 Male 142467
## 182 182 Prof B 18 5 Male 141136
## 183 183 AssocProf B 8 8 Male 100000
## 184 184 Prof B 26 22 Male 150000
## 185 185 Prof B 23 23 Male 101000
## 186 186 Prof B 33 30 Male 134000
## 187 187 AssocProf B 13 10 Female 103750
## 188 188 Prof B 18 10 Male 107500
## 189 189 AssocProf B 28 28 Male 106300
## 190 190 Prof B 25 19 Male 153750
## 191 191 Prof B 22 9 Male 180000
## 192 192 Prof B 43 22 Male 133700
## 193 193 Prof B 19 18 Male 122100
## 194 194 AssocProf B 19 19 Male 86250
## 195 195 AssocProf B 48 53 Male 90000
## 196 196 AssocProf B 9 7 Male 113600
## 197 197 AsstProf B 4 4 Male 92700
## 198 198 AsstProf B 4 4 Male 92000
## 199 199 Prof B 34 33 Male 189409
## 200 200 Prof B 38 22 Male 114500
## 201 201 AsstProf B 4 4 Male 92700
## 202 202 Prof B 40 40 Male 119700
## 203 203 Prof B 28 17 Male 160400
## 204 204 Prof B 17 17 Male 152500
## 205 205 Prof B 19 5 Male 165000
## 207 207 Prof B 35 33 Male 162200
## 208 208 Prof B 18 18 Male 120000
## 210 210 Prof B 20 20 Male 163200
## 211 211 AsstProf B 4 3 Male 91000
## 212 212 Prof B 39 39 Male 111350
## 213 213 Prof B 15 7 Male 128400
## 214 214 Prof B 26 19 Male 126200
## 216 216 Prof B 16 11 Male 145350
## 217 217 Prof B 15 11 Male 146000
## 218 218 AssocProf B 29 22 Male 105350
## 219 219 AssocProf B 14 7 Female 109650
## 220 220 Prof B 13 11 Male 119500
## 221 221 Prof B 21 21 Male 170000
## 222 222 Prof B 23 10 Male 145200
## 223 223 AssocProf B 13 6 Male 107150
## 224 224 Prof B 34 20 Male 129600
## 225 225 Prof A 38 35 Male 87800
## 226 226 Prof A 20 20 Male 122400
## 228 228 AssocProf A 9 7 Male 70000
## 229 229 Prof A 16 11 Male 88175
## 230 230 Prof A 39 38 Male 133900
## 231 231 Prof A 29 27 Female 91000
## 232 232 AssocProf A 26 24 Female 73300
## 233 233 Prof A 38 19 Male 148750
## 234 234 Prof A 36 19 Female 117555
## 235 235 AsstProf A 8 3 Male 69700
## 236 236 Prof A 28 17 Male 81700
## 237 237 Prof A 25 25 Male 114000
## 238 238 AsstProf A 7 6 Female 63100
## 239 239 Prof A 46 40 Male 77202
## 240 240 Prof A 19 6 Male 96200
## 241 241 AsstProf A 5 3 Male 69200
## 242 242 Prof A 31 30 Male 122875
## 243 243 Prof A 38 37 Male 102600
## 244 244 Prof A 23 23 Male 108200
## 245 245 Prof A 19 23 Male 84273
## 246 246 Prof A 17 11 Female 90450
## 247 247 Prof A 30 23 Male 91100
## 248 248 Prof A 21 18 Male 101100
## 249 249 Prof A 28 23 Male 128800
## 250 250 Prof A 29 7 Male 204000
## 251 251 Prof A 39 39 Male 109000
## 252 252 Prof A 20 8 Male 102000
## 253 253 Prof A 31 12 Male 132000
## 255 255 Prof A 28 7 Female 116450
## 256 256 AssocProf A 12 8 Male 83000
## 257 257 Prof A 22 22 Male 140300
## 258 258 AssocProf A 30 23 Male 74000
## 259 259 AsstProf A 9 3 Male 73800
## 260 260 Prof A 32 30 Male 92550
## 261 261 AssocProf A 41 33 Male 88600
## 262 262 Prof A 45 45 Male 107550
## 263 263 Prof A 31 26 Male 121200
## 264 264 Prof A 31 31 Male 126000
## 265 265 Prof A 37 35 Male 99000
## 266 266 Prof A 36 30 Male 134800
## 267 267 Prof A 43 43 Male 143940
## 268 268 Prof A 14 10 Male 104350
## 269 269 Prof A 47 44 Male 89650
## 270 270 Prof A 13 7 Male 103700
## 271 271 Prof A 42 40 Male 143250
## 272 272 Prof A 42 18 Male 194800
## 274 274 AsstProf A 8 4 Male 74000
## 275 275 AsstProf A 8 3 Female 78500
## 276 276 Prof A 12 6 Male 93000
## 277 277 Prof A 52 48 Male 107200
## 278 278 Prof A 31 27 Male 163200
## 279 279 Prof A 24 18 Male 107100
## 280 280 Prof A 46 46 Male 100600
## 281 281 Prof A 39 38 Male 136500
## 282 282 Prof A 37 27 Male 103600
## 283 283 Prof A 51 51 Male 57800
## 284 284 Prof A 45 43 Male 155865
## 285 285 AssocProf A 8 6 Male 88650
## 286 286 AssocProf A 49 49 Male 81800
## 287 287 Prof A 28 27 Male 115800
## 289 289 Prof A 29 27 Male 150500
## 290 290 AsstProf A 8 5 Male 74000
## 291 291 Prof A 33 7 Male 174500
## 292 292 Prof A 32 28 Male 168500
## 293 293 Prof A 39 9 Male 183800
## 295 295 Prof A 19 7 Male 107300
## 296 296 Prof A 40 36 Male 97150
## 297 297 Prof A 18 18 Male 126300
## 298 298 Prof A 17 11 Male 148800
## 299 299 Prof A 49 43 Male 72300
## 300 300 AssocProf A 45 39 Male 70700
## 301 301 Prof A 39 36 Male 88600
## 302 302 Prof A 27 16 Male 127100
## 303 303 Prof A 28 13 Male 170500
## 304 304 Prof A 14 4 Male 105260
## 305 305 Prof A 46 44 Male 144050
## 306 306 Prof A 33 31 Male 111350
## 307 307 AsstProf A 7 4 Male 74500
## 308 308 Prof A 31 28 Male 122500
## 310 310 Prof A 22 15 Male 166800
## 311 311 Prof A 20 7 Male 92050
## 312 312 Prof A 14 9 Male 108100
## 313 313 Prof A 29 19 Male 94350
## 314 314 Prof A 35 35 Male 100351
## 315 315 Prof A 22 6 Male 146800
## 316 316 AsstProf B 6 3 Male 84716
## 317 317 AssocProf B 12 9 Female 71065
## 318 318 Prof B 46 45 Male 67559
## 319 319 Prof B 16 16 Male 134550
## 320 320 Prof B 16 15 Male 135027
## 321 321 Prof B 24 23 Male 104428
## 322 322 AssocProf B 9 9 Male 95642
## 323 323 AssocProf B 13 11 Male 126431
## 324 324 Prof B 24 15 Female 161101
## 325 325 Prof B 30 31 Male 162221
## 326 326 AsstProf B 8 4 Male 84500
## 327 327 Prof B 23 15 Male 124714
## 328 328 Prof B 37 37 Male 151650
## 329 329 AssocProf B 10 10 Male 99247
## 330 330 Prof B 23 23 Male 134778
## 331 331 Prof B 49 60 Male 192253
## 332 332 Prof B 20 9 Male 116518
## 333 333 Prof B 18 10 Female 105450
## 334 334 Prof B 33 19 Male 145098
## 335 335 AssocProf B 19 6 Female 104542
## 336 336 Prof B 36 38 Male 151445
## 337 337 Prof B 35 23 Male 98053
## 338 338 Prof B 13 12 Male 145000
## 339 339 Prof B 32 25 Male 128464
## 340 340 Prof B 37 15 Male 137317
## 341 341 Prof B 13 11 Male 106231
## 342 342 Prof B 17 17 Female 124312
## 343 343 Prof B 38 38 Male 114596
## 344 344 Prof B 31 31 Male 162150
## 345 345 Prof B 32 35 Male 150376
## 346 346 Prof B 15 10 Male 107986
## 347 347 Prof B 41 27 Male 142023
## 348 348 Prof B 39 33 Male 128250
## 349 349 AsstProf B 4 3 Male 80139
## 350 350 Prof B 27 28 Male 144309
## 351 351 Prof B 56 49 Male 186960
## 352 352 Prof B 38 38 Male 93519
## 353 353 Prof B 26 27 Male 142500
## 354 354 Prof B 22 20 Male 138000
## 356 356 Prof B 25 21 Male 145028
## 357 357 Prof A 49 40 Male 88709
## 358 358 Prof A 39 35 Male 107309
## 359 359 Prof A 28 14 Female 109954
## 360 360 AsstProf A 11 4 Male 78785
## 361 361 Prof A 14 11 Male 121946
## 362 362 Prof A 23 15 Female 109646
## 363 363 Prof A 30 30 Male 138771
## 364 364 AssocProf A 20 17 Male 81285
## 365 365 Prof A 43 43 Male 205500
## 366 366 Prof A 43 40 Male 101036
## 367 367 Prof A 15 10 Male 115435
## 369 369 Prof A 35 30 Male 131950
## 370 370 Prof A 33 31 Male 134690
## 371 371 AssocProf A 13 8 Male 78182
## 372 372 Prof A 23 20 Male 110515
## 373 373 Prof A 12 7 Male 109707
## 374 374 Prof A 30 26 Male 136660
## 375 375 Prof A 27 19 Male 103275
## 376 376 Prof A 28 26 Male 103649
## 378 378 AsstProf A 6 3 Male 77081
## 379 379 Prof A 38 38 Male 150680
## 380 380 AssocProf A 11 8 Male 104121
## 381 381 AsstProf A 8 3 Male 75996
## 382 382 Prof A 27 23 Male 172505
## 383 383 AssocProf A 8 5 Male 86895
## 384 384 Prof A 44 44 Male 105000
## 385 385 Prof A 27 21 Male 125192
## 386 386 Prof A 15 9 Male 114330
## 387 387 Prof A 29 27 Male 139219
## 388 388 Prof A 29 15 Male 109305
## 389 389 Prof A 38 36 Male 119450
## 390 390 Prof A 33 18 Male 186023
## 391 391 Prof A 40 19 Male 166605
## 392 392 Prof A 30 19 Male 151292
## 393 393 Prof A 33 30 Male 103106
## 394 394 Prof A 31 19 Male 150564
## 395 395 Prof A 42 25 Male 101738
## 396 396 Prof A 25 15 Male 95329
## 397 397 AsstProf A 8 4 Male 81035Salaries_Service_Years["Pro_Rata_Salary"] <- NA # New Column created known as Pro Rata Salary with no Values.
Salaries_Service_Years #View the new column, a variable with NA values ## X rank discipline yrs.since.phd yrs.service sex salary
## 1 1 Prof B 19 18 Male 139750
## 2 2 Prof B 20 16 Male 173200
## 3 3 AsstProf B 4 3 Male 79750
## 4 4 Prof B 45 39 Male 115000
## 5 5 Prof B 40 41 Male 141500
## 6 6 AssocProf B 6 6 Male 97000
## 7 7 Prof B 30 23 Male 175000
## 8 8 Prof B 45 45 Male 147765
## 9 9 Prof B 21 20 Male 119250
## 10 10 Prof B 18 18 Female 129000
## 11 11 AssocProf B 12 8 Male 119800
## 15 15 Prof B 20 18 Male 104800
## 16 16 Prof B 12 3 Male 117150
## 17 17 Prof B 19 20 Male 101000
## 18 18 Prof A 38 34 Male 103450
## 19 19 Prof A 37 23 Male 124750
## 20 20 Prof A 39 36 Female 137000
## 21 21 Prof A 31 26 Male 89565
## 22 22 Prof A 36 31 Male 102580
## 23 23 Prof A 34 30 Male 93904
## 24 24 Prof A 24 19 Male 113068
## 25 25 AssocProf A 13 8 Female 74830
## 26 26 Prof A 21 8 Male 106294
## 27 27 Prof A 35 23 Male 134885
## 28 28 AsstProf B 5 3 Male 82379
## 30 30 Prof B 12 8 Male 118223
## 31 31 Prof B 20 4 Male 132261
## 33 33 Prof B 13 9 Male 117256
## 37 37 Prof B 22 21 Male 155750
## 38 38 AsstProf B 7 4 Male 86373
## 39 39 Prof B 41 31 Male 125196
## 40 40 AssocProf B 9 9 Male 100938
## 42 42 AssocProf B 23 23 Male 93418
## 43 43 Prof B 40 27 Male 101299
## 44 44 Prof B 38 38 Male 231545
## 45 45 Prof B 19 19 Male 94384
## 46 46 Prof B 25 15 Male 114778
## 47 47 Prof B 40 28 Male 98193
## 48 48 Prof B 23 19 Female 151768
## 49 49 Prof B 25 25 Female 140096
## 51 51 Prof B 28 28 Male 126621
## 52 52 Prof B 12 11 Male 108875
## 53 53 AsstProf B 11 3 Female 74692
## 54 54 Prof B 16 9 Male 106639
## 55 55 AssocProf B 12 11 Male 103760
## 56 56 AssocProf B 14 5 Male 83900
## 57 57 Prof B 23 21 Male 117704
## 58 58 AssocProf B 9 8 Male 90215
## 59 59 AssocProf B 10 9 Male 100135
## 60 60 AsstProf B 8 3 Male 75044
## 61 61 AssocProf B 9 8 Male 90304
## 63 63 Prof B 33 31 Male 109785
## 64 64 AssocProf B 11 11 Female 103613
## 65 65 AsstProf B 4 3 Male 68404
## 66 66 AssocProf B 9 8 Male 100522
## 67 67 Prof B 22 12 Male 101000
## 68 68 Prof B 35 31 Male 99418
## 69 69 Prof B 17 17 Female 111512
## 70 70 Prof B 28 36 Male 91412
## 72 72 Prof B 45 45 Male 146856
## 73 73 Prof B 29 19 Male 100131
## 74 74 Prof B 35 34 Male 92391
## 75 75 Prof B 28 23 Male 113398
## 76 76 AsstProf B 8 3 Male 73266
## 77 77 Prof B 17 3 Male 150480
## 78 78 Prof B 26 19 Male 193000
## 81 81 Prof B 43 28 Male 150743
## 82 82 Prof B 17 16 Male 135585
## 83 83 Prof B 22 20 Male 144640
## 85 85 Prof B 17 18 Female 122960
## 86 86 Prof B 15 14 Male 132825
## 87 87 Prof B 37 37 Male 152708
## 89 89 Prof B 25 25 Male 172272
## 90 90 AssocProf B 9 7 Male 107008
## 91 91 AsstProf B 10 5 Female 97032
## 92 92 AssocProf B 10 7 Male 105128
## 93 93 AssocProf B 10 7 Male 105631
## 94 94 Prof B 38 38 Male 166024
## 95 95 Prof B 21 20 Male 123683
## 97 97 AssocProf B 17 12 Male 95611
## 98 98 Prof B 13 7 Male 129676
## 99 99 Prof B 30 14 Male 102235
## 100 100 Prof B 41 26 Male 106689
## 101 101 Prof B 42 25 Male 133217
## 102 102 Prof B 28 23 Male 126933
## 103 103 Prof B 16 5 Male 153303
## 104 104 Prof B 20 14 Female 127512
## 105 105 AssocProf A 18 10 Male 83850
## 106 106 Prof A 31 28 Male 113543
## 107 107 AssocProf A 11 8 Male 82099
## 108 108 AssocProf A 10 8 Male 82600
## 109 109 AssocProf A 15 8 Male 81500
## 110 110 Prof A 40 31 Male 131205
## 111 111 Prof A 20 16 Male 112429
## 112 112 AssocProf A 19 16 Male 82100
## 114 114 Prof A 37 37 Male 104279
## 116 116 Prof A 21 9 Male 120806
## 117 117 Prof A 30 29 Male 148500
## 118 118 Prof A 39 36 Male 117515
## 120 120 AsstProf A 5 3 Female 73500
## 121 121 Prof A 14 14 Male 115313
## 122 122 Prof A 32 32 Male 124309
## 123 123 Prof A 24 22 Male 97262
## 124 124 AssocProf A 25 22 Female 62884
## 125 125 Prof A 24 22 Male 96614
## 126 126 Prof A 54 49 Male 78162
## 127 127 Prof A 28 26 Male 155500
## 129 129 Prof A 32 30 Male 113278
## 131 131 AssocProf A 11 9 Male 83001
## 132 132 Prof A 56 57 Male 76840
## 133 133 AssocProf A 10 8 Female 77500
## 135 135 Prof A 35 25 Male 168635
## 136 136 Prof A 20 18 Male 136000
## 137 137 Prof A 16 14 Male 108262
## 138 138 Prof A 17 14 Male 105668
## 139 139 AssocProf A 10 7 Male 73877
## 140 140 Prof A 21 18 Male 152664
## 141 141 AssocProf A 14 8 Male 100102
## 142 142 AssocProf A 15 10 Male 81500
## 143 143 Prof A 19 11 Male 106608
## 144 144 AsstProf B 3 3 Male 89942
## 145 145 Prof B 27 27 Male 112696
## 146 146 Prof B 28 28 Male 119015
## 147 147 AsstProf B 4 4 Male 92000
## 148 148 Prof B 27 27 Male 156938
## 149 149 Prof B 36 26 Female 144651
## 150 150 AsstProf B 4 3 Male 95079
## 151 151 Prof B 14 12 Male 128148
## 152 152 AsstProf B 4 4 Male 92000
## 153 153 Prof B 21 9 Male 111168
## 154 154 AssocProf B 12 10 Female 103994
## 156 156 Prof B 21 21 Male 118971
## 157 157 AssocProf B 12 18 Male 113341
## 159 159 AssocProf B 6 6 Male 95408
## 160 160 Prof B 15 16 Male 137167
## 162 162 Prof B 26 19 Male 176500
## 163 163 AssocProf B 22 7 Male 98510
## 164 164 AsstProf B 3 3 Male 89942
## 166 166 Prof B 21 8 Male 105890
## 167 167 Prof B 16 16 Male 167284
## 168 168 Prof B 18 19 Male 130664
## 169 169 AssocProf B 8 6 Male 101210
## 170 170 Prof B 25 18 Male 181257
## 171 171 AsstProf B 5 5 Male 91227
## 172 172 Prof B 19 19 Male 151575
## 173 173 Prof B 37 24 Male 93164
## 174 174 Prof B 20 20 Male 134185
## 175 175 AssocProf B 17 6 Male 105000
## 176 176 Prof B 28 25 Male 111751
## 177 177 AssocProf B 10 7 Male 95436
## 178 178 AssocProf B 13 9 Male 100944
## 179 179 Prof B 27 14 Male 147349
## 180 180 AsstProf B 3 3 Female 92000
## 181 181 Prof B 11 11 Male 142467
## 182 182 Prof B 18 5 Male 141136
## 183 183 AssocProf B 8 8 Male 100000
## 184 184 Prof B 26 22 Male 150000
## 185 185 Prof B 23 23 Male 101000
## 186 186 Prof B 33 30 Male 134000
## 187 187 AssocProf B 13 10 Female 103750
## 188 188 Prof B 18 10 Male 107500
## 189 189 AssocProf B 28 28 Male 106300
## 190 190 Prof B 25 19 Male 153750
## 191 191 Prof B 22 9 Male 180000
## 192 192 Prof B 43 22 Male 133700
## 193 193 Prof B 19 18 Male 122100
## 194 194 AssocProf B 19 19 Male 86250
## 195 195 AssocProf B 48 53 Male 90000
## 196 196 AssocProf B 9 7 Male 113600
## 197 197 AsstProf B 4 4 Male 92700
## 198 198 AsstProf B 4 4 Male 92000
## 199 199 Prof B 34 33 Male 189409
## 200 200 Prof B 38 22 Male 114500
## 201 201 AsstProf B 4 4 Male 92700
## 202 202 Prof B 40 40 Male 119700
## 203 203 Prof B 28 17 Male 160400
## 204 204 Prof B 17 17 Male 152500
## 205 205 Prof B 19 5 Male 165000
## 207 207 Prof B 35 33 Male 162200
## 208 208 Prof B 18 18 Male 120000
## 210 210 Prof B 20 20 Male 163200
## 211 211 AsstProf B 4 3 Male 91000
## 212 212 Prof B 39 39 Male 111350
## 213 213 Prof B 15 7 Male 128400
## 214 214 Prof B 26 19 Male 126200
## 216 216 Prof B 16 11 Male 145350
## 217 217 Prof B 15 11 Male 146000
## 218 218 AssocProf B 29 22 Male 105350
## 219 219 AssocProf B 14 7 Female 109650
## 220 220 Prof B 13 11 Male 119500
## 221 221 Prof B 21 21 Male 170000
## 222 222 Prof B 23 10 Male 145200
## 223 223 AssocProf B 13 6 Male 107150
## 224 224 Prof B 34 20 Male 129600
## 225 225 Prof A 38 35 Male 87800
## 226 226 Prof A 20 20 Male 122400
## 228 228 AssocProf A 9 7 Male 70000
## 229 229 Prof A 16 11 Male 88175
## 230 230 Prof A 39 38 Male 133900
## 231 231 Prof A 29 27 Female 91000
## 232 232 AssocProf A 26 24 Female 73300
## 233 233 Prof A 38 19 Male 148750
## 234 234 Prof A 36 19 Female 117555
## 235 235 AsstProf A 8 3 Male 69700
## 236 236 Prof A 28 17 Male 81700
## 237 237 Prof A 25 25 Male 114000
## 238 238 AsstProf A 7 6 Female 63100
## 239 239 Prof A 46 40 Male 77202
## 240 240 Prof A 19 6 Male 96200
## 241 241 AsstProf A 5 3 Male 69200
## 242 242 Prof A 31 30 Male 122875
## 243 243 Prof A 38 37 Male 102600
## 244 244 Prof A 23 23 Male 108200
## 245 245 Prof A 19 23 Male 84273
## 246 246 Prof A 17 11 Female 90450
## 247 247 Prof A 30 23 Male 91100
## 248 248 Prof A 21 18 Male 101100
## 249 249 Prof A 28 23 Male 128800
## 250 250 Prof A 29 7 Male 204000
## 251 251 Prof A 39 39 Male 109000
## 252 252 Prof A 20 8 Male 102000
## 253 253 Prof A 31 12 Male 132000
## 255 255 Prof A 28 7 Female 116450
## 256 256 AssocProf A 12 8 Male 83000
## 257 257 Prof A 22 22 Male 140300
## 258 258 AssocProf A 30 23 Male 74000
## 259 259 AsstProf A 9 3 Male 73800
## 260 260 Prof A 32 30 Male 92550
## 261 261 AssocProf A 41 33 Male 88600
## 262 262 Prof A 45 45 Male 107550
## 263 263 Prof A 31 26 Male 121200
## 264 264 Prof A 31 31 Male 126000
## 265 265 Prof A 37 35 Male 99000
## 266 266 Prof A 36 30 Male 134800
## 267 267 Prof A 43 43 Male 143940
## 268 268 Prof A 14 10 Male 104350
## 269 269 Prof A 47 44 Male 89650
## 270 270 Prof A 13 7 Male 103700
## 271 271 Prof A 42 40 Male 143250
## 272 272 Prof A 42 18 Male 194800
## 274 274 AsstProf A 8 4 Male 74000
## 275 275 AsstProf A 8 3 Female 78500
## 276 276 Prof A 12 6 Male 93000
## 277 277 Prof A 52 48 Male 107200
## 278 278 Prof A 31 27 Male 163200
## 279 279 Prof A 24 18 Male 107100
## 280 280 Prof A 46 46 Male 100600
## 281 281 Prof A 39 38 Male 136500
## 282 282 Prof A 37 27 Male 103600
## 283 283 Prof A 51 51 Male 57800
## 284 284 Prof A 45 43 Male 155865
## 285 285 AssocProf A 8 6 Male 88650
## 286 286 AssocProf A 49 49 Male 81800
## 287 287 Prof A 28 27 Male 115800
## 289 289 Prof A 29 27 Male 150500
## 290 290 AsstProf A 8 5 Male 74000
## 291 291 Prof A 33 7 Male 174500
## 292 292 Prof A 32 28 Male 168500
## 293 293 Prof A 39 9 Male 183800
## 295 295 Prof A 19 7 Male 107300
## 296 296 Prof A 40 36 Male 97150
## 297 297 Prof A 18 18 Male 126300
## 298 298 Prof A 17 11 Male 148800
## 299 299 Prof A 49 43 Male 72300
## 300 300 AssocProf A 45 39 Male 70700
## 301 301 Prof A 39 36 Male 88600
## 302 302 Prof A 27 16 Male 127100
## 303 303 Prof A 28 13 Male 170500
## 304 304 Prof A 14 4 Male 105260
## 305 305 Prof A 46 44 Male 144050
## 306 306 Prof A 33 31 Male 111350
## 307 307 AsstProf A 7 4 Male 74500
## 308 308 Prof A 31 28 Male 122500
## 310 310 Prof A 22 15 Male 166800
## 311 311 Prof A 20 7 Male 92050
## 312 312 Prof A 14 9 Male 108100
## 313 313 Prof A 29 19 Male 94350
## 314 314 Prof A 35 35 Male 100351
## 315 315 Prof A 22 6 Male 146800
## 316 316 AsstProf B 6 3 Male 84716
## 317 317 AssocProf B 12 9 Female 71065
## 318 318 Prof B 46 45 Male 67559
## 319 319 Prof B 16 16 Male 134550
## 320 320 Prof B 16 15 Male 135027
## 321 321 Prof B 24 23 Male 104428
## 322 322 AssocProf B 9 9 Male 95642
## 323 323 AssocProf B 13 11 Male 126431
## 324 324 Prof B 24 15 Female 161101
## 325 325 Prof B 30 31 Male 162221
## 326 326 AsstProf B 8 4 Male 84500
## 327 327 Prof B 23 15 Male 124714
## 328 328 Prof B 37 37 Male 151650
## 329 329 AssocProf B 10 10 Male 99247
## 330 330 Prof B 23 23 Male 134778
## 331 331 Prof B 49 60 Male 192253
## 332 332 Prof B 20 9 Male 116518
## 333 333 Prof B 18 10 Female 105450
## 334 334 Prof B 33 19 Male 145098
## 335 335 AssocProf B 19 6 Female 104542
## 336 336 Prof B 36 38 Male 151445
## 337 337 Prof B 35 23 Male 98053
## 338 338 Prof B 13 12 Male 145000
## 339 339 Prof B 32 25 Male 128464
## 340 340 Prof B 37 15 Male 137317
## 341 341 Prof B 13 11 Male 106231
## 342 342 Prof B 17 17 Female 124312
## 343 343 Prof B 38 38 Male 114596
## 344 344 Prof B 31 31 Male 162150
## 345 345 Prof B 32 35 Male 150376
## 346 346 Prof B 15 10 Male 107986
## 347 347 Prof B 41 27 Male 142023
## 348 348 Prof B 39 33 Male 128250
## 349 349 AsstProf B 4 3 Male 80139
## 350 350 Prof B 27 28 Male 144309
## 351 351 Prof B 56 49 Male 186960
## 352 352 Prof B 38 38 Male 93519
## 353 353 Prof B 26 27 Male 142500
## 354 354 Prof B 22 20 Male 138000
## 356 356 Prof B 25 21 Male 145028
## 357 357 Prof A 49 40 Male 88709
## 358 358 Prof A 39 35 Male 107309
## 359 359 Prof A 28 14 Female 109954
## 360 360 AsstProf A 11 4 Male 78785
## 361 361 Prof A 14 11 Male 121946
## 362 362 Prof A 23 15 Female 109646
## 363 363 Prof A 30 30 Male 138771
## 364 364 AssocProf A 20 17 Male 81285
## 365 365 Prof A 43 43 Male 205500
## 366 366 Prof A 43 40 Male 101036
## 367 367 Prof A 15 10 Male 115435
## 369 369 Prof A 35 30 Male 131950
## 370 370 Prof A 33 31 Male 134690
## 371 371 AssocProf A 13 8 Male 78182
## 372 372 Prof A 23 20 Male 110515
## 373 373 Prof A 12 7 Male 109707
## 374 374 Prof A 30 26 Male 136660
## 375 375 Prof A 27 19 Male 103275
## 376 376 Prof A 28 26 Male 103649
## 378 378 AsstProf A 6 3 Male 77081
## 379 379 Prof A 38 38 Male 150680
## 380 380 AssocProf A 11 8 Male 104121
## 381 381 AsstProf A 8 3 Male 75996
## 382 382 Prof A 27 23 Male 172505
## 383 383 AssocProf A 8 5 Male 86895
## 384 384 Prof A 44 44 Male 105000
## 385 385 Prof A 27 21 Male 125192
## 386 386 Prof A 15 9 Male 114330
## 387 387 Prof A 29 27 Male 139219
## 388 388 Prof A 29 15 Male 109305
## 389 389 Prof A 38 36 Male 119450
## 390 390 Prof A 33 18 Male 186023
## 391 391 Prof A 40 19 Male 166605
## 392 392 Prof A 30 19 Male 151292
## 393 393 Prof A 33 30 Male 103106
## 394 394 Prof A 31 19 Male 150564
## 395 395 Prof A 42 25 Male 101738
## 396 396 Prof A 25 15 Male 95329
## 397 397 AsstProf A 8 4 Male 81035
## Pro_Rata_Salary
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## 7 NA
## 8 NA
## 9 NA
## 10 NA
## 11 NA
## 15 NA
## 16 NA
## 17 NA
## 18 NA
## 19 NA
## 20 NA
## 21 NA
## 22 NA
## 23 NA
## 24 NA
## 25 NA
## 26 NA
## 27 NA
## 28 NA
## 30 NA
## 31 NA
## 33 NA
## 37 NA
## 38 NA
## 39 NA
## 40 NA
## 42 NA
## 43 NA
## 44 NA
## 45 NA
## 46 NA
## 47 NA
## 48 NA
## 49 NA
## 51 NA
## 52 NA
## 53 NA
## 54 NA
## 55 NA
## 56 NA
## 57 NA
## 58 NA
## 59 NA
## 60 NA
## 61 NA
## 63 NA
## 64 NA
## 65 NA
## 66 NA
## 67 NA
## 68 NA
## 69 NA
## 70 NA
## 72 NA
## 73 NA
## 74 NA
## 75 NA
## 76 NA
## 77 NA
## 78 NA
## 81 NA
## 82 NA
## 83 NA
## 85 NA
## 86 NA
## 87 NA
## 89 NA
## 90 NA
## 91 NA
## 92 NA
## 93 NA
## 94 NA
## 95 NA
## 97 NA
## 98 NA
## 99 NA
## 100 NA
## 101 NA
## 102 NA
## 103 NA
## 104 NA
## 105 NA
## 106 NA
## 107 NA
## 108 NA
## 109 NA
## 110 NA
## 111 NA
## 112 NA
## 114 NA
## 116 NA
## 117 NA
## 118 NA
## 120 NA
## 121 NA
## 122 NA
## 123 NA
## 124 NA
## 125 NA
## 126 NA
## 127 NA
## 129 NA
## 131 NA
## 132 NA
## 133 NA
## 135 NA
## 136 NA
## 137 NA
## 138 NA
## 139 NA
## 140 NA
## 141 NA
## 142 NA
## 143 NA
## 144 NA
## 145 NA
## 146 NA
## 147 NA
## 148 NA
## 149 NA
## 150 NA
## 151 NA
## 152 NA
## 153 NA
## 154 NA
## 156 NA
## 157 NA
## 159 NA
## 160 NA
## 162 NA
## 163 NA
## 164 NA
## 166 NA
## 167 NA
## 168 NA
## 169 NA
## 170 NA
## 171 NA
## 172 NA
## 173 NA
## 174 NA
## 175 NA
## 176 NA
## 177 NA
## 178 NA
## 179 NA
## 180 NA
## 181 NA
## 182 NA
## 183 NA
## 184 NA
## 185 NA
## 186 NA
## 187 NA
## 188 NA
## 189 NA
## 190 NA
## 191 NA
## 192 NA
## 193 NA
## 194 NA
## 195 NA
## 196 NA
## 197 NA
## 198 NA
## 199 NA
## 200 NA
## 201 NA
## 202 NA
## 203 NA
## 204 NA
## 205 NA
## 207 NA
## 208 NA
## 210 NA
## 211 NA
## 212 NA
## 213 NA
## 214 NA
## 216 NA
## 217 NA
## 218 NA
## 219 NA
## 220 NA
## 221 NA
## 222 NA
## 223 NA
## 224 NA
## 225 NA
## 226 NA
## 228 NA
## 229 NA
## 230 NA
## 231 NA
## 232 NA
## 233 NA
## 234 NA
## 235 NA
## 236 NA
## 237 NA
## 238 NA
## 239 NA
## 240 NA
## 241 NA
## 242 NA
## 243 NA
## 244 NA
## 245 NA
## 246 NA
## 247 NA
## 248 NA
## 249 NA
## 250 NA
## 251 NA
## 252 NA
## 253 NA
## 255 NA
## 256 NA
## 257 NA
## 258 NA
## 259 NA
## 260 NA
## 261 NA
## 262 NA
## 263 NA
## 264 NA
## 265 NA
## 266 NA
## 267 NA
## 268 NA
## 269 NA
## 270 NA
## 271 NA
## 272 NA
## 274 NA
## 275 NA
## 276 NA
## 277 NA
## 278 NA
## 279 NA
## 280 NA
## 281 NA
## 282 NA
## 283 NA
## 284 NA
## 285 NA
## 286 NA
## 287 NA
## 289 NA
## 290 NA
## 291 NA
## 292 NA
## 293 NA
## 295 NA
## 296 NA
## 297 NA
## 298 NA
## 299 NA
## 300 NA
## 301 NA
## 302 NA
## 303 NA
## 304 NA
## 305 NA
## 306 NA
## 307 NA
## 308 NA
## 310 NA
## 311 NA
## 312 NA
## 313 NA
## 314 NA
## 315 NA
## 316 NA
## 317 NA
## 318 NA
## 319 NA
## 320 NA
## 321 NA
## 322 NA
## 323 NA
## 324 NA
## 325 NA
## 326 NA
## 327 NA
## 328 NA
## 329 NA
## 330 NA
## 331 NA
## 332 NA
## 333 NA
## 334 NA
## 335 NA
## 336 NA
## 337 NA
## 338 NA
## 339 NA
## 340 NA
## 341 NA
## 342 NA
## 343 NA
## 344 NA
## 345 NA
## 346 NA
## 347 NA
## 348 NA
## 349 NA
## 350 NA
## 351 NA
## 352 NA
## 353 NA
## 354 NA
## 356 NA
## 357 NA
## 358 NA
## 359 NA
## 360 NA
## 361 NA
## 362 NA
## 363 NA
## 364 NA
## 365 NA
## 366 NA
## 367 NA
## 369 NA
## 370 NA
## 371 NA
## 372 NA
## 373 NA
## 374 NA
## 375 NA
## 376 NA
## 378 NA
## 379 NA
## 380 NA
## 381 NA
## 382 NA
## 383 NA
## 384 NA
## 385 NA
## 386 NA
## 387 NA
## 388 NA
## 389 NA
## 390 NA
## 391 NA
## 392 NA
## 393 NA
## 394 NA
## 395 NA
## 396 NA
## 397 NASalaries_Service_Years$Pro_Rata_Salary <- Salaries_Service_Years$salary/Salaries_Service_Years$yrs.service # I just created values for the new column
Salaries_Service_Years # View again, New column with values## X rank discipline yrs.since.phd yrs.service sex salary
## 1 1 Prof B 19 18 Male 139750
## 2 2 Prof B 20 16 Male 173200
## 3 3 AsstProf B 4 3 Male 79750
## 4 4 Prof B 45 39 Male 115000
## 5 5 Prof B 40 41 Male 141500
## 6 6 AssocProf B 6 6 Male 97000
## 7 7 Prof B 30 23 Male 175000
## 8 8 Prof B 45 45 Male 147765
## 9 9 Prof B 21 20 Male 119250
## 10 10 Prof B 18 18 Female 129000
## 11 11 AssocProf B 12 8 Male 119800
## 15 15 Prof B 20 18 Male 104800
## 16 16 Prof B 12 3 Male 117150
## 17 17 Prof B 19 20 Male 101000
## 18 18 Prof A 38 34 Male 103450
## 19 19 Prof A 37 23 Male 124750
## 20 20 Prof A 39 36 Female 137000
## 21 21 Prof A 31 26 Male 89565
## 22 22 Prof A 36 31 Male 102580
## 23 23 Prof A 34 30 Male 93904
## 24 24 Prof A 24 19 Male 113068
## 25 25 AssocProf A 13 8 Female 74830
## 26 26 Prof A 21 8 Male 106294
## 27 27 Prof A 35 23 Male 134885
## 28 28 AsstProf B 5 3 Male 82379
## 30 30 Prof B 12 8 Male 118223
## 31 31 Prof B 20 4 Male 132261
## 33 33 Prof B 13 9 Male 117256
## 37 37 Prof B 22 21 Male 155750
## 38 38 AsstProf B 7 4 Male 86373
## 39 39 Prof B 41 31 Male 125196
## 40 40 AssocProf B 9 9 Male 100938
## 42 42 AssocProf B 23 23 Male 93418
## 43 43 Prof B 40 27 Male 101299
## 44 44 Prof B 38 38 Male 231545
## 45 45 Prof B 19 19 Male 94384
## 46 46 Prof B 25 15 Male 114778
## 47 47 Prof B 40 28 Male 98193
## 48 48 Prof B 23 19 Female 151768
## 49 49 Prof B 25 25 Female 140096
## 51 51 Prof B 28 28 Male 126621
## 52 52 Prof B 12 11 Male 108875
## 53 53 AsstProf B 11 3 Female 74692
## 54 54 Prof B 16 9 Male 106639
## 55 55 AssocProf B 12 11 Male 103760
## 56 56 AssocProf B 14 5 Male 83900
## 57 57 Prof B 23 21 Male 117704
## 58 58 AssocProf B 9 8 Male 90215
## 59 59 AssocProf B 10 9 Male 100135
## 60 60 AsstProf B 8 3 Male 75044
## 61 61 AssocProf B 9 8 Male 90304
## 63 63 Prof B 33 31 Male 109785
## 64 64 AssocProf B 11 11 Female 103613
## 65 65 AsstProf B 4 3 Male 68404
## 66 66 AssocProf B 9 8 Male 100522
## 67 67 Prof B 22 12 Male 101000
## 68 68 Prof B 35 31 Male 99418
## 69 69 Prof B 17 17 Female 111512
## 70 70 Prof B 28 36 Male 91412
## 72 72 Prof B 45 45 Male 146856
## 73 73 Prof B 29 19 Male 100131
## 74 74 Prof B 35 34 Male 92391
## 75 75 Prof B 28 23 Male 113398
## 76 76 AsstProf B 8 3 Male 73266
## 77 77 Prof B 17 3 Male 150480
## 78 78 Prof B 26 19 Male 193000
## 81 81 Prof B 43 28 Male 150743
## 82 82 Prof B 17 16 Male 135585
## 83 83 Prof B 22 20 Male 144640
## 85 85 Prof B 17 18 Female 122960
## 86 86 Prof B 15 14 Male 132825
## 87 87 Prof B 37 37 Male 152708
## 89 89 Prof B 25 25 Male 172272
## 90 90 AssocProf B 9 7 Male 107008
## 91 91 AsstProf B 10 5 Female 97032
## 92 92 AssocProf B 10 7 Male 105128
## 93 93 AssocProf B 10 7 Male 105631
## 94 94 Prof B 38 38 Male 166024
## 95 95 Prof B 21 20 Male 123683
## 97 97 AssocProf B 17 12 Male 95611
## 98 98 Prof B 13 7 Male 129676
## 99 99 Prof B 30 14 Male 102235
## 100 100 Prof B 41 26 Male 106689
## 101 101 Prof B 42 25 Male 133217
## 102 102 Prof B 28 23 Male 126933
## 103 103 Prof B 16 5 Male 153303
## 104 104 Prof B 20 14 Female 127512
## 105 105 AssocProf A 18 10 Male 83850
## 106 106 Prof A 31 28 Male 113543
## 107 107 AssocProf A 11 8 Male 82099
## 108 108 AssocProf A 10 8 Male 82600
## 109 109 AssocProf A 15 8 Male 81500
## 110 110 Prof A 40 31 Male 131205
## 111 111 Prof A 20 16 Male 112429
## 112 112 AssocProf A 19 16 Male 82100
## 114 114 Prof A 37 37 Male 104279
## 116 116 Prof A 21 9 Male 120806
## 117 117 Prof A 30 29 Male 148500
## 118 118 Prof A 39 36 Male 117515
## 120 120 AsstProf A 5 3 Female 73500
## 121 121 Prof A 14 14 Male 115313
## 122 122 Prof A 32 32 Male 124309
## 123 123 Prof A 24 22 Male 97262
## 124 124 AssocProf A 25 22 Female 62884
## 125 125 Prof A 24 22 Male 96614
## 126 126 Prof A 54 49 Male 78162
## 127 127 Prof A 28 26 Male 155500
## 129 129 Prof A 32 30 Male 113278
## 131 131 AssocProf A 11 9 Male 83001
## 132 132 Prof A 56 57 Male 76840
## 133 133 AssocProf A 10 8 Female 77500
## 135 135 Prof A 35 25 Male 168635
## 136 136 Prof A 20 18 Male 136000
## 137 137 Prof A 16 14 Male 108262
## 138 138 Prof A 17 14 Male 105668
## 139 139 AssocProf A 10 7 Male 73877
## 140 140 Prof A 21 18 Male 152664
## 141 141 AssocProf A 14 8 Male 100102
## 142 142 AssocProf A 15 10 Male 81500
## 143 143 Prof A 19 11 Male 106608
## 144 144 AsstProf B 3 3 Male 89942
## 145 145 Prof B 27 27 Male 112696
## 146 146 Prof B 28 28 Male 119015
## 147 147 AsstProf B 4 4 Male 92000
## 148 148 Prof B 27 27 Male 156938
## 149 149 Prof B 36 26 Female 144651
## 150 150 AsstProf B 4 3 Male 95079
## 151 151 Prof B 14 12 Male 128148
## 152 152 AsstProf B 4 4 Male 92000
## 153 153 Prof B 21 9 Male 111168
## 154 154 AssocProf B 12 10 Female 103994
## 156 156 Prof B 21 21 Male 118971
## 157 157 AssocProf B 12 18 Male 113341
## 159 159 AssocProf B 6 6 Male 95408
## 160 160 Prof B 15 16 Male 137167
## 162 162 Prof B 26 19 Male 176500
## 163 163 AssocProf B 22 7 Male 98510
## 164 164 AsstProf B 3 3 Male 89942
## 166 166 Prof B 21 8 Male 105890
## 167 167 Prof B 16 16 Male 167284
## 168 168 Prof B 18 19 Male 130664
## 169 169 AssocProf B 8 6 Male 101210
## 170 170 Prof B 25 18 Male 181257
## 171 171 AsstProf B 5 5 Male 91227
## 172 172 Prof B 19 19 Male 151575
## 173 173 Prof B 37 24 Male 93164
## 174 174 Prof B 20 20 Male 134185
## 175 175 AssocProf B 17 6 Male 105000
## 176 176 Prof B 28 25 Male 111751
## 177 177 AssocProf B 10 7 Male 95436
## 178 178 AssocProf B 13 9 Male 100944
## 179 179 Prof B 27 14 Male 147349
## 180 180 AsstProf B 3 3 Female 92000
## 181 181 Prof B 11 11 Male 142467
## 182 182 Prof B 18 5 Male 141136
## 183 183 AssocProf B 8 8 Male 100000
## 184 184 Prof B 26 22 Male 150000
## 185 185 Prof B 23 23 Male 101000
## 186 186 Prof B 33 30 Male 134000
## 187 187 AssocProf B 13 10 Female 103750
## 188 188 Prof B 18 10 Male 107500
## 189 189 AssocProf B 28 28 Male 106300
## 190 190 Prof B 25 19 Male 153750
## 191 191 Prof B 22 9 Male 180000
## 192 192 Prof B 43 22 Male 133700
## 193 193 Prof B 19 18 Male 122100
## 194 194 AssocProf B 19 19 Male 86250
## 195 195 AssocProf B 48 53 Male 90000
## 196 196 AssocProf B 9 7 Male 113600
## 197 197 AsstProf B 4 4 Male 92700
## 198 198 AsstProf B 4 4 Male 92000
## 199 199 Prof B 34 33 Male 189409
## 200 200 Prof B 38 22 Male 114500
## 201 201 AsstProf B 4 4 Male 92700
## 202 202 Prof B 40 40 Male 119700
## 203 203 Prof B 28 17 Male 160400
## 204 204 Prof B 17 17 Male 152500
## 205 205 Prof B 19 5 Male 165000
## 207 207 Prof B 35 33 Male 162200
## 208 208 Prof B 18 18 Male 120000
## 210 210 Prof B 20 20 Male 163200
## 211 211 AsstProf B 4 3 Male 91000
## 212 212 Prof B 39 39 Male 111350
## 213 213 Prof B 15 7 Male 128400
## 214 214 Prof B 26 19 Male 126200
## 216 216 Prof B 16 11 Male 145350
## 217 217 Prof B 15 11 Male 146000
## 218 218 AssocProf B 29 22 Male 105350
## 219 219 AssocProf B 14 7 Female 109650
## 220 220 Prof B 13 11 Male 119500
## 221 221 Prof B 21 21 Male 170000
## 222 222 Prof B 23 10 Male 145200
## 223 223 AssocProf B 13 6 Male 107150
## 224 224 Prof B 34 20 Male 129600
## 225 225 Prof A 38 35 Male 87800
## 226 226 Prof A 20 20 Male 122400
## 228 228 AssocProf A 9 7 Male 70000
## 229 229 Prof A 16 11 Male 88175
## 230 230 Prof A 39 38 Male 133900
## 231 231 Prof A 29 27 Female 91000
## 232 232 AssocProf A 26 24 Female 73300
## 233 233 Prof A 38 19 Male 148750
## 234 234 Prof A 36 19 Female 117555
## 235 235 AsstProf A 8 3 Male 69700
## 236 236 Prof A 28 17 Male 81700
## 237 237 Prof A 25 25 Male 114000
## 238 238 AsstProf A 7 6 Female 63100
## 239 239 Prof A 46 40 Male 77202
## 240 240 Prof A 19 6 Male 96200
## 241 241 AsstProf A 5 3 Male 69200
## 242 242 Prof A 31 30 Male 122875
## 243 243 Prof A 38 37 Male 102600
## 244 244 Prof A 23 23 Male 108200
## 245 245 Prof A 19 23 Male 84273
## 246 246 Prof A 17 11 Female 90450
## 247 247 Prof A 30 23 Male 91100
## 248 248 Prof A 21 18 Male 101100
## 249 249 Prof A 28 23 Male 128800
## 250 250 Prof A 29 7 Male 204000
## 251 251 Prof A 39 39 Male 109000
## 252 252 Prof A 20 8 Male 102000
## 253 253 Prof A 31 12 Male 132000
## 255 255 Prof A 28 7 Female 116450
## 256 256 AssocProf A 12 8 Male 83000
## 257 257 Prof A 22 22 Male 140300
## 258 258 AssocProf A 30 23 Male 74000
## 259 259 AsstProf A 9 3 Male 73800
## 260 260 Prof A 32 30 Male 92550
## 261 261 AssocProf A 41 33 Male 88600
## 262 262 Prof A 45 45 Male 107550
## 263 263 Prof A 31 26 Male 121200
## 264 264 Prof A 31 31 Male 126000
## 265 265 Prof A 37 35 Male 99000
## 266 266 Prof A 36 30 Male 134800
## 267 267 Prof A 43 43 Male 143940
## 268 268 Prof A 14 10 Male 104350
## 269 269 Prof A 47 44 Male 89650
## 270 270 Prof A 13 7 Male 103700
## 271 271 Prof A 42 40 Male 143250
## 272 272 Prof A 42 18 Male 194800
## 274 274 AsstProf A 8 4 Male 74000
## 275 275 AsstProf A 8 3 Female 78500
## 276 276 Prof A 12 6 Male 93000
## 277 277 Prof A 52 48 Male 107200
## 278 278 Prof A 31 27 Male 163200
## 279 279 Prof A 24 18 Male 107100
## 280 280 Prof A 46 46 Male 100600
## 281 281 Prof A 39 38 Male 136500
## 282 282 Prof A 37 27 Male 103600
## 283 283 Prof A 51 51 Male 57800
## 284 284 Prof A 45 43 Male 155865
## 285 285 AssocProf A 8 6 Male 88650
## 286 286 AssocProf A 49 49 Male 81800
## 287 287 Prof A 28 27 Male 115800
## 289 289 Prof A 29 27 Male 150500
## 290 290 AsstProf A 8 5 Male 74000
## 291 291 Prof A 33 7 Male 174500
## 292 292 Prof A 32 28 Male 168500
## 293 293 Prof A 39 9 Male 183800
## 295 295 Prof A 19 7 Male 107300
## 296 296 Prof A 40 36 Male 97150
## 297 297 Prof A 18 18 Male 126300
## 298 298 Prof A 17 11 Male 148800
## 299 299 Prof A 49 43 Male 72300
## 300 300 AssocProf A 45 39 Male 70700
## 301 301 Prof A 39 36 Male 88600
## 302 302 Prof A 27 16 Male 127100
## 303 303 Prof A 28 13 Male 170500
## 304 304 Prof A 14 4 Male 105260
## 305 305 Prof A 46 44 Male 144050
## 306 306 Prof A 33 31 Male 111350
## 307 307 AsstProf A 7 4 Male 74500
## 308 308 Prof A 31 28 Male 122500
## 310 310 Prof A 22 15 Male 166800
## 311 311 Prof A 20 7 Male 92050
## 312 312 Prof A 14 9 Male 108100
## 313 313 Prof A 29 19 Male 94350
## 314 314 Prof A 35 35 Male 100351
## 315 315 Prof A 22 6 Male 146800
## 316 316 AsstProf B 6 3 Male 84716
## 317 317 AssocProf B 12 9 Female 71065
## 318 318 Prof B 46 45 Male 67559
## 319 319 Prof B 16 16 Male 134550
## 320 320 Prof B 16 15 Male 135027
## 321 321 Prof B 24 23 Male 104428
## 322 322 AssocProf B 9 9 Male 95642
## 323 323 AssocProf B 13 11 Male 126431
## 324 324 Prof B 24 15 Female 161101
## 325 325 Prof B 30 31 Male 162221
## 326 326 AsstProf B 8 4 Male 84500
## 327 327 Prof B 23 15 Male 124714
## 328 328 Prof B 37 37 Male 151650
## 329 329 AssocProf B 10 10 Male 99247
## 330 330 Prof B 23 23 Male 134778
## 331 331 Prof B 49 60 Male 192253
## 332 332 Prof B 20 9 Male 116518
## 333 333 Prof B 18 10 Female 105450
## 334 334 Prof B 33 19 Male 145098
## 335 335 AssocProf B 19 6 Female 104542
## 336 336 Prof B 36 38 Male 151445
## 337 337 Prof B 35 23 Male 98053
## 338 338 Prof B 13 12 Male 145000
## 339 339 Prof B 32 25 Male 128464
## 340 340 Prof B 37 15 Male 137317
## 341 341 Prof B 13 11 Male 106231
## 342 342 Prof B 17 17 Female 124312
## 343 343 Prof B 38 38 Male 114596
## 344 344 Prof B 31 31 Male 162150
## 345 345 Prof B 32 35 Male 150376
## 346 346 Prof B 15 10 Male 107986
## 347 347 Prof B 41 27 Male 142023
## 348 348 Prof B 39 33 Male 128250
## 349 349 AsstProf B 4 3 Male 80139
## 350 350 Prof B 27 28 Male 144309
## 351 351 Prof B 56 49 Male 186960
## 352 352 Prof B 38 38 Male 93519
## 353 353 Prof B 26 27 Male 142500
## 354 354 Prof B 22 20 Male 138000
## 356 356 Prof B 25 21 Male 145028
## 357 357 Prof A 49 40 Male 88709
## 358 358 Prof A 39 35 Male 107309
## 359 359 Prof A 28 14 Female 109954
## 360 360 AsstProf A 11 4 Male 78785
## 361 361 Prof A 14 11 Male 121946
## 362 362 Prof A 23 15 Female 109646
## 363 363 Prof A 30 30 Male 138771
## 364 364 AssocProf A 20 17 Male 81285
## 365 365 Prof A 43 43 Male 205500
## 366 366 Prof A 43 40 Male 101036
## 367 367 Prof A 15 10 Male 115435
## 369 369 Prof A 35 30 Male 131950
## 370 370 Prof A 33 31 Male 134690
## 371 371 AssocProf A 13 8 Male 78182
## 372 372 Prof A 23 20 Male 110515
## 373 373 Prof A 12 7 Male 109707
## 374 374 Prof A 30 26 Male 136660
## 375 375 Prof A 27 19 Male 103275
## 376 376 Prof A 28 26 Male 103649
## 378 378 AsstProf A 6 3 Male 77081
## 379 379 Prof A 38 38 Male 150680
## 380 380 AssocProf A 11 8 Male 104121
## 381 381 AsstProf A 8 3 Male 75996
## 382 382 Prof A 27 23 Male 172505
## 383 383 AssocProf A 8 5 Male 86895
## 384 384 Prof A 44 44 Male 105000
## 385 385 Prof A 27 21 Male 125192
## 386 386 Prof A 15 9 Male 114330
## 387 387 Prof A 29 27 Male 139219
## 388 388 Prof A 29 15 Male 109305
## 389 389 Prof A 38 36 Male 119450
## 390 390 Prof A 33 18 Male 186023
## 391 391 Prof A 40 19 Male 166605
## 392 392 Prof A 30 19 Male 151292
## 393 393 Prof A 33 30 Male 103106
## 394 394 Prof A 31 19 Male 150564
## 395 395 Prof A 42 25 Male 101738
## 396 396 Prof A 25 15 Male 95329
## 397 397 AsstProf A 8 4 Male 81035
## Pro_Rata_Salary
## 1 7763.889
## 2 10825.000
## 3 26583.333
## 4 2948.718
## 5 3451.220
## 6 16166.667
## 7 7608.696
## 8 3283.667
## 9 5962.500
## 10 7166.667
## 11 14975.000
## 15 5822.222
## 16 39050.000
## 17 5050.000
## 18 3042.647
## 19 5423.913
## 20 3805.556
## 21 3444.808
## 22 3309.032
## 23 3130.133
## 24 5950.947
## 25 9353.750
## 26 13286.750
## 27 5864.565
## 28 27459.667
## 30 14777.875
## 31 33065.250
## 33 13028.444
## 37 7416.667
## 38 21593.250
## 39 4038.581
## 40 11215.333
## 42 4061.652
## 43 3751.815
## 44 6093.289
## 45 4967.579
## 46 7651.867
## 47 3506.893
## 48 7987.789
## 49 5603.840
## 51 4522.179
## 52 9897.727
## 53 24897.333
## 54 11848.778
## 55 9432.727
## 56 16780.000
## 57 5604.952
## 58 11276.875
## 59 11126.111
## 60 25014.667
## 61 11288.000
## 63 3541.452
## 64 9419.364
## 65 22801.333
## 66 12565.250
## 67 8416.667
## 68 3207.032
## 69 6559.529
## 70 2539.222
## 72 3263.467
## 73 5270.053
## 74 2717.382
## 75 4930.348
## 76 24422.000
## 77 50160.000
## 78 10157.895
## 81 5383.679
## 82 8474.062
## 83 7232.000
## 85 6831.111
## 86 9487.500
## 87 4127.243
## 89 6890.880
## 90 15286.857
## 91 19406.400
## 92 15018.286
## 93 15090.143
## 94 4369.053
## 95 6184.150
## 97 7967.583
## 98 18525.143
## 99 7302.500
## 100 4103.423
## 101 5328.680
## 102 5518.826
## 103 30660.600
## 104 9108.000
## 105 8385.000
## 106 4055.107
## 107 10262.375
## 108 10325.000
## 109 10187.500
## 110 4232.419
## 111 7026.812
## 112 5131.250
## 114 2818.351
## 116 13422.889
## 117 5120.690
## 118 3264.306
## 120 24500.000
## 121 8236.643
## 122 3884.656
## 123 4421.000
## 124 2858.364
## 125 4391.545
## 126 1595.143
## 127 5980.769
## 129 3775.933
## 131 9222.333
## 132 1348.070
## 133 9687.500
## 135 6745.400
## 136 7555.556
## 137 7733.000
## 138 7547.714
## 139 10553.857
## 140 8481.333
## 141 12512.750
## 142 8150.000
## 143 9691.636
## 144 29980.667
## 145 4173.926
## 146 4250.536
## 147 23000.000
## 148 5812.519
## 149 5563.500
## 150 31693.000
## 151 10679.000
## 152 23000.000
## 153 12352.000
## 154 10399.400
## 156 5665.286
## 157 6296.722
## 159 15901.333
## 160 8572.938
## 162 9289.474
## 163 14072.857
## 164 29980.667
## 166 13236.250
## 167 10455.250
## 168 6877.053
## 169 16868.333
## 170 10069.833
## 171 18245.400
## 172 7977.632
## 173 3881.833
## 174 6709.250
## 175 17500.000
## 176 4470.040
## 177 13633.714
## 178 11216.000
## 179 10524.929
## 180 30666.667
## 181 12951.545
## 182 28227.200
## 183 12500.000
## 184 6818.182
## 185 4391.304
## 186 4466.667
## 187 10375.000
## 188 10750.000
## 189 3796.429
## 190 8092.105
## 191 20000.000
## 192 6077.273
## 193 6783.333
## 194 4539.474
## 195 1698.113
## 196 16228.571
## 197 23175.000
## 198 23000.000
## 199 5739.667
## 200 5204.545
## 201 23175.000
## 202 2992.500
## 203 9435.294
## 204 8970.588
## 205 33000.000
## 207 4915.152
## 208 6666.667
## 210 8160.000
## 211 30333.333
## 212 2855.128
## 213 18342.857
## 214 6642.105
## 216 13213.636
## 217 13272.727
## 218 4788.636
## 219 15664.286
## 220 10863.636
## 221 8095.238
## 222 14520.000
## 223 17858.333
## 224 6480.000
## 225 2508.571
## 226 6120.000
## 228 10000.000
## 229 8015.909
## 230 3523.684
## 231 3370.370
## 232 3054.167
## 233 7828.947
## 234 6187.105
## 235 23233.333
## 236 4805.882
## 237 4560.000
## 238 10516.667
## 239 1930.050
## 240 16033.333
## 241 23066.667
## 242 4095.833
## 243 2772.973
## 244 4704.348
## 245 3664.043
## 246 8222.727
## 247 3960.870
## 248 5616.667
## 249 5600.000
## 250 29142.857
## 251 2794.872
## 252 12750.000
## 253 11000.000
## 255 16635.714
## 256 10375.000
## 257 6377.273
## 258 3217.391
## 259 24600.000
## 260 3085.000
## 261 2684.848
## 262 2390.000
## 263 4661.538
## 264 4064.516
## 265 2828.571
## 266 4493.333
## 267 3347.442
## 268 10435.000
## 269 2037.500
## 270 14814.286
## 271 3581.250
## 272 10822.222
## 274 18500.000
## 275 26166.667
## 276 15500.000
## 277 2233.333
## 278 6044.444
## 279 5950.000
## 280 2186.957
## 281 3592.105
## 282 3837.037
## 283 1133.333
## 284 3624.767
## 285 14775.000
## 286 1669.388
## 287 4288.889
## 289 5574.074
## 290 14800.000
## 291 24928.571
## 292 6017.857
## 293 20422.222
## 295 15328.571
## 296 2698.611
## 297 7016.667
## 298 13527.273
## 299 1681.395
## 300 1812.821
## 301 2461.111
## 302 7943.750
## 303 13115.385
## 304 26315.000
## 305 3273.864
## 306 3591.935
## 307 18625.000
## 308 4375.000
## 310 11120.000
## 311 13150.000
## 312 12011.111
## 313 4965.789
## 314 2867.171
## 315 24466.667
## 316 28238.667
## 317 7896.111
## 318 1501.311
## 319 8409.375
## 320 9001.800
## 321 4540.348
## 322 10626.889
## 323 11493.727
## 324 10740.067
## 325 5232.935
## 326 21125.000
## 327 8314.267
## 328 4098.649
## 329 9924.700
## 330 5859.913
## 331 3204.217
## 332 12946.444
## 333 10545.000
## 334 7636.737
## 335 17423.667
## 336 3985.395
## 337 4263.174
## 338 12083.333
## 339 5138.560
## 340 9154.467
## 341 9657.364
## 342 7312.471
## 343 3015.684
## 344 5230.645
## 345 4296.457
## 346 10798.600
## 347 5260.111
## 348 3886.364
## 349 26713.000
## 350 5153.893
## 351 3815.510
## 352 2461.026
## 353 5277.778
## 354 6900.000
## 356 6906.095
## 357 2217.725
## 358 3065.971
## 359 7853.857
## 360 19696.250
## 361 11086.000
## 362 7309.733
## 363 4625.700
## 364 4781.471
## 365 4779.070
## 366 2525.900
## 367 11543.500
## 369 4398.333
## 370 4344.839
## 371 9772.750
## 372 5525.750
## 373 15672.429
## 374 5256.154
## 375 5435.526
## 376 3986.500
## 378 25693.667
## 379 3965.263
## 380 13015.125
## 381 25332.000
## 382 7500.217
## 383 17379.000
## 384 2386.364
## 385 5961.524
## 386 12703.333
## 387 5156.259
## 388 7287.000
## 389 3318.056
## 390 10334.611
## 391 8768.684
## 392 7962.737
## 393 3436.867
## 394 7924.421
## 395 4069.520
## 396 6355.267
## 397 20258.750summary(Salaries_Service_Years) # Overview of new data frame## X rank discipline yrs.since.phd yrs.service
## Min. : 1.0 AssocProf: 61 A:167 Min. : 3.0 Min. : 3.00
## 1st Qu.:107.2 AsstProf : 35 B:191 1st Qu.:14.0 1st Qu.: 8.25
## Median :207.5 Prof :262 Median :23.0 Median :18.00
## Mean :205.0 Mean :24.1 Mean :19.41
## 3rd Qu.:303.8 3rd Qu.:33.0 3rd Qu.:27.00
## Max. :397.0 Max. :56.0 Max. :60.00
## sex salary Pro_Rata_Salary
## Female: 33 Min. : 57800 Min. : 1133
## Male :325 1st Qu.: 95142 1st Qu.: 4371
## Median :110235 Median : 7311
## Mean :116713 Mean : 9689
## 3rd Qu.:136375 3rd Qu.:12463
## Max. :231545 Max. :50160mean(Salaries_Service_Years$salary)# The mean salary is now $116,713.10## [1] 116713.1median(Salaries_Service_Years$salary)# The median salary is now $110,234.50## [1] 110234.5mean(Salaries_Service_Years$yrs.service)# The average year of service is now ~ 19.4 years.## [1] 19.41341median(Salaries_Service_Years$yrs.service) # The median year of service is now 18 years## [1] 18Salaries_Service_Years$rank <- gsub("Prof", "Professor", Salaries_Service_Years$rank) # Renaming Prof to Professor in the rank variable (Column)
Salaries_Service_Years$rank <- gsub("AssocProf", "Associate_Prof", Salaries_Service_Years$rank) # Renaming AssocProf to Associate_Professor in the rank variable (Column)
Salaries_Service_Years$rank <- gsub("AsstProf", "Assistant_Prof", Salaries_Service_Years$rank) # Renaming AsstProf to Assistant_Professor in the rank variable (Column)
Salaries_Service_Years## X rank discipline yrs.since.phd yrs.service sex
## 1 1 Professor B 19 18 Male
## 2 2 Professor B 20 16 Male
## 3 3 Assistant_Professor B 4 3 Male
## 4 4 Professor B 45 39 Male
## 5 5 Professor B 40 41 Male
## 6 6 Associate_Professor B 6 6 Male
## 7 7 Professor B 30 23 Male
## 8 8 Professor B 45 45 Male
## 9 9 Professor B 21 20 Male
## 10 10 Professor B 18 18 Female
## 11 11 Associate_Professor B 12 8 Male
## 15 15 Professor B 20 18 Male
## 16 16 Professor B 12 3 Male
## 17 17 Professor B 19 20 Male
## 18 18 Professor A 38 34 Male
## 19 19 Professor A 37 23 Male
## 20 20 Professor A 39 36 Female
## 21 21 Professor A 31 26 Male
## 22 22 Professor A 36 31 Male
## 23 23 Professor A 34 30 Male
## 24 24 Professor A 24 19 Male
## 25 25 Associate_Professor A 13 8 Female
## 26 26 Professor A 21 8 Male
## 27 27 Professor A 35 23 Male
## 28 28 Assistant_Professor B 5 3 Male
## 30 30 Professor B 12 8 Male
## 31 31 Professor B 20 4 Male
## 33 33 Professor B 13 9 Male
## 37 37 Professor B 22 21 Male
## 38 38 Assistant_Professor B 7 4 Male
## 39 39 Professor B 41 31 Male
## 40 40 Associate_Professor B 9 9 Male
## 42 42 Associate_Professor B 23 23 Male
## 43 43 Professor B 40 27 Male
## 44 44 Professor B 38 38 Male
## 45 45 Professor B 19 19 Male
## 46 46 Professor B 25 15 Male
## 47 47 Professor B 40 28 Male
## 48 48 Professor B 23 19 Female
## 49 49 Professor B 25 25 Female
## 51 51 Professor B 28 28 Male
## 52 52 Professor B 12 11 Male
## 53 53 Assistant_Professor B 11 3 Female
## 54 54 Professor B 16 9 Male
## 55 55 Associate_Professor B 12 11 Male
## 56 56 Associate_Professor B 14 5 Male
## 57 57 Professor B 23 21 Male
## 58 58 Associate_Professor B 9 8 Male
## 59 59 Associate_Professor B 10 9 Male
## 60 60 Assistant_Professor B 8 3 Male
## 61 61 Associate_Professor B 9 8 Male
## 63 63 Professor B 33 31 Male
## 64 64 Associate_Professor B 11 11 Female
## 65 65 Assistant_Professor B 4 3 Male
## 66 66 Associate_Professor B 9 8 Male
## 67 67 Professor B 22 12 Male
## 68 68 Professor B 35 31 Male
## 69 69 Professor B 17 17 Female
## 70 70 Professor B 28 36 Male
## 72 72 Professor B 45 45 Male
## 73 73 Professor B 29 19 Male
## 74 74 Professor B 35 34 Male
## 75 75 Professor B 28 23 Male
## 76 76 Assistant_Professor B 8 3 Male
## 77 77 Professor B 17 3 Male
## 78 78 Professor B 26 19 Male
## 81 81 Professor B 43 28 Male
## 82 82 Professor B 17 16 Male
## 83 83 Professor B 22 20 Male
## 85 85 Professor B 17 18 Female
## 86 86 Professor B 15 14 Male
## 87 87 Professor B 37 37 Male
## 89 89 Professor B 25 25 Male
## 90 90 Associate_Professor B 9 7 Male
## 91 91 Assistant_Professor B 10 5 Female
## 92 92 Associate_Professor B 10 7 Male
## 93 93 Associate_Professor B 10 7 Male
## 94 94 Professor B 38 38 Male
## 95 95 Professor B 21 20 Male
## 97 97 Associate_Professor B 17 12 Male
## 98 98 Professor B 13 7 Male
## 99 99 Professor B 30 14 Male
## 100 100 Professor B 41 26 Male
## 101 101 Professor B 42 25 Male
## 102 102 Professor B 28 23 Male
## 103 103 Professor B 16 5 Male
## 104 104 Professor B 20 14 Female
## 105 105 Associate_Professor A 18 10 Male
## 106 106 Professor A 31 28 Male
## 107 107 Associate_Professor A 11 8 Male
## 108 108 Associate_Professor A 10 8 Male
## 109 109 Associate_Professor A 15 8 Male
## 110 110 Professor A 40 31 Male
## 111 111 Professor A 20 16 Male
## 112 112 Associate_Professor A 19 16 Male
## 114 114 Professor A 37 37 Male
## 116 116 Professor A 21 9 Male
## 117 117 Professor A 30 29 Male
## 118 118 Professor A 39 36 Male
## 120 120 Assistant_Professor A 5 3 Female
## 121 121 Professor A 14 14 Male
## 122 122 Professor A 32 32 Male
## 123 123 Professor A 24 22 Male
## 124 124 Associate_Professor A 25 22 Female
## 125 125 Professor A 24 22 Male
## 126 126 Professor A 54 49 Male
## 127 127 Professor A 28 26 Male
## 129 129 Professor A 32 30 Male
## 131 131 Associate_Professor A 11 9 Male
## 132 132 Professor A 56 57 Male
## 133 133 Associate_Professor A 10 8 Female
## 135 135 Professor A 35 25 Male
## 136 136 Professor A 20 18 Male
## 137 137 Professor A 16 14 Male
## 138 138 Professor A 17 14 Male
## 139 139 Associate_Professor A 10 7 Male
## 140 140 Professor A 21 18 Male
## 141 141 Associate_Professor A 14 8 Male
## 142 142 Associate_Professor A 15 10 Male
## 143 143 Professor A 19 11 Male
## 144 144 Assistant_Professor B 3 3 Male
## 145 145 Professor B 27 27 Male
## 146 146 Professor B 28 28 Male
## 147 147 Assistant_Professor B 4 4 Male
## 148 148 Professor B 27 27 Male
## 149 149 Professor B 36 26 Female
## 150 150 Assistant_Professor B 4 3 Male
## 151 151 Professor B 14 12 Male
## 152 152 Assistant_Professor B 4 4 Male
## 153 153 Professor B 21 9 Male
## 154 154 Associate_Professor B 12 10 Female
## 156 156 Professor B 21 21 Male
## 157 157 Associate_Professor B 12 18 Male
## 159 159 Associate_Professor B 6 6 Male
## 160 160 Professor B 15 16 Male
## 162 162 Professor B 26 19 Male
## 163 163 Associate_Professor B 22 7 Male
## 164 164 Assistant_Professor B 3 3 Male
## 166 166 Professor B 21 8 Male
## 167 167 Professor B 16 16 Male
## 168 168 Professor B 18 19 Male
## 169 169 Associate_Professor B 8 6 Male
## 170 170 Professor B 25 18 Male
## 171 171 Assistant_Professor B 5 5 Male
## 172 172 Professor B 19 19 Male
## 173 173 Professor B 37 24 Male
## 174 174 Professor B 20 20 Male
## 175 175 Associate_Professor B 17 6 Male
## 176 176 Professor B 28 25 Male
## 177 177 Associate_Professor B 10 7 Male
## 178 178 Associate_Professor B 13 9 Male
## 179 179 Professor B 27 14 Male
## 180 180 Assistant_Professor B 3 3 Female
## 181 181 Professor B 11 11 Male
## 182 182 Professor B 18 5 Male
## 183 183 Associate_Professor B 8 8 Male
## 184 184 Professor B 26 22 Male
## 185 185 Professor B 23 23 Male
## 186 186 Professor B 33 30 Male
## 187 187 Associate_Professor B 13 10 Female
## 188 188 Professor B 18 10 Male
## 189 189 Associate_Professor B 28 28 Male
## 190 190 Professor B 25 19 Male
## 191 191 Professor B 22 9 Male
## 192 192 Professor B 43 22 Male
## 193 193 Professor B 19 18 Male
## 194 194 Associate_Professor B 19 19 Male
## 195 195 Associate_Professor B 48 53 Male
## 196 196 Associate_Professor B 9 7 Male
## 197 197 Assistant_Professor B 4 4 Male
## 198 198 Assistant_Professor B 4 4 Male
## 199 199 Professor B 34 33 Male
## 200 200 Professor B 38 22 Male
## 201 201 Assistant_Professor B 4 4 Male
## 202 202 Professor B 40 40 Male
## 203 203 Professor B 28 17 Male
## 204 204 Professor B 17 17 Male
## 205 205 Professor B 19 5 Male
## 207 207 Professor B 35 33 Male
## 208 208 Professor B 18 18 Male
## 210 210 Professor B 20 20 Male
## 211 211 Assistant_Professor B 4 3 Male
## 212 212 Professor B 39 39 Male
## 213 213 Professor B 15 7 Male
## 214 214 Professor B 26 19 Male
## 216 216 Professor B 16 11 Male
## 217 217 Professor B 15 11 Male
## 218 218 Associate_Professor B 29 22 Male
## 219 219 Associate_Professor B 14 7 Female
## 220 220 Professor B 13 11 Male
## 221 221 Professor B 21 21 Male
## 222 222 Professor B 23 10 Male
## 223 223 Associate_Professor B 13 6 Male
## 224 224 Professor B 34 20 Male
## 225 225 Professor A 38 35 Male
## 226 226 Professor A 20 20 Male
## 228 228 Associate_Professor A 9 7 Male
## 229 229 Professor A 16 11 Male
## 230 230 Professor A 39 38 Male
## 231 231 Professor A 29 27 Female
## 232 232 Associate_Professor A 26 24 Female
## 233 233 Professor A 38 19 Male
## 234 234 Professor A 36 19 Female
## 235 235 Assistant_Professor A 8 3 Male
## 236 236 Professor A 28 17 Male
## 237 237 Professor A 25 25 Male
## 238 238 Assistant_Professor A 7 6 Female
## 239 239 Professor A 46 40 Male
## 240 240 Professor A 19 6 Male
## 241 241 Assistant_Professor A 5 3 Male
## 242 242 Professor A 31 30 Male
## 243 243 Professor A 38 37 Male
## 244 244 Professor A 23 23 Male
## 245 245 Professor A 19 23 Male
## 246 246 Professor A 17 11 Female
## 247 247 Professor A 30 23 Male
## 248 248 Professor A 21 18 Male
## 249 249 Professor A 28 23 Male
## 250 250 Professor A 29 7 Male
## 251 251 Professor A 39 39 Male
## 252 252 Professor A 20 8 Male
## 253 253 Professor A 31 12 Male
## 255 255 Professor A 28 7 Female
## 256 256 Associate_Professor A 12 8 Male
## 257 257 Professor A 22 22 Male
## 258 258 Associate_Professor A 30 23 Male
## 259 259 Assistant_Professor A 9 3 Male
## 260 260 Professor A 32 30 Male
## 261 261 Associate_Professor A 41 33 Male
## 262 262 Professor A 45 45 Male
## 263 263 Professor A 31 26 Male
## 264 264 Professor A 31 31 Male
## 265 265 Professor A 37 35 Male
## 266 266 Professor A 36 30 Male
## 267 267 Professor A 43 43 Male
## 268 268 Professor A 14 10 Male
## 269 269 Professor A 47 44 Male
## 270 270 Professor A 13 7 Male
## 271 271 Professor A 42 40 Male
## 272 272 Professor A 42 18 Male
## 274 274 Assistant_Professor A 8 4 Male
## 275 275 Assistant_Professor A 8 3 Female
## 276 276 Professor A 12 6 Male
## 277 277 Professor A 52 48 Male
## 278 278 Professor A 31 27 Male
## 279 279 Professor A 24 18 Male
## 280 280 Professor A 46 46 Male
## 281 281 Professor A 39 38 Male
## 282 282 Professor A 37 27 Male
## 283 283 Professor A 51 51 Male
## 284 284 Professor A 45 43 Male
## 285 285 Associate_Professor A 8 6 Male
## 286 286 Associate_Professor A 49 49 Male
## 287 287 Professor A 28 27 Male
## 289 289 Professor A 29 27 Male
## 290 290 Assistant_Professor A 8 5 Male
## 291 291 Professor A 33 7 Male
## 292 292 Professor A 32 28 Male
## 293 293 Professor A 39 9 Male
## 295 295 Professor A 19 7 Male
## 296 296 Professor A 40 36 Male
## 297 297 Professor A 18 18 Male
## 298 298 Professor A 17 11 Male
## 299 299 Professor A 49 43 Male
## 300 300 Associate_Professor A 45 39 Male
## 301 301 Professor A 39 36 Male
## 302 302 Professor A 27 16 Male
## 303 303 Professor A 28 13 Male
## 304 304 Professor A 14 4 Male
## 305 305 Professor A 46 44 Male
## 306 306 Professor A 33 31 Male
## 307 307 Assistant_Professor A 7 4 Male
## 308 308 Professor A 31 28 Male
## 310 310 Professor A 22 15 Male
## 311 311 Professor A 20 7 Male
## 312 312 Professor A 14 9 Male
## 313 313 Professor A 29 19 Male
## 314 314 Professor A 35 35 Male
## 315 315 Professor A 22 6 Male
## 316 316 Assistant_Professor B 6 3 Male
## 317 317 Associate_Professor B 12 9 Female
## 318 318 Professor B 46 45 Male
## 319 319 Professor B 16 16 Male
## 320 320 Professor B 16 15 Male
## 321 321 Professor B 24 23 Male
## 322 322 Associate_Professor B 9 9 Male
## 323 323 Associate_Professor B 13 11 Male
## 324 324 Professor B 24 15 Female
## 325 325 Professor B 30 31 Male
## 326 326 Assistant_Professor B 8 4 Male
## 327 327 Professor B 23 15 Male
## 328 328 Professor B 37 37 Male
## 329 329 Associate_Professor B 10 10 Male
## 330 330 Professor B 23 23 Male
## 331 331 Professor B 49 60 Male
## 332 332 Professor B 20 9 Male
## 333 333 Professor B 18 10 Female
## 334 334 Professor B 33 19 Male
## 335 335 Associate_Professor B 19 6 Female
## 336 336 Professor B 36 38 Male
## 337 337 Professor B 35 23 Male
## 338 338 Professor B 13 12 Male
## 339 339 Professor B 32 25 Male
## 340 340 Professor B 37 15 Male
## 341 341 Professor B 13 11 Male
## 342 342 Professor B 17 17 Female
## 343 343 Professor B 38 38 Male
## 344 344 Professor B 31 31 Male
## 345 345 Professor B 32 35 Male
## 346 346 Professor B 15 10 Male
## 347 347 Professor B 41 27 Male
## 348 348 Professor B 39 33 Male
## 349 349 Assistant_Professor B 4 3 Male
## 350 350 Professor B 27 28 Male
## 351 351 Professor B 56 49 Male
## 352 352 Professor B 38 38 Male
## 353 353 Professor B 26 27 Male
## 354 354 Professor B 22 20 Male
## 356 356 Professor B 25 21 Male
## 357 357 Professor A 49 40 Male
## 358 358 Professor A 39 35 Male
## 359 359 Professor A 28 14 Female
## 360 360 Assistant_Professor A 11 4 Male
## 361 361 Professor A 14 11 Male
## 362 362 Professor A 23 15 Female
## 363 363 Professor A 30 30 Male
## 364 364 Associate_Professor A 20 17 Male
## 365 365 Professor A 43 43 Male
## 366 366 Professor A 43 40 Male
## 367 367 Professor A 15 10 Male
## 369 369 Professor A 35 30 Male
## 370 370 Professor A 33 31 Male
## 371 371 Associate_Professor A 13 8 Male
## 372 372 Professor A 23 20 Male
## 373 373 Professor A 12 7 Male
## 374 374 Professor A 30 26 Male
## 375 375 Professor A 27 19 Male
## 376 376 Professor A 28 26 Male
## 378 378 Assistant_Professor A 6 3 Male
## 379 379 Professor A 38 38 Male
## 380 380 Associate_Professor A 11 8 Male
## 381 381 Assistant_Professor A 8 3 Male
## 382 382 Professor A 27 23 Male
## 383 383 Associate_Professor A 8 5 Male
## 384 384 Professor A 44 44 Male
## 385 385 Professor A 27 21 Male
## 386 386 Professor A 15 9 Male
## 387 387 Professor A 29 27 Male
## 388 388 Professor A 29 15 Male
## 389 389 Professor A 38 36 Male
## 390 390 Professor A 33 18 Male
## 391 391 Professor A 40 19 Male
## 392 392 Professor A 30 19 Male
## 393 393 Professor A 33 30 Male
## 394 394 Professor A 31 19 Male
## 395 395 Professor A 42 25 Male
## 396 396 Professor A 25 15 Male
## 397 397 Assistant_Professor A 8 4 Male
## salary Pro_Rata_Salary
## 1 139750 7763.889
## 2 173200 10825.000
## 3 79750 26583.333
## 4 115000 2948.718
## 5 141500 3451.220
## 6 97000 16166.667
## 7 175000 7608.696
## 8 147765 3283.667
## 9 119250 5962.500
## 10 129000 7166.667
## 11 119800 14975.000
## 15 104800 5822.222
## 16 117150 39050.000
## 17 101000 5050.000
## 18 103450 3042.647
## 19 124750 5423.913
## 20 137000 3805.556
## 21 89565 3444.808
## 22 102580 3309.032
## 23 93904 3130.133
## 24 113068 5950.947
## 25 74830 9353.750
## 26 106294 13286.750
## 27 134885 5864.565
## 28 82379 27459.667
## 30 118223 14777.875
## 31 132261 33065.250
## 33 117256 13028.444
## 37 155750 7416.667
## 38 86373 21593.250
## 39 125196 4038.581
## 40 100938 11215.333
## 42 93418 4061.652
## 43 101299 3751.815
## 44 231545 6093.289
## 45 94384 4967.579
## 46 114778 7651.867
## 47 98193 3506.893
## 48 151768 7987.789
## 49 140096 5603.840
## 51 126621 4522.179
## 52 108875 9897.727
## 53 74692 24897.333
## 54 106639 11848.778
## 55 103760 9432.727
## 56 83900 16780.000
## 57 117704 5604.952
## 58 90215 11276.875
## 59 100135 11126.111
## 60 75044 25014.667
## 61 90304 11288.000
## 63 109785 3541.452
## 64 103613 9419.364
## 65 68404 22801.333
## 66 100522 12565.250
## 67 101000 8416.667
## 68 99418 3207.032
## 69 111512 6559.529
## 70 91412 2539.222
## 72 146856 3263.467
## 73 100131 5270.053
## 74 92391 2717.382
## 75 113398 4930.348
## 76 73266 24422.000
## 77 150480 50160.000
## 78 193000 10157.895
## 81 150743 5383.679
## 82 135585 8474.062
## 83 144640 7232.000
## 85 122960 6831.111
## 86 132825 9487.500
## 87 152708 4127.243
## 89 172272 6890.880
## 90 107008 15286.857
## 91 97032 19406.400
## 92 105128 15018.286
## 93 105631 15090.143
## 94 166024 4369.053
## 95 123683 6184.150
## 97 95611 7967.583
## 98 129676 18525.143
## 99 102235 7302.500
## 100 106689 4103.423
## 101 133217 5328.680
## 102 126933 5518.826
## 103 153303 30660.600
## 104 127512 9108.000
## 105 83850 8385.000
## 106 113543 4055.107
## 107 82099 10262.375
## 108 82600 10325.000
## 109 81500 10187.500
## 110 131205 4232.419
## 111 112429 7026.812
## 112 82100 5131.250
## 114 104279 2818.351
## 116 120806 13422.889
## 117 148500 5120.690
## 118 117515 3264.306
## 120 73500 24500.000
## 121 115313 8236.643
## 122 124309 3884.656
## 123 97262 4421.000
## 124 62884 2858.364
## 125 96614 4391.545
## 126 78162 1595.143
## 127 155500 5980.769
## 129 113278 3775.933
## 131 83001 9222.333
## 132 76840 1348.070
## 133 77500 9687.500
## 135 168635 6745.400
## 136 136000 7555.556
## 137 108262 7733.000
## 138 105668 7547.714
## 139 73877 10553.857
## 140 152664 8481.333
## 141 100102 12512.750
## 142 81500 8150.000
## 143 106608 9691.636
## 144 89942 29980.667
## 145 112696 4173.926
## 146 119015 4250.536
## 147 92000 23000.000
## 148 156938 5812.519
## 149 144651 5563.500
## 150 95079 31693.000
## 151 128148 10679.000
## 152 92000 23000.000
## 153 111168 12352.000
## 154 103994 10399.400
## 156 118971 5665.286
## 157 113341 6296.722
## 159 95408 15901.333
## 160 137167 8572.938
## 162 176500 9289.474
## 163 98510 14072.857
## 164 89942 29980.667
## 166 105890 13236.250
## 167 167284 10455.250
## 168 130664 6877.053
## 169 101210 16868.333
## 170 181257 10069.833
## 171 91227 18245.400
## 172 151575 7977.632
## 173 93164 3881.833
## 174 134185 6709.250
## 175 105000 17500.000
## 176 111751 4470.040
## 177 95436 13633.714
## 178 100944 11216.000
## 179 147349 10524.929
## 180 92000 30666.667
## 181 142467 12951.545
## 182 141136 28227.200
## 183 100000 12500.000
## 184 150000 6818.182
## 185 101000 4391.304
## 186 134000 4466.667
## 187 103750 10375.000
## 188 107500 10750.000
## 189 106300 3796.429
## 190 153750 8092.105
## 191 180000 20000.000
## 192 133700 6077.273
## 193 122100 6783.333
## 194 86250 4539.474
## 195 90000 1698.113
## 196 113600 16228.571
## 197 92700 23175.000
## 198 92000 23000.000
## 199 189409 5739.667
## 200 114500 5204.545
## 201 92700 23175.000
## 202 119700 2992.500
## 203 160400 9435.294
## 204 152500 8970.588
## 205 165000 33000.000
## 207 162200 4915.152
## 208 120000 6666.667
## 210 163200 8160.000
## 211 91000 30333.333
## 212 111350 2855.128
## 213 128400 18342.857
## 214 126200 6642.105
## 216 145350 13213.636
## 217 146000 13272.727
## 218 105350 4788.636
## 219 109650 15664.286
## 220 119500 10863.636
## 221 170000 8095.238
## 222 145200 14520.000
## 223 107150 17858.333
## 224 129600 6480.000
## 225 87800 2508.571
## 226 122400 6120.000
## 228 70000 10000.000
## 229 88175 8015.909
## 230 133900 3523.684
## 231 91000 3370.370
## 232 73300 3054.167
## 233 148750 7828.947
## 234 117555 6187.105
## 235 69700 23233.333
## 236 81700 4805.882
## 237 114000 4560.000
## 238 63100 10516.667
## 239 77202 1930.050
## 240 96200 16033.333
## 241 69200 23066.667
## 242 122875 4095.833
## 243 102600 2772.973
## 244 108200 4704.348
## 245 84273 3664.043
## 246 90450 8222.727
## 247 91100 3960.870
## 248 101100 5616.667
## 249 128800 5600.000
## 250 204000 29142.857
## 251 109000 2794.872
## 252 102000 12750.000
## 253 132000 11000.000
## 255 116450 16635.714
## 256 83000 10375.000
## 257 140300 6377.273
## 258 74000 3217.391
## 259 73800 24600.000
## 260 92550 3085.000
## 261 88600 2684.848
## 262 107550 2390.000
## 263 121200 4661.538
## 264 126000 4064.516
## 265 99000 2828.571
## 266 134800 4493.333
## 267 143940 3347.442
## 268 104350 10435.000
## 269 89650 2037.500
## 270 103700 14814.286
## 271 143250 3581.250
## 272 194800 10822.222
## 274 74000 18500.000
## 275 78500 26166.667
## 276 93000 15500.000
## 277 107200 2233.333
## 278 163200 6044.444
## 279 107100 5950.000
## 280 100600 2186.957
## 281 136500 3592.105
## 282 103600 3837.037
## 283 57800 1133.333
## 284 155865 3624.767
## 285 88650 14775.000
## 286 81800 1669.388
## 287 115800 4288.889
## 289 150500 5574.074
## 290 74000 14800.000
## 291 174500 24928.571
## 292 168500 6017.857
## 293 183800 20422.222
## 295 107300 15328.571
## 296 97150 2698.611
## 297 126300 7016.667
## 298 148800 13527.273
## 299 72300 1681.395
## 300 70700 1812.821
## 301 88600 2461.111
## 302 127100 7943.750
## 303 170500 13115.385
## 304 105260 26315.000
## 305 144050 3273.864
## 306 111350 3591.935
## 307 74500 18625.000
## 308 122500 4375.000
## 310 166800 11120.000
## 311 92050 13150.000
## 312 108100 12011.111
## 313 94350 4965.789
## 314 100351 2867.171
## 315 146800 24466.667
## 316 84716 28238.667
## 317 71065 7896.111
## 318 67559 1501.311
## 319 134550 8409.375
## 320 135027 9001.800
## 321 104428 4540.348
## 322 95642 10626.889
## 323 126431 11493.727
## 324 161101 10740.067
## 325 162221 5232.935
## 326 84500 21125.000
## 327 124714 8314.267
## 328 151650 4098.649
## 329 99247 9924.700
## 330 134778 5859.913
## 331 192253 3204.217
## 332 116518 12946.444
## 333 105450 10545.000
## 334 145098 7636.737
## 335 104542 17423.667
## 336 151445 3985.395
## 337 98053 4263.174
## 338 145000 12083.333
## 339 128464 5138.560
## 340 137317 9154.467
## 341 106231 9657.364
## 342 124312 7312.471
## 343 114596 3015.684
## 344 162150 5230.645
## 345 150376 4296.457
## 346 107986 10798.600
## 347 142023 5260.111
## 348 128250 3886.364
## 349 80139 26713.000
## 350 144309 5153.893
## 351 186960 3815.510
## 352 93519 2461.026
## 353 142500 5277.778
## 354 138000 6900.000
## 356 145028 6906.095
## 357 88709 2217.725
## 358 107309 3065.971
## 359 109954 7853.857
## 360 78785 19696.250
## 361 121946 11086.000
## 362 109646 7309.733
## 363 138771 4625.700
## 364 81285 4781.471
## 365 205500 4779.070
## 366 101036 2525.900
## 367 115435 11543.500
## 369 131950 4398.333
## 370 134690 4344.839
## 371 78182 9772.750
## 372 110515 5525.750
## 373 109707 15672.429
## 374 136660 5256.154
## 375 103275 5435.526
## 376 103649 3986.500
## 378 77081 25693.667
## 379 150680 3965.263
## 380 104121 13015.125
## 381 75996 25332.000
## 382 172505 7500.217
## 383 86895 17379.000
## 384 105000 2386.364
## 385 125192 5961.524
## 386 114330 12703.333
## 387 139219 5156.259
## 388 109305 7287.000
## 389 119450 3318.056
## 390 186023 10334.611
## 391 166605 8768.684
## 392 151292 7962.737
## 393 103106 3436.867
## 394 150564 7924.421
## 395 101738 4069.520
## 396 95329 6355.267
## 397 81035 20258.750Salaries_Service_Years[1:30, ] #30 rows displayed## X rank discipline yrs.since.phd yrs.service sex
## 1 1 Professor B 19 18 Male
## 2 2 Professor B 20 16 Male
## 3 3 Assistant_Professor B 4 3 Male
## 4 4 Professor B 45 39 Male
## 5 5 Professor B 40 41 Male
## 6 6 Associate_Professor B 6 6 Male
## 7 7 Professor B 30 23 Male
## 8 8 Professor B 45 45 Male
## 9 9 Professor B 21 20 Male
## 10 10 Professor B 18 18 Female
## 11 11 Associate_Professor B 12 8 Male
## 15 15 Professor B 20 18 Male
## 16 16 Professor B 12 3 Male
## 17 17 Professor B 19 20 Male
## 18 18 Professor A 38 34 Male
## 19 19 Professor A 37 23 Male
## 20 20 Professor A 39 36 Female
## 21 21 Professor A 31 26 Male
## 22 22 Professor A 36 31 Male
## 23 23 Professor A 34 30 Male
## 24 24 Professor A 24 19 Male
## 25 25 Associate_Professor A 13 8 Female
## 26 26 Professor A 21 8 Male
## 27 27 Professor A 35 23 Male
## 28 28 Assistant_Professor B 5 3 Male
## 30 30 Professor B 12 8 Male
## 31 31 Professor B 20 4 Male
## 33 33 Professor B 13 9 Male
## 37 37 Professor B 22 21 Male
## 38 38 Assistant_Professor B 7 4 Male
## salary Pro_Rata_Salary
## 1 139750 7763.889
## 2 173200 10825.000
## 3 79750 26583.333
## 4 115000 2948.718
## 5 141500 3451.220
## 6 97000 16166.667
## 7 175000 7608.696
## 8 147765 3283.667
## 9 119250 5962.500
## 10 129000 7166.667
## 11 119800 14975.000
## 15 104800 5822.222
## 16 117150 39050.000
## 17 101000 5050.000
## 18 103450 3042.647
## 19 124750 5423.913
## 20 137000 3805.556
## 21 89565 3444.808
## 22 102580 3309.032
## 23 93904 3130.133
## 24 113068 5950.947
## 25 74830 9353.750
## 26 106294 13286.750
## 27 134885 5864.565
## 28 82379 27459.667
## 30 118223 14777.875
## 31 132261 33065.250
## 33 117256 13028.444
## 37 155750 7416.667
## 38 86373 21593.250library(RCurl) # Loading the RCurl package will enable me to read the csv file using the link from my Github## Loading required package: bitopsSalaries <- read.csv(text = getURL("https://raw.githubusercontent.com/Emahayz/MSDS_R_Class/master/Salaries.csv"), header = T, sep = ",")
head(Salaries) # The original Salaries csv file is successfully read.## X rank discipline yrs.since.phd yrs.service sex salary
## 1 1 Prof B 19 18 Male 139750
## 2 2 Prof B 20 16 Male 173200
## 3 3 AsstProf B 4 3 Male 79750
## 4 4 Prof B 45 39 Male 115000
## 5 5 Prof B 40 41 Male 141500
## 6 6 AssocProf B 6 6 Male 97000