{"id":539,"date":"2019-04-22T15:43:25","date_gmt":"2019-04-22T20:43:25","guid":{"rendered":"http:\/\/web.education.wisc.edu\/nwhillman\/?p=539"},"modified":"2019-04-22T15:43:25","modified_gmt":"2019-04-22T20:43:25","slug":"state-support-for-public-higher-education-trends-and-data","status":"publish","type":"post","link":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/2019\/04\/22\/state-support-for-public-higher-education-trends-and-data\/","title":{"rendered":"State support for public higher education – trends and data"},"content":{"rendered":"

Here is a quick visualization of the relationship between state higher education appropriations and net tuition revenue per full-time equivalent student from fiscal year 1980 to 2018.<\/p>\n

The y-axis represents inflation-adjusted dollars per FTE based on SHEEO’s State Higher Education Finance data (here<\/a>). The x-axis represents fiscal years; the solid black line is net tuition; the dotted line represents appropriations. \"\"<\/a><\/p>\n

Please use, copy, and improve upon the Stata code pasted below to replicate these charts. This type of chart is a bit overwhelming, probably too much to squeeze into a small space, but it helps me see trends across multiple states. For example, I am squinting at the steady downward appropriation trends in Wisconsin that seems to have flattened out or even reversed direction in other Midwestern states over the past several years.<\/p>\n

Thanks to the SHEEO team for making this data so easy to use. Stata code below:<\/p>\n

\/\/ import data from SHEEO SHEF page
\nimport excel https:\/\/sheeo.org\/wp-content\/uploads\/2019\/04\/SHEEO_SHEF_FY18_Nominal_Data.xlsx, cellrange(A17:Q2016)<\/p>\n

\/\/ trim data to focus on public appropriations, net tuition, and fte
\nkeep A B E L N Q
\nrename A state
\nrename B fy
\nrename E heca_index
\nrename L ed_approp\u00a0 \u00a0 \/\/ state and local support less RAM
\nrename N net_tuition\u00a0 \u00a0\/\/ net tuition less federal and state grants
\nrename Q fte\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/\/ fte net medical students<\/p>\n

\/\/ adjust for inflation using HECA
\ngen approp_adj = ed_approp \/ (heca_index\/1)
\ngen tuit_adj = net_tuition \/ (heca_index\/1)<\/p>\n

\/\/ scale per fte
\ngen approp_fte = approp_adj\/fte
\ngen tuit_fte = tuit_adj\/fte<\/p>\n

\/\/ table over time
\ntable fy if state~=”US”, c(sum approp_adj sum tuit_adj sum fte) format(%15.0fc)
\ndrop if inlist(state,”US”,”Washington DC”)<\/p>\n

\/\/ lattice charts
\n* rescaled y axis
\nxtline tuit_fte approp_fte, i(state) t(fy) scheme(s1mono) byopts(rows(5) rescale note(“”)) xlabel(1980[10]2020,angle(vertical)) xtitle(“”) ymtick(none) ylabel(, nogrid angle(horizontal)) legend(size(tiny) region(lwidth(none)) label(1 “Tuition”) label(2 “Appropriations”) symxsize(6))
\n* fixed y axis
\nxtline tuit_fte approp_fte, i(state) t(fy) scheme(s1mono) byopts(rows(5) note(“”)) xlabel(1980[10]2020,angle(vertical)) xtitle(“”) ymtick(none) ylabel(0[5000]25000,nogrid angle(horizontal)) legend(size(tiny) region(lwidth(none)) label(1 “Tuition”) label(2 “Appropriations”) symxsize(6))<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Here is a quick visualization of the relationship between state higher education appropriations and net tuition revenue per full-time equivalent student from fiscal year 1980 to 2018. The y-axis represents inflation-adjusted dollars per FTE based on SHEEO’s State Higher Education Finance data (here). The x-axis represents fiscal years; the solid black line is net tuition; […]<\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[],"class_list":["post-539","post","type-post","status-publish","format-standard","hentry","category-community-college-research"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/comments?post=539"}],"version-history":[{"count":0,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/posts\/539\/revisions"}],"wp:attachment":[{"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/media?parent=539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/categories?post=539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.education.wisc.edu\/nwhillman\/index.php\/wp-json\/wp\/v2\/tags?post=539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}