Quantitative Reasoning II Project: Calculations and Visuals

profilevswedin71
QuantitativeReasoningIIProject.xlsx

Sheet1

Security and Criminal Justice Scenario
Topic 2 Predicting Total U.S. correctional population
Scenario 2 Review the data on persons supervised by U.S. adult correctional systems by correctional status. Predict the number of the United States population that will be supervised by U.S. adult correctional system in 2018.
Year Total U.S. correctional population Probation Parole
2000 6,467,800 3,839,400 725,500
2001 6,584,900 3,934,500 731,100
2002 6,730,900 3,995,000 753,100
2003 6,886,800 4,073,800 773,500
2004 6,997,000 4,140,400 775,900
2005 7,055,600 4,162,300 784,400
2006 7,199,700 4,236,800 798,200
2007 7,339,600 4,293,000 826,100
2008 7,313,600 4,270,100 828,200
2009 7,235,200 4,196,200 824,100
2010 7,086,500 4,053,600 840,700
2011 6,989,200 3,969,400 854,600
2012 6,945,100 3,940,800 857,800
2013 6,903,200 3,910,600 855,200
2014 6,851,000 3,864,100 856,900