Assignment1
Ramnath Reddy
January 31, 2019
Reading data into Rstudio
Ipeds<-read.csv("~/ipeds2016.csv")
head(Ipeds)## X UNITID INSTNM
## 1 1 100654 Alabama A & M University
## 2 2 100663 University of Alabama at Birmingham
## 3 3 100706 University of Alabama in Huntsville
## 4 4 100724 Alabama State University
## 5 5 100751 The University of Alabama
## 6 6 100830 Auburn University at Montgomery
## IALIAS
## 1 AAMU
## 2
## 3 UAH |University of Alabama Huntsville
## 4
## 5
## 6 AUM|Auburn University Montgomery|Auburn University at Montgomery|Auburn Montgomery
## ADDR CITY STABBR ZIP FIPS OBEREG
## 1 4900 Meridian Street Normal AL 35762 1 5
## 2 Administration Bldg Suite 1070 Birmingham AL 35294-0110 1 5
## 3 301 Sparkman Dr Huntsville AL 35899 1 5
## 4 915 S Jackson Street Montgomery AL 36104-0271 1 5
## 5 739 University Blvd Tuscaloosa AL 35487-0166 1 5
## 6 7440 East Drive Montgomery AL 36117-3596 1 5
## CHFNM CHFTITLE GENTELE EIN DUNS
## 1 Dr. Andrew Hugine, Jr. President 2563725000 636001109 197216455
## 2 Ray L. Watts President 2059344011 636005396 63690705
## 3 Robert A. Altenkirch President 2568246120 630520830 949687123
## 4 Leon Wilson Interim President 3342294100 636001101 40672685
## 5 Dr. Stuart R. Bell President 2053486010 636001138 45632635
## 6 Carl A Stockton Chancellor 3342443000 636000724 183862119
## OPEID OPEFLAG WEBADDR
## 1 100200 1 www.aamu.edu/
## 2 105200 1 www.uab.edu
## 3 105500 1 www.uah.edu
## 4 100500 1 www.alasu.edu
## 5 105100 1 www.ua.edu/
## 6 831000 1 www.aum.edu
## ADMINURL
## 1 www.aamu.edu/Admissions/Pages/default.aspx
## 2 www.uab.edu/students/undergraduate-admissions
## 3 admissions.uah.edu/
## 4 www.alasu.edu/admissions/index.aspx
## 5 gobama.ua.edu
## 6 www.aum.edu/admissions
## FAIDURL
## 1 www.aamu.edu/Admissions/fincialaid/Pages/default.aspx
## 2 www.uab.edu/students/paying-for-college
## 3 finaid.uah.edu/
## 4 www.alasu.edu/cost-aid/index.aspx
## 5 financialaid.ua.edu
## 6 www.aum.edu/admissions/scholarships-and-financial-aid/financial-aid
## APPLURL
## 1 www.aamu.edu/admissions/undergraduateadmissions/pages/undergraduate-application-checklist.aspx
## 2 https://idm.uab.edu/myuab/login?from=ugadmapp
## 3 register.uah.edu
## 4
## 5 apply.ua.edu
## 6 www.aum.edu/admissions/step-by-step-guide-to-apply
## NPRICURL
## 1 www2.aamu.edu/scripts/netpricecalc/npcalc.htm
## 2 uab.studentaidcalculator.com/survey.aspx
## 3 finaid.uah.edu/
## 4 www.alasu.edu/cost-aid/forms/calculator/index.aspx
## 5 financialaid.ua.edu/net-price-calculator/
## 6 www.aum.edu/current-students/financial-information/net-price-calculator
## VETURL
## 1
## 2 www.uab.edu/students/veterans
## 3 www.uah.edu/admissions/graduate/financial-aid/veterans
## 4
## 5 registrar.ua.edu/policies/residency/residency-tuition/
## 6 www.aum.edu/admissions/financial-affairs/financial-aid/veteran-services
## ATHURL
## 1 www.aamu.edu/administrativeoffices/irpsp/institutionalresearchandplanning/pages/default.aspx
## 2 www.uabsports.com/compliance/prospects-new.html
## 3 www.uah.edu/heoa
## 4 www.alasu.edu/search-results/index.aspx
## 5 registrar.ua.edu/policies/right-to-know
## 6 www.aum.edu/academics/institutional-effectiveness/consumer-information
## DISAURL
## 1 www.aamu.edu/administrativeoffices/VADS/Pages/Disability-Services.aspx
## 2 www.uab.edu/students/disability/
## 3 www.uah.edu/health-and-wellness/disability-support
## 4 www.alasu.edu/about-asu/the-campus/disability-accessibility/index.aspx
## 5 ods.ua.edu
## 6 www.aum.edu/campus-life/student-affairs/center-for-disability-services
## SECTOR ICLEVEL CONTROL HLOFFER UGOFFER GROFFER HDEGOFR1 DEGGRANT HBCU
## 1 1 1 1 9 1 1 12 1 1
## 2 1 1 1 9 1 1 11 1 2
## 3 1 1 1 9 1 1 11 1 2
## 4 1 1 1 9 1 1 11 1 1
## 5 1 1 1 9 1 1 11 1 2
## 6 1 1 1 9 1 1 12 1 2
## HOSPITAL MEDICAL TRIBAL LOCALE OPENPUBL ACT NEWID DEATHYR CLOSEDAT
## 1 2 2 2 12 1 A -2 -2 -2
## 2 1 1 2 12 1 A -2 -2 -2
## 3 2 2 2 12 1 A -2 -2 -2
## 4 2 2 2 12 1 A -2 -2 -2
## 5 2 2 2 13 1 A -2 -2 -2
## 6 2 2 2 12 1 A -2 -2 -2
## CYACTIVE POSTSEC PSEFLAG PSET4FLG RPTMTH INSTCAT C15BASIC C15IPUG
## 1 1 1 1 1 1 2 18 16
## 2 1 1 1 1 1 2 15 14
## 3 1 1 1 1 1 2 16 17
## 4 1 1 1 1 1 2 19 13
## 5 1 1 1 1 1 2 16 17
## 6 1 1 1 1 1 2 18 16
## C15IPGRD C15UGPRF C15ENPRF C15SZSET CCBASIC CARNEGIE LANDGRNT INSTSIZE
## 1 18 10 4 13 18 16 1 3
## 2 17 9 5 15 15 15 2 4
## 3 17 9 4 12 15 16 2 3
## 4 13 10 3 13 18 21 2 3
## 5 15 14 4 16 16 15 2 5
## 6 6 9 3 12 18 21 2 2
## F1SYSTYP F1SYSNAM F1SYSCOD CBSA CBSATYPE CSA
## 1 2 -2 26620 1 290
## 2 1 The University of Alabama System 101050 13820 1 142
## 3 1 The University of Alabama System 101050 26620 1 290
## 4 2 -2 33860 1 -2
## 5 1 The University of Alabama System 101050 46220 1 -2
## 6 1 Auburn University 101040 33860 1 -2
## NECTA COUNTYCD COUNTYNM CNGDSTCD LONGITUD LATITUDE ADMCON1
## 1 -2 1089 Madison County 105 -86.56850 34.78337 1
## 2 -2 1073 Jefferson County 107 -86.79935 33.50570 1
## 3 -2 1089 Madison County 105 -86.64045 34.72456 1
## 4 -2 1101 Montgomery County 107 -86.29568 32.36432 1
## 5 -2 1125 Tuscaloosa County 107 -87.54577 33.21440 1
## 6 -2 1101 Montgomery County 102 -86.17735 32.36994 1
## ADMCON2 ADMCON3 ADMCON4 ADMCON5 ADMCON6 ADMCON7 ADMCON8 ADMCON9 APPLCN
## 1 2 1 2 3 2 1 1 3 7043
## 2 3 1 1 3 3 1 3 3 9459
## 3 2 1 1 3 2 1 1 3 4545
## 4 3 2 3 3 3 1 1 3 9053
## 5 2 1 1 3 3 1 1 3 38237
## 6 2 1 3 3 3 1 1 3 2905
## APPLCNM APPLCNW ADMSSN ADMSSNM ADMSSNW ENRLT ENRLM ENRLW ENRLFT ENRLFTM
## 1 2725 4318 6154 2276 3878 1568 652 916 1536 639
## 2 3510 5949 5499 2062 3437 2021 758 1263 1948 730
## 3 2385 2160 3467 1930 1537 1213 735 478 1203 731
## 4 2967 6086 4155 1293 2862 1172 434 738 1152 428
## 5 14846 23391 20107 7819 12288 7559 3255 4304 7541 3246
## 6 1021 1884 2225 786 1439 594 226 368 558 212
## ENRLFTW ENRLPT ENRLPTM ENRLPTW SATNUM SATPCT ACTNUM ACTPCT SATVR25
## 1 897 32 13 19 217 14 1433 91 380
## 2 1218 73 28 45 85 4 1849 92 480
## 3 472 10 4 6 166 14 1152 95 520
## 4 724 20 6 14 178 15 1042 89 370
## 5 4295 18 9 9 1459 19 6062 80 490
## 6 346 36 14 22 11 2 547 92 435
## SATVR75 SATMT25 SATMT75 ACTCM25 ACTCM75 ACTEN25 ACTEN75 ACTMT25 ACTMT75
## 1 470 370 470 16 19 14 20 15 18
## 2 640 490 660 21 28 22 30 19 26
## 3 660 540 680 25 31 24 33 23 29
## 4 460 360 460 15 19 14 19 15 17
## 5 610 490 620 23 31 23 33 22 29
## 6 495 445 495 19 24 19 24 17 22
## EFFYLEV LSTUDY EFYTOTLT EFYTOTLM EFYTOTLW EFYAIANT EFYAIANM EFYAIANW
## 1 1 999 6157 2646 3511 14 3 11
## 2 1 999 21554 8383 13171 53 22 31
## 3 1 999 9206 5194 4012 111 64 47
## 4 1 999 6101 2321 3780 7 3 4
## 5 1 999 41507 18526 22981 166 83 83
## 6 1 999 5996 2158 3838 27 12 15
## EFYASIAT EFYASIAM EFYASIAW EFYBKAAT EFYBKAAM EFYBKAAW EFYHISPT EFYHISPM
## 1 21 10 11 5503 2388 3115 36 9
## 2 1096 469 627 4668 1417 3251 666 251
## 3 362 189 173 1066 456 610 329 172
## 4 30 14 16 5522 2076 3446 73 37
## 5 527 236 291 4894 1677 3217 1587 672
## 6 132 45 87 1937 524 1413 43 14
## EFYHISPW EFYNHPIT EFYNHPIM EFYNHPIW EFYWHITT EFYWHITM EFYWHITW EFY2MORT
## 1 27 9 6 3 337 136 201 0
## 2 415 15 5 10 13369 5410 7959 695
## 3 157 0 0 0 6229 3647 2582 153
## 4 36 3 0 3 218 82 136 71
## 5 915 44 17 27 31177 14155 17022 1040
## 6 29 9 3 6 3080 1245 1835 165
## EFY2MORM EFY2MORW EFYUNKNT EFYUNKNM EFYUNKNW EFYNRALT EFYNRALM EFYNRALW
## 1 0 0 161 51 110 76 43 33
## 2 259 436 239 108 131 753 442 311
## 3 72 81 396 213 183 560 381 179
## 4 20 51 61 25 36 116 64 52
## 5 418 622 180 83 97 1892 1185 707
## 6 64 101 349 116 233 254 135 119
## ARANK SAINSTT SAINSTM SAINSTW SA_9MCT SA_9MCM SA_9MCW SATOTLT SATOTLM
## 1 1 43 35 8 0 0 0 43 35
## 2 1 227 158 69 0 0 0 227 158
## 3 1 66 55 11 0 0 0 66 55
## 4 1 55 32 23 0 0 0 55 32
## 5 1 303 226 77 0 0 0 303 226
## 6 1 49 36 13 0 0 0 49 36
## SATOTLW SA09MCT SA09MCM SA09MCW SA10MCT SA10MCM SA10MCW SA11MCT SA11MCM
## 1 8 40 33 7 0 0 0 0 0
## 2 69 106 86 20 0 0 0 0 0
## 3 11 48 40 8 0 0 0 0 0
## 4 23 33 19 14 22 13 9 0 0
## 5 77 273 204 69 0 0 0 0 0
## 6 13 37 26 11 0 0 0 0 0
## SA11MCW SA12MCT SA12MCM SA12MCW SAMNTHT SAMNTHM SAMNTHW SAOUTLT
## 1 0 3 2 1 396 321 75 3806802
## 2 0 121 72 49 2406 1638 768 36167639
## 3 0 18 15 3 648 540 108 8822484
## 4 0 0 0 0 517 301 216 5612825
## 5 0 30 22 8 2817 2100 717 44176706
## 6 0 12 10 2 477 354 123 4539500
## SAOUTLM SAOUTLW SA09MOT SA09MOM SA09MOW SA10MOT SA10MOM SA10MOW
## 1 3091019 715783 3500565 2896141 604424 0 0 0
## 2 25145826 11021813 12418146 10425438 1992708 0 0 0
## 3 7349213 1473271 6025489 4993304 1032185 0 0 0
## 4 3278158 2334667 3161423 1804416 1357007 2451402 1473742 977660
## 5 33978491 10198215 39485989 30265389 9220600 0 0 0
## 6 3423166 1116334 3294204 2377050 917154 0 0 0
## SA11MOT SA11MOM SA11MOW SA12MOT SA12MOM SA12MOW SAEQ9OT SAEQ9OM
## 1 0 0 0 306237 194878 111359 3730243 3042300
## 2 0 0 0 23749493 14720388 9029105 30230266 21465729
## 3 0 0 0 2796995 2355909 441086 8123235 6760236
## 4 0 0 0 0 0 0 5367685 3130784
## 5 0 0 0 4690717 3713102 977615 43004027 33050216
## 6 0 0 0 1245296 1046116 199180 4228176 3161637
## SAEQ9OW SAEQ9AT SAEQ9AM SAEQ9AW SA09MAT SA09MAM SA09MAW SA10MAT SA10MAM
## 1 687943 86750 86923 85993 87514 87762 86346 NA NA
## 2 8764537 133173 135859 127022 117152 121226 99635 NA NA
## 3 1363000 123079 122913 123909 125531 124833 129023 NA NA
## 4 2236901 97594 97837 97257 95801 94969 96929 111427 113365
## 5 9953811 141927 146240 129270 144637 148360 133632 NA NA
## 6 1066539 86289 87823 82041 89033 91425 83378 NA NA
## SA10MAW SA11MAT SA11MAM SA11MAW SA12MAT SA12MAM SA12MAW SAAVMNT SAAVMNM
## 1 NA NA NA NA 102079 97439 111359 9613 9629
## 2 NA NA NA NA 196277 204450 184267 15032 15352
## 3 NA NA NA NA 155389 157061 147029 13615 13610
## 4 108629 NA NA NA NA NA NA 10857 10891
## 5 NA NA NA NA 156357 168777 122202 15682 16180
## 6 NA NA NA NA 103775 104612 99590 9517 9670
## SAAVMNW
## 1 9544
## 2 14351
## 3 13641
## 4 10809
## 5 14223
## 6 9076Subset the data using dplyr to include five states
library(dplyr)## Warning: package 'dplyr' was built under R version 3.4.4##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionIpeds5<- filter(Ipeds, STABBR == c('CA','AL','DC','FL','GA'))## Warning: package 'bindrcpp' was built under R version 3.4.4## Warning in is.na(e1) | is.na(e2): longer object length is not a multiple of
## shorter object length## Warning in `==.default`(STABBR, c("CA", "AL", "DC", "FL", "GA")): longer
## object length is not a multiple of shorter object lengthhead(Ipeds5)## X UNITID INSTNM IALIAS
## 1 2 100663 University of Alabama at Birmingham
## 2 7 100858 Auburn University
## 3 12 101480 Jacksonville State University
## 4 17 101879 University of North Alabama UNA
## 5 22 102261 Southeastern Bible College
## 6 56 110361 California Baptist University CBU
## ADDR CITY STABBR ZIP FIPS
## 1 Administration Bldg Suite 1070 Birmingham AL 35294-0110 1
## 2 Auburn AL 36849 1
## 3 700 Pelham Road North Jacksonville AL 36265 1
## 4 One Harrison Plaza Florence AL 35632-0001 1
## 5 2545 Valleydale Road Birmingham AL 35244-2083 1
## 6 8432 Magnolia Ave Riverside CA 92504-3297 6
## OBEREG CHFNM CHFTITLE GENTELE EIN DUNS
## 1 5 Ray L. Watts President 2059344011 636005396 63690705
## 2 5 Jay Gogue President 3348444000 636000724 66470972
## 3 5 John Beehler President 2567825781 636001099 79107165
## 4 5 Kenneth D. Kitts President 2567654100 636000893 63659577
## 5 5 Dr. Alexander Granados President 2059709200 630338081 79102406
## 6 8 Ronald Ellis President 8772283615 951890710 53845582
## OPEID OPEFLAG WEBADDR
## 1 105200 1 www.uab.edu
## 2 100900 1 www.auburn.edu
## 3 102000 1 www.jsu.edu/
## 4 101600 1 www.una.edu
## 5 2270400 1 sebc.edu/
## 6 112500 1 www.calbaptist.edu
## ADMINURL
## 1 www.uab.edu/students/undergraduate-admissions
## 2 www.auburn.edu/admissions/
## 3 www.jsu.edu/admissions/
## 4 www.una.edu/admission
## 5 sebc.edu/admissions/
## 6 www.calbaptist.edu/admissions
## FAIDURL
## 1 www.uab.edu/students/paying-for-college
## 2 www.auburn.edu/administration/business_office/finaid/
## 3 www.jsu.edu/finaid/
## 4 www.una.edu/financial-aid/index.html
## 5 sebc.edu/financial-aid/
## 6 www.calbaptist.edu/admissions/financial-aid/
## APPLURL
## 1 https://idm.uab.edu/myuab/login?from=ugadmapp
## 2 www.auburn.edu/admissions/
## 3 www.jsu.edu/undergraduate/apply/index.html
## 4 https://www.applyweb.com/aw?una
## 5 sebc.edu/online-application
## 6 www.calbaptist.edu/future-students/why-cbu/applying-cbu/
## NPRICURL
## 1 uab.studentaidcalculator.com/survey.aspx
## 2 www.auburn.edu/admissions/money-matters.html
## 3 www.jsu.edu/finaid/
## 4 studentnpc.collegeboard.org/
## 5 sebc.edu/net-price-calculator/
## 6 https://calbaptist.studentaidcalculator.com/welcome.aspx
## VETURL
## 1 www.uab.edu/students/veterans
## 2 www.auburn.edu/academic/provost/undergrad_studies/veterans/
## 3 www.jsu.edu/finaid/veteransaffairs/
## 4 www.una.edu/veterans/gi-bill-information.html
## 5
## 6
## ATHURL
## 1 www.uabsports.com/compliance/prospects-new.html
## 2 https://oira.auburn.edu/factbook/acadinfo/retention/gsrncaa.aspx
## 3 www.jsugamecocksports.com/sports/2008/6/2/Compliance.aspx?tab=compliance
## 4 www.una.edu/research/Student-Athletes%20Graduation%20Rates%20pdf.pdf
## 5
## 6 www.cbulancers.com/documents/2014/10/1//gradrates.pdf?id=649
## DISAURL
## 1 www.uab.edu/students/disability/
## 2 cws.auburn.edu/accessibility
## 3 www.jsu.edu/dss/
## 4 www.una.edu/disability-support/
## 5 sebc.edu/student-life/student-services/
## 6 www.calbaptist.edu/explore-cbu/offices/academic-success-center/disability-services/
## SECTOR ICLEVEL CONTROL HLOFFER UGOFFER GROFFER HDEGOFR1 DEGGRANT HBCU
## 1 1 1 1 9 1 1 11 1 2
## 2 1 1 1 9 1 1 11 1 2
## 3 1 1 1 9 1 1 12 1 2
## 4 1 1 1 8 1 1 20 1 2
## 5 2 1 2 5 1 2 30 1 2
## 6 2 1 2 9 1 1 12 1 2
## HOSPITAL MEDICAL TRIBAL LOCALE OPENPUBL ACT NEWID DEATHYR CLOSEDAT
## 1 1 1 2 12 1 A -2 -2 -2
## 2 2 1 2 13 1 A -2 -2 -2
## 3 2 2 2 13 1 A -2 -2 -2
## 4 2 2 2 13 1 A -2 -2 -2
## 5 2 2 2 21 1 A -2 -2 -2
## 6 2 2 2 11 1 A -2 -2 -2
## CYACTIVE POSTSEC PSEFLAG PSET4FLG RPTMTH INSTCAT C15BASIC C15IPUG
## 1 1 1 1 1 1 2 15 14
## 2 1 1 1 1 1 2 16 17
## 3 1 1 1 1 1 2 18 16
## 4 1 1 1 1 1 2 18 16
## 5 1 1 1 1 1 2 24 18
## 6 1 1 1 1 1 2 18 13
## C15IPGRD C15UGPRF C15ENPRF C15SZSET CCBASIC CARNEGIE LANDGRNT INSTSIZE
## 1 17 9 5 15 15 15 2 4
## 2 14 15 4 15 16 15 1 5
## 3 4 13 3 13 18 21 2 3
## 4 7 13 3 12 18 21 2 3
## 5 0 9 2 7 24 51 2 1
## 6 8 11 4 13 18 21 2 3
## F1SYSTYP F1SYSNAM F1SYSCOD CBSA CBSATYPE CSA
## 1 1 The University of Alabama System 101050 13820 1 142
## 2 1 Auburn University 101040 12220 1 194
## 3 2 -2 11500 1 -2
## 4 2 -2 22520 1 -2
## 5 2 -2 13820 1 142
## 6 2 -2 40140 1 348
## NECTA COUNTYCD COUNTYNM CNGDSTCD LONGITUD LATITUDE ADMCON1
## 1 -2 1073 Jefferson County 107 -86.79935 33.50570 1
## 2 -2 1081 Lee County 103 -85.48826 32.59938 1
## 3 -2 1015 Calhoun County 103 -85.76532 33.82294 1
## 4 -2 1077 Lauderdale County 105 -87.68136 34.80674 1
## 5 -2 1117 Shelby County 106 -86.74904 33.37893 1
## 6 -2 6065 Riverside County 641 -117.42587 33.92857 1
## ADMCON2 ADMCON3 ADMCON4 ADMCON5 ADMCON6 ADMCON7 ADMCON8 ADMCON9 APPLCN
## 1 3 1 1 3 3 1 3 3 9459
## 2 2 1 1 2 3 1 1 3 18256
## 3 3 1 3 3 3 1 1 3 4979
## 4 3 1 2 3 3 1 1 3 4408
## 5 3 1 2 1 3 1 1 3 18
## 6 2 1 2 1 3 1 2 3 4971
## APPLCNM APPLCNW ADMSSN ADMSSNM ADMSSNW ENRLT ENRLM ENRLW ENRLFT ENRLFTM
## 1 3510 5949 5499 2062 3437 2021 758 1263 1948 730
## 2 7886 10370 14704 6314 8390 4529 2147 2382 4487 2129
## 3 2151 2828 2643 1162 1481 1320 593 727 1294 583
## 4 1695 2713 2457 966 1491 1196 457 739 1177 448
## 5 12 6 18 12 6 15 10 5 13 8
## 6 2030 2941 3181 1080 2101 1146 413 733 1117 400
## ENRLFTW ENRLPT ENRLPTM ENRLPTW SATNUM SATPCT ACTNUM ACTPCT SATVR25
## 1 1218 73 28 45 85 4 1849 92 480
## 2 2358 42 18 24 552 12 3930 87 530
## 3 711 26 10 16 145 11 1229 93 430
## 4 729 19 9 10 34 3 1166 97 427
## 5 5 2 2 0 0 0 11 73 NA
## 6 717 29 13 16 905 79 527 46 430
## SATVR75 SATMT25 SATMT75 ACTCM25 ACTCM75 ACTEN25 ACTEN75 ACTMT25 ACTMT75
## 1 640 490 660 21 28 22 30 19 26
## 2 620 530 640 24 30 25 32 23 28
## 3 570 440 550 20 26 20 28 18 25
## 4 523 435 530 19 25 19 26 17 24
## 5 NA NA NA 18 23 15 23 15 19
## 6 550 420 550 19 24 18 25 18 25
## EFFYLEV LSTUDY EFYTOTLT EFYTOTLM EFYTOTLW EFYAIANT EFYAIANM EFYAIANW
## 1 1 999 21554 8383 13171 53 22 31
## 2 1 999 29237 14893 14344 170 70 100
## 3 1 999 9886 4146 5740 72 22 50
## 4 1 999 8050 3278 4772 84 30 54
## 5 1 999 182 109 73 2 1 1
## 6 1 999 10604 3703 6901 65 20 45
## EFYASIAT EFYASIAM EFYASIAW EFYBKAAT EFYBKAAM EFYBKAAW EFYHISPT EFYHISPM
## 1 1096 469 627 4668 1417 3251 666 251
## 2 714 371 343 2134 990 1144 897 423
## 3 63 23 40 2188 872 1316 95 45
## 4 43 14 29 1110 468 642 194 97
## 5 0 0 0 66 36 30 4 0
## 6 508 202 306 946 296 650 3564 1065
## EFYHISPW EFYNHPIT EFYNHPIM EFYNHPIW EFYWHITT EFYWHITM EFYWHITW EFY2MORT
## 1 415 15 5 10 13369 5410 7959 695
## 2 474 7 6 1 22898 11507 11391 239
## 3 50 8 4 4 6879 2918 3961 0
## 4 97 8 4 4 5762 2249 3513 185
## 5 4 0 0 0 107 71 36 0
## 6 2499 92 37 55 4070 1550 2520 485
## EFY2MORM EFY2MORW EFYUNKNT EFYUNKNM EFYUNKNW EFYNRALT EFYNRALM EFYNRALW
## 1 259 436 239 108 131 753 442 311
## 2 99 140 219 126 93 1959 1301 658
## 3 0 0 314 134 180 267 128 139
## 4 67 118 357 176 181 307 173 134
## 5 0 0 2 0 2 1 1 0
## 6 179 306 558 194 364 316 160 156
## ARANK SAINSTT SAINSTM SAINSTW SA_9MCT SA_9MCM SA_9MCW SATOTLT SATOTLM
## 1 1 227 158 69 0 0 0 227 158
## 2 1 418 322 96 0 0 0 418 322
## 3 1 90 65 25 0 0 0 90 65
## 4 1 71 46 25 0 0 0 71 46
## 5 1 4 3 1 0 0 0 4 3
## 6 1 74 51 23 0 0 0 74 51
## SATOTLW SA09MCT SA09MCM SA09MCW SA10MCT SA10MCM SA10MCW SA11MCT SA11MCM
## 1 69 106 86 20 0 0 0 0 0
## 2 96 271 216 55 0 0 0 0 0
## 3 25 73 49 24 0 0 0 0 0
## 4 25 66 43 23 0 0 0 0 0
## 5 1 0 0 0 4 3 1 0 0
## 6 23 53 37 16 1 1 0 0 0
## SA11MCW SA12MCT SA12MCM SA12MCW SAMNTHT SAMNTHM SAMNTHW SAOUTLT
## 1 0 121 72 49 2406 1638 768 36167639
## 2 0 147 106 41 4203 3216 987 55484759
## 3 0 17 16 1 861 633 228 7507965
## 4 0 5 3 2 654 423 231 5746467
## 5 0 0 0 0 40 30 10 208509
## 6 0 20 13 7 727 499 228 7540754
## SAOUTLM SAOUTLW SA09MOT SA09MOM SA09MOW SA10MOT SA10MOM SA10MOW
## 1 25145826 11021813 12418146 10425438 1992708 0 0 0
## 2 43883243 11601516 33057407 27103392 5954015 0 0 0
## 3 5554173 1953792 5768921 3929898 1839023 0 0 0
## 4 3790370 1956097 5274375 3473433 1800942 0 0 0
## 5 162229 46280 0 0 0 208509 162229 46280
## 6 5218440 2322314 5022530 3546467 1476063 113905 113905 0
## SA11MOT SA11MOM SA11MOW SA12MOT SA12MOM SA12MOW SAEQ9OT SAEQ9OM
## 1 0 0 0 23749493 14720388 9029105 30230266 21465729
## 2 0 0 0 22427352 16779851 5647501 49877921 39688280
## 3 0 0 0 1739044 1624275 114769 7073204 5148104
## 4 0 0 0 472092 316937 155155 5628444 3711136
## 5 0 0 0 0 0 0 187658 146006
## 6 0 0 0 2404319 1558068 846251 6928284 4817533
## SAEQ9OW SAEQ9AT SAEQ9AM SAEQ9AW SA09MAT SA09MAM SA09MAW SA10MAT SA10MAM
## 1 8764537 133173 135859 127022 117152 121226 99635 NA NA
## 2 10189641 119325 123256 106142 121983 125479 108255 NA NA
## 3 1925100 78591 79202 77004 79026 80202 76626 NA NA
## 4 1917308 79274 80677 76692 79915 80778 78302 NA NA
## 5 41652 46915 48669 41652 NA NA NA 52127 54076
## 6 2110751 93625 94461 91772 94765 95850 92254 113905 113905
## SA10MAW SA11MAT SA11MAM SA11MAW SA12MAT SA12MAM SA12MAW SAAVMNT SAAVMNM
## 1 NA NA NA NA 196277 204450 184267 15032 15352
## 2 NA NA NA NA 152567 158300 137744 13201 13645
## 3 NA NA NA NA 102297 101517 114769 8720 8774
## 4 NA NA NA NA 94418 105646 77578 8787 8961
## 5 46280 NA NA NA NA NA NA 5213 5408
## 6 NA NA NA NA 120216 119851 120893 10372 10458
## SAAVMNW
## 1 14351
## 2 11754
## 3 8569
## 4 8468
## 5 4628
## 6 10186Provide baseline counts of universities by STATE and another categorical/factor variable
stateCount<- Ipeds5 %>% group_by(STABBR) %>% summarize(count = n()) %>% arrange(count)
stateCount## # A tibble: 5 x 2
## STABBR count
## <fct> <int>
## 1 DC 2
## 2 AL 5
## 3 FL 10
## 4 GA 12
## 5 CA 21Arranging the data by university chief title
statea<-Ipeds5 %>% group_by(CHFTITLE) %>% summarize(count = n())
statea## # A tibble: 9 x 2
## CHFTITLE count
## <fct> <int>
## 1 CEO/President 1
## 2 Chancellor 2
## 3 Chancellor and CEO 1
## 4 Chancellor and Vice Provost for Academics 1
## 5 Dean & CEO 1
## 6 Interim President 1
## 7 President 41
## 8 President and CEO 1
## 9 President/CEO 1Make three ggplot graphs of your findings
library(ggplot2)## Warning: package 'ggplot2' was built under R version 3.4.4g1<- ggplot(Ipeds5, aes(STABBR, fill= STABBR))
g1+geom_bar(aes()) + ggtitle("Bar Plot Showing The Count of University by State")
plot showing how the leadership varied at the universities by state
d1<- ggplot(Ipeds5, aes(CHFTITLE))
d1 + geom_bar(aes(fill= STABBR), width = 0.5)
labs(title="Histogram Showing Leadership at Universities Across States")## $title
## [1] "Histogram Showing Leadership at Universities Across States"
##
## attr(,"class")
## [1] "labels"Use the annotate command to do this
f1<-ggplot(Ipeds5, aes(STABBR, fill= STABBR))
f1+geom_bar(aes()) + ggtitle("Bar Plot Showing The Count of University by State") + annotate("text", x= 3, y = 3, label = "Lowest count")
Written summary of your Analysis
Using the dplyr package, we created subset of dataset related to five states : Alabama,California,District Columbia, Florida and GA.
We can conclude that California has the highest number of universities compared to the other four states in the USA as per the presented data. The only categorical variable from this dataset is the university leader title and this varied across all the 50 universities in the above states. Also District columbia has the lowest number of universities within the group