Monday, February 27, 2017

Brain Drain - Ranking and Analysis with 2015 ACS data



Brain drain is a much talked about topic.There are various ways of measuring the brain drain. This article focuses on a simple view of the migration of residents with various education achievements. This article also explores ways of ranking USA states in the brain drain issue with migration and education attainment data obtained from Census' 2015 ACS (American Community Survey) five year PUMS data file.
* This article is aimed to review the 2015 ACS migration data for all states in the United States. For more detailed analysis about particular states, please follow the information given in Brain Drain for United States by States DIY 2010, 2015 ACS and try a DIY yourself. For Nebraska, please see Nebraska Brain Drain Migration and Ed. Attainment, 2015 United States ACS.

* Data update for other years
2016-2012 ACS 5-year PUMS data
2011-2007 ACS 5-year PUMS data
.

Continuing our previous explore of Census' ACS PUMS data: Population migration derived from ACS 2015 5-year PUMS dataset and Brain Drain - 2015 ACS State Migration for Working Age, we are going to bring in the education attainment element of the survey to this article. The education attainment levels considered are the PhD degree, the First Professional degree, the Master degree, the Bachelor degree, the Associate degree, some college experience, the High School Diploma, and the less-than-High-School level. 

For the scope, we are continue to confine ourselves to the working age (22-64) population while leaving spaces for discussion of other issues to later articles.

The main slides for this article is titled Brain Drain Rank and Analysis and have been posted at Tableau's public data site.

The story begins with the education attainment of each state in the United States of America. With the data, we can rank the states by the number of people at each education attainment level. Due to the overall population size, these rankings are dominated by large states like New York, Taxes, California, and Florida ... etc.
Ed. Attainment Head Count
  While total head counts are dominated by populated states, it is of interests to see the education attainments varies by states or regions. The second slide/sheet in the presentation allows user to look at just that. While head counts provides relative strength for each education attainment level, percents can provide better sense of quantification, which is what is presented in the third slide of the story.
Ed. Attainment Profile by Head Count
 
Ed. Attainment Profile by Per Cent


With the education attainment data been presented, we moved our focus to the net migration of working age population. The fourth slide of the story ranks the states in terms of net number of people migrated between states - the number of in-migration foreigner can be found in this article: Population migration derived from ACS 2015 5-year PUMS dataset. Observing the fourth slide, we see that both end of the net migration, again, is dominated by large states, which don't have to be, but it is what we observed.
Rank States By Net Migration Head Count
The ranking table by number of Net Migration is presented below, where the education levels were denoted as: Less Than High School Degree (LssHsDgr), High School Degree or Equivelent (HsDgrEqv), Some College But Less than Associate Degree (SomeCllg), Associate Degree (AssctDgr), Bachelor Degree (BchlrDgr), and Graduate Degrees (Grdts).

Looking at the table below, we can see that, at the graduate degree level, New York State lost the most (-16,947), with the Illinos come second (-9,089). Nebraska seems to do much better with  -1,173 and ranked 14 from the last.
========
StateEd. AttainmentHdCntUpperLower
California1. LssHsDgr-9,804-7,536-12,072
New York1. LssHsDgr-9,346-7,507-11,185
Alaska1. LssHsDgr-4,810-3,818-5,802
Illinois1. LssHsDgr-4,655-2,875-6,435
Massachusetts1. LssHsDgr-1,710-563-2,857
Alabama1. LssHsDgr-1,576-209-2,943
New Jersey1. LssHsDgr-1,27455-2,603
District of Columbia1. LssHsDgr-954-407-1,501
Hawaii1. LssHsDgr-699-292-1,106
Connecticut1. LssHsDgr-536323-1,395
Maine1. LssHsDgr-535-64-1,006
Idaho1. LssHsDgr-517477-1,511
Nebraska1. LssHsDgr-437368-1,242
New Hampshire1. LssHsDgr-313346-972
Montana1. LssHsDgr-288123-699
Vermont1. LssHsDgr-283100-666
Florida1. LssHsDgr-2582,245-2,761
North Carolina1. LssHsDgr-2271,501-1,955
Arizona1. LssHsDgr-1631,403-1,729
Iowa1. LssHsDgr-122844-1,088
Arkansas1. LssHsDgr-121,032-1,056
South Carolina1. LssHsDgr231,306-1,260
South Dakota1. LssHsDgr76653-501
New Mexico1. LssHsDgr891,052-874
Wyoming1. LssHsDgr123791-545
Rhode Island1. LssHsDgr159661-343
Maryland1. LssHsDgr1811,200-838
Utah1. LssHsDgr2491,048-550
West Virginia1. LssHsDgr3191,136-498
North Dakota1. LssHsDgr445984-94
Nevada1. LssHsDgr6081,869-653
Delaware1. LssHsDgr8011,297305
Virginia1. LssHsDgr8512,164-462
Kansas1. LssHsDgr8552,028-318
Oregon1. LssHsDgr8942,102-314
Tennessee1. LssHsDgr9082,365-549
Indiana1. LssHsDgr9292,225-367
Colorado1. LssHsDgr1,0062,315-303
Michigan1. LssHsDgr1,0692,225-87
Washington1. LssHsDgr1,0692,470-332
Missouri1. LssHsDgr1,3092,393225
Kentucky1. LssHsDgr1,3792,73028
Louisiana1. LssHsDgr1,4802,667293
Wisconsin1. LssHsDgr1,7572,742772
Mississippi1. LssHsDgr1,7963,015577
Ohio1. LssHsDgr1,8103,427193
Pennsylvania1. LssHsDgr2,0493,687411
Minnesota1. LssHsDgr2,0503,0641,036
Oklahoma1. LssHsDgr2,6223,9551,289
Georgia1. LssHsDgr3,3015,1921,410
Texas1. LssHsDgr8,31210,8635,761
California2. HsDgrEqv-19,658-15,233-24,083
New York2. HsDgrEqv-19,550-16,748-22,352
Alaska2. HsDgrEqv-10,607-9,148-12,066
Illinois2. HsDgrEqv-6,589-4,041-9,137
New Jersey2. HsDgrEqv-4,588-2,719-6,457
Massachusetts2. HsDgrEqv-4,371-2,602-6,140
District of Columbia2. HsDgrEqv-3,231-2,395-4,067
Michigan2. HsDgrEqv-1,768394-3,930
Connecticut2. HsDgrEqv-1,695-330-3,060
Kansas2. HsDgrEqv-1,560192-3,312
Minnesota2. HsDgrEqv-1,243453-2,939
Maine2. HsDgrEqv-733303-1,769
Alabama2. HsDgrEqv-6591,195-2,513
Rhode Island2. HsDgrEqv-642162-1,446
Wisconsin2. HsDgrEqv-621896-2,138
Vermont2. HsDgrEqv-52359-1,105
Pennsylvania2. HsDgrEqv-2282,227-2,683
Montana2. HsDgrEqv-171,051-1,085
Maryland2. HsDgrEqv152,117-2,087
West Virginia2. HsDgrEqv1391,739-1,461
Hawaii2. HsDgrEqv1901,502-1,122
Mississippi2. HsDgrEqv2061,816-1,404
South Dakota2. HsDgrEqv3701,201-461
New Mexico2. HsDgrEqv4741,825-877
Nebraska2. HsDgrEqv5161,826-794
Iowa2. HsDgrEqv5211,965-923
Utah2. HsDgrEqv5431,857-771
Oklahoma2. HsDgrEqv6672,978-1,644
Arkansas2. HsDgrEqv6702,452-1,112
Wyoming2. HsDgrEqv6941,858-470
Virginia2. HsDgrEqv7203,380-1,940
Missouri2. HsDgrEqv7662,907-1,375
Louisiana2. HsDgrEqv9222,997-1,153
New Hampshire2. HsDgrEqv9832,060-94
Ohio2. HsDgrEqv9943,363-1,375
North Dakota2. HsDgrEqv1,1842,413-45
Delaware2. HsDgrEqv1,2382,177299
Indiana2. HsDgrEqv1,7113,601-179
Idaho2. HsDgrEqv1,8853,297473
Kentucky2. HsDgrEqv1,9963,589403
North Carolina2. HsDgrEqv2,0335,348-1,282
Arizona2. HsDgrEqv2,3894,999-221
Washington2. HsDgrEqv2,8105,413207
Colorado2. HsDgrEqv2,9704,8141,126
Oregon2. HsDgrEqv2,9934,4801,506
South Carolina2. HsDgrEqv3,2525,4051,099
Tennessee2. HsDgrEqv3,4536,009897
Nevada2. HsDgrEqv3,6615,5391,783
Georgia2. HsDgrEqv6,6369,1554,117
Texas2. HsDgrEqv10,06913,8806,258
Florida2. HsDgrEqv20,61324,74616,480
California3. SomeCllg-29,736-25,522-33,950
New York3. SomeCllg-19,769-17,125-22,413
Illinois3. SomeCllg-9,441-6,802-12,080
New Jersey3. SomeCllg-8,289-6,392-10,186
Alaska3. SomeCllg-7,887-5,920-9,854
Michigan3. SomeCllg-4,436-2,106-6,766
Ohio3. SomeCllg-1,5661,209-4,341
Maryland3. SomeCllg-1,349429-3,127
Minnesota3. SomeCllg-1,206764-3,176
Massachusetts3. SomeCllg-1,083548-2,714
Virginia3. SomeCllg-1,0041,874-3,882
Indiana3. SomeCllg-9451,499-3,389
New Hampshire3. SomeCllg-811307-1,929
New Mexico3. SomeCllg-788784-2,360
Connecticut3. SomeCllg-672761-2,105
District of Columbia3. SomeCllg-468508-1,444
Mississippi3. SomeCllg-3941,190-1,978
Kansas3. SomeCllg-3911,523-2,305
Rhode Island3. SomeCllg-302447-1,051
West Virginia3. SomeCllg-183844-1,210
Nebraska3. SomeCllg-1571,246-1,560
Vermont3. SomeCllg149785-487
Pennsylvania3. SomeCllg3082,806-2,190
Maine3. SomeCllg4221,383-539
Hawaii3. SomeCllg4322,037-1,173
Louisiana3. SomeCllg4392,573-1,695
Montana3. SomeCllg5581,624-508
Kentucky3. SomeCllg6242,704-1,456
Delaware3. SomeCllg6591,515-197
South Dakota3. SomeCllg8021,771-167
Wyoming3. SomeCllg8781,965-209
Iowa3. SomeCllg9512,277-375
Wisconsin3. SomeCllg1,0363,056-984
Idaho3. SomeCllg1,4792,9535
Oklahoma3. SomeCllg1,5033,550-544
Arkansas3. SomeCllg1,8193,265373
North Dakota3. SomeCllg1,8723,002742
Alabama3. SomeCllg1,9903,92555
Washington3. SomeCllg2,0004,825-825
Missouri3. SomeCllg2,2784,558-2
Utah3. SomeCllg2,7644,601927
North Carolina3. SomeCllg2,9326,275-411
Tennessee3. SomeCllg4,0286,6121,444
Nevada3. SomeCllg4,9906,9413,039
Georgia3. SomeCllg5,4418,6742,208
South Carolina3. SomeCllg5,7508,2473,253
Arizona3. SomeCllg6,5809,4193,741
Oregon3. SomeCllg7,4909,5755,405
Colorado3. SomeCllg8,22210,7375,707
Florida3. SomeCllg8,23512,1094,361
Texas3. SomeCllg14,24618,08110,411
New York4. AssctDgr-9,796-8,106-11,486
California4. AssctDgr-5,643-3,372-7,914
Illinois4. AssctDgr-4,374-2,838-5,910
Pennsylvania4. AssctDgr-3,287-1,762-4,812
Georgia4. AssctDgr-2,406-706-4,106
Alaska4. AssctDgr-2,216-1,195-3,237
Michigan4. AssctDgr-1,806-662-2,950
New Jersey4. AssctDgr-1,20414-2,422
Connecticut4. AssctDgr-1,164-329-1,999
Kansas4. AssctDgr-1,011-161-1,861
Vermont4. AssctDgr-946-522-1,370
Indiana4. AssctDgr-826137-1,789
Minnesota4. AssctDgr-825589-2,239
District of Columbia4. AssctDgr-612-132-1,092
New Mexico4. AssctDgr-528188-1,244
South Dakota4. AssctDgr-299402-1,000
Arkansas4. AssctDgr-266416-948
Louisiana4. AssctDgr-203739-1,145
Rhode Island4. AssctDgr-153352-658
Nebraska4. AssctDgr-119740-978
West Virginia4. AssctDgr-37669-743
Wyoming4. AssctDgr43902-816
Mississippi4. AssctDgr62937-813
Maine4. AssctDgr208866-450
Idaho4. AssctDgr2251,045-595
Montana4. AssctDgr2771,004-450
Hawaii4. AssctDgr3411,442-760
New Hampshire4. AssctDgr3791,069-311
Oklahoma4. AssctDgr3811,333-571
Iowa4. AssctDgr3891,427-649
Maryland4. AssctDgr4791,802-844
Massachusetts4. AssctDgr5911,612-430
North Dakota4. AssctDgr7051,519-109
Wisconsin4. AssctDgr7172,076-642
Kentucky4. AssctDgr7281,823-367
Nevada4. AssctDgr7621,970-446
Ohio4. AssctDgr7822,037-473
Virginia4. AssctDgr8872,093-319
Washington4. AssctDgr9022,495-691
Utah4. AssctDgr9712,015-73
Alabama4. AssctDgr9722,229-285
North Carolina4. AssctDgr1,0132,626-600
Arizona4. AssctDgr1,0442,411-323
Missouri4. AssctDgr1,1182,460-224
Delaware4. AssctDgr1,2151,682748
Tennessee4. AssctDgr1,3232,801-155
Oregon4. AssctDgr1,6322,935329
South Carolina4. AssctDgr2,1763,3371,015
Colorado4. AssctDgr2,5094,164854
Florida4. AssctDgr7,4159,5095,321
Texas4. AssctDgr7,4759,7435,207
New Jersey5. BchlrDgr-13,992-10,691-17,293
New York5. BchlrDgr-12,088-8,361-15,815
Ohio5. BchlrDgr-9,991-6,961-13,021
Pennsylvania5. BchlrDgr-9,433-6,267-12,599
Michigan5. BchlrDgr-8,544-6,148-10,940
Indiana5. BchlrDgr-6,434-4,479-8,389
Iowa5. BchlrDgr-5,519-3,767-7,271
Alaska5. BchlrDgr-5,355-3,654-7,056
Wisconsin5. BchlrDgr-5,240-3,186-7,294
Alabama5. BchlrDgr-3,609-1,567-5,651
Mississippi5. BchlrDgr-3,064-1,621-4,507
Illinois5. BchlrDgr-2,742821-6,305
Missouri5. BchlrDgr-2,558-206-4,910
Rhode Island5. BchlrDgr-2,484-1,461-3,507
Massachusetts5. BchlrDgr-2,405230-5,040
Utah5. BchlrDgr-2,266-519-4,013
Connecticut5. BchlrDgr-1,753422-3,928
Vermont5. BchlrDgr-1,690-686-2,694
New Mexico5. BchlrDgr-1,520-146-2,894
West Virginia5. BchlrDgr-1,464-407-2,521
Oklahoma5. BchlrDgr-1,222540-2,984
South Dakota5. BchlrDgr-1,208-204-2,212
Nebraska5. BchlrDgr-1,131180-2,442
Georgia5. BchlrDgr-6862,649-4,021
North Dakota5. BchlrDgr-573695-1,841
Montana5. BchlrDgr-436781-1,653
Kansas5. BchlrDgr-3871,713-2,487
Wyoming5. BchlrDgr-311805-1,427
Delaware5. BchlrDgr-256731-1,243
Maryland5. BchlrDgr-1043,306-3,514
District of Columbia5. BchlrDgr-441,281-1,369
Kentucky5. BchlrDgr2661,987-1,455
Minnesota5. BchlrDgr3613,019-2,297
New Hampshire5. BchlrDgr3881,767-991
Idaho5. BchlrDgr5812,127-965
Hawaii5. BchlrDgr6402,080-800
Arkansas5. BchlrDgr9292,407-549
Maine5. BchlrDgr1,1622,28044
South Carolina5. BchlrDgr1,9754,389-439
Louisiana5. BchlrDgr2,2174,084350
Virginia5. BchlrDgr2,3275,573-919
Nevada5. BchlrDgr2,9064,4221,390
Tennessee5. BchlrDgr3,3526,068636
Oregon5. BchlrDgr4,4916,6712,311
Arizona5. BchlrDgr6,2959,0373,553
North Carolina5. BchlrDgr7,99611,1374,855
Washington5. BchlrDgr8,61911,6455,593
Florida5. BchlrDgr12,18915,4418,937
California5. BchlrDgr12,27417,3107,238
Colorado5. BchlrDgr13,56016,54610,574
Texas5. BchlrDgr25,98129,29122,671
New York6. Grdts-16,947-13,557-20,337
Illinois6. Grdts-9,089-6,334-11,844
Michigan6. Grdts-5,750-3,869-7,631
Pennsylvania6. Grdts-5,440-3,402-7,478
New Jersey6. Grdts-4,357-2,426-6,288
Ohio6. Grdts-4,193-1,801-6,585
Indiana6. Grdts-3,113-1,688-4,538
Georgia6. Grdts-2,772-729-4,815
Alaska6. Grdts-1,777-792-2,762
Oklahoma6. Grdts-1,676-559-2,793
Missouri6. Grdts-1,635-101-3,169
Massachusetts6. Grdts-1,624493-3,741
Rhode Island6. Grdts-1,517-521-2,513
Nebraska6. Grdts-1,173-178-2,168
Kentucky6. Grdts-1,155-141-2,169
District of Columbia6. Grdts-1,132260-2,524
West Virginia6. Grdts-1,064-522-1,606
Kansas6. Grdts-859509-2,227
Hawaii6. Grdts-628386-1,642
Connecticut6. Grdts-530949-2,009
Mississippi6. Grdts-494295-1,283
Iowa6. Grdts-449687-1,585
Utah6. Grdts-2081,007-1,423
Louisiana6. Grdts-1931,010-1,396
Wisconsin6. Grdts-1561,227-1,539
Arkansas6. Grdts-4956-964
South Dakota6. Grdts13690-664
Wyoming6. Grdts74614-466
Idaho6. Grdts1731,033-687
North Dakota6. Grdts2591,054-536
New Hampshire6. Grdts3871,496-722
Alabama6. Grdts4991,768-770
New Mexico6. Grdts5191,618-580
Delaware6. Grdts6101,375-155
Vermont6. Grdts7221,595-151
Maine6. Grdts9762,060-108
Tennessee6. Grdts1,0552,737-627
Montana6. Grdts1,1171,975259
Nevada6. Grdts1,6112,608614
Minnesota6. Grdts1,7703,323217
Arizona6. Grdts1,9573,938-24
South Carolina6. Grdts2,1183,446790
Maryland6. Grdts2,2274,38569
Virginia6. Grdts2,3335,233-567
Oregon6. Grdts3,0334,5531,513
North Carolina6. Grdts3,9136,1181,708
Colorado6. Grdts4,3666,3672,365
Florida6. Grdts6,6429,3313,953
Washington6. Grdts8,67410,4186,930
California6. Grdts9,39012,8195,961
Texas6. Grdts13,49716,20510,789
======

