Final Project Summary

Part IV - Contextual write-up: why the data is important, why the insights are important. This is addressed throughout the project.

For the final project, I’ll use fivethirtyeight’s publicly available dataset college_all_ages to determine below:

1). Majors with highest employment potential 2). Majors with lowest employment potential 3). Majors with highest full-time employment potential and if they are the same as majors with highest overall employment potential 4). Ultimately, make recommendations as to which majors might be worthwhile pursuing

There are some additional datasets such as share of women in STEM fields and graduate programs with highest employment potential that I’ll also take a look at.

Part I - Finding your data set(s) and getting approval for your project on-time, recognition of strength/weaknesses of data, analysis to find insights in the data.

I used fivethirtyeight’s dataset college_all_ages to perform analysis below. I primarily relied on the recent-grads.csv and women-stem.csv files. I submitted my proposal on time, received approval to move forward. Based on the analysis performed below, it mostly concurs with the intuition that humanities majors generally produce graduates with higher unemployment rates while graduates in engineering and STEM fields have lower unemployment rates. However, there were exceptions for example nuclear engineering graduates had one of the highest unemployment rates and it could be because there aren’t many nuclear power plants in the country and hence this niche field doesn’t require as many graduates. Similarly, the other intuitive finding was that the share of women in STEM fields such as math and computer science was lower than women in health (nursing) fields. In terms of dataset weaknesses, the analysis below couldn’t explain why nuclear engineering had a high unemployment rate, which is in part due to the limited data available in the data set. It would have been helpful if the data set for example had a long-run unemployment rate average for the different majors which would have helped confirm some of these assumptions. I also had to calculate some fields such as full-time employment as a share of total employment (full-time employment potential) for each field to eliminate the possibility for example of certain humanities majors having a higher employment rate due in part to higher part-time employment. Finally, the data set is a snap-shot in time rather than a time series which is yet another weakness to discern trends. The strength of the data is it’s ability to glean high-level trends.

Part II - Data handling: cleaning, outlier/null handling, and transfer/loading data to the web.

Although I pulled the files directly from fivethirtyeight’s website, I did have to filter out 0’s in the employed column to calculate the full-tie empoyment potential. The files were relatively clean.

Part III - The graphs are outlined below where applicable.

library(fivethirtyeight)
library(ggplot2)
library(dplyr)
## Warning: package 'dplyr' was built under R version 4.0.5
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(data.table)
## 
## Attaching package: 'data.table'
## The following objects are masked from 'package:dplyr':
## 
##     between, first, last
Recent_Grads <- read.csv(url("https://raw.githubusercontent.com/fivethirtyeight/data/master/college-majors/recent-grads.csv"))

To determine majors with highest and lowest employment potential, we take a look at majors with the highest and lowest unemployment rates.

Nuclear engineering, Public Administration and Computer Networking & Telecommunications are the three majors with the highest unemployment rates. At first glance, it’s not intuitive that Nuclear engineering would have a high unemployment rate but it could be because it’s a specialized field with limited employment potential. Computer networking & telecom appears to be hardware-related jobs than software which are highly desired. Similarly, jobs with the lowest unemployment potential are Maths & computer-related, Botany and Military Technologies.

Part III - Data presentation: compliance with best data visualization practices, clarity, information-to-ink ratio, how memorable the visualization is

# Identify the top three majors with the highest unemployment rates

Recent_Grads1 <- Recent_Grads[order(-Recent_Grads$Unemployment_rate),]

# Identify the top three majors with the lowest unemployment rates

Recent_Grads2 <- Recent_Grads[order(Recent_Grads$Unemployment_rate),]

# Bar plot with Color for the Top 3 Majors with the highest unemployment rates

barplot(Recent_Grads1$Unemployment_rate, main="Top 3 Majors with the highest unemployment rates", xlab="Majors with the highest unemployment rates", ylab="Unemployment Rate (%)", col=c("darkblue", "red"), names.arg= as.matrix(Recent_Grads1$Major), cex.names = 0.3, cex.lab = 1, cex.axis = 0.7, las = 2)

Top_3_unemployment <-  c("NUCLEAR ENGINEERING" = 17.7, "PUBLIC ADMINISTRATION" = 15.9, "COMPUTER NETWORKING AND TELECOMMUNICATIONS" = 15.2)

barplot(Top_3_unemployment, main ="Top 3 Majors with the highest unemployment rates", xlab = "Majors", ylab = "Unemployment Rate (%)", col=c("darkblue", "red", "green"),cex.names = 0.5)

# Bar plot with Color for the Top 3 Majors with the lowest unemployment rates

barplot(Recent_Grads2$Unemployment_rate, main="Top 3 Majors with the lowest unemployment rates", xlab="Majors with the lowest unemployment rates", ylab="Unemployment Rate (%)", col=c("darkblue", "red"), names.arg= as.matrix(Recent_Grads2$Major), cex.names = 0.3, cex.lab = 1, cex.axis = 0.7, las = 2)

# I hard coded a value of 0.1 as otherwise the barplot was showing nothing
Bottom_3_unemployment <-  c("MATHEMATICS AND COMPUTER SCIENCE" = 0.1, "MILITARY TECHNOLOGIES" = 0.1, "BOTANY" = 0.1)

barplot(Bottom_3_unemployment, main ="Top 3 Majors with the lowest unemployment rates", xlab = "Majors", ylab = "Unemployment Rate (%)", col=c("darkblue", "red", "green"),cex.names = 0.5)

We could also have used small multiples as a display for the majors, below is how we would do this. Although this doesn’t help us decipher clearly, we see how below in the case of women’s share of STEM majors displayed as small multiples, we can clearly see that the share of women in STEM majors such as computers and engineering is low versus high in Health (i.e. fields such as nursing)

ggplot(Recent_Grads1, aes(x = Major, y = Unemployment_rate)) +
  geom_bar(stat = "identity")+
  facet_wrap(~Major_category)+
  labs(title = "Unemployment Rate by Major")+
  theme(axis.ticks = element_blank(), axis.text.x = element_blank(), legend.position = "none")

To identify majors with the highest full-time employment potential, we divide the Full-time_year_round column by the Employed column.

Majors with the highest full time year around employment as a percent of total employment are Oceanography, Naval Architecture & Marine Engineering whereas majors with the lowest share of full-time employment are Miscellaneous fine arts, Anthropology & Archaeology and Music. Essentially engineering graduates are likely to be fully employed whereas Liberal arts graduates are less employed which concurs with intuition. It’s also interesting to note that the majors with the highest share of full-time employment are not necessarily the fields with the lowest unemployment rates which were earlier identified to be Maths & computer-related, Botany and Military Technologies majors, this could mean that although graduates with these majors have the lowest overall unemployment rates, perhaps there are an inordinate number of part-time employees with these majors accounting for the low unemployment rate.

Based on this analysis, it’s recommended that graduates pursue Oceanography, Naval Architecture & Marine Engineering and it’s recommended graduates do not pursue Miscellaneous fine arts, Anthropology & Archaeology and Music fields.

Recent_Grads3 <- Recent_Grads
Recent_Grads3 <- filter(Recent_Grads, Employed > 0)
Recent_Grads3$calc <- Recent_Grads3$Full_time_year_round / Recent_Grads3$Employed

#Ordered in descending order

