ALL ASSIGNMENTS NEED TO HAVE YOUR NAME, DATE AND ASSIGNMENT

NAME. I HAVE NO IDEA WHO SUBMITTED THIS.

1) How much would an in-state student expect to pay for the 2017-2018 school year? 

In-state students can expect to pay $24,916 in estimated expenses for the 2017 – 2018 school year.  

correct.

 
2) How much would an out-of-state student expect to pay for the 2017-2018 school year? 

Out-of-state students can expect to pay $40,162 in estimated expenses for the 2017 – 2018 school year.  

correct 
3) How much more did out-of-students pay in 2017-2018 than in-state students? 

Out-of-state students paid $15,246 more than in-state students for the 2017 – 2018 school year. 

Correct 
4) Which category increased the most from the 2014-2015 to the 2017-2018 school years? Raw change? Percent change? 

Out-of-state tuition and fees increased the most out of all the categories, with a percent change of 16 percent and a raw increase of $4,008. The largest increase that was not tuition was for Room and Board, with a 12 percent increase and a raw change of $1,250. 

 
5) Write a lead for a story based on your analysis. 

Out-of-state tuition and fees have increased by 16 percent in the past four years, according to the National Center for Education Statistics. Out-of-state students are estimated to pay $4,008 more than they did in 2014. 

Incorrect: 19.7% increase 
6) What other information and/or sources would help you finish this story? 

I would speak to senior out-of-state students to see how they feel about these changes, and if they have noticed the increase in prices over the years and how they have handled them. I would also speak to the student financial office to see how if the amount given in scholarships have increased with tuition, and if not, why.  

While tuition has increased for in-state students, out-of-state students have seen a 16 percent increase in tuition in addition to the price increases of room and board and other living expenses, compared to the 9 percent tuition increase for in-state students. 

 Out-of-state students in 2017 – 2018 pay $15,000 *INCORRECT: $15,246 * more than in-state students. The price for books and supplies have decreased by 34 percent, with $354 positive difference since 2014 – 2015.  

 

SPREADSHEET HAS WRONG PERCENTAGE CHANGE CALCULATION

Homework 2-w7g1z2

 

7 of 10 points.