To mitigate the idea of populated states, one possible alternatives is to look at the percent of the population of a state that migrated. Since the percent give us a too small a number, in this article, we introduced the idea of per mil or per thousand, which is well explained in the Wikipedia article 'Per mille'. Presented in our fifth slide is the net migration for each state for every 1,000 residents. For example, for every 1,000 residents, Washington state shows that there are about about 2.1 people moved in with graduate degrees (including professional degree) and is ranked first in the chart.
Rank Net Migration; Per mil of State Population

The ranking table by number of Net Migration per 1,000 residents is presented below. After adjusting against population, New York State no longer ranked last at the gradate degree level. Alaska is now ranked last with -4.1 graduate degree holders leaving the state per 1,000 Alaska residents. With this adjustment, Nebraska now ranked 6th from the last with -1.1 graduate degree holders leaving the state per 1,000 Nebraska residents.
========
StateEd. Attainmentper 1000 RsdUpperLower
Alaska1. LssHsDgr-11.1-8.8-13.4
District of Columbia1. LssHsDgr-2.3-1.0-3.6
Hawaii1. LssHsDgr-0.9-0.4-1.4
New York1. LssHsDgr-0.8-0.7-1.0
Vermont1. LssHsDgr-0.80.3-1.9
Maine1. LssHsDgr-0.7-0.1-1.3
Illinois1. LssHsDgr-0.6-0.4-0.9
Idaho1. LssHsDgr-0.60.5-1.7
Alabama1. LssHsDgr-0.6-0.1-1.1
Montana1. LssHsDgr-0.50.2-1.2
California1. LssHsDgr-0.4-0.3-0.5
Massachusetts1. LssHsDgr-0.4-0.1-0.7
Nebraska1. LssHsDgr-0.40.4-1.2
New Hampshire1. LssHsDgr-0.40.4-1.3
Connecticut1. LssHsDgr-0.30.2-0.7
New Jersey1. LssHsDgr-0.20.0-0.5
Iowa1. LssHsDgr-0.10.5-0.6
Arizona1. LssHsDgr0.00.4-0.5
North Carolina1. LssHsDgr0.00.3-0.4
Florida1. LssHsDgr0.00.2-0.3
Arkansas1. LssHsDgr0.00.6-0.6
South Carolina1. LssHsDgr0.00.5-0.5
Maryland1. LssHsDgr0.10.3-0.2
New Mexico1. LssHsDgr0.10.9-0.8
Utah1. LssHsDgr0.20.7-0.4
South Dakota1. LssHsDgr0.21.4-1.1
Virginia1. LssHsDgr0.20.5-0.1
Michigan1. LssHsDgr0.20.40.0
Tennessee1. LssHsDgr0.20.6-0.1
Indiana1. LssHsDgr0.30.6-0.1
Washington1. LssHsDgr0.30.6-0.1
Rhode Island1. LssHsDgr0.31.1-0.6
Ohio1. LssHsDgr0.30.50.0
Pennsylvania1. LssHsDgr0.30.50.1
West Virginia1. LssHsDgr0.31.1-0.5
Colorado1. LssHsDgr0.30.7-0.1
Wyoming1. LssHsDgr0.42.4-1.6
Nevada1. LssHsDgr0.41.2-0.4
Missouri1. LssHsDgr0.40.70.1
Oregon1. LssHsDgr0.40.9-0.1
Kansas1. LssHsDgr0.51.3-0.2
Wisconsin1. LssHsDgr0.50.80.2
Kentucky1. LssHsDgr0.61.10.0
Texas1. LssHsDgr0.60.70.4
Louisiana1. LssHsDgr0.61.00.1
Georgia1. LssHsDgr0.60.90.2
Minnesota1. LssHsDgr0.71.00.3
Mississippi1. LssHsDgr1.11.80.4
North Dakota1. LssHsDgr1.12.4-0.2
Oklahoma1. LssHsDgr1.21.90.6
Delaware1. LssHsDgr1.52.50.6
Alaska2. HsDgrEqv-24.5-21.1-27.8
District of Columbia2. HsDgrEqv-7.8-5.7-9.8
New York2. HsDgrEqv-1.7-1.5-1.9
Vermont2. HsDgrEqv-1.50.2-3.1
Massachusetts2. HsDgrEqv-1.1-0.7-1.6
Rhode Island2. HsDgrEqv-1.10.3-2.4
Kansas2. HsDgrEqv-1.00.1-2.1
Maine2. HsDgrEqv-1.00.4-2.3
Illinois2. HsDgrEqv-0.9-0.5-1.2
New Jersey2. HsDgrEqv-0.9-0.5-1.3
California2. HsDgrEqv-0.9-0.7-1.1
Connecticut2. HsDgrEqv-0.8-0.2-1.5
Minnesota2. HsDgrEqv-0.40.1-0.9
Michigan2. HsDgrEqv-0.30.1-0.7
Alabama2. HsDgrEqv-0.20.4-0.9
Wisconsin2. HsDgrEqv-0.20.3-0.7
Pennsylvania2. HsDgrEqv0.00.3-0.4
Montana2. HsDgrEqv0.01.9-1.9
Maryland2. HsDgrEqv0.00.6-0.6
Mississippi2. HsDgrEqv0.11.1-0.9
West Virginia2. HsDgrEqv0.11.7-1.4
Virginia2. HsDgrEqv0.10.7-0.4
Ohio2. HsDgrEqv0.20.5-0.2
Missouri2. HsDgrEqv0.20.9-0.4
Hawaii2. HsDgrEqv0.21.9-1.4
Iowa2. HsDgrEqv0.31.2-0.5
Oklahoma2. HsDgrEqv0.31.4-0.8
Louisiana2. HsDgrEqv0.41.1-0.4
Utah2. HsDgrEqv0.41.2-0.5
North Carolina2. HsDgrEqv0.41.0-0.2
Arkansas2. HsDgrEqv0.41.5-0.7
New Mexico2. HsDgrEqv0.41.6-0.8
Indiana2. HsDgrEqv0.51.00.0
Nebraska2. HsDgrEqv0.51.8-0.8
Arizona2. HsDgrEqv0.71.4-0.1
Texas2. HsDgrEqv0.70.90.4
Washington2. HsDgrEqv0.71.30.1
Kentucky2. HsDgrEqv0.81.40.2
South Dakota2. HsDgrEqv0.82.6-1.0
Tennessee2. HsDgrEqv0.91.60.2
Colorado2. HsDgrEqv1.01.60.4
Georgia2. HsDgrEqv1.21.60.7
South Carolina2. HsDgrEqv1.22.00.4
New Hampshire2. HsDgrEqv1.32.7-0.1
Oregon2. HsDgrEqv1.32.00.7
Florida2. HsDgrEqv1.92.31.5
Wyoming2. HsDgrEqv2.15.6-1.4
Idaho2. HsDgrEqv2.23.80.5
Nevada2. HsDgrEqv2.33.41.1
Delaware2. HsDgrEqv2.44.20.6
North Dakota2. HsDgrEqv2.96.0-0.1
Alaska3. SomeCllg-18.2-13.7-22.7
New York3. SomeCllg-1.7-1.5-2.0
New Jersey3. SomeCllg-1.6-1.2-2.0
California3. SomeCllg-1.3-1.2-1.5
Illinois3. SomeCllg-1.3-0.9-1.6
District of Columbia3. SomeCllg-1.11.2-3.5
New Hampshire3. SomeCllg-1.00.4-2.5
Michigan3. SomeCllg-0.8-0.4-1.2
New Mexico3. SomeCllg-0.70.7-2.1
Rhode Island3. SomeCllg-0.50.7-1.7
Minnesota3. SomeCllg-0.40.2-1.0
Maryland3. SomeCllg-0.40.1-0.9
Connecticut3. SomeCllg-0.30.4-1.0
Massachusetts3. SomeCllg-0.30.1-0.7
Indiana3. SomeCllg-0.30.4-0.9
Kansas3. SomeCllg-0.21.0-1.4
Ohio3. SomeCllg-0.20.2-0.7
Mississippi3. SomeCllg-0.20.7-1.2
Virginia3. SomeCllg-0.20.4-0.8
West Virginia3. SomeCllg-0.20.8-1.2
Nebraska3. SomeCllg-0.21.2-1.5
Pennsylvania3. SomeCllg0.00.4-0.3
Louisiana3. SomeCllg0.21.0-0.6
Kentucky3. SomeCllg0.21.1-0.6
Wisconsin3. SomeCllg0.30.9-0.3
Vermont3. SomeCllg0.42.2-1.4
Washington3. SomeCllg0.51.2-0.2
North Carolina3. SomeCllg0.51.1-0.1
Hawaii3. SomeCllg0.52.5-1.5
Maine3. SomeCllg0.61.8-0.7
Iowa3. SomeCllg0.61.3-0.2
Missouri3. SomeCllg0.71.30.0
Oklahoma3. SomeCllg0.71.7-0.3
Alabama3. SomeCllg0.71.40.0
Florida3. SomeCllg0.81.10.4
Georgia3. SomeCllg0.91.50.4
Texas3. SomeCllg1.01.20.7
Montana3. SomeCllg1.02.9-0.9
Tennessee3. SomeCllg1.11.80.4
Arkansas3. SomeCllg1.12.00.2
Delaware3. SomeCllg1.32.9-0.4
Idaho3. SomeCllg1.73.40.0
South Dakota3. SomeCllg1.73.9-0.4
Utah3. SomeCllg1.83.00.6
Arizona3. SomeCllg1.82.61.0
South Carolina3. SomeCllg2.13.11.2
Colorado3. SomeCllg2.73.51.8
Wyoming3. SomeCllg2.75.9-0.6
Nevada3. SomeCllg3.14.31.9
Oregon3. SomeCllg3.34.22.4
North Dakota3. SomeCllg4.67.41.8
Alaska4. AssctDgr-5.1-2.8-7.5
Vermont4. AssctDgr-2.6-1.5-3.8
District of Columbia4. AssctDgr-1.5-0.3-2.6
New York4. AssctDgr-0.9-0.7-1.0
South Dakota4. AssctDgr-0.70.9-2.2
Kansas4. AssctDgr-0.6-0.1-1.2
Illinois4. AssctDgr-0.6-0.4-0.8
Connecticut4. AssctDgr-0.6-0.2-1.0
New Mexico4. AssctDgr-0.50.2-1.1
Pennsylvania4. AssctDgr-0.5-0.2-0.7
Georgia4. AssctDgr-0.4-0.1-0.7
Michigan4. AssctDgr-0.3-0.1-0.5
Minnesota4. AssctDgr-0.30.2-0.7
California4. AssctDgr-0.3-0.2-0.4
Rhode Island4. AssctDgr-0.30.6-1.1
New Jersey4. AssctDgr-0.20.0-0.5
Indiana4. AssctDgr-0.20.0-0.5
Arkansas4. AssctDgr-0.20.3-0.6
Nebraska4. AssctDgr-0.10.7-0.9
Louisiana4. AssctDgr-0.10.3-0.4
West Virginia4. AssctDgr0.00.6-0.7
Mississippi4. AssctDgr0.00.6-0.5
Ohio4. AssctDgr0.10.3-0.1
Wyoming4. AssctDgr0.12.7-2.5
Maryland4. AssctDgr0.10.5-0.2
Massachusetts4. AssctDgr0.20.4-0.1
Oklahoma4. AssctDgr0.20.6-0.3
North Carolina4. AssctDgr0.20.5-0.1
Virginia4. AssctDgr0.20.4-0.1
Wisconsin4. AssctDgr0.20.6-0.2
Washington4. AssctDgr0.20.6-0.2
Iowa4. AssctDgr0.20.8-0.4
Idaho4. AssctDgr0.31.2-0.7
Maine4. AssctDgr0.31.1-0.6
Arizona4. AssctDgr0.30.7-0.1
Kentucky4. AssctDgr0.30.7-0.1
Missouri4. AssctDgr0.30.7-0.1
Alabama4. AssctDgr0.40.8-0.1
Tennessee4. AssctDgr0.40.80.0
Hawaii4. AssctDgr0.41.8-0.9
Nevada4. AssctDgr0.51.2-0.3
Montana4. AssctDgr0.51.8-0.8
New Hampshire4. AssctDgr0.51.4-0.4
Texas4. AssctDgr0.50.70.3
Utah4. AssctDgr0.61.30.0
Florida4. AssctDgr0.70.90.5
Oregon4. AssctDgr0.71.30.1
Colorado4. AssctDgr0.81.30.3
South Carolina4. AssctDgr0.81.20.4
North Dakota4. AssctDgr1.73.8-0.3
Delaware4. AssctDgr2.33.21.4
Alaska5. BchlrDgr-12.4-8.4-16.3
Vermont5. BchlrDgr-4.7-1.9-7.5
Rhode Island5. BchlrDgr-4.1-2.4-5.8
Iowa5. BchlrDgr-3.2-2.2-4.3
New Jersey5. BchlrDgr-2.7-2.1-3.4
South Dakota5. BchlrDgr-2.6-0.4-4.8
Mississippi5. BchlrDgr-1.9-1.0-2.7
Indiana5. BchlrDgr-1.8-1.2-2.3
Wisconsin5. BchlrDgr-1.6-1.0-2.2
Ohio5. BchlrDgr-1.5-1.1-2.0
Michigan5. BchlrDgr-1.5-1.1-2.0
Utah5. BchlrDgr-1.5-0.3-2.6
North Dakota5. BchlrDgr-1.41.7-4.6
West Virginia5. BchlrDgr-1.4-0.4-2.4
Alabama5. BchlrDgr-1.3-0.6-2.1
New Mexico5. BchlrDgr-1.3-0.1-2.5
Pennsylvania5. BchlrDgr-1.3-0.9-1.7
Nebraska5. BchlrDgr-1.10.2-2.4
New York5. BchlrDgr-1.1-0.7-1.4
Wyoming5. BchlrDgr-0.92.4-4.3
Connecticut5. BchlrDgr-0.90.2-1.9
Montana5. BchlrDgr-0.81.4-2.9
Missouri5. BchlrDgr-0.8-0.1-1.4
Massachusetts5. BchlrDgr-0.60.1-1.3
Oklahoma5. BchlrDgr-0.60.3-1.4
Delaware5. BchlrDgr-0.51.4-2.4
Illinois5. BchlrDgr-0.40.1-0.9
Kansas5. BchlrDgr-0.21.1-1.6
Georgia5. BchlrDgr-0.10.5-0.7
District of Columbia5. BchlrDgr-0.13.1-3.3
Maryland5. BchlrDgr0.01.0-1.0
Kentucky5. BchlrDgr0.10.8-0.6
Minnesota5. BchlrDgr0.11.0-0.7
Virginia5. BchlrDgr0.51.2-0.2
New Hampshire5. BchlrDgr0.52.3-1.3
California5. BchlrDgr0.60.80.3
Arkansas5. BchlrDgr0.61.5-0.3
Idaho5. BchlrDgr0.72.4-1.1
South Carolina5. BchlrDgr0.71.6-0.2
Hawaii5. BchlrDgr0.82.6-1.0
Louisiana5. BchlrDgr0.81.60.1
Tennessee5. BchlrDgr0.91.60.2
Florida5. BchlrDgr1.11.40.8
North Carolina5. BchlrDgr1.42.00.9
Maine5. BchlrDgr1.53.00.1
Arizona5. BchlrDgr1.72.51.0
Texas5. BchlrDgr1.72.01.5
Nevada5. BchlrDgr1.82.70.9
Oregon5. BchlrDgr2.02.91.0
Washington5. BchlrDgr2.12.91.4
Colorado5. BchlrDgr4.45.33.4
Alaska6. Grdts-4.1-1.8-6.4
District of Columbia6. Grdts-2.70.6-6.1
Rhode Island6. Grdts-2.5-0.9-4.2
New York6. Grdts-1.5-1.2-1.8
Illinois6. Grdts-1.2-0.9-1.6
Nebraska6. Grdts-1.1-0.2-2.1
Michigan6. Grdts-1.0-0.7-1.4
West Virginia6. Grdts-1.0-0.5-1.5
Indiana6. Grdts-0.8-0.5-1.2
New Jersey6. Grdts-0.8-0.5-1.2
Oklahoma6. Grdts-0.8-0.3-1.3
Hawaii6. Grdts-0.80.5-2.0
Pennsylvania6. Grdts-0.8-0.5-1.0
Ohio6. Grdts-0.6-0.3-1.0
Kansas6. Grdts-0.50.3-1.4
Georgia6. Grdts-0.5-0.1-0.8
Missouri6. Grdts-0.50.0-0.9
Kentucky6. Grdts-0.5-0.1-0.9
Massachusetts6. Grdts-0.40.1-1.0
Mississippi6. Grdts-0.30.2-0.8
Iowa6. Grdts-0.30.4-0.9
Connecticut6. Grdts-0.30.5-1.0
Utah6. Grdts-0.10.7-0.9
Louisiana6. Grdts-0.10.4-0.5
Wisconsin6. Grdts0.00.4-0.5
Arkansas6. Grdts0.00.6-0.6
South Dakota6. Grdts0.01.5-1.4
Alabama6. Grdts0.20.6-0.3
Idaho6. Grdts0.21.2-0.8
Wyoming6. Grdts0.21.9-1.4
Tennessee6. Grdts0.30.7-0.2
California6. Grdts0.40.60.3
New Mexico6. Grdts0.51.4-0.5
Virginia6. Grdts0.51.1-0.1
New Hampshire6. Grdts0.51.9-0.9
Arizona6. Grdts0.51.10.0
Minnesota6. Grdts0.61.10.1
Florida6. Grdts0.60.90.4
North Dakota6. Grdts0.62.6-1.3
Maryland6. Grdts0.61.30.0
North Carolina6. Grdts0.71.10.3
South Carolina6. Grdts0.81.30.3
Texas6. Grdts0.91.10.7
Nevada6. Grdts1.01.60.4
Delaware6. Grdts1.22.6-0.3
Maine6. Grdts1.32.7-0.1
Oregon6. Grdts1.32.00.7
Colorado6. Grdts1.42.10.8
Montana6. Grdts2.03.50.5
Vermont6. Grdts2.04.4-0.4
Washington6. Grdts2.12.61.7
========
 