Recent_Grads3[order(-Recent_Grads3$calc),]
##     Rank Major_code
## 50    50       5006
## 4      4       2417
## 20    20       3201
## 67    67       2504
## 7      7       6202
## 75    76       5701
## 25    25       6212
## 6      6       2418
## 66    66       2599
## 12    12       2401
## 28    28       6204
## 81    82       2106
## 27    27       5601
## 54    54       2101
## 106  107       5901
## 46    46       2105
## 56    56       2303
## 18    18       2400
## 36    36       6207
## 41    41       6201
## 86    87       6209
## 43    43       2100
## 64    64       1101
## 29    29       2499
## 38    38       6205
## 83    84       3602
## 39    39       2503
## 58    58       6200
## 11    11       2407
## 17    17       2412
## 161  162       1199
## 171  172       5203
## 76    77       6203
## 19    19       2403
## 63    63       6299
## 120  121       2301
## 9      9       2414
## 104  105       6103
## 77    78       6206
## 84    85       2107
## 89    90       5401
## 94    95       5301
## 72    72       1102
## 90    91       5005
## 53    53       4005
## 21    21       2102
## 160  161       2201
## 143  144       1105
## 45    45       6105
## 98    99       1904
## 37    37       5501
## 35    35       6107
## 26    26       2406
## 100  101       2310
## 48    48       3701
## 130  131       2399
## 10    10       2408
## 65    65       1100
## 23    23       2502
## 34    34       2411
## 31    31       2410
## 60    60       6210
## 102  103       5503
## 5      5       2405
## 96    97       1902
## 93    94       1901
## 154  155       2312
## 57    57       5505
## 51    51       2501
## 164  165       2307
## 109  110       4000
## 131  132       4007
## 152  153       1103
## 110  111       5002
## 127  128       6211
## 97    98       5098
## 40    40       5102
## 95    96       6004
## 112  113       1106
## 78    79       5506
## 113  114       2300
## 74    75       5003
## 125  126       1903
## 32    32       2500
## 119  120       2305
## 170  171       5202
## 105  106       2001
## 79    80       5504
## 151  152       5404
## 1      1       2419
## 30    30       5402
## 156  157       5403
## 124  125       5507
## 140  141       3401
## 133  134       2309
## 2      2       2416
## 144  145       2308
## 68    68       3605
## 85    86       5004
## 108  109       3611
## 71    71       5205
## 13    13       2404
## 14    14       5008
## 142  143       5500
## 107  108       1303
## 128  129       2313
## 111  112       1302
## 59    59       1401
## 122  123       3699
## 88    89       6199
## 42    42       3700
## 138  139       2304
## 55    55       4006
## 150  151       2901
## 158  159       4901
## 168  169       3609
## 126  127       6109
## 147  148       2306
## 169  170       5201
## 73    73       5000
## 44    44       5007
## 148  149       6006
## 145  146       5200
## 139  140       4101
## 69    69       5599
## 114  115       6402
## 15    15       2409
## 16    16       2402
## 172  173       3501
## 136  137       2314
## 22    22       1104
## 123  124       3600
## 87    88       3202
## 61    61       6108
## 137  138       3301
## 135  136       4801
## 8      8       5001
## 82    83       3601
## 149  150       6000
## 62    62       3603
## 159  160       6007
## 99   100       1501
## 157  158       3402
## 134  135       6100
## 3      3       2415
## 80    81       3606
## 115  116       2602
## 92    93       1301
## 129  130       2601
## 167  168       3302
## 101  102       3608
## 132  133       3604
## 118  119       6110
## 47    47       3702
## 155  156       5299
## 103  104       4002
## 117  118       2311
## 141  142       6005
## 49    49       3607
## 153  154       6003
## 91    92       5206
## 163  164       6102
## 24    24       2413
## 52    52       6104
## 116  117       4001
## 166  167       6001
## 121  122       6106
## 70    70       6403
## 165  166       2603
## 146  147       6002
## 162  163       5502
## 33    33       6099
##                                                                 Major  Total
## 50                                                       OCEANOGRAPHY   2418
## 4                           NAVAL ARCHITECTURE AND MARINE ENGINEERING   1258
## 20                                                    COURT REPORTING   1148
## 67                        MECHANICAL ENGINEERING RELATED TECHNOLOGIES   4790
## 7                                                   ACTUARIAL SCIENCE   3777
## 75  ELECTRICAL, MECHANICAL, AND PRECISION TECHNOLOGIES AND PRODUCTION   2435
## 25                      MANAGEMENT INFORMATION SYSTEMS AND STATISTICS  18713
## 6                                                 NUCLEAR ENGINEERING   2573
## 66                             MISCELLANEOUS ENGINEERING TECHNOLOGIES   8804
## 12                                              AEROSPACE ENGINEERING  15058
## 28                                OPERATIONS LOGISTICS AND E-COMMERCE  11732
## 81                    COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY   8066
## 27                                              CONSTRUCTION SERVICES  18498
## 54                           COMPUTER PROGRAMMING AND DATA PROCESSING   4168
## 106                          TRANSPORTATION SCIENCES AND TECHNOLOGIES  15150
## 46                                               INFORMATION SCIENCES  11913
## 56                                          SCHOOL STUDENT COUNSELING    818
## 18                                                GENERAL ENGINEERING  61152
## 36                                                            FINANCE 174506
## 41                                                         ACCOUNTING 198633
## 86                           HUMAN RESOURCES AND PERSONNEL MANAGEMENT  24497
## 43                                   COMPUTER AND INFORMATION SYSTEMS  36698
## 64                              AGRICULTURE PRODUCTION AND MANAGEMENT  14240
## 29                                          MISCELLANEOUS ENGINEERING   9133
## 38                                                 BUSINESS ECONOMICS  13302
## 83                                                             BOTANY   1329
## 39                                 INDUSTRIAL PRODUCTION TECHNOLOGIES   4631
## 58                                                   GENERAL BUSINESS 234590
## 11                                               COMPUTER ENGINEERING  41542
## 17                           INDUSTRIAL AND MANUFACTURING ENGINEERING  18968
## 161                                         MISCELLANEOUS AGRICULTURE   1488
## 171                                             COUNSELING PSYCHOLOGY   4626
## 76                             BUSINESS MANAGEMENT AND ADMINISTRATION 329927
## 19                                          ARCHITECTURAL ENGINEERING   2825
## 63                    MISCELLANEOUS BUSINESS & MEDICAL ADMINISTRATION  17947
## 120                        EDUCATIONAL ADMINISTRATION AND SUPERVISION    804
## 9                                              MECHANICAL ENGINEERING  91227
## 104                        HEALTH AND MEDICAL ADMINISTRATIVE SERVICES  18109
## 77                                   MARKETING AND MARKETING RESEARCH 205211
## 84                         COMPUTER NETWORKING AND TELECOMMUNICATIONS   7613
## 89                                              PUBLIC ADMINISTRATION   5629
## 94                               CRIMINAL JUSTICE AND FIRE PROTECTION 152824
## 72                                             AGRICULTURAL ECONOMICS   2439
## 90                                                        GEOSCIENCES   1978
## 53                                   MATHEMATICS AND COMPUTER SCIENCE    609
## 21                                                   COMPUTER SCIENCE 128319
## 160                            COSMETOLOGY SERVICES AND CULINARY ARTS  10510
## 143                                        PLANT SCIENCE AND AGRONOMY   7416
## 45                                   MEDICAL TECHNOLOGIES TECHNICIANS  15914
## 98                                   ADVERTISING AND PUBLIC RELATIONS  53162
## 37                                                          ECONOMICS 139247
## 35                                                            NURSING 209394
## 26                                                  CIVIL ENGINEERING  53153
## 100                                           SPECIAL NEEDS EDUCATION  28739
## 48                                                APPLIED MATHEMATICS   4939
## 130                                           MISCELLANEOUS EDUCATION  10150
## 10                                             ELECTRICAL ENGINEERING  81527
## 65                                                GENERAL AGRICULTURE  10399
## 23                                  ELECTRICAL ENGINEERING TECHNOLOGY  11565
## 34                             GEOLOGICAL AND GEOPHYSICAL ENGINEERING    720
## 31                                          ENVIRONMENTAL ENGINEERING   4047
## 60                                             INTERNATIONAL BUSINESS  25894
## 102                                                       CRIMINOLOGY  19879
## 5                                                CHEMICAL ENGINEERING  32260
## 96                                                         JOURNALISM  72619
## 93                                                     COMMUNICATIONS 213996
## 154                                TEACHER EDUCATION: MULTIPLE LEVELS  14443
## 57                                            INTERNATIONAL RELATIONS  28187
## 51                              ENGINEERING AND INDUSTRIAL MANAGEMENT   2906
## 164                                         EARLY CHILDHOOD EDUCATION  37589
## 109                                   MULTI/INTERDISCIPLINARY STUDIES  12296
## 131                                 INTERDISCIPLINARY SOCIAL SCIENCES   9916
## 152                                                   ANIMAL SCIENCES  21573
## 110                              ATMOSPHERIC SCIENCES AND METEOROLOGY   4043
## 127                                            HOSPITALITY MANAGEMENT  43647
## 97                              MULTI-DISCIPLINARY OR GENERAL SCIENCE  62052
## 40         NUCLEAR, INDUSTRIAL RADIOLOGY, AND BIOLOGICAL TECHNOLOGIES   2116
## 95                                  COMMERCIAL ART AND GRAPHIC DESIGN 103480
## 112                                                      SOIL SCIENCE    685
## 78                                   POLITICAL SCIENCE AND GOVERNMENT 182621
## 113                                                 GENERAL EDUCATION 143718
## 74                                                          CHEMISTRY  66530
## 125                                                        MASS MEDIA  52824
## 32                                           ENGINEERING TECHNOLOGIES   3600
## 119                                     MATHEMATICS TEACHER EDUCATION  14237
## 170                                               CLINICAL PSYCHOLOGY   2838
## 105                                        COMMUNICATION TECHNOLOGIES  18035
## 79                                                          GEOGRAPHY  18480
## 151                                                       SOCIAL WORK  53552
## 1                                               PETROLEUM ENGINEERING   2339
## 30                                                      PUBLIC POLICY   5978
## 156                         HUMAN SERVICES AND COMMUNITY ORGANIZATION   9374
## 124                                                         SOCIOLOGY 115433
## 140                                                      LIBERAL ARTS  71369
## 133                                       SECONDARY TEACHER EDUCATION  17125
## 2                                      MINING AND MINERAL ENGINEERING    756
## 144                            SCIENCE AND COMPUTER TEACHER EDUCATION   6483
## 68                                                           GENETICS   3635
## 85                                          GEOLOGY AND EARTH SCIENCE  10972
## 108                                                      NEUROSCIENCE  13663
## 71                           INDUSTRIAL AND ORGANIZATIONAL PSYCHOLOGY   3014
## 13                                             BIOMEDICAL ENGINEERING  14955
## 14                                                  MATERIALS SCIENCE   4279
## 142                                           GENERAL SOCIAL SCIENCES  12920
## 107                                      NATURAL RESOURCES MANAGEMENT  13773
## 128                                      LANGUAGE AND DRAMA EDUCATION  30471
## 111                                                          FORESTRY   3607
## 59                                                       ARCHITECTURE  46420
## 122                                             MISCELLANEOUS BIOLOGY  10706
## 88                           MISCELLANEOUS HEALTH MEDICAL PROFESSIONS  13386
## 42                                                        MATHEMATICS  72397
## 138                                              ELEMENTARY EDUCATION 170862
## 55                                COGNITIVE SCIENCE AND BIOPSYCHOLOGY   3831
## 150                                      FAMILY AND CONSUMER SCIENCES  58001
## 158                                  THEOLOGY AND RELIGIOUS VOCATIONS  30207
## 168                                                           ZOOLOGY   8409
## 126                                     TREATMENT THERAPY PROFESSIONS  48491
## 147                            PHYSICAL AND HEALTH EDUCATION TEACHING  28213
## 169                                            EDUCATIONAL PSYCHOLOGY   2854
## 73                                                  PHYSICAL SCIENCES   1436
## 44                                                            PHYSICS  32142
## 148                                         ART HISTORY AND CRITICISM  21030
## 145                                                        PSYCHOLOGY 393735
## 139                     PHYSICAL FITNESS PARKS RECREATION AND LEISURE 125074
## 69                                      MISCELLANEOUS SOCIAL SCIENCES   3283
## 114                                                           HISTORY 141951
## 15                          ENGINEERING MECHANICS PHYSICS AND SCIENCE   4321
## 16                                             BIOLOGICAL ENGINEERING   8925
## 172                                                   LIBRARY SCIENCE   1098
## 136                                           ART AND MUSIC EDUCATION  34181
## 22                                                       FOOD SCIENCE     NA
## 123                                                           BIOLOGY 280709
## 87                                          PRE-LAW AND LEGAL STUDIES  13528
## 61                PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTRATION  23551
## 137                                   ENGLISH LANGUAGE AND LITERATURE 194673
## 135                                  PHILOSOPHY AND RELIGIOUS STUDIES  54814
## 8                                          ASTRONOMY AND ASTROPHYSICS   1792
## 82                                               BIOCHEMICAL SCIENCES  39107
## 149                                                         FINE ARTS  74440
## 62                                                  MOLECULAR BIOLOGY  18300
## 159                                                       STUDIO ARTS  16977
## 99                               AREA ETHNIC AND CIVILIZATION STUDIES  31195
## 157                                                        HUMANITIES   6652
## 134                               GENERAL MEDICAL AND HEALTH SERVICES  33599
## 3                                           METALLURGICAL ENGINEERING    856
## 80                                                       MICROBIOLOGY  15232
## 115     FRENCH GERMAN LATIN AND OTHER COMMON FOREIGN LANGUAGE STUDIES  48246
## 92                                              ENVIRONMENTAL SCIENCE  25965
## 129               LINGUISTICS AND COMPARATIVE LANGUAGE AND LITERATURE  16601
## 167                                          COMPOSITION AND RHETORIC  18953
## 101                                                        PHYSIOLOGY  22060
## 132                                                           ECOLOGY   9154
## 118                                       COMMUNITY AND PUBLIC HEALTH  19735
## 47                                    STATISTICS AND DECISION SCIENCE   6251
## 155                                          MISCELLANEOUS PSYCHOLOGY   9628
## 103                                                NUTRITION SCIENCES  18909
## 117                       SOCIAL SCIENCE OR HISTORY TEACHER EDUCATION  20198
## 141                                  FILM VIDEO AND PHOTOGRAPHIC ARTS  38761
## 49                                                       PHARMACOLOGY   1762
## 153                                        VISUAL AND PERFORMING ARTS  16250
## 91                                                  SOCIAL PSYCHOLOGY   1386
## 163                     COMMUNICATION DISORDERS SCIENCES AND SERVICES  38279
## 24                        MATERIALS ENGINEERING AND MATERIALS SCIENCE   2993
## 52                                         MEDICAL ASSISTING SERVICES  11123
## 116                           INTERCULTURAL AND INTERNATIONAL STUDIES  24650
## 166                                            DRAMA AND THEATER ARTS  43249
## 121                           HEALTH AND MEDICAL PREPARATORY PROGRAMS  12740
## 70                                              UNITED STATES HISTORY   3079
## 165                                           OTHER FOREIGN LANGUAGES  11204
## 146                                                             MUSIC  60633
## 162                                       ANTHROPOLOGY AND ARCHEOLOGY  38844
## 33                                            MISCELLANEOUS FINE ARTS   3340
##        Men  Women                      Major_category ShareWomen Sample_size
## 50     752   1666                   Physical Sciences 0.68899917          36
## 4     1123    135                         Engineering 0.10731320          16
## 20     877    271                 Law & Public Policy 0.23606272          14
## 67    4419    371                         Engineering 0.07745303          71
## 7     2110   1667                            Business 0.44135557          51
## 75    1869    566 Industrial Arts & Consumer Services 0.23244353          37
## 25   13496   5217                            Business 0.27879015         278
## 6     2200    373                         Engineering 0.14496697          17
## 66    7043   1761                         Engineering 0.20002272         125
## 12   12953   2105                         Engineering 0.13979280         147
## 28    7921   3811                            Business 0.32483805         156
## 81    6607   1459             Computers & Mathematics 0.18088272         103
## 27   16820   1678 Industrial Arts & Consumer Services 0.09071251         295
## 54    3046   1122             Computers & Mathematics 0.26919386          43
## 106  13257   1893 Industrial Arts & Consumer Services 0.12495049         180
## 46    9005   2908             Computers & Mathematics 0.24410308         158
## 56     119    699                           Education 0.85452323           4
## 18   45683  15469                         Engineering 0.25295984         425
## 36  115030  59476                            Business 0.34082496        2189
## 41   94519 104114                            Business 0.52415258        2042
## 86    6184  18313                            Business 0.74756093         264
## 43   27392   9306             Computers & Mathematics 0.25358330         425
## 64    9658   4582     Agriculture & Natural Resources 0.32176966         273
## 29    7398   1735                         Engineering 0.18997044         118
## 38    7575   5727                            Business 0.43053676         199
## 83     626    703              Biology & Life Science 0.52896915           9
## 39    3477   1154                         Engineering 0.24919024          73
## 58  132238 102352                            Business 0.43630163        2380
## 11   33258   8284                         Engineering 0.19941264         399
## 17   12453   6515                         Engineering 0.34347322         183
## 161    404   1084     Agriculture & Natural Resources 0.72849462          24
## 171    931   3695            Psychology & Social Work 0.79874622          21
## 76  173809 156118                            Business 0.47318952        4212
## 19    1835    990                         Engineering 0.35044248          26
## 63   10285   7662                            Business 0.42692372         244
## 120    280    524                           Education 0.65174129           5
## 9    80320  10907                         Engineering 0.11955890        1029
## 104   4266  13843                              Health 0.76442653         184
## 77   78857 126354                            Business 0.61572723        2684
## 84    5291   2322             Computers & Mathematics 0.30500460          97
## 89    2947   2682                 Law & Public Policy 0.47646118          46
## 94   80231  72593                 Law & Public Policy 0.47501047        1728
## 72    1749    690     Agriculture & Natural Resources 0.28290283          44
## 90     809   1169                   Physical Sciences 0.59100101          18
## 53     500    109             Computers & Mathematics 0.17898194           7
## 21   99743  28576             Computers & Mathematics 0.22269500        1196
## 160   4364   6146 Industrial Arts & Consumer Services 0.58477640         117
## 143   4897   2519     Agriculture & Natural Resources 0.33967098         110
## 45    3916  11998                              Health 0.75392736         190
## 98   12862  40300         Communications & Journalism 0.75806027         681
## 37   89749  49498                      Social Science 0.35546906        1322
## 35   21773 187621                              Health 0.89601899        2554
## 26   41081  12072                         Engineering 0.22711794         565
## 100   2682  26057                           Education 0.90667734         246
## 48    2794   2145             Computers & Mathematics 0.43429844          45
## 130   3654   6496                           Education 0.64000000         126
## 10   65511  16016                         Engineering 0.19645026         631
## 65    6053   4346     Agriculture & Natural Resources 0.41792480         158
## 23    8181   3384                         Engineering 0.29260700          97
## 34     488    232                         Engineering 0.32222222           5
## 31    2662   1385                         Engineering 0.34222881          26
## 60   10624  15270                            Business 0.58971190         260
## 102  10031   9848                      Social Science 0.49539715         214
## 5    21239  11021                         Engineering 0.34163050         289
## 96   23736  48883         Communications & Journalism 0.67314339         843
## 93   70619 143377         Communications & Journalism 0.66999851        2394
## 154   2734  11709                           Education 0.81070415         142
## 57   10345  17842                      Social Science 0.63298684         219
## 51    2400    506                         Engineering 0.17412251          29
## 164   1167  36422                           Education 0.96895368         342
## 109   2817   9479                   Interdisciplinary 0.77090111         128
## 131   2337   7579                      Social Science 0.76432029          95
## 152   5347  16226     Agriculture & Natural Resources 0.75214388         255
## 110   2744   1299                   Physical Sciences 0.32129607          32
## 127  15204  28443                            Business 0.65165991         546
## 97   27015  35037                   Physical Sciences 0.56463933         427
## 40     528   1588                   Physical Sciences 0.75047259          31
## 95   32041  71439                                Arts 0.69036529        1186
## 112    476    209     Agriculture & Natural Resources 0.30510949           4
## 78   93880  88741                      Social Science 0.48592988        1387
## 113  26893 116825                           Education 0.81287661         919
## 74   32923  33607                   Physical Sciences 0.50514054         353
## 125  24704  28120         Communications & Journalism 0.53233379         590
## 32    2695    905                         Engineering 0.25138889          39
## 119   3872  10365                           Education 0.72803259         123
## 170    568   2270            Psychology & Social Work 0.79985906          13
## 105  11431   6604             Computers & Mathematics 0.36617688         208
## 79   11404   7076                      Social Science 0.38290043         179
## 151   5137  48415            Psychology & Social Work 0.90407454         374
## 1     2057    282                         Engineering 0.12056434          36
## 30    2639   3339                 Law & Public Policy 0.55854801          55
## 156    885   8489            Psychology & Social Work 0.90558993          89
## 124  32510  82923                      Social Science 0.71836477        1024
## 140  22339  49030           Humanities & Liberal Arts 0.68699295         569
## 133   6820  10305                           Education 0.60175183         156
## 2      679     77                         Engineering 0.10185185           7
## 144   2049   4434                           Education 0.68394262          59
## 68    1761   1874              Biology & Life Science 0.51554333          11
## 85    5813   5159                   Physical Sciences 0.47019687          78
## 108   4944   8719              Biology & Life Science 0.63814682          53
## 71    1075   1939            Psychology & Social Work 0.64333112          24
## 13    8407   6548                         Engineering 0.43784687          79
## 14    2949   1330                         Engineering 0.31082028          22
## 142   5079   7841                      Social Science 0.60688855         113
## 107   8617   5156     Agriculture & Natural Resources 0.37435562         152
## 128   3741  26730                           Education 0.87722753         235
## 111   3156    451     Agriculture & Natural Resources 0.12503465          48
## 59   25463  20957                         Engineering 0.45146489         362
## 122   4747   5959              Biology & Life Science 0.55660377          63
## 88    1589  11797                              Health 0.88129389          81
## 42   39956  32441             Computers & Mathematics 0.44809868         541
## 138  13029 157833                           Education 0.92374548        1629
## 55    1667   2164              Biology & Life Science 0.56486557          25
## 150   5166  52835 Industrial Arts & Consumer Services 0.91093257         518
## 158  18616  11591           Humanities & Liberal Arts 0.38371901         310
## 168   3050   5359              Biology & Life Science 0.63729338          47
## 126  13487  35004                              Health 0.72186591         224
## 147  15670  12543                           Education 0.44458229         259
## 169    522   2332            Psychology & Social Work 0.81709881           7
## 73     894    542                   Physical Sciences 0.37743733          10
## 44   23080   9062                   Physical Sciences 0.28193641         142
## 148   3240  17790           Humanities & Liberal Arts 0.84593438         204
## 145  86648 307087            Psychology & Social Work 0.77993320        2584
## 139  62181  62893 Industrial Arts & Consumer Services 0.50284631        1014
## 69    1499   1784                      Social Science 0.54340542          28
## 114  78253  63698           Humanities & Liberal Arts 0.44873231        1058
## 15    3526    795                         Engineering 0.18398519          30
## 16    6062   2863                         Engineering 0.32078431          55
## 172    134    964                           Education 0.87795993           2
## 136  10732  23449                           Education 0.68602440         338
## 22      NA     NA     Agriculture & Natural Resources         NA          36
## 123 111762 168947              Biology & Life Science 0.60185815        1370
## 87    4435   9093                 Law & Public Policy 0.67216144          92
## 61    8697  14854                              Health 0.63071632          38
## 137  58227 136446           Humanities & Liberal Arts 0.70089843        1436
## 135  31967  22847           Humanities & Liberal Arts 0.41680957         375
## 8      832    960                   Physical Sciences 0.53571429          10
## 82   18951  20156              Biology & Life Science 0.51540645         174
## 149  24786  49654                                Arts 0.66703385         623
## 62    7426  10874              Biology & Life Science 0.59420765          90
## 159   4754  12223                                Arts 0.71997408         182
## 99    8739  22456           Humanities & Liberal Arts 0.71985895         249
## 157   2013   4639           Humanities & Liberal Arts 0.69738424          49
## 134   7574  26025                              Health 0.77457662         202
## 3      725    131                         Engineering 0.15303738           3
## 80    6383   8849              Biology & Life Science 0.58094800          62
## 115  12835  35411           Humanities & Liberal Arts 0.73396758         342
## 92   10787  15178              Biology & Life Science 0.58455613         225
## 129   4416  12185           Humanities & Liberal Arts 0.73399193          88
## 167   7022  11931           Humanities & Liberal Arts 0.62950456         151
## 101   8422  13638              Biology & Life Science 0.61822303          99
## 132   3878   5276              Biology & Life Science 0.57636006          86
## 118   4103  15632                              Health 0.79209526         130
## 47    2960   3291             Computers & Mathematics 0.52647576          37
## 155   1936   7692            Psychology & Social Work 0.79891982          60
## 103   2563  16346                              Health 0.86445608         118
## 117   9950  10248                           Education 0.50737697         157
## 141  22357  16404                                Arts 0.42320890         331
## 49     515   1247              Biology & Life Science 0.70771850           3
## 153   4133  12117                                Arts 0.74566154         132
## 91     413    973            Psychology & Social Work 0.70202020           8
## 163   1225  37054                              Health 0.96799812          95
## 24    2020    973                         Engineering 0.32509188          22
## 52     803  10320                              Health 0.92780725          67
## 116   8575  16075           Humanities & Liberal Arts 0.65212982         184
## 166  14440  28809                                Arts 0.66611945         357
## 121   5521   7219                              Health 0.56664050          31
## 70    1756   1323           Humanities & Liberal Arts 0.42968496          22
## 165   3472   7732           Humanities & Liberal Arts 0.69011068          56
## 146  29909  30724                                Arts 0.50672076         419
## 162  11376  27468           Humanities & Liberal Arts 0.70713624         247
## 33    1970   1370                                Arts 0.41017964          30
##     Employed Full_time Part_time Full_time_year_round Unemployed
## 50      1638      1931       379                 1595         99
## 4        758      1069       150                  692         40
## 20       930       808       223                  808         11
## 67      4186      4175       247                 3607        250
## 7       2912      2924       296                 2482        308
## 75      2107      2057       287                 1752         64
## 25     16413     15141      2420                13017       1015
## 6       1857      2038       264                 1449        400
## 66      7502      7001      1240                 5825        416
## 12     11391     11106      2724                 8790        794
## 28     10027      9639      1183                 7724        504
## 81      6509      6289      1030                 4936        721
## 27     16318     15690      1751                12313       1042
## 54      3257      3204       482                 2453        419
## 106    12266     11688      2633                 9170        962
## 46      9881      9105      1468                 7378        639
## 56       730       595       135                  545         88
## 18     44931     41235      7199                33540       2859
## 36    145696    137921     21463               108595       9413
## 41    165527    151967     27693               123169      12411
## 86     20760     18550      3767                15446       1315
## 43     28459     26348      4332                21130       2934
## 64     12323     11119      2196                 9093        649
## 29      7428      6811      1662                 5476        597
## 38     10914     10048      1937                 8000       1165
## 83      1010       946       169                  740          0
## 39      4428      3988       597                 3242        129
## 58    190183    171385     36241               138299      14946
## 11     32506     30315      5146                23621       2275
## 17     15604     14879      2243                11326        699
## 161     1290      1098       335                  936         82
## 171     3777      3154       965                 2738        214
## 76    276234    251540     50357               199897      21502
## 19      2575      2277       343                 1848        170
## 63     14826     13364      3366                10637       1150
## 120      703       733         0                  504          0
## 9      76442     71298     13101                54639       4650
## 104    15419     13534      3299                10982       1518
## 77    178862    156668     35829               127230      11663
## 84      6144      5495      1447                 4369       1100
## 89      4158      4148       847                 2952        789
## 94    125393    109970     32242                88548      11268
## 72      2174      1819       620                 1528        182
## 90      1441      1264       354                 1011         36
## 53       559       584         0                  391          0
## 21    102087     91485     18726                70932       6884
## 160     8650      7662      2064                 5949        510
## 143     6594      5798      1246                 4522        314
## 45     13150     11510      2665                 9005        505
## 98     45326     38815     10948                30932       3305
## 37    104117     96567     25325                70740      11452
## 35    180903    151191     40818               122817       8497
## 26     43041     38302     10080                29196       3270
## 100    24639     21584      5153                16642       1067
## 48      3854      3465      1176                 2593        385
## 130     8691      7264      2202                 5816        547
## 10     61928     55450     12695                41413       3895
## 65      8884      7589      2031                 5888        178
## 23      8587      7530      1873                 5681        824
## 34       604       524       126                  396         49
## 31      2983      2384       930                 1951        308
## 60     19660     17563      4890                12823       2092
## 102    16181     13616      4543                10548       1743
## 5      25694     23170      5180                16697       1672
## 96     61022     51411     15902                39524       4535
## 93    179633    147335     49889               116251      14602
## 154    13076     11734      2214                 8457        496
## 57     21190     18681      5563                13583       2271
## 51      2125      1992       462                 1358         74
## 164    32551     27569      7001                20748       1360
## 109     9821      8032      3173                 6234        749
## 131     7444      5843      2834                 4714        757
## 152    17112     14479      5353                10824        917
## 110     3431      2659      1309                 2161         78
## 127    36728     32160      7494                23106       2393
## 97     46138     37850     13133                28966       2727
## 40      1778      1392       579                 1115        137
## 95     83483     67448     24387                52243       8947
## 112      613       488       185                  383          0
## 78    133454    117709     43711                83236      15022
## 113   118241     98408     29558                73531       7195
## 74     48535     39509     15066                29910       2769
## 125    44679     35769     13078                27521       4410
## 32      2799      2257       689                 1723        163
## 119    13115     11259      2273                 8073        216
## 170     2101      1724       648                 1293        368
## 105    14779     11981      4690                 9085       2006
## 79     14057     11367      5651                 8628       1799
## 151    45038     34941     13481                27588       3329
## 1       1976      1849       270                 1207         37
## 30      4547      4163      1306                 2776        670
## 156     8294      6455      2405                 5061        326
## 124    92721     73475     29639                56561       8608
## 140    54844     43401     19187                33438       4657
## 133    15116     12520      3782                 9193        833
## 2        640       556       170                  388         85
## 144     5362      4764      1227                 3247        266
## 68      2463      1787       847                 1487         87
## 85      8296      6966      2913                 5008        677
## 108     9087      8027      3078                 5482        463
## 71      2343      1644      1095                 1409        286
## 13     10047      9017      2694                 5986       1019
## 14      3307      2751       878                 1967         78
## 142     9602      7700      3396                 5679       1108
## 107    11797     10722      2613                 6954        842
## 128    26033     21419      7239                15266       1379
## 111     3007      2473       891                 1763        322
## 59     34158     29223     10206                20026       4366
## 122     7767      6076      2568                 4542        483
## 88     10076      7514      4145                 5868        893
## 42     58118     46399     18079                33738       2884
## 138   149339    123177     37965                86540       7297
## 55      2741      2470       711                 1584        223
## 150    46624     36747     15872                26906       3355
## 158    24202     18079      8767                13944       1617
## 168     6259      5043      2190                 3602        304
## 126    37861     30020     12346                21735       2409
## 147    23794     19420      7230                13651       1920
## 169     2125      1848       572                 1211        148
## 73      1146       768       437                  653         42
## 44     25302     19428      8721                14389       1282
## 148    17579     13262      6140                 9965       1128
## 145   307933    233205    115172               174438      28169
## 139   103078     77428     38515                57978       5593
## 69      2727      2183       907                 1530        215
## 114   105646     84681     40657                59218      11176
## 15      3608      2999       811                 2004         23
## 16      6170      5455      1983                 3413        589
## 172      742       593       237                  410         87
## 136    30007     23018      9209                16537       1206
## 22      3149      2558      1121                 1735        338
## 123   182295    144512     72371               100336      13874
## 87      9762      7851      3595                 5370        757
## 61     16620     12537      5346                 9131        977
## 137   149180    114386     57825                81180      14345
## 135    40157     31086     16659                21816       4267
## 8       1526      1085       553                  827         33
## 82     25678     20643      9948                13785       2249
## 149    59679     42764     23656                31877       5486
## 62     11581      9441      4590                 6183       1067
## 159    13908     10451      5673                 7413       1368
## 99     24629     18755      9541                13109       1668
## 157     5052      3565      2225                 2661        372
## 134    24406     18166     11088                12809       2183
## 3        648       558       133                  340         16
## 80      9685      7453      3379                 5080        693
## 115    38315     29340     14569                20056       3132
## 92     20859     16987      7071                10916       1779
## 129    11165      8462      4831                 5821       1302
## 167    15053     10121      6612                 7832       1340
## 101    14643     10732      6541                 7588       1088
## 132     7585      5603      2741                 3912        437
## 118    14512     10099      6377                 7460       1833
## 47      4247      3190      1840                 2151        401
## 155     7653      5201      3221                 3838        419
## 103    13217      9601      6648                 6625        975
## 117    17700     14002      5168                 8871       1012
## 141    31433     22457     12818                15740       3718
## 49      1144       657       532                  565        107
## 153    12870      8447      6253                 6322       1465
## 91      1080       828       433                  529         33
## 163    29763     19975     13862                14460       1487
## 24      2449      1658      1040                 1151         70
## 52      9168      5643      4107                 4290        407
## 116    18824     14354      7978                 8801       1718
## 166    36165     25147     15994                16891       3040
## 121     7052      5029      3891                 3236        529
## 70      2787      2103       839                 1274        138
## 165     7052      5197      3685                 3214        846
## 146    47662     29010     24943                21425       3918
## 162    29633     20147     14515                13232       3395
## 33      2914      2049      1067                 1200        286
##     Unemployment_rate Median P25th  P75th College_jobs Non_college_jobs
## 50        0.056994819  44700 23000  50000          459              996
## 4         0.050125313  70000 43000  80000          529              102
## 20        0.011689692  54000 50000  54000          402              528
## 67        0.056357078  40000 27000  52000         1861             2121
## 7         0.095652174  62000 53000  72000         1768              314
## 75        0.029479503  38400 22500  45000          221             1659
## 25        0.058239614  51000 38000  60000         6342             5741
## 6         0.177226407  65000 50000 102000         1142              657
## 66        0.052538520  40000 30400  56000         2446             3896
## 12        0.065162085  60000 42000  70000         8184             2425
## 28        0.047858703  50000 40000  60000         1466             3629
## 81        0.099723375  37500 25000  50000         2354             3244
## 27        0.060023041  50000 36000  60000         3275             5351
## 54        0.113982590  41300 20000  46000         2024             1033
## 106       0.072724524  35000 22000  52000         4575             6147
## 46        0.060741445  45000 32500  58000         4390             4102
## 56        0.107579462  41000 41000  43000          509              221
## 18        0.059824231  56000 36000  69000        26898            11734
## 36        0.060686356  47000 35000  64000        24243            48447
## 41        0.069749014  45000 34000  56000        11417            39323
## 86        0.059569649  36000 28000  45000         2406             9629
## 43        0.093460326  45000 30000  60000        13344            11783
## 64        0.050030836  40000 25000  50000         1925             6221
## 29        0.074392523  50000 39000  65000         3445             2426
## 38        0.096448381  46000 33000  58000         1578             4612
## 83        0.000000000  37000 26000  40000          677              184
## 39        0.028308097  46000 35000  65000         1394             2454
## 58        0.072861468  40000 30000  55000        29334           100831
## 11        0.065409275  60000 45000  75000        23694             5721
## 17        0.042875544  57000 37900  67000         8306             3235
## 161       0.059766764  29000 23000  42100          483              626
## 171       0.053620646  23400 19200  26000         2403             1245
## 76        0.072218341  38000 29000  50000        36720           148395
## 19        0.061930783  54000 38000  65000         1665              649
## 63        0.071982974  40000 30000  51000         2236             8937
## 120       0.000000000  34000 29000  35000          346              206
## 9         0.057342278  60000 48000  70000        52844            16384
## 104       0.089626262  35000 27000  42000         2589             8592
## 77        0.061215064  38000 30000  50000        25320            93889
## 84        0.151849807  36400 27000  49000         2593             2941
## 89        0.159490600  36000 23000  60000          919             2313
## 94        0.082452199  35000 26000  45000        24348            88858
## 72        0.077249576  40000 27000  54000          535              893
## 90        0.024373731  36000 21000  41000          784              591
## 53        0.000000000  42000 30000  78000          452               67
## 21        0.063172771  53000 39000  70000        68622            25667
## 160       0.055676856  29000 20000  36000          563             7384
## 143       0.045454545  32000 22900  40000         2089             3545
## 45        0.036982790  45000 36000  50000         5546             7176
## 98        0.067960766  35000 27000  47000         9659            23059
## 37        0.099092317  47000 35000  65000        25582            37057
## 35        0.044862724  48000 39000  58000       151643            26146
## 26        0.070609574  50000 40000  60000        28526             9356
## 100       0.041507819  35000 32000  42000        20185             3797
## 48        0.090823307  45000 34000  63000         2437              803
## 130       0.059211951  33000 30000  45000         5284             2438
## 10        0.059173845  60000 45000  72000        45829            10874
## 65        0.019642463  40000 30000  50000         2418             4717
## 23        0.087557114  52000 35000  60000         5126             2686
## 34        0.075038285  50000 42800  57000          501               50
## 31        0.093588575  50000 42000  56000         2028              830
## 60        0.096175064  40000 30000  50000         3383             9482
## 102       0.097243919  35000 25000  45000         3373            10605
## 5         0.061097712  65000 50000  75000        18314             4440
## 96        0.069176442  35000 26000  42900        23279            26672
## 93        0.075176976  35000 27000  45000        40763            97964
## 154       0.036545830  30000 24000  37000        10766             1949
## 57        0.096798943  40100 31200  53000         6774             9570
## 51        0.033651660  44000 30000  50000          482              844
## 164       0.040104981  28000 21000  35000        23515             7705
## 109       0.070860927  35000 25000  44000         5176             3903
## 131       0.092305816  33000 24000  40000         2630             3906
## 152       0.050862499  30000 22000  40000         5443             9571
## 110       0.022228555  35000 28000  50000         1808             1317
## 127       0.061169193  33000 25000  42000         2325            23341
## 97        0.055806815  35000 24000  50000        17923            22039
## 40        0.071540470  46000 38000  53000          162             1475
## 95        0.096797577  35000 25000  45000        37389            38119
## 112       0.000000000  35000 18500  44000          355              144
## 78        0.101174601  38000 28000  50000        36854            66947
## 113       0.057359929  34000 26000  41000        82007            31112
## 74        0.053972400  39000 30000  49900        30382            14718
## 125       0.089836827  33000 25000  45000        12855            25297
## 32        0.055030385  50000 43000  60000         1017             1269
## 119       0.016202835  34000 30000  40000        10699             1977
## 170       0.149048198  25000 25000  40000          986              870
## 105       0.119511469  35000 25000  45000         4545             8794
## 79        0.113458628  38000 30000  50000         5350             6830
## 151       0.068827920  30000 25000  35000        27449            14416
## 1         0.018380527 110000 95000 125000         1534              364
## 30        0.128426299  50000 35000  70000         1550             1871
## 156       0.037819026  30000 24000  35000         2878             4595
## 124       0.084951001  33000 25000  44000        29051            48899
## 140       0.078267592  32000 25000  42000        18565            28558
## 133       0.052228980  32500 25000  38000        10304             3967
## 2         0.117241379  75000 55000  90000          350              257
## 144       0.047263682  32000 28000  39000         4214             1106
## 68        0.034117647  40000 34000  45000         1675              678
## 85        0.075448568  36200 28000  47000         4858             2792
## 108       0.048481675  35000 30000  44000         5605             2301
## 71        0.108786611  40000 32000  53000          559             1224
## 13        0.092083860  60000 36000  70000         6439             2471
## 14        0.023042836  60000 39000  65000         2626              391
## 142       0.103454715  32000 27000  50000         3602             4778
## 107       0.066619195  35000 25000  42000         4333             5808
## 128       0.050306435  33000 24000  40000        17985             6824
## 111       0.096725743  35000 28600  48000         1096             1692
## 59        0.113331949  40000 31000  50000        16178            13724
## 122       0.058545455  33500 23000  48000         4253             2722
## 88        0.081411250  36000 23000  42000         5652             3835
## 42        0.047277138  45000 33000  60000        34800            14829
## 138       0.046585715  32000 23400  38000       108085            36972
## 55        0.075236167  41000 20000  60000         1369              921
## 150       0.067128194  30000 22900  40000        20985            20133
## 158       0.062628297  29000 22000  38000         9927            12037
## 168       0.046320280  26000 20000  39000         2771             2947
## 126       0.059821207  33000 24000  41000        22215            14616
## 147       0.074667496  31000 24000  40000        12777             9328
## 169       0.065112187  25000 24000  34000         1488              615
## 73        0.035353535  40000 30000  55000          530              465
## 44        0.048224496  45000 30000  68000        18674             4576
## 148       0.060298284  31000 23000  40000         5139             9738
## 145       0.083810867  31500 24000  41000       125148           141860
## 139       0.051467273  32000 24000  43000        27581            63946
## 69        0.073079538  40000 30000  54000          744             1654
## 114       0.095666912  34000 25000  47000        35336            54569
## 15        0.006334343  58000 25000  74000         2439              947
## 16        0.087143069  57100 40000  76000         3603             1595
## 172       0.104945718  22000 20000  22000          288              338
## 136       0.038637747  32100 25000  40000        20821             8260
## 22        0.096931460  53000 32000  70000         1183             1274
## 123       0.070724732  33400 24000  45000        88232            81109
## 87        0.071965016  36000 29200  46000         2002             6454
## 61        0.055520827  40000 20000  90000        11573             4493
## 137       0.087723590  32000 23000  41000        57690            71827
## 135       0.096051684  32200 23000  47100        14444            20313
## 8         0.021167415  62000 31500 109000          972              500
## 82        0.080531385  37400 29000  50000        15654             8394
## 149       0.084186296  30500 21000  41000        20792            32725
## 62        0.084361164  40000 29000  47000         7225             3145
## 159       0.089552239  29000 19200  38300         3948             8707
## 99        0.063429289  35000 24500  44000         8465            11818
## 157       0.068584071  30000 20000  49000         1168             3354
## 134       0.082101621  32400 25000  45000         9364            12889
## 3         0.024096386  73000 50000 105000          456              176
## 80        0.066775872  38000 29600  50000         5577             3174
## 115       0.075566386  34000 25000  45000        15051            18193
## 92        0.078584681  35600 25000  40200         8149            10076
## 129       0.104435710  33000 25000  40000         4122             5695
## 167       0.081742207  27000 20000  35000         4855             8100
## 101       0.069162800  35000 20000  50000         6587             6894
## 132       0.054475193  33000 23000  42000         2856             4159
## 118       0.112144387  34000 21000  45000         5225             7385
## 47        0.086273666  45000 26700  60000         2298             1200
## 155       0.051907830  30000 20800  40000         2960             3948
## 103       0.068700676  35000 26000  45000         6535             5473
## 117       0.054082941  34000 23050  42000        10928             5561
## 141       0.105772240  32000 22000  42000         7368            20721
## 49        0.085531575  45000 40000  45000          603              478
## 153       0.102197419  30000 22000  40000         3849             7635
## 91        0.029649596  36000 34000  45000          434              593
## 163       0.047584000  28000 20000  40000        19957             9404
## 24        0.027788805  52000 35000  62000         1911              305
## 52        0.042506527  42000 30000  65000         2091             6948
## 116       0.083633531  34000 24000  45000         4956            10343
## 166       0.077541130  27000 19200  35000         6994            25313
## 121       0.069779712  33500 23000  40000         3051             3539
## 70        0.047179487  40000 30000  42000          801             1591
## 165       0.107115726  27500 22900  38000         2326             3703
## 146       0.075959674  31000 22300  42000        13752            28786
## 162       0.102791571  28000 20000  38000         9805            16693
## 33        0.089375000  50000 25000  66000          693             1714
##     Low_wage_jobs      calc
## 50            186 0.9737485
## 4               0 0.9129288
## 20            144 0.8688172
## 67            406 0.8616818
## 7             259 0.8523352
## 75             81 0.8315140
## 25            708 0.7930908
## 6             244 0.7802908
## 66            386 0.7764596
## 12            372 0.7716618
## 28            285 0.7703201
## 81            308 0.7583346
## 27            703 0.7545655
## 54            263 0.7531471
## 106           557 0.7475950
## 46            608 0.7466856
## 56              0 0.7465753
## 18           3192 0.7464779
## 36           9910 0.7453533
## 41          10886 0.7441022
## 86           1906 0.7440270
## 43           1672 0.7424716
## 64           1362 0.7378885
## 29            365 0.7372106
## 38           1284 0.7330035
## 83             56 0.7326733
## 39            480 0.7321590
## 58          27320 0.7271891
## 11            980 0.7266658
## 17            640 0.7258395
## 161            31 0.7255814
## 171           308 0.7249140
## 76          32395 0.7236510
## 19            137 0.7176699
## 63           1758 0.7174558
## 120           111 0.7169275
## 9            3253 0.7147772
## 104          1391 0.7122381
## 77          27968 0.7113305
## 84            352 0.7111003
## 89            496 0.7099567
## 94          18404 0.7061638
## 72             94 0.7028519
## 90            221 0.7015961
## 53             25 0.6994633
## 21           5144 0.6948191
## 160          3163 0.6877457
## 143          1231 0.6857749
## 45           1002 0.6847909
## 98           7214 0.6824339
## 37          10653 0.6794280
## 35           6193 0.6789108
## 26           2899 0.6783300
## 100          1179 0.6754333
## 48            357 0.6728075
## 130           657 0.6691980
## 10           3170 0.6687282
## 65            839 0.6627645
## 23            696 0.6615815
## 34             49 0.6556291
## 31            260 0.6540396
## 60           3046 0.6522380
## 102          1895 0.6518757
## 5             972 0.6498404
## 96           8512 0.6477008
## 93          27440 0.6471584
## 154           722 0.6467574
## 57           2499 0.6410099
## 51            245 0.6390588
## 164          2868 0.6373998
## 109          1061 0.6347622
## 131          1470 0.6332617
## 152          2125 0.6325386
## 110           237 0.6298455
## 127          9063 0.6291113
## 97           5751 0.6278122
## 40            124 0.6271091
## 95          14839 0.6257921
## 112             0 0.6247961
## 78          19803 0.6237055
## 113         11443 0.6218740
## 74           4288 0.6162563
## 125          6429 0.6159717
## 32            142 0.6155770
## 119           786 0.6155547
## 170           622 0.6154212
## 105          2495 0.6147236
## 79           1905 0.6137867
## 151          4344 0.6125494
## 1             193 0.6108300
## 30            340 0.6105124
## 156           724 0.6102001
## 124         13748 0.6100128
## 140          9030 0.6096929
## 133          1385 0.6081635
## 2              50 0.6062500
## 144           591 0.6055576
## 68            201 0.6037353
## 85            959 0.6036644
## 108           902 0.6032794
## 71            272 0.6013658
## 13            789 0.5957997
## 14             81 0.5947989
## 142          1634 0.5914393
## 107          1405 0.5894719
## 128          2819 0.5864096
## 111           327 0.5862986
## 59           4221 0.5862755
## 122           459 0.5847818
## 88           1422 0.5823740
## 42           4569 0.5805086
## 138         11502 0.5794869
## 55            135 0.5778913
## 150          5248 0.5770848
## 158          3304 0.5761507
## 168           743 0.5754913
## 126          4468 0.5740736
## 147          2042 0.5737161
## 169            82 0.5698824
## 73            269 0.5698080
## 44           1823 0.5686902
## 148          3426 0.5668696
## 145         48207 0.5664804
## 139         16838 0.5624673
## 69            573 0.5610561
## 114         16839 0.5605323
## 15            263 0.5554324
## 16            524 0.5531605
## 172           192 0.5525606
## 136          2767 0.5511047
## 22            485 0.5509686
## 123         28339 0.5504046
## 87           1336 0.5500922
## 61           1121 0.5493983
## 137         26503 0.5441748
## 135          8051 0.5432677
## 8             220 0.5419397
## 82           3012 0.5368409
## 149         11880 0.5341410
## 62           1168 0.5338917
## 159          3586 0.5330026
## 99           3677 0.5322587
## 157          1141 0.5267221
## 134          3816 0.5248300
## 3               0 0.5246914
## 80           1246 0.5245225
## 115          5267 0.5234503
## 92           3175 0.5233233
## 129          2085 0.5213614
## 167          3466 0.5202950
## 101          2237 0.5181998
## 132           976 0.5157548
## 118          1854 0.5140573
## 47            343 0.5064752
## 155          1650 0.5015027
## 103          2449 0.5012484
## 117          1806 0.5011864
## 141          5862 0.5007476
## 49             93 0.4938811
## 153          2840 0.4912199
## 91             37 0.4898148
## 163          5125 0.4858381
## 24             70 0.4699878
## 52           1270 0.4679319
## 116          3168 0.4675414
## 166         11068 0.4670538
## 121          1159 0.4588769
## 70            302 0.4571224
## 165          1115 0.4557572
## 146          9286 0.4495195
## 162          6866 0.4465292
## 33            755 0.4118051
#Ordered in ascending order

