Economics question on excel for regression

profilesvharah
Homework1.Regression1.xlsx
Home>Business & Finance homework help>Economics homework help>Economics question on excel for regression

jstdatasetr4_csv

year country rgdppc pop rconpc iy exports debtgdp expenditure hpnom
2016 Australia 113.9126532497 23853.4504563233 108.6951990056 0.2494800775 258430 0.41091 450594 469.942136
2016 Belgium 105.7573760107 11426.8229704797 101.5653628988 0.2390948648 14362416.2965 1.057127 4689743.31242 360.0255269836
2016 Canada 106.5291355098 36235.0975727958 115.4359263047 0.2298811444 515.9153 0.92327 297.663 322.0786287014
2016 Denmark 103.1935372018 5716.0909716947 97.8243891356 0.200155272 633.7703 0.379 822.546 323.5354750798
2016 Finland 101.0374216433 5503.297 108.4341611749 0.2139119873 307870.86855399 0.630712 323560.68087 185.043879668
2016 France 104.2139381017 66604.443389394 104.2649674823 0.2195701916 2898.4771959 0.965046 3344.24589439 245.8414555262
2016 Germany 117.645174575 79669.6851738754 108.3723099351 0.2003893068 2360.7259266 0.680654 709.28370533 169.2154621534
2016 Italy 92.2761796385 59620.1390852638 90.9191522807 0.1699952165 970986.351201999 1.314 960509.96874 165.98697223
2016 Japan 107.2749306796 126558.315947749 105.9031942534 0.2196656436 86.6396 2.389697 93.8807 59.5208266749
2016 Netherlands 108.6475889898 17236.3875288824 99.9318301503 0.20056 1019674.9298301 0.617961 405905.75232 364.2558241957
2016 Norway 102.0277653804 5095.6106463338 114.5291364387 0.29079 739310.01 0.331 1289796 569.4366833241
2016 Portugal 101.9154383678 10461.7808478425 102.3727260426 0.1459459459 14930696.468 1.301213 10096474.002 194.9079876196
2016 Spain 101.3313984476 46450.439 92.9583831283 0.1992818671 61315736.79 0.9898971837 36586617.54 279.2762912115
2016 Sweden 112.9546861047 9767.1537381158 107.8891334129 0.2422223643 1194900 0.421952 1276999 396.8070703993
2016 Switzerland 108.8258143357 8314.4102515475 107.1446745008 0.2423076923 210714.68 0.433 70595.2279 149.8250954153
2016 UK 105.6377409753 64389.567935624 103.6178510363 0.1666443258 302.067 0.882857 746.497 324.3235791635
2016 USA 107.4014611147 322783.33273921 109.5310189076 0.195830708 2232.45 1.058 3852.612 240.4187737319