The idea of per mil or per thousand of residents do provide a sensible perception of the net migration situation for each state. However, since each state has different education attainment profile, it is also reasonable to take this information into consideration. One possible way of taking that into consideration is to calculate the per mil number of the education population instead of the total working age population. This idea is realized in the sixth slide of this presentation. For example, for Nebraska, if we look at the per mil number for graduate degree against the total working age population, Nebraska shows a net out migration of 1.1 people and ranked the 6th worst including the DC. However, if we look at the same net migration but against the graduate degree holder population, it shows a net out migration of 12.2 per thousand of graduate degree holders in Nebraska. Therefore, graduate degree holders in Nebraska is more likely to move out of the state of Nebraska.
Rank Net Migration; Per mil of Education Level Population

The ranking table by number of Net Migration per 1,000 degree holders is presented below:
========
StateEd. Attainmentper 1000 Ed.RsdUpperLower
Alaska1. LssHsDgr-166.4-132.1-200.7
District of Columbia1. LssHsDgr-25.9-11.1-40.8
Hawaii1. LssHsDgr-13.2-5.5-20.9
Vermont1. LssHsDgr-12.54.4-29.4
Maine1. LssHsDgr-11.6-1.4-21.9
Montana1. LssHsDgr-8.33.5-20.1
New Hampshire1. LssHsDgr-6.77.4-20.9
New York1. LssHsDgr-6.7-5.4-8.0
Idaho1. LssHsDgr-6.25.7-18.0
Illinois1. LssHsDgr-6.1-3.8-8.5
Massachusetts1. LssHsDgr-5.4-1.8-9.0
Nebraska1. LssHsDgr-5.14.3-14.4
Alabama1. LssHsDgr-4.3-0.6-8.0
Connecticut1. LssHsDgr-3.21.9-8.3
New Jersey1. LssHsDgr-2.70.1-5.5
California1. LssHsDgr-2.6-2.0-3.2
Iowa1. LssHsDgr-1.17.4-9.5
North Carolina1. LssHsDgr-0.32.2-2.9
Arizona1. LssHsDgr-0.32.8-3.4
Florida1. LssHsDgr-0.21.8-2.2
Arkansas1. LssHsDgr-0.15.0-5.1
South Carolina1. LssHsDgr0.13.9-3.8
New Mexico1. LssHsDgr0.56.2-5.2
Maryland1. LssHsDgr0.63.9-2.7
Virginia1. LssHsDgr1.94.8-1.0
Utah1. LssHsDgr1.98.1-4.2
Tennessee1. LssHsDgr2.15.5-1.3
Michigan1. LssHsDgr2.24.6-0.2
South Dakota1. LssHsDgr2.320.1-15.4
Indiana1. LssHsDgr2.45.6-0.9
Rhode Island1. LssHsDgr2.49.9-5.1
West Virginia1. LssHsDgr2.69.1-4.0
Nevada1. LssHsDgr2.67.9-2.8
Washington1. LssHsDgr2.96.7-0.9
Ohio1. LssHsDgr3.15.90.3
Pennsylvania1. LssHsDgr3.46.00.7
Texas1. LssHsDgr3.44.42.3
Colorado1. LssHsDgr3.68.4-1.1
Louisiana1. LssHsDgr3.86.90.8
Missouri1. LssHsDgr4.07.30.7
Oregon1. LssHsDgr4.09.5-1.4
Kentucky1. LssHsDgr4.38.60.1
Georgia1. LssHsDgr4.47.01.9
Wyoming1. LssHsDgr5.736.7-25.3
Kansas1. LssHsDgr5.913.9-2.2
Mississippi1. LssHsDgr7.312.22.3
Wisconsin1. LssHsDgr7.311.43.2
Oklahoma1. LssHsDgr10.315.65.1
Minnesota1. LssHsDgr10.615.95.4
Delaware1. LssHsDgr15.124.55.7
North Dakota1. LssHsDgr22.649.9-4.8
Alaska2. HsDgrEqv-86.9-74.9-98.8
District of Columbia2. HsDgrEqv-46.5-34.5-58.6
New York2. HsDgrEqv-6.9-5.9-7.9
Vermont2. HsDgrEqv-4.90.6-10.4
Massachusetts2. HsDgrEqv-4.8-2.9-6.7
California2. HsDgrEqv-4.3-3.3-5.2
Rhode Island2. HsDgrEqv-4.11.0-9.3
Kansas2. HsDgrEqv-4.10.5-8.6
Illinois2. HsDgrEqv-3.6-2.2-5.0
New Jersey2. HsDgrEqv-3.4-2.0-4.7
Connecticut2. HsDgrEqv-3.2-0.6-5.8
Maine2. HsDgrEqv-3.01.2-7.2
Minnesota2. HsDgrEqv-1.70.6-4.1
Michigan2. HsDgrEqv-1.10.3-2.5
Alabama2. HsDgrEqv-0.81.5-3.1
Wisconsin2. HsDgrEqv-0.71.0-2.3
Montana2. HsDgrEqv-0.16.4-6.6
Pennsylvania2. HsDgrEqv-0.10.9-1.1
Maryland2. HsDgrEqv0.02.5-2.4
West Virginia2. HsDgrEqv0.34.2-3.5
Mississippi2. HsDgrEqv0.43.7-2.9
Ohio2. HsDgrEqv0.51.6-0.7
Virginia2. HsDgrEqv0.62.9-1.7
Missouri2. HsDgrEqv0.82.9-1.4
Hawaii2. HsDgrEqv0.96.9-5.2
Oklahoma2. HsDgrEqv1.04.6-2.5
Louisiana2. HsDgrEqv1.13.4-1.3
Iowa2. HsDgrEqv1.14.1-1.9
Arkansas2. HsDgrEqv1.24.4-2.0
North Carolina2. HsDgrEqv1.43.8-0.9
Indiana2. HsDgrEqv1.53.1-0.2
Utah2. HsDgrEqv1.55.3-2.2
New Mexico2. HsDgrEqv1.66.0-2.9
Nebraska2. HsDgrEqv2.17.5-3.3
Kentucky2. HsDgrEqv2.44.40.5
Texas2. HsDgrEqv2.73.71.7
South Dakota2. HsDgrEqv2.78.9-3.4
Arizona2. HsDgrEqv2.85.8-0.3
Tennessee2. HsDgrEqv2.95.00.7
Washington2. HsDgrEqv3.15.90.2
South Carolina2. HsDgrEqv4.26.91.4
Georgia2. HsDgrEqv4.25.82.6
Colorado2. HsDgrEqv4.67.41.7
New Hampshire2. HsDgrEqv4.69.7-0.4
Oregon2. HsDgrEqv5.78.52.9
Florida2. HsDgrEqv6.67.95.3
Wyoming2. HsDgrEqv7.419.8-5.0
Nevada2. HsDgrEqv8.012.13.9
Idaho2. HsDgrEqv8.014.02.0
Delaware2. HsDgrEqv8.014.11.9
North Dakota2. HsDgrEqv12.224.9-0.5
Alaska3. SomeCllg-60.6-45.5-75.7
New York3. SomeCllg-9.7-8.4-11.0
New Jersey3. SomeCllg-8.7-6.7-10.7
District of Columbia3. SomeCllg-8.08.7-24.7
California3. SomeCllg-5.7-4.9-6.6
Illinois3. SomeCllg-5.7-4.1-7.3
New Hampshire3. SomeCllg-5.22.0-12.3
Michigan3. SomeCllg-3.1-1.5-4.7
New Mexico3. SomeCllg-2.72.7-8.1
Rhode Island3. SomeCllg-2.43.5-8.3
Maryland3. SomeCllg-1.90.6-4.3
Connecticut3. SomeCllg-1.71.9-5.4
Minnesota3. SomeCllg-1.71.1-4.4
Massachusetts3. SomeCllg-1.60.8-4.0
Indiana3. SomeCllg-1.11.8-4.0
Ohio3. SomeCllg-1.10.8-2.9
Virginia3. SomeCllg-1.01.8-3.8
Mississippi3. SomeCllg-1.02.9-4.8
Kansas3. SomeCllg-1.03.7-5.6
West Virginia3. SomeCllg-0.83.9-5.6
Nebraska3. SomeCllg-0.64.8-6.1
Pennsylvania3. SomeCllg0.22.2-1.7
Louisiana3. SomeCllg0.74.2-2.8
Kentucky3. SomeCllg1.14.7-2.5
Wisconsin3. SomeCllg1.44.1-1.3
Washington3. SomeCllg2.04.7-0.8
Vermont3. SomeCllg2.211.5-7.1
Hawaii3. SomeCllg2.210.4-6.0
North Carolina3. SomeCllg2.24.7-0.3
Iowa3. SomeCllg2.45.8-1.0
Maine3. SomeCllg2.58.3-3.2
Missouri3. SomeCllg2.85.50.0
Oklahoma3. SomeCllg2.86.7-1.0
Alabama3. SomeCllg3.06.00.1
Florida3. SomeCllg3.55.11.8
Montana3. SomeCllg3.710.7-3.3
Texas3. SomeCllg4.05.12.9
Georgia3. SomeCllg4.26.61.7
Arkansas3. SomeCllg4.68.30.9
Tennessee3. SomeCllg4.87.91.7
Delaware3. SomeCllg5.913.7-1.8
Idaho3. SomeCllg6.012.00.0
Utah3. SomeCllg6.210.32.1
Arizona3. SomeCllg6.89.83.9
South Dakota3. SomeCllg7.416.4-1.5
South Carolina3. SomeCllg9.313.45.3
Wyoming3. SomeCllg9.521.2-2.3
Colorado3. SomeCllg11.314.77.8
Nevada3. SomeCllg11.516.07.0
Oregon3. SomeCllg12.015.48.7
North Dakota3. SomeCllg18.028.97.1
Alaska4. AssctDgr-62.9-33.9-91.9
District of Columbia4. AssctDgr-47.6-10.3-84.9
Vermont4. AssctDgr-30.9-17.1-44.7
New York4. AssctDgr-9.2-7.6-10.8
Connecticut4. AssctDgr-7.2-2.0-12.4
Kansas4. AssctDgr-7.1-1.1-13.0
Illinois4. AssctDgr-7.0-4.5-9.4
Georgia4. AssctDgr-5.5-1.6-9.4
South Dakota4. AssctDgr-5.37.1-17.7
New Mexico4. AssctDgr-5.31.9-12.5
Pennsylvania4. AssctDgr-5.0-2.7-7.3
New Jersey4. AssctDgr-3.30.0-6.7
Michigan4. AssctDgr-3.3-1.2-5.4
California4. AssctDgr-3.2-1.9-4.5
Rhode Island4. AssctDgr-2.86.5-12.1
Indiana4. AssctDgr-2.50.4-5.4
Arkansas4. AssctDgr-2.33.6-8.2
Minnesota4. AssctDgr-2.21.6-6.0
Louisiana4. AssctDgr-1.34.6-7.1
Nebraska4. AssctDgr-1.06.3-8.4
West Virginia4. AssctDgr-0.58.5-9.4
Mississippi4. AssctDgr0.45.8-5.0
Wyoming4. AssctDgr1.124.0-21.7
Ohio4. AssctDgr1.33.4-0.8
Iowa4. AssctDgr1.76.4-2.9
North Carolina4. AssctDgr1.94.9-1.1
Massachusetts4. AssctDgr1.95.2-1.4
Wisconsin4. AssctDgr1.95.6-1.7
Maryland4. AssctDgr2.07.4-3.5
Washington4. AssctDgr2.15.8-1.6
Oklahoma4. AssctDgr2.27.7-3.3
Virginia4. AssctDgr2.45.6-0.9
Maine4. AssctDgr2.610.7-5.5
Idaho4. AssctDgr2.612.1-6.9
Arizona4. AssctDgr3.27.4-1.0
Kentucky4. AssctDgr3.48.6-1.7
Hawaii4. AssctDgr3.715.8-8.3
Missouri4. AssctDgr3.98.6-0.8
Alabama4. AssctDgr4.19.5-1.2
New Hampshire4. AssctDgr4.813.6-3.9
Tennessee4. AssctDgr4.910.5-0.6
Montana4. AssctDgr5.218.9-8.5
Nevada4. AssctDgr5.815.1-3.4
Utah4. AssctDgr6.012.4-0.4
Florida4. AssctDgr6.38.14.5
Texas4. AssctDgr7.19.24.9
Oregon4. AssctDgr8.014.31.6
South Carolina4. AssctDgr8.513.04.0
Colorado4. AssctDgr9.215.23.1
North Dakota4. AssctDgr11.324.4-1.8
Delaware4. AssctDgr29.340.618.0
Alaska5. BchlrDgr-70.8-48.3-93.3
Vermont5. BchlrDgr-19.7-8.0-31.4
Rhode Island5. BchlrDgr-19.4-11.4-27.3
Iowa5. BchlrDgr-16.0-10.9-21.1
Mississippi5. BchlrDgr-13.6-7.2-19.9
South Dakota5. BchlrDgr-12.7-2.1-23.2
New Jersey5. BchlrDgr-10.8-8.3-13.4
West Virginia5. BchlrDgr-10.7-3.0-18.3
Indiana5. BchlrDgr-10.1-7.0-13.2
New Mexico5. BchlrDgr-9.0-0.9-17.2
Ohio5. BchlrDgr-8.5-5.9-11.0
Michigan5. BchlrDgr-8.5-6.1-10.8
Alabama5. BchlrDgr-8.4-3.6-13.1
Wisconsin5. BchlrDgr-7.9-4.8-11.0
Utah5. BchlrDgr-7.2-1.6-12.7
Pennsylvania5. BchlrDgr-6.6-4.4-8.8
North Dakota5. BchlrDgr-6.27.6-20.1
Wyoming5. BchlrDgr-5.413.9-24.6
Nebraska5. BchlrDgr-4.90.8-10.6
New York5. BchlrDgr-4.8-3.3-6.3
Missouri5. BchlrDgr-4.0-0.3-7.8
Montana5. BchlrDgr-3.86.8-14.4
Connecticut5. BchlrDgr-3.70.9-8.2
Oklahoma5. BchlrDgr-3.31.5-8.1
Delaware5. BchlrDgr-2.57.2-12.3
Massachusetts5. BchlrDgr-2.40.2-5.0
Illinois5. BchlrDgr-1.70.5-3.9
Kansas5. BchlrDgr-1.15.0-7.3
Georgia5. BchlrDgr-0.62.4-3.7
District of Columbia5. BchlrDgr-0.411.1-11.9
Maryland5. BchlrDgr-0.14.3-4.5
Minnesota5. BchlrDgr0.54.0-3.0
Kentucky5. BchlrDgr0.75.5-4.1
New Hampshire5. BchlrDgr2.19.7-5.4
Virginia5. BchlrDgr2.15.1-0.8
California5. BchlrDgr2.73.81.6
Hawaii5. BchlrDgr3.712.0-4.6
Idaho5. BchlrDgr3.713.7-6.2
Arkansas5. BchlrDgr3.910.0-2.3
South Carolina5. BchlrDgr4.29.4-0.9
Tennessee5. BchlrDgr5.29.51.0
Louisiana5. BchlrDgr5.39.80.8
Florida5. BchlrDgr6.17.74.4
North Carolina5. BchlrDgr7.310.14.4
Maine5. BchlrDgr7.514.80.3
Texas5. BchlrDgr9.210.48.1
Washington5. BchlrDgr9.813.26.4
Arizona5. BchlrDgr9.814.15.5
Oregon5. BchlrDgr10.014.85.1
Nevada5. BchlrDgr11.918.05.7
Colorado5. BchlrDgr17.421.213.6
Alaska6. Grdts-43.0-19.2-66.8
Rhode Island6. Grdts-20.9-7.2-34.7
West Virginia6. Grdts-13.7-6.7-20.7
Nebraska6. Grdts-12.2-1.9-22.5
Oklahoma6. Grdts-10.8-3.6-18.0
Indiana6. Grdts-10.6-5.8-15.5
Michigan6. Grdts-10.5-7.0-13.9
New York6. Grdts-10.4-8.3-12.4
Illinois6. Grdts-10.2-7.1-13.2
District of Columbia6. Grdts-9.12.1-20.3
Hawaii6. Grdts-8.35.1-21.7
Ohio6. Grdts-6.9-2.9-10.8
Pennsylvania6. Grdts-6.8-4.2-9.3
New Jersey6. Grdts-6.2-3.4-8.9
Kentucky6. Grdts-5.2-0.6-9.8
Kansas6. Grdts-5.13.0-13.3
Missouri6. Grdts-4.9-0.3-9.4
Georgia6. Grdts-4.8-1.3-8.3
Mississippi6. Grdts-4.32.6-11.3
Iowa6. Grdts-3.14.8-11.0
Massachusetts6. Grdts-2.40.7-5.6
Connecticut6. Grdts-1.62.9-6.1
Utah6. Grdts-1.57.2-10.2
Louisiana6. Grdts-1.15.5-7.6
Wisconsin6. Grdts-0.54.2-5.2
Arkansas6. Grdts0.08.4-8.4
South Dakota6. Grdts0.421.4-20.6
Alabama6. Grdts2.38.0-3.5
Idaho6. Grdts2.615.8-10.5
Wyoming6. Grdts2.722.8-17.3
Virginia6. Grdts3.37.3-0.8
Tennessee6. Grdts3.38.5-1.9
Maryland6. Grdts3.97.70.1
New Hampshire6. Grdts4.015.4-7.4
California6. Grdts4.05.52.5
New Mexico6. Grdts4.514.2-5.1
Minnesota6. Grdts5.39.90.6
Arizona6. Grdts6.012.1-0.1
Florida6. Grdts6.99.64.1
North Carolina6. Grdts7.511.73.3
North Dakota6. Grdts9.036.4-18.5
South Carolina6. Grdts9.415.33.5
Delaware6. Grdts10.323.2-2.6
Texas6. Grdts10.512.68.4
Colorado6. Grdts11.016.16.0
Oregon6. Grdts12.719.16.4
Maine6. Grdts13.929.2-1.5
Nevada6. Grdts14.523.55.5
Vermont6. Grdts15.834.9-3.3
Washington6. Grdts19.523.415.5
Montana6. Grdts23.140.95.4
========

