B D N State Populations State 19! 19 19! 6L 61 6L 19 19 19% abs growth * % growth Nevada 1,809,253 1,743,772 1,675,581 1,596,476 1,525,777 1,456,388 1,380, 197 1,330,694 1,285,046 1,218,629 590,624 0.4847 Arizona 4,778,332 4,667,277 4,552,207 4,432,308 4,306,908 4,147,561 3,993,390 3,867,333 3,762,394 3,679,056 1,099,276 0.298 Idaho 1,251,700 1,230,923 1,210,638 1,187,706 1,165,000 1,135,459 1,101,204 1,066,490 1,038,915 1,011,882 239,818 0.2370 Utah 2,129,836 2,100,562 2,065,397 2,022,253 1,976,774 1,930,436 1,875,993 1,821,498 1,771,941 1,729,722 400, 114 0.2313 Colorado 4,056,133 3,968,967 3,891,293 3,812,716 3,738,061 3,653,910 3,560,884 3,459,995 3,367,567 3,303,862 752,271 0.2277 Georgia 7,788,240 7,636,522 7,486,094 7,332,225 7,188,538 7,045,900 6,894,092 6,759,474 6,621,279 6,506,531 1,281,709 0.1970 Texas 20,044,141 19,712,389 19,355,427 19,006,240 18,679,706 18,338,319 17,996,764 17,650,479 17,339,904 17,044,714 2,999,427 0.1760 Washington 5,756,361 5,687,832 5,604,105 5,509,963 5,431,024 5,334,896 5,247,704 5,139,011 5,013,443 4,900,780 855,581 0.1746 Florida 15,111,244 14,908,230 14,683,350 14,426,911 14,185,403 13,961,798 13,713,593 13,504,775 13,289,497 13,018,365 2,092,879 0.1608 Oregon 3,316,154 3,282,055 3,243,254 3,195,087 3,141,421 3,087,142 3,034,490 2,973,934 2,918,745 2,858,547 457,607 0.1601 North Carolina 7,650,789 7,545,828 7,428,672 7,307,658 7,185,403 7,060,959 6,947,412 6,831,850 6,748, 135 6,656,987 193,802 0.1493 New Mexico 1,739,844 1,733,535 1,722,939 1,706, 151 1,682,417 1,653,329 1,614,937 1,580,750 1,547,115 1,519,933 219,911 0.1447 Delaware 753,538 744,066 735,024 727,090 718,265 708,416 699,475 690,158 680,495 669,063 84,475 0.1263 Tennessee 5,483,535 5,432,679 5,378,433 5,313,576 5,241,168 5,163,016 5,085,666 5,013,999 4,946,886 4,890,626 92,909 0.1212 Alaska 619,500 615,205 608,846 604,918 601,345 600,624 596,993 587,073 569,273 553,120 $6,380 .1200 South Carolina 3,885,736 3,839,578 3,790,066 3,738,974 3,699,943 3,666,456 3,634,507 3,600,576 3,559,470 3,499,064 386,672 0.1105 California 33,145,121 32,682,794 32,217,708 31,780,829 31,493,525 31,317,179 31,147,208 30,875,920 30,414,114 29,950,111 3, 195,010 0.1067 Virginia 6,872,912 6,789,225 6,732,878 6,665,491 6,601,392 6,536,771 6,464,795 6,383,315 6,283,853 6,213,526 59,386 0.1061 Montana 882,779 879,533 878,706 876,656 868,522 854,923 839,876 822,436 807,837 799,824 82,955 0.1037 Minnesota 4,775,508 4,726,411 4,687,726 4,647,723 4,605,445 4,566,028 4,521,709 4,471,503 4,427,429 4,387,283 388,225 0.088 Arkansas 2,551,373 2,538,202 2,524,007 2,504,858 2,480,121 2,450,605 2,423,743 2,394,098 2,370,666 2,354,343 197,030 0.0837 New Hampshire 1,201,134 1,185,823 1,173,239 1,160,768 1,145,604 1,133,054 1,122,191 1,112,766 1,107,055 1,111,831 89,303 0.080 Alabama 4,369,862 4,351,037 4,320,281 4,290,403 4,262,731 4,232,965 4,193,114 4,139,269 4,091,025 4,048,508 321,354 0.0794 Maryland 5,171,634 5,130,072 5,092.914 5,057,142 5,023,650 4,985,411 4,942,504 4,902,545 4,856, 176 4,797,431 374,203 0.0780 Mississippi 2,768,619 2,751,335 2,731,826 2,709,925 2,690,788 2,663,450 2,635,574 2,610,193 2,591,230 2,577,426 191,193 0.0742 Kentucky 3,960,825 3,934,310 3,907,816 3,881,051 3,855,248 3,823,215 3,792,288 3,756,358 3,714,686 3,692,584 268,241 0.0726 Wisconsin 5,250,446 5,222,124 5,200,235 5,173,828 5,137,004 5,095,504 5,055,318 5,004,636 4,952,675 4,902,265 348, 181 0.0710 Kansas 2,654,052 2,638,667 2,616,339 2,598,266 2,586,942 2,569, 118 2,547,605 2,526,042 2,495,209 2,480,683 173,369 0.0699 Indiana 5,942,901 5,907,617 5,872,370 5,834,908 5,791,819 5,745,626 5,701,965 5,648,649 5,602,062 5,555,097 387,804 0.0698 Oklahoma 3,358,044 3,339,478 3,314,259 3,289,634 3,265,547 3,246,119 3,228,829 3,204,174 3,166,471 3,147,105 210,939 0.0670 Miss our 5,468,338 5,437,562 5,407,113 5,367,888 5,324,610 5,281,206 5,237,757 5,193,686 5,157,770 5,126,370 341,968 0.0667 Hawai 1,185,497 1,190,472 1,189,322 1,184,434 1,180,490 1,173,903 1,161,508 1,149,926 1,131,412 1,112,703 72,794 0.0654 Illinois 12,128,370 12,069,774 12,011,509 11,953,003 11,884,935 11,804,986 11,725,984 11,635,197 11,535,973 11,446,979 81,391 0.0595 Michigan 9,863,775 9.820,231 9,785,450 9,739, 184 9,659,871 9,584,481 9.529,240 9,470,323 9,395,022 9,310,462 53,313 0.0594 Wyoming 479,602 480,045 480,031 480,085 478,447 474,982 469,033 463,491 457,739 453,401 26,201 0.0578 Nebraska 1,666,028 1,660,772 1,656,042 1,647,657 1,635,142 1,621,551 1,612,149 1,602,406 1,590,805 1,580,664 85,364 0.0540 South Dakota 733,133 730,789 730,855 730,699 728,251 723,038 716,258 708,698 701,445 696,667 36,466 0.0523 Vermont 593,740 590,579 588,665 586,352 582,827 578,900 574,004 570,115 567,141 564,526 29,214 0.0517 New Jersey 8,143,412 8,095,542 8,054,178 8,009,624 7,965,523 7,918,796 7,874,891 7,827,770 7,784,269 7.757,158 386,254 0.0498 Ohio 1,256,654 11,237,752 11,212,498 11,187,032 11,155,493 11,111,451 11,070,385 11,007,609 10,933,683 10,861,837 394,817 0.0363 Louisiana 4,372,035 4,362,758 4,351,390 4,338,763 4,327,978 4,306,500 4,284,749 4,270,849 4,240,950 4,219,179 52,856 0.0362 lowa 2,869,413 2,861,025 2,854,396 2,848,473 2,840,860 2,829,422 2,820,525 2,806,923 2,791,227 2,779,769 89,644 0.0322 Massachusetts 6,175,169 6,144,407 6,115,476 6,085,393 6,062,335 6,031,352 6,010,884 5,993,474 5,998,652 6,018,664 56,505 0.0260 Maine 1,253,040 1,247,554 1,245,215 1,241,436 1,237,438 1,237,687 1,238,256 1,235,748 1,235,439 1,231,296 21,744 0.0177 New York 18,196,601 18,159,175 18,143,184 18,143,805 18,150,928 18,156,652 18,140,894 18,082,032 18,029,532 18,002,855 93,746 0.0108 Pennsylvania 11,994,016 12,002,329 12,015,888 12,038,008 12,044,780 12,042,545 12,022,128 11,980,819 11,943,160 11,895,604 98,412 0.0083 West Virginia 1,806,928 1,811,688 1,815,588 1,818,983 1,820,560 1,818,490 1,816,179 1,805,462 1,798,212 1,792,481 14,447 0.0081 Connecticut 3,282,031 3,272,563 3,268,514 3,267,030 3,265,293 3,268,346 3,272,325 3,274,997 3,288,640 3,289,056 -7,025 0.0021 North Dakota 633,666 637,808 640,945 642,858 641,548 639,762 637,229 635,427 634,199 637,364 -3,698 0.0058 Rhode Island 990,819 987,704 986,966 987,858 989,203 993,412 997,852 1,000,571 1,003,990 1,004,649 13,830 0.0138 District of Columbia 19,000 521,426 528,752 538,273 551,273 564,982 576,358 584,183 593,239 603,814 84,814 0.1405 Averages with DC 5,346,879 5,298,980 5,250.659 5,200,560 5,153,005 5,104,451 5,054.561 5,000,582 4.944,178 4,891,459 w/out DC 5,443,436 5,394,532 5,345,097 5,293,806 5,245,040 5,195,241 5,144.125 5,088,910 5,031,197 4,977,212 Differences w/ DC 47,898 96,220 146,318 193,873 242,427 292,318 346,296 402,700 455,420 w/out DC 48,905 98,339 149,630 198,396 248,195 299,311 354,526 412,239 466,225E H Exercise 5-3 a. How many records are in the dataset? b. How many fields are in the database? c. Are there any missing data? Hint: Use COUNTBLANK on all columns d. What state was ranked 25th in population in 1993? Hint: Use MATCH(Large(H3:H53,25,H3:H53,0) e. What state had the largest percentage increase in population from 1990 to 19997 Hint: Create new column for the percentage increase 1999 over 1900 and sort. f. Which states had populations of more than 1 million and less than 2 million in 19957 Hint: Use FILTER on population 1995 and use the Number filter option to specify upper and lower limits. g. Create a histogram of the population by state for 1999 and interpet it. Interpretation