AutoSave On . Jail^J Prison Rates EXCEL PROJECT - Saved Search Marlena Rude MR X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 A" A " ap Wrap Text AutoSum General AY O Paste [ Copy Fill BIUFSA EEZ E Merge & Center $ ~ % 9 08 20 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting ~ Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity SUM X V =AVERAGE(C2:C52,D2:D52,E2:E52,F2:F52,G2:G52,H2:H52,12:152,J2:152) A B C D E F G H K L M N O P Q R S U Prison Rate/Jail Late ? Rate 1980 2 1985 1990 2 1995 2 2000 2 2005 2010 2 2015 Prison 6 126.3 236.1 313.4 385.6 377-3 372.2 312.2 2 Connecticut Rate 1980 Prison 3-3 284-5 334-7 413 500.6 472.9 440.2 440.7 3 Delaware Rate mean =AVERAGE(C2:C52,D2:D52,E2:E52,F2:F52,G2:G52, H2:H52,12:152,J2:152) Prison 89.1 105.5 120.2 106.6 128 145-2 146.3 131.9 AVERAGE(number1, [number2], [number3], [number4], [number5], [number6], [number7], [number8], [number9], ..) 4 Maine Rate standard deviation 185.13523 Prison 89.7 278.8 348.6 403.4 423-5 396.7 385 338.8 5 Maryland Rate median 291.1 Massachusetison 91.6 87.7 133.1 169.8 149 140.7 153 179.3 6 its Rate mode 227 New Prison 114.4 58.5 120.6 174.1 182 193.6 209.7 217.5 7 Hampshire Rate range New Prison 116.3 149.8 272.2 334.8 353-3 317.3 284.2 228.2 8 Jersey Rate Prison 123.2 194 304.6 369.7 369.5 323-2 291.1 260.1 9 New York Rate Pennsylvania Prison 157.8 120 187.2 265-7 299.9 341 401.6 386.7 10 a Rate NORTHEASTERN STATE PRISON RATES BY EVERY 5 YEARS Prison 208.5 83.6 120.6 177.9 215-3 249.2 263-5 206.2 11 Vermont Rate STATE 1980 1985 1990 1995 2000 2005 2010 2015 Prison 28.3 287.3 334-5 337.9 339.1 415-4 388.6 306.2 12 Alaska Rate Maine 59.5 105.5 120.2 106.6 128 145.2 146.3 131.9 Prison 35-3 259-9 374-1 457.8 491.8 525-7 599.1 595-9 Massachu 13 Arizona Rate setts 54.8 87.7 133.1 169.8 149 140.7 153 179.3 Prison 54.8 182.8 314.2 415-6 471.9 472.1 439.8 328.6 Rhode 14 California Rate Island 63.3 99.4 157.7 180.2 187.1 190.1 198.2 203.8 Prison 9-5 105-5 231.9 289.1 388.9 460.4 452 364.2 Connecti Sheet1 + Edit + 100% Type here to search O W 9 X 3:13 PM 3/30/2021