The last slide of the presentation allows user to compare selected states.
Net Migration; Per mil of Education Level Population


Thursday, October 06, 2016

A mind of STEM graduates


 

With a higher education panel, error was caught by STEM graduates, but the reputation  worth less to nothing.

Many things went by in life without consciously been recorded or memorized. With my mind in education and STEM, a recent event is worth noting.

An office draft that is to be published were routed internally and to external experts for review. A section of the document presented the following information:

State and Local Appropriation Per FTE student

Data Source: State Higher Education Executive Officers Association (SHEEO), State Higher Education Finance (SHEF) Report: FY2014

Cost of living adjustment (COLA)
Enrollment mix index(EMI)

(adjusted)  State and local appropriations per FTE student = ([Educational appropriations]/[FTE enrollment...])/[COLA/EMI]
...
The section, basically, describes how much money the state or local government spend on (per FTE, Full-Time Equivalent) student with adjusting factors of COLA and EMI.

When given the above information, for most or all reviewers, there isn't much to suspect the accuracy of the information - for one, the source is authoritative, for two, the formula involves more items/numbers than they want to see. Then, the third, there could be doubts if they could understand the methodology behind the calculation.These kinds of scene happened often. A report/publication often is a mash of information from other sources with limited originality. Lots of times, entities lack the talent and confidence in devising and defending their own methodologies.

