Economics question on excel for regression

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

jstdatasetr4_csv

year country pop rgdppc rconpc iy exports debtgdp expenditure hpnom
1902 Australia 3850 16.2204548126 23.0631 0.1554054 85 0.464439 7.8 0.5960976855
1903 Australia 3896 17.3096186925 23.5522 0.1588785 94 0.497428 8.6 0.5808131295
1904 Australia 3946 18.2492894909 24.6377 0.1160714 113 0.478772 8.6 0.5578862954
1905 Australia 4004 18.1943302876 24.9941 0.1058559 110 0.491269 9 0.5502440174
1906 Australia 4062 19.1659847108 24.2845 0.1106472 135 0.47075 10 0.5808131295
1907 Australia 4127 19.637034678 27.1731 0.133829 143 0.412483 12 0.6266667976
1908 Australia 4197 19.9688141779 25.6892 0.141791 127 0.423596 13 0.6572359097
1909 Australia 4278 21.2156694736 25.2685 0.1308901 128 0.406307 15 0.6648781877
1910 Australia 4375 22.2142468214 25.438 0.130016 147 0.387713 26 0.6725204657
1911 Australia 4500 21.7490672663 27.6266 0.1432749 156 0.258879 30 0.7183741339
1912 Australia 4661 21.7256868318 27.3037 0.1689373 155 0.373647 34 0.764227802
1913 Australia 4821 21.9828716119 28.0439 0.1832918 154 0.370718 36 0.8177237481
1914 Australia 4933 21.4155671284 26.9714 0.1724537 135 0.381482 64 0.8330083042
1915 Australia 4971 20.8567646211 25.2199 0.1527446 116 0.443556 128 0.8559351382
1916 Australia 4955 20.7790322672 25.0483 0.124871 128 0.460578 162 0.8865042503
1917 Australia 4950 20.4080829484 21.6011 0.1164384 173 0.512035 174 0.9170733624
1918 Australia 5032 19.5872373888 21.3702 0.1007533 150 0.61629 214 0.9858538645
1919 Australia 5193 20.0881454868 22.6671 0.1213974 214 0.606288 194 1.1157725909
1920 Australia 5358 20.3079823 22.7858 0.1644054 288 0.612051 186 1.2609758733
1921 Australia 5461 20.938747963 24.1007 0.1758321 254 0.59081 156 1.3221140974
1922 Australia 5574 21.6040276009 23.9901 0.1872279 248 0.633672 142 1.3526832095
1923 Australia 5697 22.1636398202 26.3609 0.1807947 232 0.592318 150 1.3679677655
1924 Australia 5819 23.1464277836 29.2334 0.1848311 234 0.588273 150 1.3679677655
1925 Australia 5943 23.7384284838 29.7612 0.1753775 322 0.55302 164 1.3679677655
1926 Australia 6064 23.8233470318 29.5945 0.1838457 288 0.604521 164 1.3832523216
1927 Australia 6188 23.6978416688 30.356 0.1862348 266 0.597108 178 1.3908945996
1928 Australia 6304 23.2971354332 29.2924 0.186314 276 0.623232 170 1.4443905457
1929 Australia 6396 22.4786177957 28.0923 0.1787383 278 0.638435 168 1.4826019358
1930 Australia 6469 20.0824775026 29.4631 0.1526181 196 0.702682 164 1.2151222051
1931 Australia 6527 18.5560691322 23.6234 0.1367521 180 0.898135 148 1.0469920887
1932 Australia 6579 19.4588980338 23.2408 0.0983471 192 0.98157 142 1.0011384206
1933 Australia 6631 20.6563608963 25.0851 0.1052215 196 0.952927 146 0.9629270305
1934 Australia 6682 21.5910722086 26.2182 0.1135693 228 0.901475 158 1.0164229766
1935 Australia 6732 22.699061893 25.8 0.1396648 208 0.867318 160 1.1004880348
1936 Australia 6783 23.5517898633 28.0165 0.1397713 248 0.797776 168 1.1386994249
1937 Australia 6841 24.5413591649 28.7718 0.1456028 296 0.735469 180 1.176910815
1938 Australia 6904 25.1478334673 29.1542 0.1610124 284 0.686591 196 1.1998376491
1939 Australia 6971 24.9719235312 26.1641 0.1594283 246 0.71193 280 1.2304067612
1940 Australia 7042 26.3554177301 24.345 0.1454545 300 0.677323 510 1.2609758733
1941 Australia 7111 29.0404227861 23.7585 0.1165501 270 0.664942 846 1.3603254875
1942 Australia 7173 32.1354457659 24.0162 0.0768923 320 0.652303 1394 1.4749596578
1943 Australia 7236 32.9879713082 21.791 0.0503849 252 0.701784 1440 1.551382438
1944 Australia 7309 31.5136881491 20.3669 0.053012 294 0.787298 1286 1.551382438
1945 Australia 7389 29.5874844692 23.0412 0.0661506 310 0.897326 1102 1.551382438
1946 Australia 7474 28.19437494 23.4821 0.0981261 394 0.92494 960 1.551382438
1947 Australia 7578 28.4954865971 27.8467 0.138718 618 0.886607 956 1.551382438
1948 Australia 7715 29.8148111186 31.0284 0.138718 1023.2 0.744649 1100 1.551382438
1949 Australia 7919 30.9978003788 32.6629 0.1793103448 1069.2 0.654024 1246 1.551382438
1950 Australia 8267.337 31.7793749054 33.7089 0.2047556143 1489 0.570583 1784 3.6071552253
1951 Australia 8510.6 32.2020445795 33.2588 0.2211155378 1819.6 0.451868 2144 4.2108951889
1952 Australia 8691.212 31.8099415341 32.5682 0.2579752175 1544 0.449222 2188 4.1573992427
1953 Australia 8857.924 32.1920243932 31.174 0.2270188504 1800.5 0.416291 2182 4.1039032966
1954 Australia 9064.017 33.4443452451 32.861 0.2296793438 1496.9 0.400177 2260 4.2261797449
1955 Australia 9277.087 34.4849264039 35.0316 0.2381761824 1595.9 0.39044 2416 4.3408139152
1956 Australia 9500.606 34.8408960504 35.0197 0.239449626 1701.1 0.373724 2722 4.8069928744
1957 Australia 9712.569 34.7614430585 34.486 0.2277933316 1990.7 0.352268 2766 5.3266677798
1958 Australia 9915.267 35.705567273 35.4616 0.2391376451 1485.9 0.3437 2780 5.4795133401
1959 Australia 10131.73 37.1242839448 35.7542 0.2354485101 1791.9 0.324622 2996 5.6323589005
1960 Australia 10361.27 37.8391584438 38.3253 0.2297197097 1830.2 0.31474 3360 6.4271558146
1961 Australia 10598.81 38.7037284524 38.2782 0.2201904928 2109.4 0.303105 3466 5.823415851
1962 Australia 10794.97 37.9751900631 37.6869 0.2178586825 2103.7 0.304193 3544 6.4806517607
1963 Australia 11001.48 39.904835019 39.0317 0.224567382 2504.1 0.293188 3960 7.2830909528
1964 Australia 11218.3 41.5126194474 40.634 0.2352561388 2726 0.276522 4348 7.5887820736
1965 Australia 11439.38 43.9007638343 42.1613 0.246671534 2683.3 0.344419 4819 7.9097577504
1966 Australia 11655.08 45.7792957191 43.2598 0.246918704 2831.2 0.412316 5376 8.2001643152
1967 Australia 11872.26 46.9473053069 45.0937 0.2417230685 3105.4 0.392458 5961 8.505855436
1968 Australia 12101.66 50.2082180366 46.6573 0.2462105384 3148.4 0.382114 6284 9.1095953995
1969 Australia 12379.38 51.8587147739 48.4384 0.2489145276 3768.1 0.357269 7040 9.8814654795
1970 Australia 12660.16 53.2306705766 49.494 0.2460632649 4258.5 0.33905 7770 10.9131730122
1971 Australia 12937.2 53.4900820648 49.6726 0.2531213972 4599.2 0.313265 8630 12.3193521678
1972 Australia 13177 54.04503844 51.1994 0.2451559201 5418.6 0.297352 9740 13.572685763
1973 Australia 13380.4 55.5400704697 53.4392 0.2458109917 6718.6 0.264661 11200 16.3391904062
1974 Australia 13599.1 54.7674027753 54.1798 0.2267650073 7684.8 0.230131 15700 19.740004125
1975 Australia 13771.4 55.6057583572 54.1745 0.2156822553 9122.5 0.228612 20400 22.1396794232
1976 Australia 13915.5 56.9579774295 56.0712 0.2212698889 10774.1 0.222987 23300 25.0055336806
1977 Australia 14074.1 56.8890506938 56.591 0.2217301316 12050 0.214885 26200 27.3135016425
1978 Australia 14248.6 58.5877252963 57.1339 0.2259685489 12591 0.223799 28700 28.7961035784
1979 Australia 14421.9 59.8140341495 57.7537 0.2245402918 16710.9 0.228866 31800 30.7601690294
1980 Australia 14615.9 61.1118000885 59.161 0.2355931895 19268.6 0.213488 36400 36.2931783157
1981 Australia 14923.26 62.0711064033 61.1189 0.2479947588 18686 0.189447 41400 41.6886265976
1982 Australia 15162 59.5575578674 61.1974 0.2405866447 21032 0.173873 49000 44.0959441739
1983 Australia 15348 61.59661516 61.4266 0.2204607206 22306 0.188926 57000 46.4268389699
1984 Australia 15510 64.1906288278 61.9074 0.2294949823 26366 0.203591 65200 52.3725312692
1985 Australia 15695 66.1452736424 63.9638 0.2427207126 32408 0.219957 71700 57.2330200898
1986 Australia 15900 66.5577207023 63.6461 0.2323500036 33716 0.234131 77500 61.3751347765
1987 Australia 16137 69.1853374189 64.8465 0.2301638594 37947 0.220637 82300 64.4438915153
1988 Australia 16400 70.8332025922 66.7095 0.2396884061 42369 0.248187 87900 78.9748693705
1989 Australia 16681 72.4111288898 69.052 0.2529068842 47005 0.2277 98900 98.4324458821
1990 Australia 16956 70.9128580121 68.579 0.2307130158 50892 0.215777 105000 100
1991 Australia 17202 70.0831056203 68.9807 0.2125130091 53728 0.229141 109000 100.6285171381
1992 Australia 17419 71.8626502107 69.2388 0.2103311134 58363 0.271514 116000 103.1718190455
1993 Australia 17608 74.1367264169 70.1318 0.2126573541 62839 0.303218 122000 106.0659212161
1994 Australia 17781 76.6624206331 72.9907 0.2271968662 64917 0.314529 128000 109.8370240444
1995 Australia 17976 78.8885214021 74.7442 0.2248561712 71091 0.31123 136000 111.7152671198
1996 Australia 18195 80.9493397053 75.7046 0.2259002006 77206 0.29317 140000 113.1769348827
1997 Australia 18415 83.664202892 78.4431 0.2392915939 84775 0.25908 135928.2 116.6922458525
1998 Australia 18621 87.1180295103 81.4166 0.2438449118 88989 0.23754 135784 128.2686545348
1999 Australia 18830 89.5848171771 83.8227 0.2486389366 86895 0.22588 140814.4 136.5855441058
2000 Australia 19053 90.2472628229 85.8776 0.241303684 110368 0.19559 160408 150.1936709786
2001 Australia 19294 92.4264002948 87.2277 0.2286534498 122531 0.17177 164548 162.6763136739
2002 Australia 19345 94.3409643644 89.3663 0.2545782871 119466 0.15062 174403 195.9657969743
2003 Australia 19767 96.9819413294 93.2298 0.2642255431 107896 0.13208 182268 231.6315720237
2004 Australia 19995 98.1709022157 96.1831 0.2765384111 117773 0.11942 189587 246.7209383907
2005 Australia 20232 100 97.9226 0.276589331 139080 0.10891 207932 250.2483227362
2006 Australia 20489 101.4700439939 100 0.2765231801 163753 0.09959 209797 269.8449024337
2007 Australia 20750 104.6193142104 100.3681 0.2826296306 168386 0.09677 224579 300.4155667617
2008 Australia 21007 106.3357950516 100.6207 0.2879183825 222341 0.11741 281011 313.545275159
2009 Australia 21388.4830508474 106.0540513439 101.2158 0.2793159544 196556 0.16758 324569 324.3233939925
2010 Australia 21687.8005215123 106.5116380191 101.9216839977 0.2709887717 231143 0.20497 339239 363.5165533874
2011 Australia 22035.0479139504 107.5343199253 104.3437700184 0.2703205309 261697 0.24243 356100 354.1101951326
2012 Australia 22440.9850065189 109.4703002841 105.1314286809 0.2866128358 247749 0.27858 377739 351.366673975
2013 Australia 22812.6864406779 110.326461764 104.8836535167 0.276556847 261958 0.30903 419640 374.6458060406
2014 Australia 23156.0211864406 111.4799703688 106.0467050442 0.2688475383 265923 0.34323 434634 408.5618448214
2015 Australia 23488.5961538461 112.5201012652 107.2477918765 0.2631772178 250740 0.37638 431470 445.4422674003
2016 Australia 23853.4504563233 113.9126532497 108.6951990056 0.2494800775 258430 0.41091 450594 469.942136