Chat with us, powered by LiveChat Examine the County Complete?database. Pick three states in the same area of the country as yours, one of which is your home state. Determine one variable that - EssayAbode

## 03 Sep Examine the County Complete?database. Pick three states in the same area of the country as yours, one of which is your home state. Determine one variable that

Examine the County Complete database. Pick three states in the same area of the country as yours, one of which is your home state. Determine one variable that was not included in your workshop two analysis. Complete the following analysis:

1. Determine the mean, median, mode, standard deviation, and variance for the counties in all three states. How are they different? The same?
2. Assess each of your three variables for normality.
3. Determine a 95% confidence level for each of the three states for the mean value of counties.
4. Compare the confidence level of your home state to the actual value for your home county. Is it within the confidence limit you have calculated? If not, what could be factors causing it to be an outlier?
5. Write a short report that includes the results of your analysis. Include whatever graphs or statistical output you may have generated in answering these questions along with a short explanation of your analysis.

## Sheet1

 Sum of fed_spending Column Labels Row Labels (blank) 0-10 10-20 20-30 30-40 40-50 50-60 Grand Total Alabama 1041343 46896248 4361777 1221533 53520901 Alaska 9244326 1067022 420528 105266 10837142 Arizona 55005624 3731150 1573639 60310413 Arkansas 516622 18916589 6308308 653017 26394536 California 41375442 249651669 18254266 309281377 Colorado 8516375 33983460 774249 43274084 Connecticut 23361829 27457941 50819770 Delaware 7511530 7511530 District of Columbia 60719306 60719306 Florida 5092373 153097660 13787696 171977729 Georgia 4622785 58106386 16824800 1441482 80995453 Hawaii 16785035 1295641 18080676 Idaho 263735 12171683 428740 121324 12985482 Illinois 21622891 76147986 2935244 100706121 Indiana 6297414 45946130 3143861 55387405 Iowa 7136290 20184882 27321172 Kansas 7002091 18881283 2189707 28073081 Kentucky 1226990 34455682 15139712 2642415 224766 53689565 Louisiana 1364710 27969642 20607091 453273 114846 50509562 Maine 2629333 11188151 13817484 Maryland 68441886 5148519 17406603 90997008 Massachusetts 38089296 22198848 16051877 76340021 Michigan 22893510 34052756 27852628 84798894 Minnesota 9925352 30793964 73719 40793035 Mississippi 636426 11626651 14503323 4186057 390571 31343028 Missouri 20969042 28168242 13758167 315971 63211422 Montana 1636288 6753069 1366833 9756190 Nebraska 3359459 11887506 184125 15431090 Nevada 887786 17258167 18145953 New Hampshire 9177762 2012320 11190082 New Jersey 40640849 32488616 73129465 New Mexico 2678789 15648335 6292744 1112576 25732444 New York 37138908 67528622 79508143 184175673 North Carolina 9119153 59669818 10469824 1142486 80401281 North Dakota 3996388 4143640 349370 90334 8579732 Ohio 7793910 88292203 2508521 519275 99113909 Oklahoma 1370484 29210828 5744031 36325343 Oregon 4512756 26014825 422057 30949638 Pennsylvania 42117376 65112766 22582167 129812309 Rhode Island 4324925 6405131 10730056 South Carolina 39497073 5470478 632210 108468 45708229 South Dakota 3785666 4395855 395900 223387 222720 244464 9267992 Tennessee 1524203 53766312 6631998 240958 62163471 Texas 14238846 155135007 25230902 7644273 321208 202570236 Utah 4972054 15360424 484849 20817327 Vermont 680804 5686011 6366815 Virginia 78171548 29550023 13781199 671026 122173796 Washington 8020601 53531730 3232833 64785164 West Virginia 500076 13469761 5308319 441174 19719330 Wisconsin 11334139 37062610 166177 71642 48634568 Wyoming 4039741 708106 272995 5020842 (blank) Grand Total 615077607 1933232253 388607541 25762354 1472913 244464 2964397132