STEM graduates, due to their training, confidences in handling complicated situation are high. It became more likely for them to take extra steps to try to seriously understand the limits and implications of a methodology. In other words, the ability of STEM graduates are peers to those that devised the methodology.

With their training, the first thing went through STEM graduates' mind is what [COLA/EMI] trying to show? From the syntax convention used, it seems that square brackets were used to denote items. However, due to their desire of unambiguity, they will either questioning the use of square brackets in '[COLA/EMI]' or questioning what COLA/EMI trying to show - as '/' can mean divide in mathematics but can mean something totally different in casual writings.


In order to answer the requisition mind, quick Googling revealed the info on EMI:
1. Integrated Postsecondary Education Data System (IPEDS) data were usedto develop a national average cost per fall FTE for each of the Carnegie
Classifications of institutions. This calculation used financial information from
FY 2011 and fall 2010 FTE data.
2. The proportion of each state’s FTE in each of the Carnegie Classifications was
calculated for fall 2010, and then multiplied by the national average cost per
FTE in FY 2011 for each respective classification. For each state, the products
for each Classification were summed, which yields the state’s enrollment mix
unit cost for the year.


With the mathematical training and the understanding of the purpose of the formula, it is clear that the EMI have to be divided by the '[Educational appropriation]'. At this point, the question is if the authoritative source made the mistakes? A STEM graduate knows what is right and what is wrong and would not afraid to challenge the authoritarians - after all, there is no authoritarians in the science - it is a matter of truth.

