Skip to main content

Section 2.5 Student Debt by College Type

described in detail following the image
A graph showing total U.S. consumer debt of various types from 2003 to 2021, showing that mortgage debt made up the vast majority of U.S. consumer debt in all years measured, around \(70\%\) in 2022, while student loan debt had increased over time to become the second-largest source of U.S. consumer debt, making up around \(35\%\) of non-mortgage debt in 2022. Source: Fitch Ratings, New York Fed Consumer Credit Panel, Equifax.
Figure 2.5.1. A graph showing total U.S. consumer debt of various types from 2003 to 2021.
described in detail following the image
Breakdown of the percentage of U.S. non-mortgage consumer debt from 2009 to 2022 showing the following approximate 2022 distribution: \(35\%\) auto debt, \(35\%\) student loan debt, \(20\%\) credit card debt, \(3\%\) consumer finance, \(7\%\) "other". Source: Equifax Inc., 2022.
Figure 2.5.2. Breakdown of the percentage of U.S. non-mortgage consumer debt from 2009 to 2022.

Exercises Student Debt over Time

Exercise Group.

FigureΒ 2.5.1FigureΒ 2.5.2linked Equifax report
 41 
assets.equifax.com/marketing/US/assets/EFX_PortfolioCreditTrends_202207.pdf
1.
The percentage of total debt in 2008 that was student loans vs. mortgage debt.
2.
The percentage of total debt in 2021 that was student loans vs. mortgage debt.
3.
Why do you think did this graph choose 2003 as a starting year?
4.
Do research online if needed to determine why the second quarter of \(2008\) was the previous peak in U.S. total consumer debt.
5.
Find another source for the US consumer debt broken down by type of debt in 2008 and in 2019. Does it agree with the graph above? Why or why not?

Exercises Tuition by Nonprofit and Public Status

Exercise Group.

Excel spreadsheet on undergrad and grad tuition/fees from the National Center for Education Statistics
 42 
docs.google.com/spreadsheets/d/1lbB5OSSsxrwQdDh5Px8fqMSRRwwvxseg/edit?usp=sharing&ouid=113361107850751941418&rtpof=true&sd=true/copy
Excel version of this table
 43 
nces.ed.gov/programs/digest/d21/tables/dt21_330.10.asp
1.
Create a graph, trendline, and interpret the \(R^{2}\) value for each type of institution: public nonprofit, private nonprofit, private for-profit. What does it mean? Use it to predict average tuition and fees across the country in the current year. How accurate is your prediction?
2.
Fit the data to a polynomial function (of least degree). We’ll talk about how to do this in class, so let your instructor know when you reach this step. For your reference, the steps in Excel are:
3.
Left-click on your graph. In the top menu under "Chart Tools", click Design. Click Add Chart Element -> Trendline -> More trendline options. Click on the data you want to make a trendline for. In the right sidebar, select Polynomial and play around with the "Order" until you get a good fit for your data. Check "Display Equation on chart" and "Display R-squared value on chart". Now, our goal is to get all our \(R^{2}\) values larger than roughly 0.96, which is a very large degree of accuracy. If some of your trendlines have \(R^{2}\leq0.96\text{,}\) double-click on the offending trendline(s) until the sidebar comes up and increase the "Order" of your polynomial until \(R^{2}\gt 0.96\text{.}\)
4.
What trends over time do you notice in each the three graphs? Describe trends in words, using phrases like "increasing", "decreasing", "increasing slope", "decreasing slope". What overall trend do we notice that’s common to all three graphs over time?
5.
The \(R\)-squared value that you were asked to show in ExerciseΒ 2.5.3 above measures what proportion of the variation in the \(y\)-variable is explained by the trendline. For instance, \(R^{2}=1\) means that \(100\%\) of the variation in y is explained by the trendline, so the trendline is a perfect fit. Conversely, \(R^{2}=0\) means that the trendline explains \(0\%\) of the variation in the \(y\) variable, so this trendline doesn’t fit the data at all.What percentage of the variation in two-year public college tuition (\(y\)) is explained by the variation in year (\(x\))? What about when \(y=\) four-year private college tuition? Four-year public college tuition?
6.
Outliers are data that fall far away from the trendline. What outliers do you notice, if any? Interpret these outliers in context: what do they mean for tuition and fees over time, and what possible historical explanations could there be for these outliers?
7.
Polynomials are a special type of mathematical function, or process for turning one number into another. Polynomials are functions of the form \(f(x)=a_{n}x^{n}+a_{n-1}x^{n-1}+\dots+a_{1}x^{1}+a_{0}\text{:}\) sums of powers of \(x\text{,}\) maybe with constant terms in front. For example, \(f(x)=x+1\text{,}\) \(g(x)=17x^{3}-234x+7\text{,}\) and \(h(x)=-x^{1}42+1\) are all polynomials. The polynomial \(a(x)=x^{2}+2x+3\) takes the input 1 and turns it into the output \(1^{2}+2(1)+3=6\text{.}\) All numbers which make sense to input are called the domain of the function, and the possible sensical outputs you could get are called the range.What is the domain and range of each of the polynomial trendlines?
8.
Use this model to predict the tuition cost for a student entering each type of institution in the academic year current academic year. How accurate do you think your prediction is?
9.
Use the model to predict the tuition cost for a student entering a public two-year college in the academic years \(2050\)-\(2051\text{,}\) \(2100\)-\(2101\text{,}\) and \(1900\)-\(1901\text{.}\) How accurate do you think your predictions are?
10.
Within (roughly) what domain do you think your trendline can make fairly accurate predictions? Explain.
11.
Does this table (and the supplement
 44 
nces.ed.gov/programs/coe/indicator/chb/postbaccalaureate-enrollment
on the number of students in grad school) back up the suggestion of this Atlantic article
 45 
webcache.googleusercontent.com/search?q=cache:QCadmloDEIoJ:https://www.theatlantic.com/ideas/archive/2022/04/should-biden-forgive-student-loan-debt/629700/&cd=18&hl=en&ct=clnk&gl=us
demsasWhoReallyBenefits that the cause of increased student debt is that more students are taking out loans to enroll in grad school? Why or why not?

Exercises Trends at Your Institution

1.

Use TuitionTracker
 46 
www.tuitiontracker.org/school.html?unitid=230807
to describe recent trends at your own institution in the same way. Is your college or university better or worse in amount of student debt than the average in the US? The average for institutions of the same type?