In: Statistics and Probability
state | GDP (millions of dollars) | 2015pop |
Alabama | 207303 | 4862058 |
Alaska | 54256 | 736130 |
Arizona | 295445 | 6816049 |
Arkansas | 122492 | 2972524 |
California | 2424033 | 39124308 |
Colorado | 316535 | 5429368 |
Connecticut | 259661 | 3593690 |
Delaware | 66150 | 944664 |
Florida | 883735 | 20150420 |
Georgia | 496180 | 10186225 |
Hawaii | 79595 | 1428650 |
Idaho | 65202 | 1653347 |
Illinois | 764817 | 12869625 |
Indiana | 326538 | 6618616 |
Iowa | 168089 | 3119552 |
Kansas | 146219 | 2910710 |
Kentucky | 192874 | 4424845 |
Louisiana | 252965 | 4666799 |
Maine | 55137 | 1331057 |
Maryland | 360969 | 6008550 |
Massachusetts | 473606 | 6776251 |
Michigan | 462252 | 9918381 |
Minnesota | 330782 | 5487040 |
Mississippi | 106880 | 2995225 |
Missouri | 287207 | 6078884 |
Montana | 45799 | 1031080 |
Nebraska | 112208 | 1892208 |
Nevada | 140608 | 2880996 |
New Hampshire | 71632 | 1330250 |
New Jersey | 573947 | 8960072 |
New Mexico | 90810 | 2084090 |
New York | 1444406 | 19787315 |
North Carolina | 503745 | 10026169 |
North Dakota | 53686 | 753317 |
Ohio | 592899 | 11611559 |
Oklahoma | 181089 | 3899322 |
Oregon | 225661 | 4006827 |
Pennsylvania | 677582 | 12790083 |
Rhode Island | 56323 | 1056571 |
South Carolina | 196887 | 4885343 |
South Dakota | 45415 | 859781 |
Tennessee | 307125 | 6594129 |
Texas | 1648007 | 27354011 |
Utah | 146697 | 2977970 |
Vermont | 29750 | 626186 |
Virginia | 476919 | 8374081 |
Washington | 446096 | 7138029 |
West Virginia | 71123 | 1847153 |
Wisconsin | 296971 | 5769285 |
Wyoming | 40170 | 584861 |
Here is the data set for the questions.
1 a. Filter the list of states to a list of states that have more than 500,000 million US dollars. (Select all that apply.)
1 b. Find the difference between each state's GDP and the average GDP you calculated by subtracting the average GDP from each state's GDP. (Round your answers to the nearest integer.)
Im fine with you uploading excel data sheets for the answers.
1.(A)
THE FILTERED DATA SET FOR STATES HAVING GDP MORE THAN 500000 MILLION DOLLAR IS GIVEN BY
STATE | GDP (millions of dollars) | 2015 POP |
California | 2424033 | 39124308 |
Texas | 1648007 | 27354011 |
New York | 1444406 | 19787315 |
Florida | 883735 | 20150420 |
Illinois | 764817 | 12869625 |
Pennsylvania | 677582 | 12790083 |
Ohio | 592899 | 11611559 |
New Jersey | 573947 | 8960072 |
North Carolina | 503745 | 10026169 |
1 (B)
THE EXCEL SHEET FOR THE DIFFERENCE BETWEEN EACH STATE'S GDP AND THE AVERAGE GDP OF STATES IS GIVEN BY
STATE | GDP (millions of dollars) | 2015 POP | DIFFERENCE IN GDP | |
Alabama | 207303 | 4862058 | -146186.54 | |
Alaska | 54256 | 736130 | -299233.54 | |
Arizona | 295445 | 6816049 | -58044.54 | |
Arkansas | 122492 | 2972524 | -230997.54 | |
California | 2424033 | 39124308 | 2070543.46 | |
Colorado | 316535 | 5429368 | -36954.54 | |
Connecticut | 259661 | 3593690 | -93828.54 | |
Delaware | 66150 | 944664 | -287339.54 | |
Florida | 883735 | 20150420 | 530245.46 | |
Georgia | 496180 | 10186225 | 142690.46 | |
Hawaii | 79595 | 1428650 | -273894.54 | |
Idaho | 65202 | 1653347 | -288287.54 | |
Illinois | 764817 | 12869625 | 411327.46 | |
Indiana | 326538 | 6618616 | -26951.54 | |
Iowa | 168089 | 3119552 | -185400.54 | |
Kansas | 146219 | 2910710 | -207270.54 | |
Kentucky | 192874 | 4424845 | -160615.54 | |
Louisiana | 252965 | 4666799 | -100524.54 | |
Maine | 55137 | 1331057 | -298352.54 | |
Maryland | 360969 | 6008550 | 7479.46 | |
Massachusetts | 473606 | 6776251 | 120116.46 | |
Michigan | 462252 | 9918381 | 108762.46 | |
Minnesota | 330782 | 5487040 | -22707.54 | |
Mississippi | 106880 | 2995225 | -246609.54 | |
Missouri | 287207 | 6078884 | -66282.54 | |
Montana | 45799 | 1031080 | -307690.54 | |
Nebraska | 112208 | 1892208 | -241281.54 | |
Nevada | 140608 | 2880996 | -212881.54 | |
New Hampshire | 71632 | 1330250 | -281857.54 | |
New Jersey | 573947 | 8960072 | 220457.46 | |
New Mexico | 90810 | 2084090 | -262679.54 | |
New York | 1444406 | 19787315 | 1090916.46 | |
North Carolina | 503745 | 10026169 | 150255.46 | |
North Dakota | 53686 | 753317 | -299803.54 | |
Ohio | 592899 | 11611559 | 239409.46 | |
Oklahoma | 181089 | 3899322 | -172400.54 | |
Oregon | 225661 | 4006827 | -127828.54 | |
Pennsylvania | 677582 | 12790083 | 324092.46 | |
Rhode Island | 56323 | 1056571 | -297166.54 | |
South Carolina | 196887 | 4885343 | -156602.54 | |
South Dakota | 45415 | 859781 | -308074.54 | |
Tennessee | 307125 | 6594129 | -46364.54 | |
Texas | 1648007 | 27354011 | 1294517.46 | |
Utah | 146697 | 2977970 | -206792.54 | |
Vermont | 29750 | 626186 | -323739.54 | |
Virginia | 476919 | 8374081 | 123429.46 | |
Washington | 446096 | 7138029 | 92606.46 | |
West Virginia | 71123 | 1847153 | -282366.54 | |
Wisconsin | 296971 | 5769285 | -56518.54 | |
Wyoming | 40170 | 584861 | -313319.54 | |
AVERAGE | 353489.54 | |||
HERE -VE SIGN REPRESENTS THAT THE STATE HAS LESS GDP THAN AVERAGE GDP AND +VE SIGN REPRESENTS MORE GDP THAN AVERAGE GDP