In this particular case, the source did it right. The question is then, what we did wrong and how should it be presented correctly. The turn of this event is that, as expected, among these specialists, all but one notice the error, none but two cares the voice of a STEM graduate.

If this is happened in the higher education, how about the general public? Do you really think our STEM push can be successful while, in most people's mind, STEM graduates do not worth the attention.


Tuesday, June 02, 2015

Methodology: Higher Education-Workforce Pipeline IPEDS CIP SOC crosswalk

Original Article

To Be Completed!

** If you are using Microsoft Internet Explorer or Google Chrom browser, you would not be able to read the formulas in this article. These formulas were written in MathML, a W3C standard, and can be viewed in FireFox.

This methodology is much improved over my previous methodology.

In essence, the number of graduates can potentially be hired for a program with CIP code C is:
Potentially_Hired ( C ) = ( G c + ε ) S c O s c [ 1 C S c ( G C S c + ε ) ]
Where G x is the number of graduates for CIP x, O z is the number of job opening for a given SOC z, S x is the SOC S related to a CIP x, C z is the CIP C related to an SOC z, and ε is a very small number, which play important role when G x is zero.

Following are drafts and is to be ignored for Now!
Number of graduates for CIP c:

Number of job open for SOC s:
O s
SOC related to a CIP c:
S c
CIP related to an SOC s:
C s
G S C s
-1 +1
( x 1 - x 2 ) 2 + ( y 1 - y 2 ) 2

An exciting discovery ... Yeh !!

An exciting discovery!

I started this blog to provide my analysis to the Internet society and, especially, as my thanks to wonderful people who contribute contents freely to the Internet society. Every time I am on the Internet reading personal websites, blogs, or the Wikipedia, I appreciate their volunteer works. These individuals may not volunteer in any physical form, but their contribution to the human society is of no less. A while back, I thought about creating some kind of website that can recognize these wonderful people for their volunteer works. Unfortunately, I haven't have time to move forward on the project.

Now my discovery. The other day, I was surprised to find that one of my post is actually referenced by a book. I considered that a great honor and totally flattered. But I would like to attribute this to all the people who volunteered their time and made our life better and easier.

 

Monday, June 01, 2015

Evaluate Nebraska's Education-Workforce Pipeline - CIP SOC Crosswalk


The methodology employed by this article is a major improvement over the previous model in that suggested increase or decrease of award production will have no side effects on related fields!
With the P20 initiatives bobbling up all over the United States, the idea of education pipeline has extended from education to the workforce supply. The idea of linking higher education production to economic prosperity has found its way into legislatures.

The idea of aligning higher education production with the workforce demand isn't new. A crosswalk system that linking the field of study to appropriate occupation was last updated in March 2012 by National Center for Education Statistics (NCES) and the Bureau of Labor Statistics (BLS). The crosswalk, also known as CIP to SOC crosswalk, had been used in various workforce supply studies. However, because the complexity of the crosswalk, most of the studies limited their use to few focused fields of interest.

While the CIP to SOC crosswalk is a useful tool, limitations must be observed. The guiding principle behind the development summarized it well:
  • “A CIP-SOC relationship must indicate a “direct” relationship, that is, programs in the CIP category are preparation directly for entry into and performance in jobs in the SOC category. The programs satisfy requirements for entry and/or prepare individuals to meet licensure or certification requirements to work in the occupation.”
An example can provide some clarity to the principle. In the nursing field, the registered nurse program (CIP 513801 Associate degree) is crosswalked to the registered nurse (RN) occupation (SOC 291141 Registered Nurse) and not the Licensed Practical Nurse (LPN) occupation (SOC 292061) even though the registered nurse can certainly worked in the LPN occupation. When interpret the result of this work, please keep this in mind, the result is based on 'appropriate' mapping and not the 'all possible mapping'. In the case of Registered Nurse, State of Nebraska can decide to produce more Registered Nurses to fill the LPN occupation. But that probably isn't the most efficient approach.

This article presents a general approach that is applied to all field of studies. The approach is applied to the state of Nebraska data set but can be easily applied to other states.

The data employed are the 2012-22 long term occupation projection data from Nebraska's Department of Labor and the 2013 degree awarded data from IPEDS' (Integrated Postsecondary Education Data System) completion survey.

While the methodology possessed some very desirable characteristics, like all researches, the data employed played vital role in the outcome. During the development, the job opening advertise data available from Nebraska Department of Labor's website were examined. The data for occupation like 'bus driver, School or Special Client' seems to be OK. The data for hot occupations like nurse or computer related positions post some challenges. For one, there were a lot of entries posted by staffing companies or recruiters and, by reading through some of the entries, some of them are simply phantom entries that mimic the real positions. For the nursing jobs, multi-leveled job listings are common. For example, a position can be advertized as RN/LPN, which begged the question of which category this position is counted under. With these observations, the result presented is based on Labor's projection data which can easily be replaced with more accurate data if such data is available.

The methodology employed by this article is different from that of our previous articles. This new approach eliminated couple of the mentioned limitations of previous methodology. Noticeably, when increase or reduce the number of graduates for a given field following the suggestion of this article would not interfere with the number suggested by this article for other fields. This is a major improvement over the previous model in which additional analysis is needed to make sure no side effect occurred in other related fields.

At the heart of this new methodology is the assumption of equal chance of employment, which means that all graduates that can be walked to an occupation, they all have the same chance of getting hired. If supported by real-life data, this factor can be modified to provide better result.

The top 10 education programs that could be targeted to produce more graduates are:
CIPTitleDgr LevelJob OpenUnFilled
490205Truck and Bus Driver/Commercial Vehicle Operator and Instructor.LessAssct1,024(953)
513999Practical Nursing, Vocational Nursing and Nursing Assistants, Other.LessAssct468(456)
513801Registered Nursing/Registered Nurse.Associate702(292)
520301Accounting.Bachelor467(156)
110101Computer and Information Sciences, General.Bachelor259(113)
520801Finance, General.Bachelor300(55)
460302Electrician.LessAssct154(96)
120401Cosmetology/Cosmetologist, General.LessAssct126(84)
110701Computer Science.Bachelor121(75)
480501Machine Tool Technology/Machinist.LessAssct144(65)
460303Lineworker.LessAssct71(56)


The top 10 eduction programs that could consider reducing graduates are:
CIPTitleDgr LevelJob OpenOver Supplied
540101History, General.Bachelor22163
513801Registered Nursing/Registered Nurse.Master11180
230101English Language and Literature, General.Bachelor27198
510912Physician Assistant.Master43245
450101Social Sciences, General.Bachelor41255
130301Curriculum and Instruction.Master13398
131202Elementary Education and Teaching.Bachelor276404
260101Biology/Biological Sciences, General.Bachelor70436
520201Business Administration and Management, General.Bachelor368588
520101Business/Commerce, General.Bachelor386618


Tuesday, February 04, 2014

Now Microsoft has spoken, Microsoft, Yahoo, and Google CEO...



Let truth speaks for itself...
Microsoft CEO Satya Nadella
Yahoo CEO Marissa Mayer
Google CEO Larry Page
How about Apple's Tim Cook?

Thursday, December 12, 2013

ACT score distribution (2013) in charts

Introduction:
While working on our project, we find the need to visualize the ACT score distribution. ACT published the score distribution annually for National and for each state. What is missing is charts that help visualizing the distribution.

Below, we presented the National ACT score distributions for the class of 2013.Please note the math distribution has a very distinctive shape.

The main scores:
Figure 1 - ACT English Score Distribution (2013)


Figure 2 - ACT Math Score Distribution (2013)

Figure 3 - ACT Reading Score Distribution (2013)

Figure 4 - ACT Science Score Distribution (2013)

Figure 5 - ACT Composite Score Distribution (2013)

In addition to the main score, ACT also published distributions for sub-scores that constituted the main score.

Sub-Scores - ACT English Score Distribution (2013):
Figure 6 - English (Usage/Mechanics) Score Distribution (2013)

Figure 7 - English (Rhetorical Skills) Score Distribution (2013)


Sub-Scores - ACT Math Score Distribution (2013):

Figure 8 - Math (Pre-Algebra) Score Distribution (2013)

Figure 9 - Math (Algebra/Coordinate Geometry) Score Distribution (2013)
 

Figure 10 - Math (Plane Geometry/Trigonometry) Score Distribution (2013)

Sub-Scores - ACT Reading Score Distribution (2013):
Figure 11 - Reading (Social Science) Score Distribution (2013)

Figure 12 - Reading (Art/Literature) Score Distribution (2013)

Wednesday, November 13, 2013

Distance picked, peer institution selected, the nearest IPEDS

Other Peer Institution Selection Article

** If you are using Microsoft Internet Explorer or Google Chrom browser, you would not be able to read the formulas in this article. These formulas were written in MathML, a W3C standard, and can be viewed in FireFox.

Summary
The goal of this article is to provide mathematical insights into the selection of nearest peer institutions. The discussion begins with a general review of distance in mathematics and extended the idea to the measurement of nearness. Examples were used to demonstrate the importance of properly selected distance function.

The idea of peer
In many fields of study, it is a useful practice to tag objects that are similar to a particular object, the Anchor, as peers. The similarity can customarily be measured by the shortness of distance. The smaller the distance, the more similar an object is to the Anchor and the more likely an object to be selected as a peer of the Anchor.

Distances in Mathematics
In mathematics a metric or distance function is a function that defines the distance between two elements/objects (see Wikipedia article). However, as the abstract nature of the mathematics, the 'set theory' set criteria on behavior of the distance function but left the explicit definition of the distance to the case of application since the explicit definition is irrelevant in the content of the set theory.

For cases were the elements are Euclidean geometry points, the distances are commonly defined as:  ( x 1 - x 2 ) 2 + ( y 1 - y 2 ) 2

However, this is not the only permissible definition for distance.


Distance in a case of study
The lack of explicit definition of distance for a case of study call into question of the distance between the mathematics and the real world.

However, contrary to most believes, mathematics is not isolated in its own abstract world, plenty of mathematical branches grow out of real world problems. For example, the criteria for the distance function are abstracted qualities of the common distance definition of the Euclidean geometry.

The absent of the definition, in essence, offer the opportunity to select a sensible definition for the case of study.

In the land of peer selection, properties are constantly associated with objects and distances are customary defined through properties.

In the case of higher-education-institution objects, possible properties are fall enrollment headcounts, percent of male enrollment, total revenue, ... etc, like those collected by IPEDS ( Integrated Postsecondary Education Data System) survey.

Distance of Interest for this article
Of all the possible choice of distance definitions, the following are of demonstrative interest. The subscript i denoted various properties while the X denoted the Anchor object in the set and x a different object. The D denote the distance

  1. Sum of the square of the difference
    D = i d i = i ( x i - X i ) 2
  2. Sum of the Ranking of difference
    D = i d i = i Ranking of | x i - X i |
    where the minimum value has a rank of 1 and the next smallest has a rank of 2 ... etc.
  3. Sum of the square of the percent difference
    D = i d i = i ( x i X i - 1 ) 2
  4. Sum of the absolute value of the percent difference
    D = i d i = i | x i X i - 1 |
