Answered step by step
Verified Expert Solution
Question
1 Approved Answer
State Populations 1999 1998 1997 1996 1995 1994 1993 1992 1991 1990 Alabama 4369862 4351037 4320281 4290403 4262731 4232965 4193114 4139269 4091025 4048508 Alaska 619500
State Populations | ||||||||||
1999 | 1998 | 1997 | 1996 | 1995 | 1994 | 1993 | 1992 | 1991 | 1990 | |
Alabama | 4369862 | 4351037 | 4320281 | 4290403 | 4262731 | 4232965 | 4193114 | 4139269 | 4091025 | 4048508 |
Alaska | 619500 | 615205 | 608846 | 604918 | 601345 | 600624 | 596993 | 587073 | 569273 | 553120 |
Arizona | 4778332 | 4667277 | 4552207 | 4432308 | 4306908 | 4147561 | 3993390 | 3867333 | 3762394 | 3679056 |
Arkansas | 2551373 | 2538202 | 2524007 | 2504858 | 2480121 | 2450605 | 2423743 | 2394098 | 2370666 | 2354343 |
California | 33145121 | 32682794 | 32217708 | 31780829 | 31493525 | 31317179 | 31147208 | 30875920 | 30414114 | 29950111 |
Colorado | 4056133 | 3968967 | 3891293 | 3812716 | 3738061 | 3653910 | 3560884 | 3459995 | 3367567 | 3303862 |
Connecticut | 3282031 | 3272563 | 3268514 | 3267030 | 3265293 | 3268346 | 3272325 | 3274997 | 3288640 | 3289056 |
Delaware | 753538 | 744066 | 735024 | 727090 | 718265 | 708416 | 699475 | 690158 | 680495 | 669063 |
District of Columbia | 519000 | 521426 | 528752 | 538273 | 551273 | 564982 | 576358 | 584183 | 593239 | 603814 |
Florida | 15111244 | 14908230 | 14683350 | 14426911 | 14185403 | 13961798 | 13713593 | 13504775 | 13289497 | 13018365 |
Georgia | 7788240 | 7636522 | 7486094 | 7332225 | 7188538 | 7045900 | 6894092 | 6759474 | 6621279 | 6506531 |
Hawaii | 1185497 | 1190472 | 1189322 | 1184434 | 1180490 | 1173903 | 1161508 | 1149926 | 1131412 | 1112703 |
Idaho | 1251700 | 1230923 | 1210638 | 1187706 | 1165000 | 1135459 | 1101204 | 1066490 | 1038915 | 1011882 |
Illinois | 12128370 | 12069774 | 12011509 | 11953003 | 11884935 | 11804986 | 11725984 | 11635197 | 11535973 | 11446979 |
Indiana | 5942901 | 5907617 | 5872370 | 5834908 | 5791819 | 5745626 | 5701965 | 5648649 | 5602062 | 5555097 |
Iowa | 2869413 | 2861025 | 2854396 | 2848473 | 2840860 | 2829422 | 2820525 | 2806923 | 2791227 | 2779769 |
Kansas | 2654052 | 2638667 | 2616339 | 2598266 | 2586942 | 2569118 | 2547605 | 2526042 | 2495209 | 2480683 |
Kentucky | 3960825 | 3934310 | 3907816 | 3881051 | 3855248 | 3823215 | 3792288 | 3756358 | 3714686 | 3692584 |
Louisiana | 4372035 | 4362758 | 4351390 | 4338763 | 4327978 | 4306500 | 4284749 | 4270849 | 4240950 | 4219179 |
Maine | 1253040 | 1247554 | 1245215 | 1241436 | 1237438 | 1237687 | 1238256 | 1235748 | 1235439 | 1231296 |
Maryland | 5171634 | 5130072 | 5092914 | 5057142 | 5023650 | 4985411 | 4942504 | 4902545 | 4856176 | 4797431 |
Massachusetts | 6175169 | 6144407 | 6115476 | 6085393 | 6062335 | 6031352 | 6010884 | 5993474 | 5998652 | 6018664 |
Michigan | 9863775 | 9820231 | 9785450 | 9739184 | 9659871 | 9584481 | 9529240 | 9470323 | 9395022 | 9310462 |
Minnesota | 4775508 | 4726411 | 4687726 | 4647723 | 4605445 | 4566028 | 4521709 | 4471503 | 4427429 | 4387283 |
Mississippi | 2768619 | 2751335 | 2731826 | 2709925 | 2690788 | 2663450 | 2635574 | 2610193 | 2591230 | 2577426 |
Missouri | 5468338 | 5437562 | 5407113 | 5367888 | 5324610 | 5281206 | 5237757 | 5193686 | 5157770 | 5126370 |
Montana | 882779 | 879533 | 878706 | 876656 | 868522 | 854923 | 839876 | 822436 | 807837 | 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 | 8143412 | 8095542 | 8054178 | 8009624 | 7965523 | 7918796 | 7874891 | 7827770 | 7784269 | 7757158 |
New Mexico | 1739844 | 1733535 | 1722939 | 1706151 | 1682417 | 1653329 | 1614937 | 1580750 | 1547115 | 1519933 |
New York | 18196601 | 18159175 | 18143184 | 18143805 | 18150928 | 18156652 | 18140894 | 18082032 | 18029532 | 18002855 |
North Carolina | 7650789 | 7545828 | 7428672 | 7307658 | 7185403 | 7060959 | 6947412 | 6831850 | 6748135 | 6656987 |
North Dakota | 633666 | 637808 | 640945 | 642858 | 641548 | 639762 | 637229 | 635427 | 634199 | 637364 |
Ohio | 11256654 | 11237752 | 11212498 | 11187032 | 11155493 | 11111451 | 11070385 | 11007609 | 10933683 | 10861837 |
Oklahoma | 3358044 | 3339478 | 3314259 | 3289634 | 3265547 | 3246119 | 3228829 | 3204174 | 3166471 | 3147105 |
Oregon | 3316154 | 3282055 | 3243254 | 3195087 | 3141421 | 3087142 | 3034490 | 2973934 | 2918745 | 2858547 |
Pennsylvania | 11994016 | 12002329 | 12015888 | 12038008 | 12044780 | 12042545 | 12022128 | 11980819 | 11943160 | 11895604 |
Rhode Island | 990819 | 987704 | 986966 | 987858 | 989203 | 993412 | 997852 | 1000571 | 1003990 | 1004649 |
South Carolina | 3885736 | 3839578 | 3790066 | 3738974 | 3699943 | 3666456 | 3634507 | 3600576 | 3559470 | 3499064 |
South Dakota | 733133 | 730789 | 730855 | 730699 | 728251 | 723038 | 716258 | 708698 | 701445 | 696667 |
Tennessee | 5483535 | 5432679 | 5378433 | 5313576 | 5241168 | 5163016 | 5085666 | 5013999 | 4946886 | 4890626 |
Texas | 20044141 | 19712389 | 19355427 | 19006240 | 18679706 | 18338319 | 17996764 | 17650479 | 17339904 | 17044714 |
Utah | 2129836 | 2100562 | 2065397 | 2022253 | 1976774 | 1930436 | 1875993 | 1821498 | 1771941 | 1729722 |
Vermont | 593740 | 590579 | 588665 | 586352 | 582827 | 578900 | 574004 | 570115 | 567141 | 564526 |
Virginia | 6872912 | 6789225 | 6732878 | 6665491 | 6601392 | 6536771 | 6464795 | 6383315 | 6283853 | 6213526 |
Washington | 5756361 | 5687832 | 5604105 | 5509963 | 5431024 | 5334896 | 5247704 | 5139011 | 5013443 | 4900780 |
West Virginia | 1806928 | 1811688 | 1815588 | 1818983 | 1820560 | 1818490 | 1816179 | 1805462 | 1798212 | 1792481 |
Wisconsin | 5250446 | 5222124 | 5200235 | 5173828 | 5137004 | 5095504 | 5055318 | 5004636 | 4952675 | 4902265 |
Wyoming | 479602 | 480045 | 480031 | 480085 | 478447 | 474982 | 469033 | 463491 | 457739 | 453401 |
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started