excel project

profileblueamber95
C.W-EX2016-SkillReview-7-1-9-8-19.xlsx

Population Data

Population of the 10 Largest U.S. Cities
City Name Year
1970 1980 1990 2000 2010
New York, NY 7,895,563 7,811,801 7,322,564 8,008,278 8,391,881
Los Angeles, CA 2,811,801 2,968,528 3,485,398 3,694,820 3,831,868
Chicago, IL 3,369,357 3,005,072 2,783,726 2,896,016 2,851,268
Houston, TX 1,233,535 1,595,138 1,630,553 1,953,631 2,257,926
Phoenix, AZ 584,303 789,704 983,403 1,321,045 1,601,587
Philadelphia, PA 1,949,996 1,688,210 1,585,577 1,517,550 1,547,297
San Antonio, TX 654,153 785,940 935,933 1,444,646 1,373,668
San Diego, CA 697,471 875,538 1,110,549 1,223,400 1,306,301
Dallas, TX 844,401 904,599 782,248 1,188,580 1,299,543
San Jose, CA 459,913 629,400 782,248 894,943 964,695
Total US population 203,211,926 226,545,805 248,709,873 281,421,906 308,745,538

Census Data by State

# POPULATION CHANGE DATA PROVIDED BY U.S. CENSUS.
# CHANGE EXPRESSED AS PERCENTAGE (0-100).
STATE_OR_REGION 1910_POPULATION 1920_POPULATION 1930_POPULATION 1940_POPULATION 1950_POPULATION 1960_POPULATION 1970_POPULATION 1980_POPULATION 1990_POPULATION 2000_POPULATION 2010_POPULATION 1910_CHANGE 1920_CHANGE 1930_CHANGE 1940_CHANGE 1950_CHANGE 1960_CHANGE 1970_CHANGE 1980_CHANGE 1990_CHANGE 2000_CHANGE 2010_CHANGE
United States 92,228,531 106,021,568 123,202,660 132,165,129 151,325,798 179,323,175 203,211,926 226,545,805 248,709,873 281,421,906 308,745,538 21 15 16.2 7.3 14.5 18.5 13.3 11.5 9.8 13.2 9.7
Northeast 25,868,573 29,662,053 34,427,091 35,976,777 39,477,986 44,677,819 49,040,703 49,135,283 50,809,229 53,594,378 55,317,240 22.9 14.7 16.1 4.5 9.7 13.2 9.8 0.2 3.4 5.5 3.2
Midwest 29,888,542 34,019,792 38,594,100 40,143,332 44,460,762 51,619,139 56,571,663 58,865,670 59,668,632 64,392,776 66,927,001 13.5 13.8 13.4 4 10.8 16.1 9.6 4.1 1.4 7.9 3.9
South 29,389,330 33,125,803 37,857,633 41,665,901 47,197,088 54,973,113 62,795,367 75,372,362 85,445,930 100,236,820 114,555,744 19.8 12.7 14.3 10.1 13.3 16.5 14.2 20 13.4 17.3 14.3
West 7,082,086 9,213,920 12,323,836 14,379,119 20,189,962 28,053,104 34,804,193 43,172,490 52,786,082 63,197,932 71,945,553 64.4 30.1 33.8 16.7 40.4 38.9 24.1 24 22.3 19.7 13.8
Alabama 2,138,093 2,348,174 2,646,248 2,832,961 3,061,743 3,266,740 3,444,165 3,893,888 4,040,587 4,447,100 4,779,736 16.9 9.8 12.7 7.1 8.1 6.7 5.4 13.1 3.8 10.1 7.5
Alaska 64,356 55,036 59,278 72,524 128,643 226,167 300,382 401,851 550,043 626,932 710,231 1.2 -14.5 7.7 22.3 77.4 75.8 32.8 33.8 36.9 14 13.3
Arizona 204,354 334,162 435,573 499,261 749,587 1,302,161 1,770,900 2,718,215 3,665,228 5,130,632 6,392,017 66.2 63.5 30.3 14.6 50.1 73.7 36 53.5 34.8 40 24.6
Arkansas 1,574,449 1,752,204 1,854,482 1,949,387 1,909,511 1,786,272 1,923,295 2,286,435 2,350,725 2,673,400 2,915,918 20 11.3 5.8 5.1 -2 -6.5 7.7 18.9 2.8 13.7 9.1
California 2,377,549 3,426,861 5,677,251 6,907,387 10,586,223 15,717,204 19,953,134 23,667,902 29,760,021 33,871,648 37,253,956 60.1 44.1 65.7 21.7 53.3 48.5 27 18.6 25.7 13.8 10
Colorado 799,024 939,629 1,035,791 1,123,296 1,325,089 1,753,947 2,207,259 2,889,964 3,294,394 4,301,261 5,029,196 48 17.6 10.2 8.4 18 32.4 25.8 30.9 14 30.6 16.9
Connecticut 1,114,756 1,380,631 1,606,903 1,709,242 2,007,280 2,535,234 3,031,709 3,107,576 3,287,116 3,405,565 3,574,097 22.7 23.9 16.4 6.4 17.4 26.3 19.6 2.5 5.8 3.6 4.9
Delaware 202,322 223,003 238,380 266,505 318,085 446,292 548,104 594,338 666,168 783,600 897,934 9.5 10.2 6.9 11.8 19.4 40.3 22.8 8.4 12.1 17.6 14.6
District of Columbia 331,069 437,571 486,869 663,091 802,178 763,956 756,510 638,333 606,900 572,059 601,723 18.8 32.2 11.3 36.2 21 -4.8 -1 -15.6 -4.9 -5.7 5.2
Florida 752,619 968,470 1,468,211 1,897,414 2,771,305 4,951,560 6,789,443 9,746,324 12,937,926 15,982,378 18,801,310 42.4 28.7 51.6 29.2 46.1 78.7 37.1 43.6 32.7 23.5 17.6
Georgia 2,609,121 2,895,832 2,908,506 3,123,723 3,444,578 3,943,116 4,589,575 5,463,105 6,478,216 8,186,453 9,687,653 17.7 11 0.4 7.4 10.3 14.5 16.4 19 18.6 26.4 18.3
Hawaii 191,909 255,912 368,336 423,330 499,794 632,772 768,561 964,691 1,108,229 1,211,537 1,360,301 24.6 33.4 43.9 14.9 18.1 26.6 21.5 25.5 14.9 9.3 12.3
Idaho 325,594 431,866 445,032 524,873 588,637 667,191 712,567 943,935 1,006,749 1,293,953 1,567,582 101.3 32.6 3 17.9 12.1 13.3 6.8 32.5 6.7 28.5 21.1
Illinois 5,638,591 6,485,280 7,630,654 7,897,241 8,712,176 10,081,158 11,113,976 11,426,518 11,430,602 12,419,293 12,830,632 16.9 15 17.7 3.5 10.3 15.7 10.2 2.8 0 8.6 3.3
Indiana 2,700,876 2,930,390 3,238,503 3,427,796 3,934,224 4,662,498 5,193,669 5,490,224 5,544,159 6,080,485 6,483,802 7.3 8.5 10.5 5.8 14.8 18.5 11.4 5.7 1 9.7 6.6
Iowa 2,224,771 2,404,021 2,470,939 2,538,268 2,621,073 2,757,537 2,824,376 2,913,808 2,776,755 2,926,324 3,046,355 -0.3 8.1 2.8 2.7 3.3 5.2 2.4 3.2 -4.7 5.4 4.1
Kansas 1,690,949 1,769,257 1,880,999 1,801,028 1,905,299 2,178,611 2,246,578 2,363,679 2,477,574 2,688,418 2,853,118 15 4.6 6.3 -4.3 5.8 14.3 3.1 5.2 4.8 8.5 6.1
Kentucky 2,289,905 2,416,630 2,614,589 2,845,627 2,944,806 3,038,156 3,218,706 3,660,777 3,685,296 4,041,769 4,339,367 6.6 5.5 8.2 8.8 3.5 3.2 5.9 13.7 0.7 9.7 7.4
Louisiana 1,656,388 1,798,509 2,101,593 2,363,880 2,683,516 3,257,022 3,641,306 4,205,900 4,219,973 4,468,976 4,533,372 19.9 8.6 16.9 12.5 13.5 21.4 11.8 15.5 0.3 5.9 1.4
Maine 742,371 768,014 797,423 847,226 913,774 969,265 992,048 1,124,660 1,227,928 1,274,923 1,328,361 6.9 3.5 3.8 6.2 7.9 6.1 2.4 13.4 9.2 3.8 4.2
Maryland 1,295,346 1,449,661 1,631,526 1,821,244 2,343,001 3,100,689 3,922,399 4,216,975 4,781,468 5,296,486 5,773,552 9 11.9 12.5 11.6 28.6 32.3 26.5 7.5 13.4 10.8 9
Massachusetts 3,366,416 3,852,356 4,249,614 4,316,721 4,690,514 5,148,578 5,689,170 5,737,037 6,016,425 6,349,097 6,547,629 20 14.4 10.3 1.6 8.7 9.8 10.5 0.8 4.9 5.5 3.1
Michigan 2,810,173 3,668,412 4,842,325 5,256,106 6,371,766 7,823,194 8,875,083 9,262,078 9,295,297 9,938,444 9,883,640 16.1 30.5 32 8.5 21.2 22.8 13.4 4.4 0.4 6.9 -0.6
Minnesota 2,075,708 2,387,125 2,563,953 2,792,300 2,982,483 3,413,864 3,804,971 4,075,970 4,375,099 4,919,479 5,303,925 18.5 15 7.4 8.9 6.8 14.5 11.5 7.1 7.3 12.4 7.8
Mississippi 1,797,114 1,790,618 2,009,821 2,183,796 2,178,914 2,178,141 2,216,912 2,520,638 2,573,216 2,844,658 2,967,297 15.8 -0.4 12.2 8.7 -0.2 0 1.8 13.7 2.1 10.5 4.3
Missouri 3,293,335 3,404,055 3,629,367 3,784,664 3,954,653 4,319,813 4,676,501 4,916,686 5,117,073 5,595,211 5,988,927 6 3.4 6.6 4.3 4.5 9.2 8.3 5.1 4.1 9.3 7
Montana 376,053 548,889 537,606 559,456 591,024 674,767 694,409 786,690 799,065 902,195 989,415 54.5 46 -2.1 4.1 5.6 14.2 2.9 13.3 1.6 12.9 9.7
Nebraska 1,192,214 1,296,372 1,377,963 1,315,834 1,325,510 1,411,330 1,483,493 1,569,825 1,578,385 1,711,263 1,826,341 11.8 8.7 6.3 -4.5 0.7 6.5 5.1 5.8 0.5 8.4 6.7
Nevada 81,875 77,407 91,058 110,247 160,083 285,278 488,738 800,493 1,201,833 1,998,257 2,700,551 93.4 -5.5 17.6 21.1 45.2 78.2 71.3 63.8 50.1 66.3 35.1
New Hampshire 430,572 443,083 465,293 491,524 533,242 606,921 737,681 920,610 1,109,252 1,235,786 1,316,470 4.6 2.9 5 5.6 8.5 13.8 21.5 24.8 20.5 11.4 6.5
New Jersey 2,537,167 3,155,900 4,041,334 4,160,165 4,835,329 6,066,782 7,168,164 7,364,823 7,730,188 8,414,350 8,791,894 34.7 24.4 28.1 2.9 16.2 25.5 18.2 2.7 5 8.9 4.5
New Mexico 327,301 360,350 423,317 531,818 681,187 951,023 1,016,000 1,302,894 1,515,069 1,819,046 2,059,179 67.6 10.1 17.5 25.6 28.1 39.6 6.8 28.2 16.3 20.1 13.2
New York 9,113,614 10,385,227 12,588,066 13,479,142 14,830,192 16,782,304 18,236,967 17,558,072 17,990,455 18,976,457 19,378,102 25.4 14 21.2 7.1 10 13.2 8.7 -3.7 2.5 5.5 2.1
North Carolina 2,206,287 2,559,123 3,170,276 3,571,623 4,061,929 4,556,155 5,082,059 5,881,766 6,628,637 8,049,313 9,535,483 16.5 16 23.9 12.7 13.7 12.2 11.5 15.7 12.7 21.4 18.5
North Dakota 577,056 646,872 680,845 641,935 619,636 632,446 617,761 652,717 638,800 642,200 672,591 80.8 12.1 5.3 -5.7 -3.5 2.1 -2.3 5.7 -2.1 0.5 4.7
Ohio 4,767,121 5,759,394 6,646,697 6,907,612 7,946,627 9,706,397 10,652,017 10,797,630 10,847,115 11,353,140 11,536,504 14.7 20.8 15.4 3.9 15 22.1 9.7 1.4 0.5 4.7 1.6
Oklahoma 1,657,155 2,028,283 2,396,040 2,336,434 2,233,351 2,328,284 2,559,229 3,025,290 3,145,585 3,450,654 3,751,351 109.7 22.4 18.1 -2.5 -4.4 4.3 9.9 18.2 4 9.7 8.7
Oregon 672,765 783,389 953,786 1,089,684 1,521,341 1,768,687 2,091,385 2,633,105 2,842,321 3,421,399 3,831,074 62.7 16.4 21.8 14.2 39.6 16.3 18.2 25.9 7.9 20.4 12
Pennsylvania 7,665,111 8,720,017 9,631,350 9,900,180 10,498,012 11,319,366 11,793,909 11,863,895 11,881,643 12,281,054 12,702,379 21.6 13.8 10.5 2.8 6 7.8 4.2 0.6 0.1 3.4 3.4
Rhode Island 542,610 604,397 687,497 713,346 791,896 859,488 946,725 947,154 1,003,464 1,048,319 1,052,567 26.6 11.4 13.7 3.8 11 8.5 10.1 0 5.9 4.5 0.4
South Carolina 1,515,400 1,683,724 1,738,765 1,899,804 2,117,027 2,382,594 2,590,516 3,121,820 3,486,703 4,012,012 4,625,364 13.1 11.1 3.3 9.3 11.4 12.5 8.7 20.5 11.7 15.1 15.3
South Dakota 583,888 636,547 692,849 642,961 652,740 680,514 665,507 690,768 696,004 754,844 814,180 45.4 9 8.8 -7.2 1.5 4.3 -2.2 3.8 0.8 8.5 7.9
Tennessee 2,184,789 2,337,885 2,616,556 2,915,841 3,291,718 3,567,089 3,923,687 4,591,120 4,877,185 5,689,283 6,346,105 8.1 7 11.9 11.4 12.9 8.4 10 17 6.2 16.7 11.5
Texas 3,896,542 4,663,228 5,824,715 6,414,824 7,711,194 9,579,677 11,196,730 14,229,191 16,986,510 20,851,820 25,145,561 27.8 19.7 24.9 10.1 20.2 24.2 16.9 27.1 19.4 22.8 20.6
Utah 373,351 449,396 507,847 550,310 688,862 890,627 1,059,273 1,461,037 1,722,850 2,233,169 2,763,885 34.9 20.4 13 8.4 25.2 29.3 18.9 37.9 17.9 29.6 23.8
Vermont 355,956 352,428 359,611 359,231 377,747 389,881 444,330 511,456 562,758 608,827 625,741 3.6 -1 2 -0.1 5.2 3.2 14 15.1 10 8.2 2.8
Virginia 2,061,612 2,309,187 2,421,851 2,677,773 3,318,680 3,966,949 4,648,494 5,346,818 6,187,358 7,078,515 8,001,024 11.2 12 4.9 10.6 23.9 19.5 17.2 15 15.7 14.4 13
Washington 1,141,990 1,356,621 1,563,396 1,736,191 2,378,963 2,853,214 3,409,169 4,132,156 4,866,692 5,894,121 6,724,540 120.4 18.8 15.2 11.1 37 19.9 19.5 21.2 17.8 21.1 14.1
West Virginia 1,221,119 1,463,701 1,729,205 1,901,974 2,005,552 1,860,421 1,744,237 1,949,644 1,793,477 1,808,344 1,852,994 27.4 19.9 18.1 10 5.4 -7.2 -6.2 11.8 -8 0.8 2.5
Wisconsin 2,333,860 2,632,067 2,939,006 3,137,587 3,434,575 3,951,777 4,417,731 4,705,767 4,891,769 5,363,675 5,686,986 12.8 12.8 11.7 6.8 9.5 15.1 11.8 6.5 4 9.6 6
Wyoming 145,965 194,402 225,565 250,742 290,529 330,066 332,416 469,557 453,588 493,782 563,626 57.7 33.2 16 11.2 15.9 13.6 0.7 41.3 -3.4 8.9 14.1
Puerto Rico 1,118,012 1,299,809 1,543,913 1,869,255 2,210,703 2,349,544 2,712,033 3,196,520 3,522,037 3,808,610 3,725,789 17.3 16.3 18.8 21.1 18.3 6.3 15.4 17.9 10.2 8.1 -2.2