Fabricated demonstrative data
For the sack of demonstration, higher education institution IPEDS like objects were considered. The Anchor institution, My Inst, alone with three other institutions and their fabricated property values were listed in Table 1. Comparisons of these institution were presented in Figure 1. Data are fabricated to demonstrate that a good methodology would not depend on data to produce reasonable result. With Figure 1, it is clearly shown that Inst-1 is the institution that most similar to My Inst, the Anchor institution, followed by Inst-2 and Inst-3.

Table 1 - demonstrative data
InstEnrollment% MenRevenue
Institution 1190063%105,000
Institution 2205090%101,000
Institution 3197035%104,000
My Institution200060%100,000

Figure 1 - comparing institutions (click to see the picture)


Distance evaluated with each illustrative definition

Table 2 - Sum of the square of the difference
InstEnrollmentPercent MenRevenueDistance
Inst 1100000.000925,000,00025,010,000.0
Inst 225000.091,000,0001,002,500.1
Inst 39000.062516,000,00016,000,900.1


With the 'sum of the square of the difference' approach, the similarity ranking is in the order of Inst-2, Inst-3, and followed by Inst 1. Table 2 demonstrated that, in this model, the property having larger value would overshadow differences in other properties. It is, therefore, important to scale properties to a compatible matter.t


Table 3 - Sum of the Ranking of difference
InstEnrollmentPercent MenRevenueDistance
Inst 13137
Inst 22316
Inst 31225

The 'Sum of the Ranking' practice considered the Inst-3 as the most similar peer with Inst-2 and Inst-1 following. The problem with this approach may not be obvious. Couple of points can be made, if observe carefully. First of all is the misrepresentation of the true differences with category like integers, which by itself can't even avoid rounding errors. Using ordering also create problem in that distances between adjacent values are been replaced by 1.

Table 4 - Sum of the square of the percent difference
InstEnrollment% MenRevenueDistance
Inst 10.3%0.3%0.3%0.8%
Inst 20.1%25.0%0.0%25.1%
Inst 30.0%17.4%0.2%17.5%

Inst-1 is ranked as the most likely followed by Inst-3 and Inst-2 in the 'Sum of the square of the percent difference' process. 

Under this approach, differences are represented by the percent difference from the Anchor with no categorization attempted. Another benefit of this approach is the straightforward approach and the ease of explanation to audiences. Weighting to each property, as will be discussed later, is also plain to see and easy to identify.

Lesson learned
Properties' value varied in magnitudes, invoking values directly undermined the difference in properties with smaller magnitude. The employ of ranking could over-shadow the difference in value and, in effect, assigned a difference of 1 for all adjacent values.

The square vs. the absolute value (definition 3 vs. definition 4) 
The fact that ( i A i ) 2 i A i 2 implied that the squared method would favor multiple smaller differences than a single larger difference while the absolute value method will weight small differences and single bigger difference equally. Visually, the squared method made sense.

Weighting properties
Once standardize to the 'sum of the square of the percent difference', weighting can easily be done by multiples to the 'square of the percent difference' before the sum.

* While customized distance can be used in Nearest Neighbor analysis, Nearest Neighbor represent a specific topic in the cluster analysis.

Tuesday, November 05, 2013

Doctor's degree by field of study, race, foreign, and gender


The field of choice for US doctor awardees are similar regard less of race. Non-resident alien accounted for almost 30% of the supply for higher education instructors!

Observing of doctoral degree conferred in the United States provided us a unique look into the US higher education system. It provided implications for our future higher education system. For one, the doctors are the main source of future college instructors, and secondly, they are future leaders of our higher education institutions. They are also the main research talent that will continue to move the country forward. Lawyers also play important roles in the social justice of our society, especially in protecting minorities' legal rights.

The CL education center has just released a set of data processing reports based on the IPEDS (Integrated Postsecondary Education Data System) 2011-12 completer survey - the analysis can be found under the section: United State's Doctor Production.

IPEDS survey classifies Doctors into 3 groups: The Research Doctors, the Professional Practice Doctors, and the Other Doctors. For non-legal, and non-medical field, the research doctors are the main source for college instructors. The professional practice doctors are mainly the lawyers, and the medical doctors, but also includes doctors that are mainly prepared for specialized career practices like ...

Total Doctor Degrees Awarded by Field of Study (CIP)

Figure 1, Doctors' field of study for each race (click to view the whole chart)
The major field/CIP of interested are list in Table 1 below.

Table 1, major field of interest for each race (multiple and unknown race not displayed)
CIPTitleNativeAsianPIBlackHispanicWhiteAlien
11Computer and Info. Sci.0.3%0.8%0.4%0.2%0.5%4.2%
13Education8.6%1.9%15.9%6.6%5.8%3.4%
14Engineering1.6%3.7%1.4%2.0%2.4%24.8%
22Legal Prof. and Studies37.5%21.2%29.1%38.8%30.5%5.7%
26Bio and Biomedical Sci.3.1%4.1%2.6%3.7%4.0%11.2%
40Physical Sciences1.3%1.5%0.9%1.5%2.4%11.3%
42Psychology3.5%1.7%3.9%5.5%4.0%1.8%
45Social Science1.1%1.0%1.3%1.5%1.7%5.9%
51Health Professions related36.3%58.7%32.3%33.3%39.4%10.1%


Figure 1 and Table 1 revealed that, for US citizen, almost all races are favoring Legal, and Health Professions roughly equally, except Asian Pacific Islander are skewed more toward Health Professions. Beside the point made above, in general, all races exhibit similar field-of-study pattern. The major disparities in the chart come from the non-residence alien, where the dominated field is the engineering. Their domination on physical science and biology is also noticeable.


Total Doctor Degrees Awarded by Race
Table 2, total doctor degree awarded by race
NativeAsianPIBlackHispanicWhiteAlienUnknownMult.Rc
0.5%9.5%6.1%5.5%58.8%11.5%7.3%0.7%

Total Research Doctors Awarded by Race
Table 3, total research doctors awarded by race
NativeAsianPIBlackHispanicWhiteAlienUnknownMult.Rc
0.4%5.3%6.3%4.1%49.2%27.3%6.8%0.6%

The research doctor degree, which mainly removed the lawyers and medical doctors from the total doctor count, awarded to non-residence alien comprise a whooping 27% of all the research doctor degree awarded. Research doctors are the major supply of teachers for our higher education system.

Table 4, research doctors awarded by fields(CIP) and by race
CIPTitleNativeAsianPIBlackHispanicWhiteAlienUnknownMult.Rc
1Agriculture and Operation0.7%2.5%1.3%4.1%34.5%52.0%4.5%0.4%
3Nature Resource and Conservation0.4%3.4%2.5%3.4%56.7%27.4%5.6%0.5%
4Architecture0.0%17.8%4.0%3.5%29.2%37.1%6.4%2.0%
5Area, Ethnic, Cultural, Gender Studies2.2%8.6%11.9%5.0%44.2%16.9%10.4%0.7%
9Communication, Journalism0.7%2.6%5.7%2.1%56.3%25.3%6.9%0.3%
10Communication Technologies0.0%0.0%0.0%0.0%0.0%100.0%0.0%0.0%
11Computer and Info Sci.0.2%8.3%2.0%1.2%33.0%50.4%4.7%0.2%
12Personal and Culinary Services







13Education0.8%3.1%16.6%6.1%58.3%7.0%7.5%0.6%
14Engineering0.2%7.0%1.7%2.2%28.2%56.2%4.2%0.4%
15Engineering Technologies0.0%5.5%1.8%1.8%49.1%34.5%7.3%0.0%
16Foreign Languages, Literatures0.1%3.6%1.7%6.6%47.0%32.4%8.4%0.3%
19Family, Consumer Sci.0.3%3.4%9.1%2.2%57.2%25.3%2.2%0.3%
22Legal Prof. and studies0.0%1.6%0.5%2.1%11.0%77.0%7.9%0.0%
23English, Literature0.4%3.4%4.0%3.8%70.8%8.5%7.9%1.1%
24Liberal Arts, Sci. General Studies0.0%4.5%3.4%1.1%56.8%12.5%20.5%1.1%
25Library Sci.0.0%2.0%2.0%2.0%48.0%42.0%4.0%0.0%
26Bio. Biomedical Sci.0.3%8.2%3.3%4.3%49.8%27.2%6.3%0.6%
27Math. And Statistics0.3%5.7%1.4%1.8%39.4%46.5%4.7%0.1%
28Military Sci. Leadership







29Military Tech.0.0%0.0%0.0%0.0%83.3%16.7%0.0%0.0%
30Interdisciplinary Studies0.5%5.3%10.0%4.8%52.3%20.2%5.6%1.4%
31Recreation, Leisure Studies0.4%1.2%7.0%2.1%62.8%24.8%1.2%0.4%
32Basic, Remedial Education







33Citizenship Activities







34Health Knowledge and Skill







35Social Skills







36Leisure, Recreational Activities







37Self-Improvement







38Philosophy and Religious Studies0.1%2.6%5.4%2.9%62.5%18.1%7.5%1.0%
39Theology, Religious Vocations0.0%4.7%10.8%3.3%61.0%12.6%7.3%0.2%
40Physical Sciences0.2%4.6%1.7%2.6%43.7%40.6%6.2%0.5%
41Science Tech.0.0%33.3%0.0%0.0%66.7%0.0%0.0%0.0%
42Psychology0.6%4.7%6.7%8.0%63.1%6.9%9.0%0.9%
43Protective Services0.0%3.8%11.5%3.1%63.4%12.2%5.3%0.8%
44Public Administration0.4%4.7%15.1%5.3%47.2%17.0%9.7%0.7%
45Social Science0.3%4.5%3.8%3.9%47.4%32.2%7.2%0.7%
46Construction Trades







47Mechanic, Repair Tech.







48Precision Production







49Materials Transportation







50Performing Arts0.4%6.1%1.9%3.5%57.8%22.1%7.8%0.5%
51Health Professions0.3%5.9%7.7%3.3%60.9%13.3%8.1%0.5%
52Business, Marketing0.4%5.2%12.5%4.4%41.2%26.0%10.2%0.2%
53Secondary Diplomas







54History0.5%2.6%4.5%4.5%64.7%12.3%9.6%1.2%
60Residency Programs








Figure 4 further breaks down the research doctors by field of study (CIP) and by race. The engineering stand out. 56% of the engineering doctor degrees were awarded to non-resident alien. Other non-resident alien heavy fields include Agriculture(52%),
Architecture(37%), Computer Sci.(50%), Engineering Tech(35%), Foreign Languages(32%), Library Sci.(42%), Math. And Statistics(47%), Physical Sciences(41%), Social Science(32%). All of these fields displayed a non-resident alien rate that is higher than the 27.3%, the average rate held by non-resident alien.

Total Research Doctors Awarded by Gender
Men(51%) and women(49%) held roughly the same share of all the research doctor degrees awarded by US institutions. The lowest fields with women recipients are Military Tech(17%), Theology(19%), Computer(20%), and Engineering(22%).

Professional Practice Doctor Degrees Awarded by Gender
In this category, men(53%) held a slightly larger share in the Legal Profession while women(57%) hold larger share in the Medical Doctor field.

Thursday, August 22, 2013

Salaries for Professor, Instructor and Graduate Assistant - an IPEDS derivation


