The datasheet Population.xlsx contains data on the populations of the 50 states
ID: 343757 • Letter: T
Question
The datasheet Population.xlsx contains data on the populations of the 50 states from 1990 to 1999.
How many records are in this database?
How many fields are in this database?
Are there any missing data?
Which state was ranked 25th in population in 1993?
Which state had the largest percentage increase in population from 1990 to 1999?
Which states had populations of more than 1 million and less than 2 million in 1995?
Createahistogramofthepopulationsbystatefor1999and interpret it.
State Populations 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 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 4048508 Alaska 619,500 615,205 608,846 604,918 601,345 600,624 596,993 587,073 569,273 553120 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 3679056 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 2354343 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 29950111 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 3303862 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 3289056 Delaware 753,538 744,066 735,024 727,090 718,265 708,416 699,475 690,158 680,495 669063 District of Columbia 519,000 521,426 528,752 538,273 551,273 564,982 576,358 584,183 593,239 603814 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 13018365 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 6506531 Hawaii 1185497 1190472 1189322 1184434 1180490 1173903 1161508 1149926 1131412 1112703 Idaho 1251700 1230923 1210638 1187706 1165000 1135459 1101204 1066490 1038915 1011882 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 11446979 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 5555097 Iowa 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 2779769 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 2480683 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 3692584 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 4219179 Maine 1253040 1247554 1245215 1241436 1237438 1237687 1238256 1235748 1235439 1231296 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 4797431 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 6018664 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 9310462 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 4387283 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 2577426 Missouri 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 5126370 Montana 882,779 879,533 878,706 876,656 868,522 854,923 839,876 822,436 807,837 799824 Nebraska 1666028 1660772 1656042 1647657 1635142 1621551 1612149 1602406 1590805 1580664 Nevada 1809253 1743772 1675581 1596476 1525777 1456388 1380197 1330694 1285046 1218629 New Hampshire 1201134 1185823 1173239 1160768 1145604 1133054 1122191 1112766 1107055 1111831 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 7757158 New Mexico 1739844 1733535 1722939 1706151 1682417 1653329 1614937 1580750 1547115 1519933 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 18002855 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 6656987 North Dakota 633,666 637,808 640,945 642,858 641,548 639,762 637,229 635,427 634,199 637364 Ohio 11,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 10861837 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 3147105 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 2858547 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 11895604 Rhode Island 990,819 987,704 986,966 987,858 989,203 993,412 997,852 1,000,571 1,003,990 1004649 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 3499064 South Dakota 733,133 730,789 730,855 730,699 728,251 723,038 716,258 708,698 701,445 696667 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 4890626 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 17044714 Utah 2129836 2100562 2065397 2022253 1976774 1930436 1875993 1821498 1771941 1729722 Vermont 593,740 590,579 588,665 586,352 582,827 578,900 574,004 570,115 567,141 564526 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 6213526 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 4900780 West Virginia 1806928 1811688 1815588 1818983 1820560 1818490 1816179 1805462 1798212 1792481 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 4902265 Wyoming 479,602 480,045 480,031 480,085 478,447 474,982 469,033 463,491 457,739 453401Explanation / Answer
>>The total number of records in the database are: 510
There are 51 records for each year and there are 10 years in total
>> There are two fields in the database. One field is year and another field is State
>> There is no missing data
>> South Carolina is ranked 25th in population in 1993
>> Nevada has the highest percenatge increase with percentage increase of 48.47%
>> Following states have population between 1 million and 2 million in 1995
Nevada Idaho Utah New Mexico New Hampshire Hawaii Nebraska Maine West VirginiaRelated Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.