Recent_Grads3[order(Recent_Grads3$calc),]
##     Rank Major_code
## 33    33       6099
## 162  163       5502
## 146  147       6002
## 165  166       2603
## 70    70       6403
## 121  122       6106
## 166  167       6001
## 116  117       4001
## 52    52       6104
## 24    24       2413
## 163  164       6102
## 91    92       5206
## 153  154       6003
## 49    49       3607
## 141  142       6005
## 117  118       2311
## 103  104       4002
## 155  156       5299
## 47    47       3702
## 118  119       6110
## 132  133       3604
## 101  102       3608
## 167  168       3302
## 129  130       2601
## 92    93       1301
## 115  116       2602
## 80    81       3606
## 3      3       2415
## 134  135       6100
## 157  158       3402
## 99   100       1501
## 159  160       6007
## 62    62       3603
## 149  150       6000
## 82    83       3601
## 8      8       5001
## 135  136       4801
## 137  138       3301
## 61    61       6108
## 87    88       3202
## 123  124       3600
## 22    22       1104
## 136  137       2314
## 172  173       3501
## 16    16       2402
## 15    15       2409
## 114  115       6402
## 69    69       5599
## 139  140       4101
## 145  146       5200
## 148  149       6006
## 44    44       5007
## 73    73       5000
## 169  170       5201
## 147  148       2306
## 126  127       6109
## 168  169       3609
## 158  159       4901
## 150  151       2901
## 55    55       4006
## 138  139       2304
## 42    42       3700
## 88    89       6199
## 122  123       3699
## 59    59       1401
## 111  112       1302
## 128  129       2313
## 107  108       1303
## 142  143       5500
## 14    14       5008
## 13    13       2404
## 71    71       5205
## 108  109       3611
## 85    86       5004
## 68    68       3605
## 144  145       2308
## 2      2       2416
## 133  134       2309
## 140  141       3401
## 124  125       5507
## 156  157       5403
## 30    30       5402
## 1      1       2419
## 151  152       5404
## 79    80       5504
## 105  106       2001
## 170  171       5202
## 119  120       2305
## 32    32       2500
## 125  126       1903
## 74    75       5003
## 113  114       2300
## 78    79       5506
## 112  113       1106
## 95    96       6004
## 40    40       5102
## 97    98       5098
## 127  128       6211
## 110  111       5002
## 152  153       1103
## 131  132       4007
## 109  110       4000
## 164  165       2307
## 51    51       2501
## 57    57       5505
## 154  155       2312
## 93    94       1901
## 96    97       1902
## 5      5       2405
## 102  103       5503
## 60    60       6210
## 31    31       2410
## 34    34       2411
## 23    23       2502
## 65    65       1100
## 10    10       2408
## 130  131       2399
## 48    48       3701
## 100  101       2310
## 26    26       2406
## 35    35       6107
## 37    37       5501
## 98    99       1904
## 45    45       6105
## 143  144       1105
## 160  161       2201
## 21    21       2102
## 53    53       4005
## 90    91       5005
## 72    72       1102
## 94    95       5301
## 89    90       5401
## 84    85       2107
## 77    78       6206
## 104  105       6103
## 9      9       2414
## 120  121       2301
## 63    63       6299
## 19    19       2403
## 76    77       6203
## 171  172       5203
## 161  162       1199
## 17    17       2412
## 11    11       2407
## 58    58       6200
## 39    39       2503
## 83    84       3602
## 38    38       6205
## 29    29       2499
## 64    64       1101
## 43    43       2100
## 86    87       6209
## 41    41       6201
## 36    36       6207
## 18    18       2400
## 56    56       2303
## 46    46       2105
## 106  107       5901
## 54    54       2101
## 27    27       5601
## 81    82       2106
## 28    28       6204
## 12    12       2401
## 66    66       2599
## 6      6       2418
## 25    25       6212
## 75    76       5701
## 7      7       6202
## 67    67       2504
## 20    20       3201
## 4      4       2417
## 50    50       5006
##                                                                 Major  Total
## 33                                            MISCELLANEOUS FINE ARTS   3340
## 162                                       ANTHROPOLOGY AND ARCHEOLOGY  38844
## 146                                                             MUSIC  60633
## 165                                           OTHER FOREIGN LANGUAGES  11204
## 70                                              UNITED STATES HISTORY   3079
## 121                           HEALTH AND MEDICAL PREPARATORY PROGRAMS  12740
## 166                                            DRAMA AND THEATER ARTS  43249
## 116                           INTERCULTURAL AND INTERNATIONAL STUDIES  24650
## 52                                         MEDICAL ASSISTING SERVICES  11123
## 24                        MATERIALS ENGINEERING AND MATERIALS SCIENCE   2993
## 163                     COMMUNICATION DISORDERS SCIENCES AND SERVICES  38279
## 91                                                  SOCIAL PSYCHOLOGY   1386
## 153                                        VISUAL AND PERFORMING ARTS  16250
## 49                                                       PHARMACOLOGY   1762
## 141                                  FILM VIDEO AND PHOTOGRAPHIC ARTS  38761
## 117                       SOCIAL SCIENCE OR HISTORY TEACHER EDUCATION  20198
## 103                                                NUTRITION SCIENCES  18909
## 155                                          MISCELLANEOUS PSYCHOLOGY   9628
## 47                                    STATISTICS AND DECISION SCIENCE   6251
## 118                                       COMMUNITY AND PUBLIC HEALTH  19735
## 132                                                           ECOLOGY   9154
## 101                                                        PHYSIOLOGY  22060
## 167                                          COMPOSITION AND RHETORIC  18953
## 129               LINGUISTICS AND COMPARATIVE LANGUAGE AND LITERATURE  16601
## 92                                              ENVIRONMENTAL SCIENCE  25965
## 115     FRENCH GERMAN LATIN AND OTHER COMMON FOREIGN LANGUAGE STUDIES  48246
## 80                                                       MICROBIOLOGY  15232
## 3                                           METALLURGICAL ENGINEERING    856
## 134                               GENERAL MEDICAL AND HEALTH SERVICES  33599
## 157                                                        HUMANITIES   6652
## 99                               AREA ETHNIC AND CIVILIZATION STUDIES  31195
## 159                                                       STUDIO ARTS  16977
## 62                                                  MOLECULAR BIOLOGY  18300
## 149                                                         FINE ARTS  74440
## 82                                               BIOCHEMICAL SCIENCES  39107
## 8                                          ASTRONOMY AND ASTROPHYSICS   1792
## 135                                  PHILOSOPHY AND RELIGIOUS STUDIES  54814
## 137                                   ENGLISH LANGUAGE AND LITERATURE 194673
## 61                PHARMACY PHARMACEUTICAL SCIENCES AND ADMINISTRATION  23551
## 87                                          PRE-LAW AND LEGAL STUDIES  13528
## 123                                                           BIOLOGY 280709
## 22                                                       FOOD SCIENCE     NA
## 136                                           ART AND MUSIC EDUCATION  34181
## 172                                                   LIBRARY SCIENCE   1098
## 16                                             BIOLOGICAL ENGINEERING   8925
## 15                          ENGINEERING MECHANICS PHYSICS AND SCIENCE   4321
## 114                                                           HISTORY 141951
## 69                                      MISCELLANEOUS SOCIAL SCIENCES   3283
## 139                     PHYSICAL FITNESS PARKS RECREATION AND LEISURE 125074
## 145                                                        PSYCHOLOGY 393735
## 148                                         ART HISTORY AND CRITICISM  21030
## 44                                                            PHYSICS  32142
## 73                                                  PHYSICAL SCIENCES   1436
## 169                                            EDUCATIONAL PSYCHOLOGY   2854
## 147                            PHYSICAL AND HEALTH EDUCATION TEACHING  28213
## 126                                     TREATMENT THERAPY PROFESSIONS  48491
## 168                                                           ZOOLOGY   8409
## 158                                  THEOLOGY AND RELIGIOUS VOCATIONS  30207
## 150                                      FAMILY AND CONSUMER SCIENCES  58001
## 55                                COGNITIVE SCIENCE AND BIOPSYCHOLOGY   3831
## 138                                              ELEMENTARY EDUCATION 170862
## 42                                                        MATHEMATICS  72397
## 88                           MISCELLANEOUS HEALTH MEDICAL PROFESSIONS  13386
## 122                                             MISCELLANEOUS BIOLOGY  10706
## 59                                                       ARCHITECTURE  46420
## 111                                                          FORESTRY   3607
## 128                                      LANGUAGE AND DRAMA EDUCATION  30471
## 107                                      NATURAL RESOURCES MANAGEMENT  13773
## 142                                           GENERAL SOCIAL SCIENCES  12920
## 14                                                  MATERIALS SCIENCE   4279
## 13                                             BIOMEDICAL ENGINEERING  14955
## 71                           INDUSTRIAL AND ORGANIZATIONAL PSYCHOLOGY   3014
## 108                                                      NEUROSCIENCE  13663
## 85                                          GEOLOGY AND EARTH SCIENCE  10972
## 68                                                           GENETICS   3635
## 144                            SCIENCE AND COMPUTER TEACHER EDUCATION   6483
## 2                                      MINING AND MINERAL ENGINEERING    756
## 133                                       SECONDARY TEACHER EDUCATION  17125
## 140                                                      LIBERAL ARTS  71369
## 124                                                         SOCIOLOGY 115433
## 156                         HUMAN SERVICES AND COMMUNITY ORGANIZATION   9374
## 30                                                      PUBLIC POLICY   5978
## 1                                               PETROLEUM ENGINEERING   2339
## 151                                                       SOCIAL WORK  53552
## 79                                                          GEOGRAPHY  18480
## 105                                        COMMUNICATION TECHNOLOGIES  18035
## 170                                               CLINICAL PSYCHOLOGY   2838
## 119                                     MATHEMATICS TEACHER EDUCATION  14237
## 32                                           ENGINEERING TECHNOLOGIES   3600
## 125                                                        MASS MEDIA  52824
## 74                                                          CHEMISTRY  66530
## 113                                                 GENERAL EDUCATION 143718
## 78                                   POLITICAL SCIENCE AND GOVERNMENT 182621
## 112                                                      SOIL SCIENCE    685
## 95                                  COMMERCIAL ART AND GRAPHIC DESIGN 103480
## 40         NUCLEAR, INDUSTRIAL RADIOLOGY, AND BIOLOGICAL TECHNOLOGIES   2116
## 97                              MULTI-DISCIPLINARY OR GENERAL SCIENCE  62052
## 127                                            HOSPITALITY MANAGEMENT  43647
## 110                              ATMOSPHERIC SCIENCES AND METEOROLOGY   4043
## 152                                                   ANIMAL SCIENCES  21573
## 131                                 INTERDISCIPLINARY SOCIAL SCIENCES   9916
## 109                                   MULTI/INTERDISCIPLINARY STUDIES  12296
## 164                                         EARLY CHILDHOOD EDUCATION  37589
## 51                              ENGINEERING AND INDUSTRIAL MANAGEMENT   2906
## 57                                            INTERNATIONAL RELATIONS  28187
## 154                                TEACHER EDUCATION: MULTIPLE LEVELS  14443
## 93                                                     COMMUNICATIONS 213996
## 96                                                         JOURNALISM  72619
## 5                                                CHEMICAL ENGINEERING  32260
## 102                                                       CRIMINOLOGY  19879
## 60                                             INTERNATIONAL BUSINESS  25894
## 31                                          ENVIRONMENTAL ENGINEERING   4047
## 34                             GEOLOGICAL AND GEOPHYSICAL ENGINEERING    720
## 23                                  ELECTRICAL ENGINEERING TECHNOLOGY  11565
## 65                                                GENERAL AGRICULTURE  10399
## 10                                             ELECTRICAL ENGINEERING  81527
## 130                                           MISCELLANEOUS EDUCATION  10150
## 48                                                APPLIED MATHEMATICS   4939
## 100                                           SPECIAL NEEDS EDUCATION  28739
## 26                                                  CIVIL ENGINEERING  53153
## 35                                                            NURSING 209394
## 37                                                          ECONOMICS 139247
## 98                                   ADVERTISING AND PUBLIC RELATIONS  53162
## 45                                   MEDICAL TECHNOLOGIES TECHNICIANS  15914
## 143                                        PLANT SCIENCE AND AGRONOMY   7416
## 160                            COSMETOLOGY SERVICES AND CULINARY ARTS  10510
## 21                                                   COMPUTER SCIENCE 128319
## 53                                   MATHEMATICS AND COMPUTER SCIENCE    609
## 90                                                        GEOSCIENCES   1978
## 72                                             AGRICULTURAL ECONOMICS   2439
## 94                               CRIMINAL JUSTICE AND FIRE PROTECTION 152824
## 89                                              PUBLIC ADMINISTRATION   5629
## 84                         COMPUTER NETWORKING AND TELECOMMUNICATIONS   7613
## 77                                   MARKETING AND MARKETING RESEARCH 205211
## 104                        HEALTH AND MEDICAL ADMINISTRATIVE SERVICES  18109
## 9                                              MECHANICAL ENGINEERING  91227
## 120                        EDUCATIONAL ADMINISTRATION AND SUPERVISION    804
## 63                    MISCELLANEOUS BUSINESS & MEDICAL ADMINISTRATION  17947
## 19                                          ARCHITECTURAL ENGINEERING   2825
## 76                             BUSINESS MANAGEMENT AND ADMINISTRATION 329927
## 171                                             COUNSELING PSYCHOLOGY   4626
## 161                                         MISCELLANEOUS AGRICULTURE   1488
## 17                           INDUSTRIAL AND MANUFACTURING ENGINEERING  18968
## 11                                               COMPUTER ENGINEERING  41542
## 58                                                   GENERAL BUSINESS 234590
## 39                                 INDUSTRIAL PRODUCTION TECHNOLOGIES   4631
## 83                                                             BOTANY   1329
## 38                                                 BUSINESS ECONOMICS  13302
## 29                                          MISCELLANEOUS ENGINEERING   9133
## 64                              AGRICULTURE PRODUCTION AND MANAGEMENT  14240
## 43                                   COMPUTER AND INFORMATION SYSTEMS  36698
## 86                           HUMAN RESOURCES AND PERSONNEL MANAGEMENT  24497
## 41                                                         ACCOUNTING 198633
## 36                                                            FINANCE 174506
## 18                                                GENERAL ENGINEERING  61152
## 56                                          SCHOOL STUDENT COUNSELING    818
## 46                                               INFORMATION SCIENCES  11913
## 106                          TRANSPORTATION SCIENCES AND TECHNOLOGIES  15150
## 54                           COMPUTER PROGRAMMING AND DATA PROCESSING   4168
## 27                                              CONSTRUCTION SERVICES  18498
## 81                    COMPUTER ADMINISTRATION MANAGEMENT AND SECURITY   8066
## 28                                OPERATIONS LOGISTICS AND E-COMMERCE  11732
## 12                                              AEROSPACE ENGINEERING  15058
## 66                             MISCELLANEOUS ENGINEERING TECHNOLOGIES   8804
## 6                                                 NUCLEAR ENGINEERING   2573
## 25                      MANAGEMENT INFORMATION SYSTEMS AND STATISTICS  18713
## 75  ELECTRICAL, MECHANICAL, AND PRECISION TECHNOLOGIES AND PRODUCTION   2435
## 7                                                   ACTUARIAL SCIENCE   3777
## 67                        MECHANICAL ENGINEERING RELATED TECHNOLOGIES   4790
## 20                                                    COURT REPORTING   1148
## 4                           NAVAL ARCHITECTURE AND MARINE ENGINEERING   1258
## 50                                                       OCEANOGRAPHY   2418
##        Men  Women                      Major_category ShareWomen Sample_size
## 33    1970   1370                                Arts 0.41017964          30
## 162  11376  27468           Humanities & Liberal Arts 0.70713624         247
## 146  29909  30724                                Arts 0.50672076         419
## 165   3472   7732           Humanities & Liberal Arts 0.69011068          56
## 70    1756   1323           Humanities & Liberal Arts 0.42968496          22
## 121   5521   7219                              Health 0.56664050          31
## 166  14440  28809                                Arts 0.66611945         357
## 116   8575  16075           Humanities & Liberal Arts 0.65212982         184
## 52     803  10320                              Health 0.92780725          67
## 24    2020    973                         Engineering 0.32509188          22
## 163   1225  37054                              Health 0.96799812          95
## 91     413    973            Psychology & Social Work 0.70202020           8
## 153   4133  12117                                Arts 0.74566154         132
## 49     515   1247              Biology & Life Science 0.70771850           3
## 141  22357  16404                                Arts 0.42320890         331
## 117   9950  10248                           Education 0.50737697         157
## 103   2563  16346                              Health 0.86445608         118
## 155   1936   7692            Psychology & Social Work 0.79891982          60
## 47    2960   3291             Computers & Mathematics 0.52647576          37
## 118   4103  15632                              Health 0.79209526         130
## 132   3878   5276              Biology & Life Science 0.57636006          86
## 101   8422  13638              Biology & Life Science 0.61822303          99
## 167   7022  11931           Humanities & Liberal Arts 0.62950456         151
## 129   4416  12185           Humanities & Liberal Arts 0.73399193          88
## 92   10787  15178              Biology & Life Science 0.58455613         225
## 115  12835  35411           Humanities & Liberal Arts 0.73396758         342
## 80    6383   8849              Biology & Life Science 0.58094800          62
## 3      725    131                         Engineering 0.15303738           3
## 134   7574  26025                              Health 0.77457662         202
## 157   2013   4639           Humanities & Liberal Arts 0.69738424          49
## 99    8739  22456           Humanities & Liberal Arts 0.71985895         249
## 159   4754  12223                                Arts 0.71997408         182
## 62    7426  10874              Biology & Life Science 0.59420765          90
## 149  24786  49654                                Arts 0.66703385         623
## 82   18951  20156              Biology & Life Science 0.51540645         174
## 8      832    960                   Physical Sciences 0.53571429          10
## 135  31967  22847           Humanities & Liberal Arts 0.41680957         375
## 137  58227 136446           Humanities & Liberal Arts 0.70089843        1436
## 61    8697  14854                              Health 0.63071632          38
## 87    4435   9093                 Law & Public Policy 0.67216144          92
## 123 111762 168947              Biology & Life Science 0.60185815        1370
## 22      NA     NA     Agriculture & Natural Resources         NA          36
## 136  10732  23449                           Education 0.68602440         338
## 172    134    964                           Education 0.87795993           2
## 16    6062   2863                         Engineering 0.32078431          55
## 15    3526    795                         Engineering 0.18398519          30
## 114  78253  63698           Humanities & Liberal Arts 0.44873231        1058
## 69    1499   1784                      Social Science 0.54340542          28
## 139  62181  62893 Industrial Arts & Consumer Services 0.50284631        1014
## 145  86648 307087            Psychology & Social Work 0.77993320        2584
## 148   3240  17790           Humanities & Liberal Arts 0.84593438         204
## 44   23080   9062                   Physical Sciences 0.28193641         142
## 73     894    542                   Physical Sciences 0.37743733          10
## 169    522   2332            Psychology & Social Work 0.81709881           7
## 147  15670  12543                           Education 0.44458229         259
## 126  13487  35004                              Health 0.72186591         224
## 168   3050   5359              Biology & Life Science 0.63729338          47
## 158  18616  11591           Humanities & Liberal Arts 0.38371901         310
## 150   5166  52835 Industrial Arts & Consumer Services 0.91093257         518
## 55    1667   2164              Biology & Life Science 0.56486557          25
## 138  13029 157833                           Education 0.92374548        1629
## 42   39956  32441             Computers & Mathematics 0.44809868         541
## 88    1589  11797                              Health 0.88129389          81
## 122   4747   5959              Biology & Life Science 0.55660377          63
## 59   25463  20957                         Engineering 0.45146489         362
## 111   3156    451     Agriculture & Natural Resources 0.12503465          48
## 128   3741  26730                           Education 0.87722753         235
## 107   8617   5156     Agriculture & Natural Resources 0.37435562         152
## 142   5079   7841                      Social Science 0.60688855         113
## 14    2949   1330                         Engineering 0.31082028          22
## 13    8407   6548                         Engineering 0.43784687          79
## 71    1075   1939            Psychology & Social Work 0.64333112          24
## 108   4944   8719              Biology & Life Science 0.63814682          53
## 85    5813   5159                   Physical Sciences 0.47019687          78
## 68    1761   1874              Biology & Life Science 0.51554333          11
## 144   2049   4434                           Education 0.68394262          59
## 2      679     77                         Engineering 0.10185185           7
## 133   6820  10305                           Education 0.60175183         156
## 140  22339  49030           Humanities & Liberal Arts 0.68699295         569
## 124  32510  82923                      Social Science 0.71836477        1024
## 156    885   8489            Psychology & Social Work 0.90558993          89
## 30    2639   3339                 Law & Public Policy 0.55854801          55
## 1     2057    282                         Engineering 0.12056434          36
## 151   5137  48415            Psychology & Social Work 0.90407454         374
## 79   11404   7076                      Social Science 0.38290043         179
## 105  11431   6604             Computers & Mathematics 0.36617688         208
## 170    568   2270            Psychology & Social Work 0.79985906          13
## 119   3872  10365                           Education 0.72803259         123
## 32    2695    905                         Engineering 0.25138889          39
## 125  24704  28120         Communications & Journalism 0.53233379         590
## 74   32923  33607                   Physical Sciences 0.50514054         353
## 113  26893 116825                           Education 0.81287661         919
## 78   93880  88741                      Social Science 0.48592988        1387
## 112    476    209     Agriculture & Natural Resources 0.30510949           4
## 95   32041  71439                                Arts 0.69036529        1186
## 40     528   1588                   Physical Sciences 0.75047259          31
## 97   27015  35037                   Physical Sciences 0.56463933         427
## 127  15204  28443                            Business 0.65165991         546
## 110   2744   1299                   Physical Sciences 0.32129607          32
## 152   5347  16226     Agriculture & Natural Resources 0.75214388         255
## 131   2337   7579                      Social Science 0.76432029          95
## 109   2817   9479                   Interdisciplinary 0.77090111         128
## 164   1167  36422                           Education 0.96895368         342
## 51    2400    506                         Engineering 0.17412251          29
## 57   10345  17842                      Social Science 0.63298684         219
## 154   2734  11709                           Education 0.81070415         142
## 93   70619 143377         Communications & Journalism 0.66999851        2394
## 96   23736  48883         Communications & Journalism 0.67314339         843
## 5    21239  11021                         Engineering 0.34163050         289
## 102  10031   9848                      Social Science 0.49539715         214
## 60   10624  15270                            Business 0.58971190         260
## 31    2662   1385                         Engineering 0.34222881          26
## 34     488    232                         Engineering 0.32222222           5
## 23    8181   3384                         Engineering 0.29260700          97
## 65    6053   4346     Agriculture & Natural Resources 0.41792480         158
## 10   65511  16016                         Engineering 0.19645026         631
## 130   3654   6496                           Education 0.64000000         126
## 48    2794   2145             Computers & Mathematics 0.43429844          45
## 100   2682  26057                           Education 0.90667734         246
## 26   41081  12072                         Engineering 0.22711794         565
## 35   21773 187621                              Health 0.89601899        2554
## 37   89749  49498                      Social Science 0.35546906        1322
## 98   12862  40300         Communications & Journalism 0.75806027         681
## 45    3916  11998                              Health 0.75392736         190
## 143   4897   2519     Agriculture & Natural Resources 0.33967098         110
## 160   4364   6146 Industrial Arts & Consumer Services 0.58477640         117
## 21   99743  28576             Computers & Mathematics 0.22269500        1196
## 53     500    109             Computers & Mathematics 0.17898194           7
## 90     809   1169                   Physical Sciences 0.59100101          18
## 72    1749    690     Agriculture & Natural Resources 0.28290283          44
## 94   80231  72593                 Law & Public Policy 0.47501047        1728
## 89    2947   2682                 Law & Public Policy 0.47646118          46
## 84    5291   2322             Computers & Mathematics 0.30500460          97
## 77   78857 126354                            Business 0.61572723        2684
## 104   4266  13843                              Health 0.76442653         184
## 9    80320  10907                         Engineering 0.11955890        1029
## 120    280    524                           Education 0.65174129           5
## 63   10285   7662                            Business 0.42692372         244
## 19    1835    990                         Engineering 0.35044248          26
## 76  173809 156118                            Business 0.47318952        4212
## 171    931   3695            Psychology & Social Work 0.79874622          21
## 161    404   1084     Agriculture & Natural Resources 0.72849462          24
## 17   12453   6515                         Engineering 0.34347322         183
## 11   33258   8284                         Engineering 0.19941264         399
## 58  132238 102352                            Business 0.43630163        2380
## 39    3477   1154                         Engineering 0.24919024          73
## 83     626    703              Biology & Life Science 0.52896915           9
## 38    7575   5727                            Business 0.43053676         199
## 29    7398   1735                         Engineering 0.18997044         118
## 64    9658   4582     Agriculture & Natural Resources 0.32176966         273
## 43   27392   9306             Computers & Mathematics 0.25358330         425
## 86    6184  18313                            Business 0.74756093         264
## 41   94519 104114                            Business 0.52415258        2042
## 36  115030  59476                            Business 0.34082496        2189
## 18   45683  15469                         Engineering 0.25295984         425
## 56     119    699                           Education 0.85452323           4
## 46    9005   2908             Computers & Mathematics 0.24410308         158
## 106  13257   1893 Industrial Arts & Consumer Services 0.12495049         180
## 54    3046   1122             Computers & Mathematics 0.26919386          43
## 27   16820   1678 Industrial Arts & Consumer Services 0.09071251         295
## 81    6607   1459             Computers & Mathematics 0.18088272         103
## 28    7921   3811                            Business 0.32483805         156
## 12   12953   2105                         Engineering 0.13979280         147
## 66    7043   1761                         Engineering 0.20002272         125
## 6     2200    373                         Engineering 0.14496697          17
## 25   13496   5217                            Business 0.27879015         278
## 75    1869    566 Industrial Arts & Consumer Services 0.23244353          37
## 7     2110   1667                            Business 0.44135557          51
## 67    4419    371                         Engineering 0.07745303          71
## 20     877    271                 Law & Public Policy 0.23606272          14
## 4     1123    135                         Engineering 0.10731320          16
## 50     752   1666                   Physical Sciences 0.68899917          36
##     Employed Full_time Part_time Full_time_year_round Unemployed
## 33      2914      2049      1067                 1200        286
## 162    29633     20147     14515                13232       3395
## 146    47662     29010     24943                21425       3918
## 165     7052      5197      3685                 3214        846
## 70      2787      2103       839                 1274        138
## 121     7052      5029      3891                 3236        529
## 166    36165     25147     15994                16891       3040
## 116    18824     14354      7978                 8801       1718
## 52      9168      5643      4107                 4290        407
## 24      2449      1658      1040                 1151         70
## 163    29763     19975     13862                14460       1487
## 91      1080       828       433                  529         33
## 153    12870      8447      6253                 6322       1465
## 49      1144       657       532                  565        107
## 141    31433     22457     12818                15740       3718
## 117    17700     14002      5168                 8871       1012
## 103    13217      9601      6648                 6625        975
## 155     7653      5201      3221                 3838        419
## 47      4247      3190      1840                 2151        401
## 118    14512     10099      6377                 7460       1833
## 132     7585      5603      2741                 3912        437
## 101    14643     10732      6541                 7588       1088
## 167    15053     10121      6612                 7832       1340
## 129    11165      8462      4831                 5821       1302
## 92     20859     16987      7071                10916       1779
## 115    38315     29340     14569                20056       3132
## 80      9685      7453      3379                 5080        693
## 3        648       558       133                  340         16
## 134    24406     18166     11088                12809       2183
## 157     5052      3565      2225                 2661        372
## 99     24629     18755      9541                13109       1668
## 159    13908     10451      5673                 7413       1368
## 62     11581      9441      4590                 6183       1067
## 149    59679     42764     23656                31877       5486
## 82     25678     20643      9948                13785       2249
## 8       1526      1085       553                  827         33
## 135    40157     31086     16659                21816       4267
## 137   149180    114386     57825                81180      14345
## 61     16620     12537      5346                 9131        977
## 87      9762      7851      3595                 5370        757
## 123   182295    144512     72371               100336      13874
## 22      3149      2558      1121                 1735        338
## 136    30007     23018      9209                16537       1206
## 172      742       593       237                  410         87
## 16      6170      5455      1983                 3413        589
## 15      3608      2999       811                 2004         23
## 114   105646     84681     40657                59218      11176
## 69      2727      2183       907                 1530        215
## 139   103078     77428     38515                57978       5593
## 145   307933    233205    115172               174438      28169
## 148    17579     13262      6140                 9965       1128
## 44     25302     19428      8721                14389       1282
## 73      1146       768       437                  653         42
## 169     2125      1848       572                 1211        148
## 147    23794     19420      7230                13651       1920
## 126    37861     30020     12346                21735       2409
## 168     6259      5043      2190                 3602        304
## 158    24202     18079      8767                13944       1617
## 150    46624     36747     15872                26906       3355
## 55      2741      2470       711                 1584        223
## 138   149339    123177     37965                86540       7297
## 42     58118     46399     18079                33738       2884
## 88     10076      7514      4145                 5868        893
## 122     7767      6076      2568                 4542        483
## 59     34158     29223     10206                20026       4366
## 111     3007      2473       891                 1763        322
## 128    26033     21419      7239                15266       1379
## 107    11797     10722      2613                 6954        842
## 142     9602      7700      3396                 5679       1108
## 14      3307      2751       878                 1967         78
## 13     10047      9017      2694                 5986       1019
## 71      2343      1644      1095                 1409        286
## 108     9087      8027      3078                 5482        463
## 85      8296      6966      2913                 5008        677
## 68      2463      1787       847                 1487         87
## 144     5362      4764      1227                 3247        266
## 2        640       556       170                  388         85
## 133    15116     12520      3782                 9193        833
## 140    54844     43401     19187                33438       4657
## 124    92721     73475     29639                56561       8608
## 156     8294      6455      2405                 5061        326
## 30      4547      4163      1306                 2776        670
## 1       1976      1849       270                 1207         37
## 151    45038     34941     13481                27588       3329
## 79     14057     11367      5651                 8628       1799
## 105    14779     11981      4690                 9085       2006
## 170     2101      1724       648                 1293        368
## 119    13115     11259      2273                 8073        216
## 32      2799      2257       689                 1723        163
## 125    44679     35769     13078                27521       4410
## 74     48535     39509     15066                29910       2769
## 113   118241     98408     29558                73531       7195
## 78    133454    117709     43711                83236      15022
## 112      613       488       185                  383          0
## 95     83483     67448     24387                52243       8947
## 40      1778      1392       579                 1115        137
## 97     46138     37850     13133                28966       2727
## 127    36728     32160      7494                23106       2393
## 110     3431      2659      1309                 2161         78
## 152    17112     14479      5353                10824        917
## 131     7444      5843      2834                 4714        757
## 109     9821      8032      3173                 6234        749
## 164    32551     27569      7001                20748       1360
## 51      2125      1992       462                 1358         74
## 57     21190     18681      5563                13583       2271
## 154    13076     11734      2214                 8457        496
## 93    179633    147335     49889               116251      14602
## 96     61022     51411     15902                39524       4535
## 5      25694     23170      5180                16697       1672
## 102    16181     13616      4543                10548       1743
## 60     19660     17563      4890                12823       2092
## 31      2983      2384       930                 1951        308
## 34       604       524       126                  396         49
## 23      8587      7530      1873                 5681        824
## 65      8884      7589      2031                 5888        178
## 10     61928     55450     12695                41413       3895
## 130     8691      7264      2202                 5816        547
## 48      3854      3465      1176                 2593        385
## 100    24639     21584      5153                16642       1067
## 26     43041     38302     10080                29196       3270
## 35    180903    151191     40818               122817       8497
## 37    104117     96567     25325                70740      11452
## 98     45326     38815     10948                30932       3305
## 45     13150     11510      2665                 9005        505
## 143     6594      5798      1246                 4522        314
## 160     8650      7662      2064                 5949        510
## 21    102087     91485     18726                70932       6884
## 53       559       584         0                  391          0
## 90      1441      1264       354                 1011         36
## 72      2174      1819       620                 1528        182
## 94    125393    109970     32242                88548      11268
## 89      4158      4148       847                 2952        789
## 84      6144      5495      1447                 4369       1100
## 77    178862    156668     35829               127230      11663
## 104    15419     13534      3299                10982       1518
## 9      76442     71298     13101                54639       4650
## 120      703       733         0                  504          0
## 63     14826     13364      3366                10637       1150
## 19      2575      2277       343                 1848        170
## 76    276234    251540     50357               199897      21502
## 171     3777      3154       965                 2738        214
## 161     1290      1098       335                  936         82
## 17     15604     14879      2243                11326        699
## 11     32506     30315      5146                23621       2275
## 58    190183    171385     36241               138299      14946
## 39      4428      3988       597                 3242        129
## 83      1010       946       169                  740          0
## 38     10914     10048      1937                 8000       1165
## 29      7428      6811      1662                 5476        597
## 64     12323     11119      2196                 9093        649
## 43     28459     26348      4332                21130       2934
## 86     20760     18550      3767                15446       1315
## 41    165527    151967     27693               123169      12411
## 36    145696    137921     21463               108595       9413
## 18     44931     41235      7199                33540       2859
## 56       730       595       135                  545         88
## 46      9881      9105      1468                 7378        639
## 106    12266     11688      2633                 9170        962
## 54      3257      3204       482                 2453        419
## 27     16318     15690      1751                12313       1042
## 81      6509      6289      1030                 4936        721
## 28     10027      9639      1183                 7724        504
## 12     11391     11106      2724                 8790        794
## 66      7502      7001      1240                 5825        416
## 6       1857      2038       264                 1449        400
## 25     16413     15141      2420                13017       1015
## 75      2107      2057       287                 1752         64
## 7       2912      2924       296                 2482        308
## 67      4186      4175       247                 3607        250
## 20       930       808       223                  808         11
## 4        758      1069       150                  692         40
## 50      1638      1931       379                 1595         99
##     Unemployment_rate Median P25th  P75th College_jobs Non_college_jobs
## 33        0.089375000  50000 25000  66000          693             1714
## 162       0.102791571  28000 20000  38000         9805            16693
## 146       0.075959674  31000 22300  42000        13752            28786
## 165       0.107115726  27500 22900  38000         2326             3703
## 70        0.047179487  40000 30000  42000          801             1591
## 121       0.069779712  33500 23000  40000         3051             3539
## 166       0.077541130  27000 19200  35000         6994            25313
## 116       0.083633531  34000 24000  45000         4956            10343
## 52        0.042506527  42000 30000  65000         2091             6948
## 24        0.027788805  52000 35000  62000         1911              305
## 163       0.047584000  28000 20000  40000        19957             9404
## 91        0.029649596  36000 34000  45000          434              593
## 153       0.102197419  30000 22000  40000         3849             7635
## 49        0.085531575  45000 40000  45000          603              478
## 141       0.105772240  32000 22000  42000         7368            20721
## 117       0.054082941  34000 23050  42000        10928             5561
## 103       0.068700676  35000 26000  45000         6535             5473
## 155       0.051907830  30000 20800  40000         2960             3948
## 47        0.086273666  45000 26700  60000         2298             1200
## 118       0.112144387  34000 21000  45000         5225             7385
## 132       0.054475193  33000 23000  42000         2856             4159
## 101       0.069162800  35000 20000  50000         6587             6894
## 167       0.081742207  27000 20000  35000         4855             8100
## 129       0.104435710  33000 25000  40000         4122             5695
## 92        0.078584681  35600 25000  40200         8149            10076
## 115       0.075566386  34000 25000  45000        15051            18193
## 80        0.066775872  38000 29600  50000         5577             3174
## 3         0.024096386  73000 50000 105000          456              176
## 134       0.082101621  32400 25000  45000         9364            12889
## 157       0.068584071  30000 20000  49000         1168             3354
## 99        0.063429289  35000 24500  44000         8465            11818
## 159       0.089552239  29000 19200  38300         3948             8707
## 62        0.084361164  40000 29000  47000         7225             3145
## 149       0.084186296  30500 21000  41000        20792            32725
## 82        0.080531385  37400 29000  50000        15654             8394
## 8         0.021167415  62000 31500 109000          972              500
## 135       0.096051684  32200 23000  47100        14444            20313
## 137       0.087723590  32000 23000  41000        57690            71827
## 61        0.055520827  40000 20000  90000        11573             4493
## 87        0.071965016  36000 29200  46000         2002             6454
## 123       0.070724732  33400 24000  45000        88232            81109
## 22        0.096931460  53000 32000  70000         1183             1274
## 136       0.038637747  32100 25000  40000        20821             8260
## 172       0.104945718  22000 20000  22000          288              338
## 16        0.087143069  57100 40000  76000         3603             1595
## 15        0.006334343  58000 25000  74000         2439              947
## 114       0.095666912  34000 25000  47000        35336            54569
## 69        0.073079538  40000 30000  54000          744             1654
## 139       0.051467273  32000 24000  43000        27581            63946
## 145       0.083810867  31500 24000  41000       125148           141860
## 148       0.060298284  31000 23000  40000         5139             9738
## 44        0.048224496  45000 30000  68000        18674             4576
## 73        0.035353535  40000 30000  55000          530              465
## 169       0.065112187  25000 24000  34000         1488              615
## 147       0.074667496  31000 24000  40000        12777             9328
## 126       0.059821207  33000 24000  41000        22215            14616
## 168       0.046320280  26000 20000  39000         2771             2947
## 158       0.062628297  29000 22000  38000         9927            12037
## 150       0.067128194  30000 22900  40000        20985            20133
## 55        0.075236167  41000 20000  60000         1369              921
## 138       0.046585715  32000 23400  38000       108085            36972
## 42        0.047277138  45000 33000  60000        34800            14829
## 88        0.081411250  36000 23000  42000         5652             3835
## 122       0.058545455  33500 23000  48000         4253             2722
## 59        0.113331949  40000 31000  50000        16178            13724
## 111       0.096725743  35000 28600  48000         1096             1692
## 128       0.050306435  33000 24000  40000        17985             6824
## 107       0.066619195  35000 25000  42000         4333             5808
## 142       0.103454715  32000 27000  50000         3602             4778
## 14        0.023042836  60000 39000  65000         2626              391
## 13        0.092083860  60000 36000  70000         6439             2471
## 71        0.108786611  40000 32000  53000          559             1224
## 108       0.048481675  35000 30000  44000         5605             2301
## 85        0.075448568  36200 28000  47000         4858             2792
## 68        0.034117647  40000 34000  45000         1675              678
## 144       0.047263682  32000 28000  39000         4214             1106
## 2         0.117241379  75000 55000  90000          350              257
## 133       0.052228980  32500 25000  38000        10304             3967
## 140       0.078267592  32000 25000  42000        18565            28558
## 124       0.084951001  33000 25000  44000        29051            48899
## 156       0.037819026  30000 24000  35000         2878             4595
## 30        0.128426299  50000 35000  70000         1550             1871
## 1         0.018380527 110000 95000 125000         1534              364
## 151       0.068827920  30000 25000  35000        27449            14416
## 79        0.113458628  38000 30000  50000         5350             6830
## 105       0.119511469  35000 25000  45000         4545             8794
## 170       0.149048198  25000 25000  40000          986              870
## 119       0.016202835  34000 30000  40000        10699             1977
## 32        0.055030385  50000 43000  60000         1017             1269
## 125       0.089836827  33000 25000  45000        12855            25297
## 74        0.053972400  39000 30000  49900        30382            14718
## 113       0.057359929  34000 26000  41000        82007            31112
## 78        0.101174601  38000 28000  50000        36854            66947
## 112       0.000000000  35000 18500  44000          355              144
## 95        0.096797577  35000 25000  45000        37389            38119
## 40        0.071540470  46000 38000  53000          162             1475
## 97        0.055806815  35000 24000  50000        17923            22039
## 127       0.061169193  33000 25000  42000         2325            23341
## 110       0.022228555  35000 28000  50000         1808             1317
## 152       0.050862499  30000 22000  40000         5443             9571
## 131       0.092305816  33000 24000  40000         2630             3906
## 109       0.070860927  35000 25000  44000         5176             3903
## 164       0.040104981  28000 21000  35000        23515             7705
## 51        0.033651660  44000 30000  50000          482              844
## 57        0.096798943  40100 31200  53000         6774             9570
## 154       0.036545830  30000 24000  37000        10766             1949
## 93        0.075176976  35000 27000  45000        40763            97964
## 96        0.069176442  35000 26000  42900        23279            26672
## 5         0.061097712  65000 50000  75000        18314             4440
## 102       0.097243919  35000 25000  45000         3373            10605
## 60        0.096175064  40000 30000  50000         3383             9482
## 31        0.093588575  50000 42000  56000         2028              830
## 34        0.075038285  50000 42800  57000          501               50
## 23        0.087557114  52000 35000  60000         5126             2686
## 65        0.019642463  40000 30000  50000         2418             4717
## 10        0.059173845  60000 45000  72000        45829            10874
## 130       0.059211951  33000 30000  45000         5284             2438
## 48        0.090823307  45000 34000  63000         2437              803
## 100       0.041507819  35000 32000  42000        20185             3797
## 26        0.070609574  50000 40000  60000        28526             9356
## 35        0.044862724  48000 39000  58000       151643            26146
## 37        0.099092317  47000 35000  65000        25582            37057
## 98        0.067960766  35000 27000  47000         9659            23059
## 45        0.036982790  45000 36000  50000         5546             7176
## 143       0.045454545  32000 22900  40000         2089             3545
## 160       0.055676856  29000 20000  36000          563             7384
## 21        0.063172771  53000 39000  70000        68622            25667
## 53        0.000000000  42000 30000  78000          452               67
## 90        0.024373731  36000 21000  41000          784              591
## 72        0.077249576  40000 27000  54000          535              893
## 94        0.082452199  35000 26000  45000        24348            88858
## 89        0.159490600  36000 23000  60000          919             2313
## 84        0.151849807  36400 27000  49000         2593             2941
## 77        0.061215064  38000 30000  50000        25320            93889
## 104       0.089626262  35000 27000  42000         2589             8592
## 9         0.057342278  60000 48000  70000        52844            16384
## 120       0.000000000  34000 29000  35000          346              206
## 63        0.071982974  40000 30000  51000         2236             8937
## 19        0.061930783  54000 38000  65000         1665              649
## 76        0.072218341  38000 29000  50000        36720           148395
## 171       0.053620646  23400 19200  26000         2403             1245
## 161       0.059766764  29000 23000  42100          483              626
## 17        0.042875544  57000 37900  67000         8306             3235
## 11        0.065409275  60000 45000  75000        23694             5721
## 58        0.072861468  40000 30000  55000        29334           100831
## 39        0.028308097  46000 35000  65000         1394             2454
## 83        0.000000000  37000 26000  40000          677              184
## 38        0.096448381  46000 33000  58000         1578             4612
## 29        0.074392523  50000 39000  65000         3445             2426
## 64        0.050030836  40000 25000  50000         1925             6221
## 43        0.093460326  45000 30000  60000        13344            11783
## 86        0.059569649  36000 28000  45000         2406             9629
## 41        0.069749014  45000 34000  56000        11417            39323
## 36        0.060686356  47000 35000  64000        24243            48447
## 18        0.059824231  56000 36000  69000        26898            11734
## 56        0.107579462  41000 41000  43000          509              221
## 46        0.060741445  45000 32500  58000         4390             4102
## 106       0.072724524  35000 22000  52000         4575             6147
## 54        0.113982590  41300 20000  46000         2024             1033
## 27        0.060023041  50000 36000  60000         3275             5351
## 81        0.099723375  37500 25000  50000         2354             3244
## 28        0.047858703  50000 40000  60000         1466             3629
## 12        0.065162085  60000 42000  70000         8184             2425
## 66        0.052538520  40000 30400  56000         2446             3896
## 6         0.177226407  65000 50000 102000         1142              657
## 25        0.058239614  51000 38000  60000         6342             5741
## 75        0.029479503  38400 22500  45000          221             1659
## 7         0.095652174  62000 53000  72000         1768              314
## 67        0.056357078  40000 27000  52000         1861             2121
## 20        0.011689692  54000 50000  54000          402              528
## 4         0.050125313  70000 43000  80000          529              102
## 50        0.056994819  44700 23000  50000          459              996
##     Low_wage_jobs      calc
## 33            755 0.4118051
## 162          6866 0.4465292
## 146          9286 0.4495195
## 165          1115 0.4557572
## 70            302 0.4571224
## 121          1159 0.4588769
## 166         11068 0.4670538
## 116          3168 0.4675414
## 52           1270 0.4679319
## 24             70 0.4699878
## 163          5125 0.4858381
## 91             37 0.4898148
## 153          2840 0.4912199
## 49             93 0.4938811
## 141          5862 0.5007476
## 117          1806 0.5011864
## 103          2449 0.5012484
## 155          1650 0.5015027
## 47            343 0.5064752
## 118          1854 0.5140573
## 132           976 0.5157548
## 101          2237 0.5181998
## 167          3466 0.5202950
## 129          2085 0.5213614
## 92           3175 0.5233233
## 115          5267 0.5234503
## 80           1246 0.5245225
## 3               0 0.5246914
## 134          3816 0.5248300
## 157          1141 0.5267221
## 99           3677 0.5322587
## 159          3586 0.5330026
## 62           1168 0.5338917
## 149         11880 0.5341410
## 82           3012 0.5368409
## 8             220 0.5419397
## 135          8051 0.5432677
## 137         26503 0.5441748
## 61           1121 0.5493983
## 87           1336 0.5500922
## 123         28339 0.5504046
## 22            485 0.5509686
## 136          2767 0.5511047
## 172           192 0.5525606
## 16            524 0.5531605
## 15            263 0.5554324
## 114         16839 0.5605323
## 69            573 0.5610561
## 139         16838 0.5624673
## 145         48207 0.5664804
## 148          3426 0.5668696
## 44           1823 0.5686902
## 73            269 0.5698080
## 169            82 0.5698824
## 147          2042 0.5737161
## 126          4468 0.5740736
## 168           743 0.5754913
## 158          3304 0.5761507
## 150          5248 0.5770848
## 55            135 0.5778913
## 138         11502 0.5794869
## 42           4569 0.5805086
## 88           1422 0.5823740
## 122           459 0.5847818
## 59           4221 0.5862755
## 111           327 0.5862986
## 128          2819 0.5864096
## 107          1405 0.5894719
## 142          1634 0.5914393
## 14             81 0.5947989
## 13            789 0.5957997
## 71            272 0.6013658
## 108           902 0.6032794
## 85            959 0.6036644
## 68            201 0.6037353
## 144           591 0.6055576
## 2              50 0.6062500
## 133          1385 0.6081635
## 140          9030 0.6096929
## 124         13748 0.6100128
## 156           724 0.6102001
## 30            340 0.6105124
## 1             193 0.6108300
## 151          4344 0.6125494
## 79           1905 0.6137867
## 105          2495 0.6147236
## 170           622 0.6154212
## 119           786 0.6155547
## 32            142 0.6155770
## 125          6429 0.6159717
## 74           4288 0.6162563
## 113         11443 0.6218740
## 78          19803 0.6237055
## 112             0 0.6247961
## 95          14839 0.6257921
## 40            124 0.6271091
## 97           5751 0.6278122
## 127          9063 0.6291113
## 110           237 0.6298455
## 152          2125 0.6325386
## 131          1470 0.6332617
## 109          1061 0.6347622
## 164          2868 0.6373998
## 51            245 0.6390588
## 57           2499 0.6410099
## 154           722 0.6467574
## 93          27440 0.6471584
## 96           8512 0.6477008
## 5             972 0.6498404
## 102          1895 0.6518757
## 60           3046 0.6522380
## 31            260 0.6540396
## 34             49 0.6556291
## 23            696 0.6615815
## 65            839 0.6627645
## 10           3170 0.6687282
## 130           657 0.6691980
## 48            357 0.6728075
## 100          1179 0.6754333
## 26           2899 0.6783300
## 35           6193 0.6789108
## 37          10653 0.6794280
## 98           7214 0.6824339
## 45           1002 0.6847909
## 143          1231 0.6857749
## 160          3163 0.6877457
## 21           5144 0.6948191
## 53             25 0.6994633
## 90            221 0.7015961
## 72             94 0.7028519
## 94          18404 0.7061638
## 89            496 0.7099567
## 84            352 0.7111003
## 77          27968 0.7113305
## 104          1391 0.7122381
## 9            3253 0.7147772
## 120           111 0.7169275
## 63           1758 0.7174558
## 19            137 0.7176699
## 76          32395 0.7236510
## 171           308 0.7249140
## 161            31 0.7255814
## 17            640 0.7258395
## 11            980 0.7266658
## 58          27320 0.7271891
## 39            480 0.7321590
## 83             56 0.7326733
## 38           1284 0.7330035
## 29            365 0.7372106
## 64           1362 0.7378885
## 43           1672 0.7424716
## 86           1906 0.7440270
## 41          10886 0.7441022
## 36           9910 0.7453533
## 18           3192 0.7464779
## 56              0 0.7465753
## 46            608 0.7466856
## 106           557 0.7475950
## 54            263 0.7531471
## 27            703 0.7545655
## 81            308 0.7583346
## 28            285 0.7703201
## 12            372 0.7716618
## 66            386 0.7764596
## 6             244 0.7802908
## 25            708 0.7930908
## 75             81 0.8315140
## 7             259 0.8523352
## 67            406 0.8616818
## 20            144 0.8688172
## 4               0 0.9129288
## 50            186 0.9737485

