Question

In: Statistics and Probability

state GDP (millions of dollars) 2015pop Alabama 207303 4862058 Alaska 54256 736130 Arizona 295445 6816049 Arkansas...

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.

Solutions

Expert Solution

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


Related Solutions

State Alabama Alaska Arizona Arkansas California Connecticut Delaware District of Columbia Florida Idaho Illinois Indiana Iowa...
State Alabama Alaska Arizona Arkansas California Connecticut Delaware District of Columbia Florida Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Jersey New Mexico New York North Dakota Ohio Oklahoma Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Washington West Virginia Wisconsin Wyoming Cigarettes 1820 3034 2582 1824 2860 3110 3360 4046 2827 2010 2791 2618 2212 2184 2344 2158 2892 2591 2692 2496 2206 1608 2756 2375...
Alabama 89.3% Alaska 78.2% Arizona 78% Arkansas 88% California 82.7% Colorado 79.1% Connecticut 87.9% Delaware 86.9%...
Alabama 89.3% Alaska 78.2% Arizona 78% Arkansas 88% California 82.7% Colorado 79.1% Connecticut 87.9% Delaware 86.9% Florida 82.3% Georgia 80.6% Hawaii 82.7% Idaho 79.7% Illinois 87% Indiana 83.8% Iowa 91% Kansas 86.5% Kentucky 89.7% Louisiana 78.1% Maine 86.9% Maryland 87.7% Massachusetts 88.3% Michigan 80.2% Minnesota 82.7% Mississippi 83% Missouri 88.3% Montana 85.8% Nebraska 89.1% Nevada 80.9% New Hampshire 88.9% New Jersey 90.5% New Mexico 71.1% New York 81.8% North Carolina 86.6% North Dakota 87.2% Ohio 84.2% Oklahoma 82.6% Oregon 76.7%...
state %Coll Grad Burglary VehTheft Alabama 19.8 1081.3 288.7 Alaska 28.6 472.1 238.7 Arizona 28 868.9...
state %Coll Grad Burglary VehTheft Alabama 19.8 1081.3 288.7 Alaska 28.6 472.1 238.7 Arizona 28 868.9 572.6 Arkansas 17.5 1180 228 California 30.6 647.1 523.8 Colorado 35.5 572 273.7 Connecticut 36.8 428.7 256 Delaware 25.6 774.3 291 District of Columbia 46.9 640 1092.4 Florida 25.4 1028.3 346.5 Georgia 27.1 1038.9 409.1 Hawaii 30.4 728.1 398.5 Idaho 25.9 439.8 109.5 Illinois 29.6 612.1 252.5 Indiana 22.6 762.8 273.7 Iowa 24.5 547.9 144.3 Kansas 30.4 699.9 263.9 Kentucky 18.9 675.5 179.6 Louisiana...
School Revenue %Wins Salary Alabama 6.5 61 1.00 Arizona 16.6 63 0.70 Arkansas 11.1 72 0.80...
School Revenue %Wins Salary Alabama 6.5 61 1.00 Arizona 16.6 63 0.70 Arkansas 11.1 72 0.80 Boston College 3.4 80 0.53 California 6.0 68 0.85 Cincinnati 5.7 61 0.18 Duke 12.4 90 1.40 Florida 6.5 80 1.70 Florida State 6.8 68 0.74 Gonzaga 2.5 90 0.50 Illinois 11.3 83 0.70 Indiana 11.9 63 0.78 Iowa 10.5 73 0.80 Kansas 11.8 76 1.00 LSU 4.6 76 0.72 Marquette 5.8 67 1.10 Memphis 5.6 90 1.20 Michigan State 11.0 68 1.60 N.C....
The values of Alabama building contracts (in millions of dollars) for a 12-month period follow: 240...
The values of Alabama building contracts (in millions of dollars) for a 12-month period follow: 240 350 230 260 280 320 220 310 240 310 240 230 a. Construct a time series plot. What type of pattern exists in the data? b. Compare a three-month moving average forecast with an exponential smoothing forecast. Use alpha =0.2 Which provides the better forecasts based on MSE? c. What is the forecast for the next month?
The budget​ (in millions of​ dollars) and worldwide gross​ (in millions of​ dollars) for eight movies...
The budget​ (in millions of​ dollars) and worldwide gross​ (in millions of​ dollars) for eight movies are shown below. Complete parts​ (a) through​ (c). Budget, x Gross, y 206 253 205 302 200 423 199 688 182 688 175 1035 173 1878 168 1225 (a) Display the data in a scatter plot ​(b) Calculate the correlation coefficient r. (c) Make a conclusion about the type of correlation.
State/Region Membership Alabama 121 Arizona 527 Maryland, Deleware, DC 754 Connectuict 293 Florida 829 Georgia 315...
State/Region Membership Alabama 121 Arizona 527 Maryland, Deleware, DC 754 Connectuict 293 Florida 829 Georgia 315 Hawaii 50 Illinois 117 Indiana 260 Iowa 354 Kentucky 129 Louisinia 141 Michigan 373 Massachusetts 74 Maine 676 Minnesota, Dakotas 527 Missouri, Kansas 919 Mississippi 908 Nebraska 146 North Carolinia 43 Neveda 329 New Jersey 339 Alaska, Idaho, Montana, Oregon, Washington 85 New York 177 Ohio 153 Oklahoma 378 Arkansas 543 California 961 New Mexico 98 Pennyslvania 411 Rhode Island 53 Colorado 445 South...
what is the time complexity of the edit distance ("ALASKA" vs "ALABAMA" example) dynamic programming algorithm?...
what is the time complexity of the edit distance ("ALASKA" vs "ALABAMA" example) dynamic programming algorithm? what is the space complexity of the edit distance ("ALASKA" vs "ALABAMA" example) dynamic programming algorithm?
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. Answer parts ​a-c. Budget (x)   Gross (y) 63   60 93   66 45   51 31   57 203   624 105   143 90   46 a. Find the value of the linear correlation coefficient b. Find the critical values of r from the table showing the critical values for the Pearson correlation coefficient using α=0.05. c. Is there sufficient evidence to conclude that...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. Construct a​ scatterplot, find the value of the linear correlation coefficient​ r, and find the​ P-value using alphaequals0.05. Is there sufficient evidence to conclude that there is a linear correlation between budgets and gross​ receipts? Do the results change if the actual budgets listed are ​$60,000,000​, ​$91,000,000​, ​$48,000,000​, and so​ on? Budget​ (x) 60 91 48 40 196 100...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT