Econometrics homework

profileVincent666
GDPCO2France.xlsx

Feuil1

Year GDP per capita ($) CO2 per capita
1870 1875.6506503642 358.8189386056
1871 1899.4074898624 363.5737192229
1872 2078.4266567584 441.3068287375
1873 1922.0961279595 474.3579591944
1874 2157.232467669 449.4006939333
1875 2219.0691766306 466.0003662908
1876 2028.2194645555 464.5554455961
1877 2127.4821650767 452.276026545
1878 2091.1263060135 459.2265820499
1879 1953.3067927729 473.4637230461
1880 2120.4301959278 532.2832629018
1881 2193.6402490368 543.083871297
1882 2288.3455016905 571.0654091568
1883 2287.8401145115 596.8534657479
1884 2253.2539806707 571.0212218325
1885 2207.3546674049 547.5549291521
1886 2236.6830498269 541.4471373375
1887 2249.4339040838 569.8814209431
1888 2269.4038827655 592.4348697395
1889 2322.4284321568 605.8144185581
1890 2376.012445644 667.191482981
1891 2432.0610509467 668.8342545582
1892 2492.8715025129 669.617183007
1893 2534.8947368421 657.045034238
1894 2626.0233672858 694.3029758338
1895 2569.2218315128 699.5361364657
1896 2685.4419536226 721.7107882166
1897 2639.2483642312 752.6023594726
1898 2759.6174486695 775.8011513849
1899 2911.446579194 809.7716174222
1900 2875.686289965 869.0822207991
1901 2826.4949557087 839.4931102362
1902 2775.2903986442 788.7652592538
1903 2830.5475163046 865.5175795616
1904 2846.7080692136 841.6260799334
1905 2894.0203228173 850.5258009293
1906 2943.2813736505 910.3854232817
1907 3070.3294904988 970.5681207562
1908 3044.9492033329 975.5396384544
1909 3166.8147850836 996.4971174195
1910 2965.2070153309 997.1375897535
1911 3249.5770934708 1036.7250102888
1912 3514.4934355279 1046.446964385
1913 3484.7695535779 1126.3294985891
1914 3236.336218536 778.7877326647
1915 3248.066747363 696.0055334601
1916 3463.3307592017 750.6017450607
1917 2978.9271533293 844.7617593158
1918 2395.5287997509 767.9674121737
1919 2811.3751162791 819.0697674419
1920 3226.921 1062.1538461539
1921 3074.625764526 959.1997961264
1922 3610.3923135464 1129.5788939625
1923 3753.5256770311 1260.5315947844
1924 4179.4635078144 1399.0573058794
1925 4166.3782073381 1437.0598374784
1926 4249.4685099095 1427.2816246636
1927 4153.970517831 1420.2247191011
1928 4431.4653105968 1407.0889159562
1929 4709.9979626486 1551.0065486296
1930 4531.5583994232 1558.8079788512
1931 4235.2604634496 1418.1796464405
1932 3959.1228619207 1250.5016722408
1933 4239.1258295536 1299.1883504416
1934 4191.7309415971 1310.1072705602
1935 4085.9311874106 1271.50691464
1936 4243.998067287 1290.0501073729
1937 4486.6367278798 1417.17147627
1938 4466.2114632984 1312.5834127741
1939 4793.3105011933 1267.6849642005
1940 4042.1678780488 916.8780487805
1941 3309.3818939394 826.5151515152
1942 2981.4608375634 848.6040609137
1943 2860.1412307692 876.5641025641
1944 2421.7693573265 561.233933162
1945 2573.1416372796 736.7758186398
1946 3855.1917349218 1119.434102755
1947 4137.8978613569 1232.0550639135
1948 4393.365361226 1304.694721479
1949 4946.3447444552 1507.256509161
1950 5185.8506985277 1298.6264640858
1951 5461.1077411227 1456.6515794877
1952 5564.2599110782 1434.7906632086
1953 5683.9406828371 1346.4995976549
1954 5915.1795901602 1409.9767240199
1955 6198.7878239631 1475.326789995
1956 6448.4627270081 1641.2432541371
1957 6761.7824238129 1677.6665485471
1958 6855.1715074254 1591.4268191177
1959 6978.7769082356 1549.8276572221
1960 7397.5828610682 1587.7125193199
1961 7718.4264131726 1627.2067560686
1962 8067.0631537358 1693.9008920959
1963 8362.6713662165 1866.5956269596
1964 8819.3366695707 1907.8347549486
1965 9165.4150435725 1926.6495321473
1966 9544.1357901859 1884.2679189716
1967 9907.1865745311 2002.9220138203
1968 10267.0180663871 2055.2964690206
1969 10885.5644064504 2189.5667379056
1970 11410.0889864787 2305.9439885974
1971 11844.9610924626 2405.1533414709
1972 12263.5459598442 2478.4663666957
1973 12824.4239026494 2641.4790092438
1974 13112.5349227044 2534.8854535295
1975 12957.205078306 2258.8453340747
1976 13466.3860115586 2545.8187928137
1977 13912.7036669241 2411.4715509949
1978 14240.2109812827 2526.4459177319
1979 14634.3825224305 2631.5194397841
1980 14766.1585919071 2500.707675558
1981 14839.9068575245 2238.2714489431
1982 15131.6408424152 2139.109826382
1983 15245.1143413971 2060.5589229201
1984 15381.9293816449 1965.2597518046
1985 15530.2708443972 1935.2274738892
1986 15833.0365799912 1853.8210665491
1987 16157.8901191458 1806.3661408342
1988 16789.57296306 1772.8058684831
1989 17299.7008007471 1842.4274917417
1990 17647.0052262412 1870.7192958328
1991 17755.1018050575 1993.1298492668
1992 17994.2686636938 1839.5317623473
1993 17722.8158152112 1793.3377275262
1994 18007.7833429146 1694.8776179662
1995 18349.2742613431 1796.1381296892
1996 18466.9114634083 1855.5375869025
1997 18824.680075039 1717.5125302885
1998 19213.1659370612 1842.9173205583
1999 19753.8471655925 1664.7540444561
2000 20421.6922649132 1630.5837708752
2001 20683.7619349697 1711.4136534426
2002 20777.5154053923 1679.7295767358
2003 20891.0746167827 1700.1013334191
2004 21262.2573320114 1701.1865545143
2005 21536.0662512716 1699.5008901323
2006 21920.180746686 1648.3813375887
2007 22287.3653465657 1609.6228133539
2008 22223.0166411689 1586.0470198882
2009 22650.3281079361 1510.8344716255
2010 22958.5637413756 1521.3094502779

1

2

3

4

5

6

7

8

9

A

B

C

D

Year

GDP per capita ($)

CO2 per capita

1870

1875.65065

358.818939

1871

1899.40749

363.573719

1872

2078.42666

441.306829

1873

1922.09613

474.357959

1874

2157.23247

449.400694

1875

2219.06918

466.000366

1876

2028.21946

464.555446

1877

2127.48217

452.276027