For the second part of the problem, we analyze the share of women in Stem fields in descending and ascending order.

It’s interesting to note that nursing is one of the three STEM fields with the highest share of women, the other two fields confirm that it’s low-paying STEM majors that attract the highest share of women. For example, Communications Disorders Sciences & Services has the highest share of women in STEM fields enrolled but is also one of the lowest paying majors.

Stem_Women <- read.csv(url("https://raw.githubusercontent.com/fivethirtyeight/data/master/college-majors/women-stem.csv"))
# Identify the top three majors with the highest share of women in STEM fields

Stem_Women1 <- Stem_Women[order(-Stem_Women$ShareWomen),]

# Identify the top three majors with the lowest share of women in STEM fields

Stem_Women2 <- Stem_Women[order(Stem_Women$ShareWomen),]

# Bar plot with Color for the Top 3 Majors with the highest share of women in STEM fields

barplot(Stem_Women1$ShareWomen, main="Top 3 Majors with the highest share of women in STEM fields", xlab="Majors with the highest share of women in STEM fields", ylab="STEM share of women (%)", col=c("darkblue", "red"), names.arg= as.matrix(Stem_Women1$Major), cex.names = 0.3, cex.lab = 1, cex.axis = 0.7, las = 2)

Top_3_STEM <-  c("COMMUNICATION DISORDERS SCIENCES AND SERVICES" = 96.8, "MEDICAL ASSISTING SERVICES" = 92.8, "NURSING" = 89.6)

