As per your choice, choose a random subset of data from this large database. The subset will that you select at random will contain 15 states and their associated data.

 

Using the data for your 15 selected states, from 2001 - 2010, do the following:

 

1. Present a summary spreadsheet of the data that you selected.
2. Present a graph of your choice using excel charts, that offers a data visualization format that will be understood by the meeting attendees that you will be presenting this data to. 
3. In chart form using excel, present a variance analysis for each of the 15 states that you selected, comparing the median income of each state to the median income for the United States.
4. Using excel, present a vertical bar chart that displays the comparison of the median income of each of your selected states to the median US income.
5. Using excel, structure a new excel spreadsheet that adds 10% to the median income of each state. Label the spreadsheet and present this additional spreadsheet.
6. Present a comparative analysis vertical bar chart that compares the original median income for each state to the median income with the 10% add-on.

 

2010 2009 (36) 2008 2007 2006 2005 2004 (35) 2003 2002 2001 2000 (30) 1999 (29) 1998 State Median income Median income Median income Median income Median income Median income Median Median Median income Median income Median Median Median 1997 Median 1996 Median 1995 (25) 1994 (24) 1993 (23) 1992 (22) 1991 1990 1989 1988 1987 (21) Median Median Median Median Median Median Median Median Median 1986 Median 1985 (20) 1984 (19) Median Median income income income income income income income income income income income income income income income income income income income United States Alabama Alaska 49,445 40,976 50,599 50,939 52,823 52,124 51,739 51,174 51,353 51,398 52,005 53,164 53,252 51,944 50,123 49,112 48,408 46,937 46,419 46,646 47,032 48,423 49,076 48,216 47,848 47,256 45,640 44,802 40,640 45,039 44,388 41,041 41,491 42,280 44,165 45,573 43,301 44,851 47,436 48,445 43,261 41,930 36,922 39,565 37,268 39,295 38,009 37,772 36,135 35,328 36,232 36,313 35,427 34,598 58,198 62.621 64.798 66,241 61,010 62,422 63,559 61,452 63,960 70,645 66.910 67,254 67,716 65,007 73.033 68,123 66,000 63,789 63,647 63,403 63,552 61,130 58,626 61,016 59,515 67,213 64,672 Arizona Arkansas California Colorado Connecticut 47,279 46,494 47,507 49,649 50,454 50,532 50,611 48,802 48,156 52,592 50,370 48,409 49,546 44,346 43,778 43,844 45,525 45,333 44,700 47,986 47,260 48,475 46,817 49,111 48,400 46,140 42,823 38,571 37,141 40,087 42,898 40,073 40,941 40,382 37,938 39,252 41,058 37,600 38,840 36,956 35,436 37,531 36,671 37,192 34,232 36,362 36,586 36,849 36,388 35,725 34,567 35,550 33,722 31,328 54,459 57,061 57,735 58,608 59,821 57,802 56,816 58,445 57,492 58,205 59,274 57,090 54,681 53,765 53,706 52,574 51,399 50,627 53,143 52,556 53,836 56,042 53,639 55,348 55,062 52,138 50,542 60,442 56,853 61,714 64,293 60,230 56,344 58,737 59,203 58,530 60,834 61,077 63,042 62,249 58,558 56,665 57,826 55,039 51,244 49,460 49,176 49,701 45,511 46,425 48,610 51,612 54,459 51,570 66,452 65,922 65,500 67,448 67,483 63,476 63,601 65,160 64,703 65,699 63,523 66,203 62,127 59,577 58,282 57,169 59,788 58,715 62,184 65,810 62,859 71,851 64,134 60,335 62,106 60,079 59,865 Delaware 55,269 52,974 51,343 57,404 56,706 57,222 55,462 58,111 60,174 61,087 63,768 61,015 55,381 58,288 54,394 49,618 52,188 53,586 54,323 50,871 49,815 54,444 54,025 53,692 48,639 44,407 51,606 District of Columbia 55,528 54,018 56,293 53,401 52,423 50,250 50,155 53,399 47,351 50,701 52,192 50,601 44,661 43,154 44,233 43,680 43,813 40,570 46,054 46,656 44,298 45,419 47,359 50,408 46,164 40,727 40,791 Florida 44,243 46,384 45,424 48,155 49,394 48,013 46,789 46,201 46,084 44,854 49,196 46,886 46,633 43,960 42,400 42.255 42,617 42,421 41,641 42,546 43,154 44,286 44,994 44,962 43,368 41,243 39,545 Georgia 44,108 44,055 46,812 51,149 53,360 51,292 47,307 50,310 52,040 52,434 53,051 51,589 51,650 49,659 44,966 48,441 45,778 47,046 43,846 42,483 44,571 46,760 47,049 49,047 46,255 40,675 39,943 Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisianal 58,507 56,568 62,299 67,323 65,392 66,548 64,920 61,449 57,329 58,423 65,263 58,235 54,538 55,444 57,802 60,874 61,472 63,389 64,121 58,148 62,942 59,481 58,486 64,301 55,049 55,964 57,718 47,014 47,550 48,020 51,720 49,974 49,338 51,202 50,231 45,709 47,095 47,620 46,846 48,998 45,245 48,029 46,419 45,878 46,076 42,182 40,772 40,923 41,857 41,530 38,106 39,383 40,119 42,158 50,761 53,743 53,928 55,213 52,632 54,053 53,186 53,528 51,763 56,861 58,322 60,625 57,679 55,917 54,733 54,083 51,036 48,820 48,039 49,777 52,626 53,140 52,288 49,726 50,319 48,059 47,474 46,322 45,036 47,108 49,900 49,103 47,396 48,860 50.294 49,747 49,728 51,740 53,438 53,074 52,675 48,635 47,426 40,528 43,795 43,439 42,291 43,547 43,969 46,565 41,345 43,139 43,817 45,512 49,177 51,558 50,776 51,430 52,043 51,933 50,086 49,060 49,750 50,464 51,899 53,778 49,451 45,759 45,953 50,458 48,123 42,589 43,764 44,577 44.129 44,592 43,045 40,741 42,628 40,440 39,701 46,229 45,455 48,483 50,998 49,260 46,938 47,402 52,436 51,653 51,004 51,985 48,871 49,040 49,399 45,090 43,102 41,203 44,234 46,204 45,735 48,381 45,606 45,278 46,971 45,413 44,036 49,227 41,236 43,368 41,669 41,486 42,699 40,987 41,104 43,787 44,554 47,337 45,916 44,148 48,427 45,310 44,852 42,348 38,690 36,219 35,758 37,100 40,074 39,529 35,256 37,956 37,722 33,549 35,338 39,443 46,183 40,063 43,443 39,458 41,587 42,050 39,722 41,216 41,037 38,892 42,729 42,393 45,050 41,875 39,704 37,353 39,096 38,733 39,497 36,233 38,813 36,301 39,197 39,650 40,926 37,874 Maine 48,133 48,286 47,825 50,363 49,357 49,055 47,706 43,997 44,664 45,089 47,183 50,853 47,609 44,389 48,011 48,098 44,104 40,769 45,094 43,507 44,414 47,913 46,758 43,330 44,460 39,651 41,270 Maryland 64,025 65,246 64,517 69,014 68,850 67,583 65,913 62,018 68,363 65,924 69,047 68,312 66,813 63,234 60,875 58,302 57,025 59,343 56,645 57,689 62,838 61,147 64,734 64,205 58,088 58,235 59,379 Massachusetts 61,333 60,353 61,083 61,477 59,833 62,562 60,045 60,406 60,422 64,352 59,195 57,582 56,566 56,919 54,650 54,798 58,919 55,071 55,360 55,756 58,618 61,266 58,821 59,195 57,585 54,507 53,884 Michigan 46,441 46,753 50,418 51,916 52,606 51,300 48,776 53,373 51,769 55,477 57,623 60,309 55,866 52,475 54,278 51,746 51,331 48,531 49,129 50,141 48,413 52,249 52,195 50,861 50,497 46,845 45,901 Minnesota 52,554 57,016 55,620 61,051 60,786 60,550 64,760 62.621 66,200 64,879 68,688 61,551 64,021 57,652 56,721 53,887 48,945 50,046 47,171 46,022 50,884 51,247 51,514 51,559 50,190 46,100 48,841 Mississippi Missouri Montana 37,985 35,657 36,907 39,201 37,560 36,716 40,117 38,799 37,428 37,144 43,426 42,499 38,900 38,601 36,914 37,700 36,952 32,972 31,320 30,404 32,631 33,815 32,172 33,990 31,342 31,717 30,841 46,184 49,574 46,620 48,377 48,207 48,009 48,638 51,879 51,843 50,911 57,098 54,151 53,702 49,510 47,414 49,472 43,920 42,617 41,659 43,598 44,201 44,986 41,518 43,550 41,615 42,395 41,524 41,467 41,105 43,443 45,906 44,451 41,673 39,195 40,435 42,219 39,564 41,499 40,614 42,182 39,567 39,692 39,431 40,197 39,330 40,387 38,760 37,801 40,224 39,371 37,590 38,583 39,104 39,048 Nebraska 52,728 50,414 51,370 51,709 52,064 53,523 50,542 52,131 51,867 53,709 52,860 50,544 48,642 46,990 47,067 46,778 46,254 46,073 45,751 46,132 44,443 44,684 44,557 42,720 41,324 42,125 42,767 Nevada 51,525 52,283 55,437 56,845 56,537 53,842 54,487 53,565 54,487 55,916 57,935 54,253 53,108 52,627 53,330 51,260 52,185 53,214 48,583 51,421 51,787 49,813 49,558 49,348 49,761 44,975 51,520 New Hampshire 66,707 65,190 67,013 71,060 67,014 63,642 65,581 65,874 67,047 63,216 64,478 60,265 60,057 55,531 54,529 55,646 51,274 56,409 60,045 56,253 65,989 63,721 61,321 59,373 57,981 51,021 51,796 New Jersey 63,540 65,846 66,132 63,628 73,598 70,772 63,803 66,441 66,134 63,758 63,818 65,079 66,559 65,044 65,684 62,398 61,509 60,177 59,381 62,524 62,640 66,417 64,265 62,867 60,196 59,866 55,517 New Mexico 45,098 44,261 42,635 46,643 43,286 43,498 45,666 41,617 42,972 40,793 44,432 42,624 42,136 40,751 34,713 36.922 39,141 39,758 39,374 41,434 40,492 38,373 34,174 38,112 37,667 39,466 41,234 New York 49,826 51,045 51,099 51,468 52,147 52,688 51,538 50,725 50,861 51,865 51,587 52,327 49,952 48,488 48,999 46,919 46,406 47,097 47,278 49,636 51,088 53,473 51,209 48,441 47,499 45,680 44,027 North Carolina 43,753 42,598 43,473 45,757 43,036 46,970 46,446 44,194 44,255 46,998 48,514 48,748 47,874 48,545 49,263 45,429 43,810 42,822 42,284 41,923 42,579 44,831 43,239 41,788 41,493 41,452 41,112 North Dakota 51,380 50,902 50,259 49,639 44,388 47,122 45,271 47,906 43,873 44,080 45,575 42,741 40,481 42,884 43,547 41,323 41,139 41,779 41,047 40,422 40,856 42,833 42,667 41,450 40,823 40,977 41,516 Ohio 46,093 46,636 47,528 51,631 49,636 49,368 49,698 51,592 51,731 51,460 54,395 51,673 51,997 48,943 47,144 49,637 46,342 46,485 47,815 46,508 48,536 49,271 49,128 47,319 47,669 48,646 46,217 Oklahoma 43,400 46,635 46,694 45,444 41,999 42,044 45,726 42,561 44,186 43,854 41,063 42,767 45,054 42,464 37,966 37,377 39,266 39,018 38,497 39,751 39,433 40,181 41,915 39,825 39,760 40,977 42,270 Oregon Pennsylvania 50,526 49,909 52,381 52,826 50,924 49,319 47,319 49,361 50,662 50,829 53,809 53,152 52,187 50,450 49,112 51,672 45,762 49,238 48,612 47,132 47,352 48,436 49,142 45,970 47,020 42,308 42,771 48,460 48,967 52,052 50,934 52,423 51,710 50,911 50,897 51,506 53,571 53,400 49,408 52,118 50,816 48,292 49,044 46,649 46,054 45,498 47,409 46,906 48,709 47,361 46,679 45,187 44,208 40,667 Rhode Island 51,914 52.486 53,915 57,005 58,110 55,266 55,331 53,004 51,408 56,310 53,426 55,900 54,350 47,132 51,179 50,230 46,449 49,789 46,335 48,141 51.698 51,144 52,851 51,944 50,374 47,586 43,197 South Carolina 41,709 41,779 42,688 46,493 42,841 44,931 44,661 45,616 45,827 46,473 47,568 47,712 44,439 46,407 47,968 41,298 43,420 38,711 41,990 42,875 46,469 40,404 45,219 45,990 41,696 38,718 40,593 South Dakota 45,669 46,582 52,253 48,811 49,124 48,193 47,449 46,853 45,901 48,856 46.181 46,882 43,797 40,220 40,857 42,018 43,255 41,213 39,982 38,466 39,736 40,930 39,483 38,833 37,767 35,058 38,794 Tennessee 38,686 41,186 40,204 43,319 44,005 44,010 43,946 44,483 44,879 44,068 43,169 47,791 45,540 41,496 42,606 41,218 41,664 37,298 37,026 38,176 36,535 38,388 36,936 38,885 34,651 34,354 33,543 Texas 47,464 48,259 47,078 48,427 46,832 46,262 47,784 46,555 48,659 50,321 48,883 50,625 47,800 47,509 45,763 45,514 44,742 42,684 42,561 43,296 45,650 43,949 44,210 45,388 45,861 45,881 46,019 Utah 56,787 59,457 63,328 56,289 59,074 61,218 58,720 58,415 58,006 58,303 60,204 60,258 59,176 57,938 51,251 51.823 51,959 53,173 52,150 43,738 48,745 52,150 46,601 48,707 49,882 48,770 46,085 Vermont Virginia 55,942 53,182 51,347 49,833 56,212 56,629 54,631 51,285 52,113 50,239 50,130 54,414 52,595 47,479 44,775 48.050 52,085 46,158 49,872 45.516 50,291 53,132 51,338 46,662 46,690 50,243 45,128 60,363 61,500 62,769 62,211 61,768 57,980 59,032 64,945 60,151 61,874 59,714 59,791 57,914 58,185 54,258 51,456 54,769 54,134 58,160 56,417 56,719 57,925 57,820 55,073 56,400 54,936 53,017 Washington West Virginia. 56,253 61,389 57,347 61,075 59,177 56,564 57,624 56,320 54,760 52,328 53,841 59,503 63.347 60,359 50,750 50,527 48,784 52,978 51,616 53,034 51,931 54,263 57,252 50,158 51,021 46,378 50,003 42,839 41,158 38,475 44,261 41,546 40,703 38.522 38,840 35,582 36,543 37,238 38,336 35,672 37,232 34,936 35,344 34,281 33,314 30,864 36,137 35,799 36,803 34.275 31,592 31,249 30,886 33,665 Wisconsin 50,522 52,083 51,848 53,921 Wyoming 52,359 53,336 54,012 51,257 55,899 50,870 49,867 52,788 54,851 55,633 55,845 57,087 59,757 55,206 53,631 55,351 58,180 51,482 47,199 50,714 48,605 49,665 49,444 52,378 48,414 50,165 44,921 41,460 49,943 52,401 50,448 48,191 48,915 50,175 48,741 47,088 45,271 42,831 44,790 48,212 43,746 45,996 45,353 47,642 50,120 46,789 50,655 44,716 42,670 47,602 For footnotes, see www.census.gov/hhes/www/income/histinc/ftnotes.html For suggested citations, see www.census.gov/main/www/citation.html Source: U.S. Census Bureau, Current Population Survey, Annual Social and Economic Supplements. For information on confidentiality protection, sampling error, nonsampling error, and definitions, see www.census.gov/apsd/techdoc/cps/cpsmar11.pdf[PDF].