Caitlin Lane
1) How much would an in-state student expect to pay for the 2017-2018 school year?
An in-state student would expect to pay $24,916 for the 2017-2018 year.
2) How much would an out-of-state student expect to pay for the 2017-2018 school year?
An out-of-state student can expect to pay $40,162 for the 2017-2018 school year.
3) How much more did out-of-state students pay in 2017-2018 than in-state student?
An out-of-state student can expect to pay $15,246 more than an in-state student.
4) Which category increased the most from the 2014-2015 to the 2017-2018 school years? Raw change? Percent change?
Percent Change: The total out-of-state student tuition increased the most with a percent change of 4.92% *Incorrect. Needed to compare to the 2014-2015 numbers.
Raw Change: It (the total out-of-state student tuition) also had a raw change of $4,008.
5) Write a lead for a story based on your analysis.
For the Fayetteville out-of-state undergraduate students at the University of Arkansas, tuition is on the rise at about 4.9 percent since the 2014-2015 school year according to the National Center for Education Resources. (good attribution, wrong number)
6) What other information and/or sources would help you finish this story?
I would have liked to have more information on why these categories are going up/down and if the tuition for out-of-state students is on the rise then does that also mean that the number of out-of-state students is also rising?
CL Data Analysis Exercise 2-1t7h399
CL Data Analysis Exercise2-1se0u1l
Spreadsheet has error in percentage change calculation. It should be with 2014-15 data, not 2016.
Good professional presentation in this assignment. 8 of 10 points.
Recent Comments