** If you are using Microsoft Internet Explorer or Google Chrom browser, you would not be able to read the formulas in this article. These formulas were written in MathML, a W3C standard, and can be viewed in FireFox.

For the 2012-13 IPEDS (Integrated Postsecondary Education Data System) data collection year, National Center for Education Statistics (NCES) changed the information it collected through its Human Resource component. This change in data collection dictates how the average salary for Full-Time instructional Faculty can be calculated.

This article intended to provide a comparison of the new and the old way of calculating the average salary. The discussion is intentionally simplified in order to demonstrate the conceptual differences.

Prior to 2012-13 data collection, headcount numbers and salary outlays were collected for faculty with 9- or 10-month contract and 11- or 12-month contract for each gender and rank. So, for each gender and rank, there are basically 4 numbers: Total Salary Outlay for faculty with 9- or 10-month contract (S9), Total Headcount for faculty with 9- or 10-month contract (H9), Total Salary Outlay for faculty with 11- or 12-month contract (S11), and Total Headcount for faculty with 11- or 12-month contract (H11). The suggested way (by NCES) to calculate the annual 9-month average salary for each gender-rank combination is given by:

  S9+ 911S11 H9+ H11

, which, in essence, is the average of the monthly salary times 9.

Beginning 2012-13 data collection year, for each gender-rank combination, 5 numbers are collected: the Total Headcount for faculty with 9-month contract (H9), the Total Headcount for faculty with 10-month contract (H10), the Total Headcount for faculty with 11-month contract (H11), the Total Headcount for faculty with 12-month contract (H12), and the Total Salary Outlay for faculty with all four contract length (S9+S10+S11+S12). The suggested way (by NCES) to calculate the annual 9-month average salary for each gender-rank combination is given by:

S9+S10+ S11+S12 9H9+ 10H10+ 11H11+ 12H12 x9

, which, in essence, is the total salary outlay distributed into the total number of manpower-month.

Logically, the methodology changes begged the explanation of the differences between these two methods.

For simplicity, case with only 9-month and 11-month faculties are considered. Under this condition, the 2012-13 method reduced to:

  S9+ S11 9H9+ 11H11x9 .

By carrying out the difference of the new and old methods, we arrived at:

211S11 - 29x ( S9+ 911S11 H9+ H11 ) xH11 9H9+ 11H11 x 9.

The difference indicates if the new number is higher or lower than the old number and by how much. The value represented by the parenthesis is that of the old method - the average monthly salary times 9 month. By multiplying it by two over nine and times the number of faculty with 11-month contract, the result represents the amount of money needed to bring the 11-month faculties' average salary to that of the old method for the two months (9-11). The leading term in the numerator indicates the two month allocation from the total salary outlay for the 11-month faculties. The net value of the numerator is, therefore, the amount of money that can be used the raise or lower the value of the new method apart from the average monthly salary of the old method. By solving the inequality equation:

211S11 - 29x ( S9+ 911S11 H9+ H11 ) xH11 >0
 
, it can be proofed that higher monthly salary for the 11-month faculties would result in higher value for the 2012-13 formula than the older formula and the reverse is also true.

By consideration above and by making the same assumption NCES had made in the past (i.e. assuming all faculty with 9- or 10-month contracts are actually 9-month contract and that all faculty with 11- or 12-month contract are actually 11-month contract), it is possible to apply the new method to the pre 2012-13 data with predictable discrepancy.

Even though NCES had used the 9- and 11-month assumption in the past, the new 2012-13 data can be used to gauge if that assumption is a valid one. For example, the 2012-13 data revealed that majority of Nebraska's colleges are either have 9-month contracts or 12-month contracts. There are some 10-month contracts, but the 11-month contracts are nearly none. With these observation, the following formulas is a better estimate for the pre 2012-13 data:
S9+ 912S12 H9+ H12  

At the same time, by discounting the minorities, the following formula can be applied to all years:
S9+ S12 9H9+ 12H12x9

This would show the effects and differences caused by the new formula and also provide a ( reasonably ) compatible trend from the past to current.

Thursday, February 14, 2013

On Obama’s Bold Plan to Reshape American Higher Education

Original Article

Summary goes here!

A step finally taken, which I have advocated for a long time.

Jest few points about things the author of the article like to see to be included in Obama's plan.

On 'Nobel Prize winner wants to get in the Physics 101 business' should get more weight:
  • Personally, I don't think a Researcher is necessary a better teacher. They may have their own way of understanding things, it does not necessary mean those understanding are on all levels and that they can transfer those idea effectively especially to students that may have totally different mindsets.
  • If there is going to have an objective measurements of outcome, why do we try to add some un-objective impurity to the formula? This is more like going back to the old system where the established (regional accredited) are carrying more weights.
  • By providing this loophole to encourage high level researcher to teach low level courses, aren't we promoting inefficiency? I am not saying there would have no benefits to the students, but I am saying that this by-law is not needed. If they can provide extra benefits to lower level courses, those benefits should be build into the objective measurement formula and, therefore, it will show if the benefits is there and, would, therefore, render the by law unnecessary.

Wednesday, February 13, 2013

A song for the Ed community



Educate future generation and change the world!
 Gem like you, Gem like you, here is a song for you.

Give me a song, give me a song, give me is the name of the song.

Give me the word, give me the word, give me has taken the world.
Game boring girl, game boring girl, give me has taken them all.
Bragging boy, bragging boy, give me is their whole.

Boring game, bragging game, give me is all their game.
The give me will never end their game.

Gem like you, gem like you, may the give me never got you.
Gem like you, gem like you, may the ring never got you.

May the ring never replace you. May the ring never replace a gem like you.





- Of cause, there is a story behind it.

 

Tuesday, October 23, 2012

Summary of the IPEDS data release schedule



The Best Known Date for IPEDS data release!
IPEDS stand for Integrated Postsecondary Education Data System and is a set of survey conducted by the National Center for Education Statistics (NCES), a division of the United State Education Department(US ED).

All the IPEDS survey data can be obtained through the IPEDS data center. IPEDS survey data are published in various quality control levels. The most recent guide line are covered in the document: IPEDS Data Release Procedure. In essence, beginning with data submitted in the 2011-12 survey year, data will be released in 3 phases: preliminary, provisional and final, geared toward national, state and institutional level analysis. In tech terms, these are what they mean:
  • Preliminary - Edited but unimputed for non-responding school
  • Provisional - Fully Edited with Imputing for non-responding institutions
  • Final - Includes Edited updates from PYR - were referred to as 'revised data'

However, to track down when each set of data were published, it is not an easy task. One source of this kind of information is the 'This Week in IPEDS' news letter/email. The archive for these news letters can be found at IPEDS news site. However, even with the news letter, sometimes it is still hard to pinpoint the date a certain data set is made available at the IPEDS data center.

The following info is compiled from the news letters mentioned above. The only thing can be said about the date is these are the 'best known date'. Procedures to derive these info are detailed in this document.

Survey Year 2010-11
Survey Year Survey Preliminary* Provisional Final
2010-11 IC 2/8/2011 9/20/2011 4/27/2012
2010-11 C 2/8/2011 9/20/2011 4/27/2012
2010-11 E12 2/8/2011 9/20/2011 4/27/2012
2010-11 HR - 11/22/2011 Target ?/?/2013
2010-11 SFA - - 4/27/2012
2010-11 EF - - -
2010-11 F - - -
2010-11 GR - - -

Survey Year 2011-12
Survey Year Survey Preliminary* Provisional Final
2011-12 IC - 9/26/2012 Target ?/?/2013
2011-12 C - 9/26/2012 Target ?/?/2013
2011-12 E12 - 9/26/2012 Target ?/?/2013
2011-12 HR - 9/26/2012 Target ?/?/2013
2011-12 SFA - 9/26/2012 Target ?/?/2013
2011-12 EF 10/9/2012 Target ?/?/2012 Target ?/?/2013
2011-12 F 10/9/2012 Target ?/?/2012 Target ?/?/2013
2011-12 GR 10/9/2012 Target ?/?/2012 Target ?/?/2013
* Preliminary data will not be accessible once the provisional data is made available.

IC -Institutional Characteristics
C - The Completion Survey
E12 - 12-month Enrollment Survey
HR - Human Resource Survey
SFA - Student Financial Aid Survey
EF - Fall Enrollment Survey
GR - The Graduation Rate Survey

* A personal note: It take about 5 months for preliminary release and about 7-11 months for provisional release.

Sunday, August 12, 2012

Homeland: Immigration in America Refugees

Original Article
 

Keep that spirit up - not that the America is a Great country, but that how lucky we are and how to light the spirits of our youth and best our efforts.


My first reaction after watching the show is that this is why America is a Great country - the heart of American people.

It has been a long time, I totally appreciated the America Dream - You will get there as long as you work hard for it - the opportunity. Just imaging how these refugees have to go through to survive in America and compare with our kids that growing up in America. Shouldn't our kids appreciate how fortunate they are - as the old saying goes: Counting your blessings - my feel is that a lot of us have lost that and that big heart. A lot of us seems to forget how fortunate we are and what we should have done our best to advance the world.

Have we done our best? With tones of fortune after the World War II, have we not worked our best to educate our children to keep that spirits up? Or have we been blamed other countries for products and jobs we can do with our ancient education?

America is a Great country, don't let that fade away!

Please keep that spirit up - not that the America is a Great country, but that how lucky we are and how to light the spirits of our youth and best our efforts.







Wednesday, May 30, 2012

It’s time to drop the college-for-all crusade

Original Article

Summary goes here!

Personally, I would attribute some of these kind of  bad American policies to the generosity of American and some to the idea of 'Political Correctness'.

As a foreign born American, I am totally impressed by the generosity of American and, at times, puzzled and resisted. Growing up, I took nothing for granted even though I have supporting parents. I was educated, taught and self-studied, that begging is of no dignity and god only help people that help themselves. Personally, I have been summon all these under the 'responsibility'.

As to the 'Political Correctness', for one thing, I would like to remind the reader that OPPORTUNITIES is all it should be considered. Given the opportunity, in the sense of promote responsibility, it is up to the people to work hard to get what they want.

More practically, we should realized that not all people were born equal, intellectually. The best a society can hopeful is to have everyone do their best. To have people reach their best is to teach them being responsible. To teach responsibility, the operation of the system and the society must, by itself, promote responsibility. For example, to entitle to education as a right, students must demonstrate their wiliness to put in efforts in studying. For a normal people, this can simply be a requirement to reach certain testing scores. This is nothing new, what is new is the infusion of the idea of responsibility.

In theory, I am willing to support the idea of free education for all those who did their best. On the other hand, since resources are limited, we should support those who will benefit the society the most. With the full support of the society, I am visioning the building of a system where the freely educated scholars recognizing the support from and the responsibility to the society. Formula may need be sought to build a practical system, the idea is to promote responsibility as the core value of education.

For people reaching their best but were not able to be the best, this is where the society come in to benefit the constituent of the whole society.

Tuesday, May 08, 2012

Can Financial Aid Improve Student Success at Louisiana’s Community Colleges?

Original Article

Summary goes here!
An old saying: "Help people who helped themselves."

Financial Aid can help if students were matured enough to realize the value of the extra time they got and put it into study. If not, I don't see how the extra money can improve students' success. It may even distract them from the study to enjoy other things in life.

This is a good demonstration of why building the sense responsibility is the number one task in education. Any attempt to improve the education outcome without promoting students' sense of responsibility is a wrong approach. You can hire personal coaches that following student around to improve his/her education. But does the society have the responsibility to support people this way? Will this ever been sustainable?

The histories of a lot of Federal Aid programs have shown that a lot of people will take advantages of these systems in undesirable ways and a lot of these programs were later re-tweaked or added responsibility strings to it.