Week 5 and 6 Two Sample T Tests and ANOVA - Excel X File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. Brandon N. Pless Share do Cut AutoSum . Calibri 11 - A A Wrap Text General AY O B Copy Fill Paste Sort & Find & Format Painter BIUT Merge & Center - $ - % " Conditional Format as Cell Insert Delete Format Formatting * Table * Styles 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing C10 Nonmetropolitan A B C D F G H K M N O NCHS Urban - 2018 Average 2019 Average 2019 Financial 2018 Financial Dichotomous Urban County Rural |Jail Occupancy | Jail Occupancy % % - Rural Classification Classification Percentage Percentage Misdemeanors Misdemeanors 2 Alamance Small Metro Metropolitan 97.943 100.787 80.758 85.100 3 Alexander Medium Metro Metropolitan 61.535 59.909 76.864 74.352 Alleghany Noncore Nonmetropolitan 38.895 10.046 64.977 65.126 5 Anson Noncore Nonmetropolitan 93.597 93.644 55.207 56.684 6 Ashe Noncore Nonmetropolitan 78.292 72.727 70.833 78.711 Avery Noncore Nonmetropolitan 85.044 95.161 50.929 58.405 8 Beaufort Micropolitan Nonmetropolitan 65.359 N/A 56.250 62.121 Bertie Noncore Nonmetropolitan 38.182 95.455 77.698 82.813 10 Bladen Noncore Nonmetropolitan 54.227 48.011 71.927 73.160 11 Brunswick Medium Metro Metropolitan 81.345 74.369 81.345 81.125 12 Buncombe Medium Metro Metropolitan 37.555 88.275 48.795 55.239 13 Burke Medium Metro Metropolitan 96.157 94.503 76.801 76.449 14 Cabarrus Large Fringe Metro Metropolitan 53.465 50.526 76.594 76.500 15 Caldwell Medium Metro Metropolitan 99.760 39.955 70.195 71.570 16 Camden Micropolitan Nonmetropolitan N/A N/A 59.211 44.706 17 Carteret Micropolitan Nonmetropolitan 119.891 125.783 62.425 70.120 18 Caswell Noncore Nonmetropolitan 70.988 10.236 57.547 59.862 19 Catawba Medium Metro Metropolitan 78.799 80.460 72.831 74.128 20 Chatham Medium Metro Metropolitan 55.985 59.091 50.701 62.593 21 Cherokee Noncore Nonmetropolitan 73.611 35.778 49.462 51.768 Sheet1 + 100% Ready 8:10 PM Type here to search O e o 4/15/2023Week 5 and 6 Two Sample T Tests and ANOVA - Excel X File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. Brandon N. Pless Share do Cut Calibri 11 - A A Wrap Text AutoSum . General AY O B Copy Fill Paste $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter BIUT Merge & Center - Formatting * Table Styles 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing C10 fic Nonmetropolitan A B C D E F G H K M N O 22 Chowan Noncore Nonmetropolitan 107.246 93.281 56.234 69.595 23 Clay Noncore Nonmetropolitan 73.551 80.163 45.918 57.714 24 Cleveland Micropolitan Nonmetropolitan 38.551 96.417 74.662 76.076 25 Columbus Noncore Nonmetropolitan 81.814 34.115 70.149 71.023 26 Craven Small Metro Metropolitan 18.887 102.968 76.587 77.818 27 Cumberland Medium Metro Metropolitan 84.887 78.874 57.579 63.217 28 Currituck Large Fringe Metro Metropolitan 55.530 53.226 71.642 72.376 29 Dare Micropolitan Nonmetropolitan 65.483 58.929 86.812 84.852 30 Davidson Medium Metro Metropolitan 114.646 122.587 70.322 66.723 31 Davie Medium Metro Metropolitan 82.870 89.352 57.143 55.738 32 Duplin Noncore Nonmetropolitan 98.316 114.184 59.536 56.697 33 Durham Medium Metro Metropolitan 65.057 53.631 53.744 61.683 Edgecombe mall Metro Metropolitan 74.118 65.622 51.037 61.732 35 Forsyth Medium Metro Metropolitan 81.067 84.621 74.643 77.485 36 Franklin Large Fringe Metro Metropolitan 105.395 108.933 85.842 87.617 37 Gaston Large Fringe Metro Metropolitan 105.537 105.023 70.032 68.950 38 Gates Large Fringe Metro Metropolitan V/A N/A 40.187 32.903 39 Graham Noncore Nonmetropolitan 77.083 109.375 57.738 71.429 40 Granville Micropolitan Nonmetropolitan 88.819 95.785 71.854 73.653 41 Greene Noncore Nonmetropolitan 85.133 69.981 74.349 79.344 42 Guilford Medium Metro Metropolitan 70.077 57.865 50.566 63.188 43 Halifax Micropolitan Nonmetropolitan 104.171 87.52 72.251 75.224 44 Harnett Micropolitan Nonmetropolitan 73.585 80.022 65.152 71.978 Sheet1 + Ready 100% 8:10 PM H Type here to search O e O 4/15/2023Week 5 and 6 Two Sample T Tests and ANOVA - Excel X File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. Brandon N. Pless Share do Cut Calibri Wrap Text AutoSum . 11 - A A General AY O B Copy Fill Paste Merge & Center - Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter BIUT $ - % " Formatting * Table Styles 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing C10 fc Nonmetropolitan A B C D E F G H K M N O 45 Haywood Medium Metro Metropolitan 15.436 94.076 39.103 53.922 46 Henderson Medium Metro Metropolitan 78.303 85.285 81.757 83.804 47 Hertford Noncore Nonmetropolitan 71.830 74.506 77.858 77.308 48 Hoke Medium Metro Metropolitan 66.489 72.480 68.215 66.456 49 Hyde Noncore Nonmetropolitan V/A N/A 19.057 16.988 50 Iredell Large Fringe Metro Metropolitan 100.563 100.107 81.267 80.613 51 Jackson Micropolitan Nonmetropolitan 106.592 79.353 36.094 54.054 52 Johnston Large Fringe Metro Metropolitan 121.309 131.806 73.278 76.026 53 Jones mall Metro Metropolitan 77.976 32.540 70.748 71.264 54 Micropolitan Nonmetropolitan 91.053 99.784 73.417 78.702 55 Lenoir Micropolitan Nonmetropolitan 80.867 76.381 63.898 64.793 56 Lincoln Large Fringe Metro Metropolitan 89.137 94.881 78.679 78.091 57 Macon Micropolitan Nonmetropolitan 126.93 None 51.626 65.792 58 Madison Noncore Nonmetropolitan 89.916 92.402 76.471 73.923 59 Martin Medium Metro Metropolitan N/A V/A 68.274 72.627 60 Mcdowell Noncore Nonmetropolitan 103.860 103.265 79.677 82.299 61 Mecklenburg Large Central Metro Metropolitan 66.230 57.151 46.216 $1.836 62 Mitchell Noncore Nonmetropolitan V/A N/A 72.321 74.206 63 Montgomery Noncore Nonmetropolitan 83.208 83.154 69.984 65.842 64 Moore Micropolitan Nonmetropolitan 59.321 62.921 66.417 69.458 65 Nash `mall Metro Metropolitan 91.413 76.857 56.359 65.757 66 New Hanover Medium Metro Metropolitan 88.418 81.020 68.025 67.038 67 Northampton Micropolitan Nonmetropolitan 69.89 51.957 77.354 77.969 Sheet1 + Ready 100% 8:10 PM Type here to search O e o 4/15/2023Week 5 and 6 Two Sample T Tests and ANOVA - Excel X File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. Brandon N. Pless Share do Cut AutoSum . Calibri 11 - A A Wrap Text General AY O B Copy Fill Paste BIUT Merge & Center - $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter Formatting * Table Styles 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing C10 Nonmetropolitan B C D E F G H K M N O A 68 Onslow Small Metro Metropolitan 75.473 77.824 73.638 74.330 69 Orange Medium Metro Metropolitan 96.667 94.509 58.019 63.558 70 Pamlico Small Metro Metropolitan 107.793 None 51.217 56.975 71 Pasquotank Micropolitan Nonmetropolitan 78.556 77.566 69.082 69.192 72 Pender Medium Metro Metropolitan 50.978 54.941 54.050 58.865 73 Perquimans Micropolitan Nonmetropolitan V/A N/A 67.089 66.387 Person Medium Metro Metropolitan 72.181 77.696 56.826 62.843 75 Pitt mall Metro Metropolitan 63.916 76.133 85.728 84.413 76 Polk Noncore Nonmetropolitan 73.900 87.000 73.154 9.554 77 Randolph Medium Metro Metropolitan 145.381 141.074 67.586 70.000 78 Richmond Micropolitan Nonmetropolitan 137.374 147.083 64.997 62.797 79 Robeson Micropolitan Nonmetropolitan 79.094 82.578 57.693 70.413 80 Rockingham Medium Metro Metropolitan 76.873 33.492 54.711 65.707 81 Rowan Large Fringe Metro Metropolitan 87.409 94.219 78.797 78.563 82 Rutherford Micropolitan Nonmetropolitan 98.397 38.982 67.682 68.978 Sampson Noncore Nonmetropolitan 98.545 100.893 75.647 71.545 Scotland Micropolitan Nonmetropolitan 111.510 122.477 59.079 58.805 85 Stanly Micropolitan Nonmetropolitan 96.438 99.237 74.825 80.107 86 Stokes Medium Metro Metropolitan 52.244 70.000 68.969 62.900 87 Surry Micropolitan Nonmetropolitan 113.091 130.327 76.804 75.328 88 Swain Noncore Nonmetropolitan 75.000 89.673 54.407 68.396 89 Transylvania Micropolitan Nonmetropolitan 70.016 77.412 59.909 56.022 90 Tyrrel Micropolitan Nonmetropolitan NA N/A 41.333 44.565 Sheet1 + + 100% Ready 8:11 PM H Type here to search O e o 4/15/2023Week 5 and 6 Two Sample T Tests and ANOVA - Excel X File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. Brandon N. Pless Share do Cut Wrap Text AutoSum . Calibri 11 - A A General AY O B Copy Fill Paste $ - % " Conditional Format as Cell Insert Delete Format Sort & Find & Format Painter BIUT Merge & Center . Formatting * Table Styles 2 Clear Filter . Select Clipboard Font Alignment Number Styles Cells Editing C10 fac Nonmetropolitan B C D E F G H K M N O 79 Robeson Micropolitan Nonmetropolitan 79.094 82.578 57.693 70.413 80 Rockingham Medium Metro Metropolitan 76.873 83.492 64.711 65.707 81 Rowan Large Fringe Metro Metropolitan 37.409 94.219 78.797 78.563 82 Rutherford Micropolitan Nonmetropolitan 98.397 88.982 67.682 68.978 83 Sampson Noncore Nonmetropolitan 98.545 100.893 75.647 71.545 Scotland Micropolitan Nonmetropolitan 111.510 122.477 59.079 58.805 85 Stanly Micropolitan Nonmetropolitan 96.438 39.237 74.825 80.107 86 Stokes Medium Metro Metropolitan 52.244 70.000 68.969 62.900 87 Surry Micropolitan Nonmetropolitan 113.09 130.327 76.804 75.328 88 Swain Noncore Nonmetropolitan 75.000 89.673 64.407 68.396 89 Transylvania Micropolitan Nonmetropolitan 70.016 77.412 59.909 56.022 90 Tyrrell Micropolitan Nonmetropolitan V/A N/A 41.333 44.565 91 Union Large Fringe Metro Metropolitan 90.215 87.027 78.195 78.823 92 Vance Micropolitan Nonmetropolitan 101.126 113.514 76.169 79.602 93 Wake Large Central Metro Metropolitan 79.336 77.800 82.493 83.631 94 Warren Noncore Nonmetropolitan 112.973 116.462 78.171 82.007 95 Washington Noncore Nonmetropolitan 80.417 32.273 52.445 68.730 96 Watauga Micropolitan Nonmetropolitan 78.396 73.113 79.131 78.118 97 Wayne Small Metro Metropolitan 38.401 36.956 52.214 63.237 98 Wilkes Micropolitan Nonmetropolitan 68.598 72.386 67.005 68.857 99 Wilson Micropolitan Nonmetropolitan 66.24 None 67.147 69.24 100 Yadkin Medium Metro Metropolitan 90.924 99.587 69.863 69.843 101 Yancey Noncore Nonmetropolitan 81.395 93.217 3.200 53.519 Sheet1 + Ready + 100% 8:11 PM Type here to search O e o 4/15/2023