barplot(Top_3_STEM, main ="Top 3 Majors with the highest share of women in STEM fields", xlab = "Majors with the highest share of women", ylab = "STEM share of women (%)", col=c("darkblue", "red", "green"),cex.names = 0.5)

# Bar plot with Color for the Top 3 Majors with the lowest share of women in STEM fields

barplot(Stem_Women2$ShareWomen, main="Top 3 Majors with the lowest share of women in STEM fields", xlab="Majors with the lowest share of women in STEM fields", ylab="STEM share of women (%)", col=c("darkblue", "red"), names.arg= as.matrix(Stem_Women2$Major), cex.names = 0.3, cex.lab = 1, cex.axis = 0.7, las = 2)

Bottom_3_STEM <-  c("MECHANICAL ENGINEERING RELATED TECHNOLOGIES" = 7.7, "MINING AND MINERAL ENGINEERING" = 10.2, "NAVAL ARCHITECTURE AND MARINE ENGINEERING" = 10.7)

barplot(Bottom_3_STEM, main ="Top 3 Majors with the lowest share of women in STEM fields", xlab = "Majors with the lowest share of women in STEM fields", ylab = "STEM share of women (%)", col=c("darkblue", "red", "green"),cex.names = 0.5)

# Identify the top three lowest-paying STEM majors

Stem_Women3 <- Stem_Women[order(Stem_Women$Median),]

We could also have used small multiples as a display for the majors, below is how we would do this. We see how below in the case of women’s share of STEM majors displayed as small multiples, we can clearly see that the share of women in STEM majors such as computers and engineering is low versus high in Health (i.e. fields such as nursing)

ggplot(Stem_Women, aes(x = Major, y = ShareWomen)) +
  geom_bar(stat = "identity")+
  facet_wrap(~Major_category)+
  labs(title = "Women's share of STEM majors")+
  theme(axis.ticks = element_blank(), axis.text.x = element_blank(), legend.position = "none")