This is the same student loan data we$$ve used in class, but extended over several years. For each state and year, the data has:

Number of US borrowers who currently have an outstanding student loan

Total outstanding balance for the state

Recall that the data reflects current state $--$ the values might go up or down each month depending on whether new people took on loans, or existing borrowers paid money off. Also note that while the data has two entries for $2020($one for June and one for the entire year$),$ treat the columns as separate years.

Part $1-$ Questions about the Data

When you find this assignment on gradescope, the first part will ask you the following questions; type or select your answers. You must compute the answers to these questions programmatically.

Check the output! Gradescope can be a little picky about formatting, and we don$$t want you to lose points for putting extra characters or whitespace in an answer. Make sure you$$ve got the correct answer to each question for full credit. Note that the original dataset has monetary values in millions $($e$.$g$.,$ $$100==$ $$100$ million$),$ but the homework questions want the $$real$$ values $($$$100$ million $==$ $$100$ million$).$

Answer these questions $($make sure you compute these answers in your Python solution$)$:

How many borrowers had student loans in $2019?$

What is the total outstanding balance for all students as of $2021?$

What is the average outstanding balance per student in $2016?$

What is Nevada$$s average outstanding balance over all years in the dataset?

Which state had the greatest balance on average over all years in the dataset, and how much was it$?$

Which state had the lowest balance on average over all years in the dataset, and how much was it$?$

On average, how much did the number of borrowers in a given state change per year? $($Assume that, in the first year, the number of borrowers did not change. Compute your first value as the change from $2016$ to $2017.$ Negatives$/$positives don$$t matter here. Going from $10$ borrowers to $11,$ or from $10$ to $9,$ is a change of $1$ person.$)$

Part $2-$ Visualization

Create two Python plots and upload them as screenshots$/$downloads$.$

Plot #$1$: A histogram showing the average outstanding balance per borrower in each state, in $2021.$ Note that a histogram shows a frequency distribution $($i$.$e$.,$ number of states within a range of outstanding balances$),$ and you should not create a plot with one bar per state.

Plot #$2$: A line chart showing how the average outstanding balance per borrowing changed over time. This chart should have two lines, comparing any two states you choose.

Part $3-$ Code Quality

Submit on gradescope the code you developed to compute your answers to the Part $1$ questions, and to generate the plots for Part $2.$

Your code will be graded on modularity, readability, and reusability as discussed in class and outlines in our grading guidelines.