Spreadsheets (You are not logged in)

The following spreadsheets reflect some of the major data tabulations and analyses reported in past issues of OPPORTUNITY. To save newsletter space, they are made available here. If these spreadsheets are used, please cite this website as the source: www.postsecondary.org The [XLS] links are password protected for our current Subscribers. If you are not a Subscriber you can initiate a Subscription now

 
Username:
Password:
Remember me

Page: next 
1 2 3 4 
Sort by: Title , Date
  

Unemployment Rates by State, 1976-2013 8/1/2014

Employment by Industry, 1990-2013 8/1/2014

Gross State Product by Industry, 1963 to 2013 8/1/2014

Per Capita Personal Income for U.S., States and Regions, 1929 to 2013
These data have been compiled and reported by the Bureau of Economic Analysis. 
We have organized these data to describe changes in state and regional per capita personal income compared to U.S. per capita personal income.The comparisons are time series and are of three types: states (or regions) as a percent of U.S., states (or regions) in CPI adjusted constant dollars, and state ranks year by year. 7/16/2014

Pell Grant Recipients as a Percentage of Pell-Eligible Undergraduate Enrollment by Institutional Type/Control and State, 1993-94 to 2012-13 7/16/2014

Dependent and Independent Pell Grant Recipients by Institutional Type/Control and State, 1993-94 to 2011-12 7/15/2014

Pell Grant Recipient Data by State, 1976-77 to 2012-13
This large Excel workbook contains Pell Grant recipient data by state, by institutional control, and by year, 1976-77 to 2012-13.
The data are compiled from annual Pell Grant End of Year reports prepared by the U.S. Department of Education. The recipient data included both the numbers of Pell Grant recipients and the Pell Grant dollars they received for each academic year. The Pell Grant recipient data are classified in two ways: first by location of institution, then by state of residence of the recipients. The difference between these two is net migration of Pell Grant recipients and dollars into or out of each state. 7/11/2014

National School Lunch Program, State-Level Data, FFY1989 to FFY2013
These data provide annual, state-level data on participation by K-12 students in the the U.S. Department of Agriculture's National School Lunch Program.
School children approved for free lunches come from the lowest family income levels, and those approved for reduced price lunches come from somewhat high but sill low income families.These data are useful when measuring the number of children from low income families enrolled in K-12 education, and headed for higher education in each state. The data used in these tables were prepared by Jeffrey Derr and Anne Pauls, Child Nutrition Division, Food and Nutrition Service, U.S. Department of Agriculture. 7/11/2014

College Participation Rates for Students from Low Income Families by State, AY 1993 to AY 2013
This Excel workbook contains state and national data used to calculate college participation rates for students from low income families for the years AY 1993 to AY 2013. This rate is the ratio of dependent Pell Grant Recipients divided by 4th to 9th graders nine years earlier, approved for free or reduced-price school lunches.
The data for each state includes: dependent Pell Grant recipients by state of residence, 4th to 9th grade enrollments in public schools, the percent of children approved for subsidized school lunches, the number of 4th to 9th graders in these low income families, and their rate of enrollment in college nine years later. These data show the number of children in these low income families in the K-12 pipeline headed toward higher education in each state. 7/11/2014

Degrees Conferred by Level of Degree, Gender and State, 1970 to 2012 5/20/2014

Interstate Net Migration of Bachelor's Degree Holders, 1989 to 2013
This is a stock & flow analysis of annual changes in the number of Bachelor Degree Holders in the state between 1989 and 2013. 5/20/2014

Current Fund Expenditures of Public and Private Higher Education as a Percentage of Gross State Product by State, FY1977 to FY2012
This Excel workbook summarizes by state available current fund expenditures data for public, private and proprietary higher education institutions from FY1977 through FY2012.
These sector data are also expressed as a share of Gross State Product in each state, and these shares are ranked against all other states. Current funds expenditure data for private institutions was redefined in FY1997 and thus is not strictly comparable to prior years' data.  5/7/2014

Interstate Migration Patterns of College Freshman, 1996 to 2012
This new spreadsheet was prepared to clarify and simplify understanding of freshman interstate migration in each state. This is a true zero-sum game:some states attract more freshmen than they export.
Other states lose more freshmen to other states than they attract. These migration data imply important information about the attractiveness, or lack thereof, of state higher education opportunities. 5/1/2014

Residence and Migration of College Freshmen Graduating from High School in the Past 12 Months, 1996 to 2012
These data are for the fall terms of 1996, 1998, 2000, 2002, 2004, 2006, 2008, 2010 and 2012. This data was collected in the fall IPEDS enrollment surveys by the National Center for Education Statistics. These data are used to study the interstate migration of college freshmen. 4/29/2014

Poverty Rates by State, 1980-2012 4/8/2014

Agricultural Employment, 1990-2012 4/1/2014

State, Local and Federal Fiscal Support for Higher Education per $1000 of State Personal Income, FY1961 to FY2014
This large Excel spreadsheet combines the Grapevine data from Illinois State University on state tax fund appropriations for higher education, with state personal income data published by the Bureau of Economic Analysis.Data are reported for each state for each fiscal year from 1961 through 2014. These data illustrate the ebb and flow of state investment in higher education over the last three decades. 2/18/2014

Gini Coefficients for Household and Family Income by State, 1969, 1979, 1989, 1999 and 2006-2012 1/30/2014

Median Family Income by State and Median Household Income by State, 1959 to 2012 1/29/2014

Dependent Pell Grant Recipients by Institutional Control, Level and State, FY2003 to FY2013 12/18/2013