Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Along with this Exam are posted three data files, Exam1.Summer2021.File1.xlsx, Exam1.Summer2021.File2.xlsx and Exam1.Summer2021.File3.xlsx. These files contain development data for some European and...

1 answer below »
Along with this Exam are posted three data files, Exam1.Summer2021.File1.xlsx, Exam1.Summer2021.File2.xlsx and Exam1.Summer2021.File3.xlsx. These files contain development data for some European and North American countries. Each of the files has the same columns. The columns in the files are as follows
Yea
Country     Country name
gdppc        Real GDP per capita
exports        Exports
money        Money Supply
stir        Short term interest rate
evenue    Government Revenue
thh        Total loans to households
tbus         Total loans to business
debtgdp    Public (government) debt to GDP ratio (Public debt divided by GDP)
Exam1.Summer2021.File1.xlsx contains data for each country for the period XXXXXXXXXX
Exam1.Summer2021.File2.xlsx contains data for France and Germany for the period 1960 –
2015.
Exam1.Summer2021.File3.xlsx contains data for Canada and USA for the period 1960 – 2015.
(a) Using the data set Exam 1.Summer2021.File1.xlsx, please run a regression with rgdppc (RealGDP per capita) as the dependent (Y) variable and all other variables exports, money, stir, revenue, thh, tbus, debtgdp as the independent (X) variables.
Please copy and paste your Excel output into your word document and do not submit your Excel file.
(b) What can you say about the goodness of fit of the equation? Please explain.
(c) Which independent variables have a significant coefficient in the regression? Please explain.
(d) Using the data set Exam1.Summer2021.File2.xlsx, please run a regression with rgdppc
(RealGDP per capita) as the dependent (Y) variable and all other variables exports, money, stir, revenue, thh, tbus, debtgdp as the independent (X) variables.
Please copy and paste your Excel output into your word document and do not submit your Excel
(e) What can you say about the goodness of fit of the regression in (d)? Please explain.
(f) Which independent variables have a significant coefficient in the regression in (d)? Please
explain.
(g) Using the data set Exam1.Summer2021.File3.xlsx, please run a regression with rgdppc
(RealGDP per capita) as the dependent (Y) variable and all other variables exports, money, stir, revenue, thh, tbus, debtgdp as the independent (X) variables.
Please copy and paste your Excel output into your word document and do not submit your Excel file
(h) What can you say about the goodness of fit of the regression in (g)? Please explain.
(i) Which independent variables have a significant coefficient in the regression in (g)? Please
explain.
(j) Which regression, the one in (a) or the one in (d), or the one in (g) is a better fit for the data?
Please explain.

jstdatasetr4_csv
    year    country    rgdppc    exports    money    stir    revenue    thh    tbus    debtgdp
    1960    Australia     XXXXXXXXXX    1830.2    7192     XXXXXXXXXX    3030    738.427    2070.57    0.31474
    1961    Australia     XXXXXXXXXX    2109.4    7301     XXXXXXXXXX    3408    789.538    2120.46     XXXXXXXXXX
    1962    Australia     XXXXXXXXXX    2103.7    7846     XXXXXXXXXX    3436    889.727    2139.27     XXXXXXXXXX
    1963    Australia     XXXXXXXXXX    2504.1    8517     XXXXXXXXXX    3539    1039.18    2288.82     XXXXXXXXXX
    1964    Australia     XXXXXXXXXX    2726    9556     XXXXXXXXXX    3950    1288.73    2400.27     XXXXXXXXXX
    1965    Australia     XXXXXXXXXX    2683.3    10337     XXXXXXXXXX    4592    1498.73    2757.27     XXXXXXXXXX
    1966    Australia     XXXXXXXXXX    2831.2     XXXXXXXXXX     XXXXXXXXXX    4754    1713.55    2983.45     XXXXXXXXXX
    1967    Australia     XXXXXXXXXX    3105.4     XXXXXXXXXX    4.55    5019    1969.82    3327.18     XXXXXXXXXX
    1968    Australia     XXXXXXXXXX    3148.4     XXXXXXXXXX     XXXXXXXXXX    5608    2210.18    3801.82     XXXXXXXXXX
    1969    Australia     XXXXXXXXXX    3768.1     XXXXXXXXXX     XXXXXXXXXX    6248    2445.9    4175.1     XXXXXXXXXX
    1970    Australia     XXXXXXXXXX    4258.5     XXXXXXXXXX     XXXXXXXXXX    7160    2689.33    4541.67    0.33905
    1971    Australia     XXXXXXXXXX    4599.2     XXXXXXXXXX     XXXXXXXXXX    8039    2949.56    4954.44     XXXXXXXXXX
    1972    Australia     XXXXXXXXXX    5418.6    19467.3     XXXXXXXXXX    9811    3359.2    5392.8     XXXXXXXXXX
    1973    Australia     XXXXXXXXXX    6718.6     XXXXXXXXXX    5.2125    10757    4221.03    6885.97     XXXXXXXXXX
    1974    Australia     XXXXXXXXXX    7684.8     XXXXXXXXXX     XXXXXXXXXX    13746    5132.03    9146.97     XXXXXXXXXX
    1975    Australia     XXXXXXXXXX    9122.5     XXXXXXXXXX    7.51    17802    6473.67    10022.3     XXXXXXXXXX
    1976    Australia     XXXXXXXXXX    10774.1     XXXXXXXXXX     XXXXXXXXXX    21504    8069.42    11257.6     XXXXXXXXXX
    1977    Australia     XXXXXXXXXX    12050    42872.1    8.525    24935    9766.5    12647.5     XXXXXXXXXX
    1978    Australia     XXXXXXXXXX    12591     XXXXXXXXXX     XXXXXXXXXX    27173    11443    13600     XXXXXXXXXX
    1979    Australia     XXXXXXXXXX    16710.9    57232     XXXXXXXXXX    29664    13285.3    15743.7     XXXXXXXXXX
    1980    Australia     XXXXXXXXXX    19268.6    65457    10.6675    34584    15578.2    16570.8     XXXXXXXXXX
    1981    Australia     XXXXXXXXXX    18686    72752     XXXXXXXXXX    40727    17985.4    19289.6     XXXXXXXXXX
    1982    Australia     XXXXXXXXXX    21032    81035    14.6425    47388    20254.5    20331.5     XXXXXXXXXX
    1983    Australia     XXXXXXXXXX    22306    92562     XXXXXXXXXX    52001    23937.8    21518.2     XXXXXXXXXX
    1984    Australia     XXXXXXXXXX    26366    105399    10.985    56912    28917.9    25409.1     XXXXXXXXXX
    1985    Australia     XXXXXXXXXX    32408    120667    15.42    66458    36007.4    33206.6     XXXXXXXXXX
    1986    Australia     XXXXXXXXXX    33716    131643     XXXXXXXXXX    75000    39960.4    41392.6     XXXXXXXXXX
    1987    Australia     XXXXXXXXXX    37947    148219     XXXXXXXXXX    83500    47582.2    47245.8     XXXXXXXXXX
    1988    Australia     XXXXXXXXXX    42369    173005     XXXXXXXXXX    91200    56949.8    63177.2     XXXXXXXXXX
    1989    Australia     XXXXXXXXXX    47005     XXXXXXXXXX    16.8    91200    84450.1    89945.1    0.2277
    1990    Australia     XXXXXXXXXX    50892     XXXXXXXXXX     XXXXXXXXXX    93300    94159.9    106717     XXXXXXXXXX
    1991    Australia     XXXXXXXXXX    53728     XXXXXXXXXX     XXXXXXXXXX    87400    101070    115675     XXXXXXXXXX
    1992    Australia     XXXXXXXXXX    58363     XXXXXXXXXX    6.265    88600    118249    106038     XXXXXXXXXX
    1993    Australia     XXXXXXXXXX    62839     XXXXXXXXXX     XXXXXXXXXX    93100    136751    103991     XXXXXXXXXX
    1994    Australia     XXXXXXXXXX    64917     XXXXXXXXXX     XXXXXXXXXX    105000    162973    107704     XXXXXXXXXX
    1995    Australia     XXXXXXXXXX    71091     XXXXXXXXXX     XXXXXXXXXX    114000    181604    121213    0.31123
    1996    Australia     XXXXXXXXXX    77206     XXXXXXXXXX     XXXXXXXXXX    126000    201208    131572    0.29317
    1997    Australia     XXXXXXXXXX    84775     XXXXXXXXXX     XXXXXXXXXX    131031    219638    146521    0.25908
    1998    Australia     XXXXXXXXXX    88989     XXXXXXXXXX     XXXXXXXXXX    136969    242467    159432    0.23754
    1999    Australia     XXXXXXXXXX    86895     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    274093    179355    0.22588
    2000    Australia     XXXXXXXXXX    110368     XXXXXXXXXX     XXXXXXXXXX    169921    313281    187887    0.19559
    2001    Australia     XXXXXXXXXX    122531     XXXXXXXXXX     XXXXXXXXXX    166079    352485    200436    0.17177
    2002    Australia     XXXXXXXXXX    119466     XXXXXXXXXX     XXXXXXXXXX    170753    410680    227381    0.15062
    2003    Australia     XXXXXXXXXX    107896     XXXXXXXXXX     XXXXXXXXXX    183659    486353    268773    0.13208
    2004    Australia     XXXXXXXXXX    117773     XXXXXXXXXX    5.25    192723    549628    315698    0.11942
    2005    Australia    100    139080     XXXXXXXXXX    5.4575    211032    615977    369501    0.10891
    2006    Australia     XXXXXXXXXX    163753     XXXXXXXXXX    5.805    225513    685281    439161    0.09959
    2007    Australia     XXXXXXXXXX    168386     XXXXXXXXXX     XXXXXXXXXX    254761    772485    579591    0.09677
    2008    Australia     XXXXXXXXXX    222341     XXXXXXXXXX     XXXXXXXXXX    303713    879526    682444    0.11741
    2009    Australia     XXXXXXXXXX    196556     XXXXXXXXXX     XXXXXXXXXX    298933     XXXXXXXXXX    681479    0.16758
    2010    Australia     XXXXXXXXXX    231143     XXXXXXXXXX     XXXXXXXXXX    292767    1099118    648885    0.20497
    2011    Australia     XXXXXXXXXX    261697     XXXXXXXXXX     XXXXXXXXXX    309890    1165541    680106    0.24243
    2012    Australia     XXXXXXXXXX    247749     XXXXXXXXXX     XXXXXXXXXX    338109     XXXXXXXXXX    696229    0.27858
    2013    Australia     XXXXXXXXXX    261958    1620778    2.7375    376071     XXXXXXXXXX     XXXXXXXXXX    0.30903
    2014    Australia     XXXXXXXXXX    265923    1738348    2.5     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    0.34323
    2015    Australia     XXXXXXXXXX    250740    1841238     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    0.37638
    1960    Canada     XXXXXXXXXX     XXXXXXXXXX    13.1959     XXXXXXXXXX     XXXXXXXXXX    3.99078    6.186     XXXXXXXXXX
    1961    Canada     XXXXXXXXXX     XXXXXXXXXX    14.3582     XXXXXXXXXX     XXXXXXXXXX    4.388    6.186     XXXXXXXXXX
    1962    Canada     XXXXXXXXXX     XXXXXXXXXX    14.9593    4.0525     XXXXXXXXXX    5.038    6.988     XXXXXXXXXX
    1963    Canada     XXXXXXXXXX     XXXXXXXXXX    16.7763     XXXXXXXXXX    7.003    5.901    8.176     XXXXXXXXXX
    1964    Canada     XXXXXXXXXX     XXXXXXXXXX    18.5079     XXXXXXXXXX    8.141    7.08    9.17     XXXXXXXXXX
    1965    Canada     XXXXXXXXXX     XXXXXXXXXX    20.3724     XXXXXXXXXX    8.865    8.631    11.055     XXXXXXXXXX
    1966    Canada     XXXXXXXXXX     XXXXXXXXXX    22.0041    4.995    9.662    9.385    11.852     XXXXXXXXXX
    1967    Canada     XXXXXXXXXX     XXXXXXXXXX    25.828     XXXXXXXXXX    10.571    10.672    13.034     XXXXXXXXXX
    1968    Canada     XXXXXXXXXX     XXXXXXXXXX    29.118    6.2675    11.817    12.34    14.188     XXXXXXXXXX
    1969    Canada     XXXXXXXXXX     XXXXXXXXXX    31.892    7.1925    14.155    14.19    15.878     XXXXXXXXXX
    1970    Canada     XXXXXXXXXX     XXXXXXXXXX    34.785     XXXXXXXXXX    14.717    15.993    16.314     XXXXXXXXXX
    1971    Canada     XXXXXXXXXX     XXXXXXXXXX    38.792    3.5625    13.345    19.411    18.597     XXXXXXXXXX
    1972    Canada     XXXXXXXXXX     XXXXXXXXXX    43.952     XXXXXXXXXX    18.821    24.592    21.796     XXXXXXXXXX
    1973    Canada     XXXXXXXXXX     XXXXXXXXXX    52.229    5.47    25.102    31.996    26.996     XXXXXXXXXX
    1974    Canada     XXXXXXXXXX     XXXXXXXXXX    60.854     XXXXXXXXXX    32.192    39.254    33.067     XXXXXXXXXX
    1975    Canada     XXXXXXXXXX     XXXXXXXXXX    70.76    7.395    34.703    47.797    38.325     XXXXXXXXXX
    1976    Canada     XXXXXXXXXX     XXXXXXXXXX    81.753    8.8675    38.313    58.32    45.904     XXXXXXXXXX
    1977    Canada     XXXXXXXXXX     XXXXXXXXXX    92.677     XXXXXXXXXX    38.237    70.878    51.509     XXXXXXXXXX
    1978    Canada     XXXXXXXXXX     XXXXXXXXXX    105.655     XXXXXXXXXX    41.638    85.406    59.471     XXXXXXXXXX
    1979    Canada     XXXXXXXXXX     XXXXXXXXXX    125.034    11.6875    48.219    100.981    74.555     XXXXXXXXXX
    1980    Canada     XXXXXXXXXX     XXXXXXXXXX    146.923     XXXXXXXXXX    57.491    113.031    91.191     XXXXXXXXXX
    1981    Canada     XXXXXXXXXX     XXXXXXXXXX    162.514    17.72    63.531    118.84    131.927     XXXXXXXXXX
    1982    Canada     XXXXXXXXXX     XXXXXXXXXX    174.328    13.6575    65.24    119.251    130.554     XXXXXXXXXX
    1983    Canada     XXXXXXXXXX     XXXXXXXXXX    184.37    9.31    67.51    130.444    118.888     XXXXXXXXXX
    1984    Canada     XXXXXXXXXX     XXXXXXXXXX    199.52     XXXXXXXXXX    73.628    140.895    131.957     XXXXXXXXXX
    1985    Canada     XXXXXXXXXX     XXXXXXXXXX    220.807    9.43    80.264    159.436    139.826     XXXXXXXXXX
    1986    Canada     XXXXXXXXXX     XXXXXXXXXX    246.197     XXXXXXXXXX    88.686    183.354    131.628     XXXXXXXXXX
    1987    Canada     XXXXXXXXXX     XXXXXXXXXX    267.704     XXXXXXXXXX    97.43    216.907    133.784     XXXXXXXXXX
    1988    Canada     XXXXXXXXXX     XXXXXXXXXX    302.38    9.4825    106.731    252.726    146.179     XXXXXXXXXX
    1989    Canada     XXXXXXXXXX    144.248    345.478     XXXXXXXXXX    113.881    289.931    159.942     XXXXXXXXXX
    1990    Canada     XXXXXXXXXX    148.912    373.909     XXXXXXXXXX    121.514    305.061     XXXXXXXXXX     XXXXXXXXXX
    1991    Canada     XXXXXXXXXX    145.658    391.322     XXXXXXXXXX    127.277    325.467     XXXXXXXXXX     XXXXXXXXXX
    1992    Canada     XXXXXXXXXX    162.596    404.448    6.585    131.491    343.989     XXXXXXXXXX     XXXXXXXXXX
    1993    Canada     XXXXXXXXXX    187.346    415.341     XXXXXXXXXX    130.231    360.793     XXXXXXXXXX     XXXXXXXXXX
    1994    Canada     XXXXXXXXXX     XXXXXXXXXX    426.028     XXXXXXXXXX    133.264    373.954     XXXXXXXXXX     XXXXXXXXXX
    1995    Canada     XXXXXXXXXX     XXXXXXXXXX    445.04    6.8925    142.2    392.001     XXXXXXXXXX     XXXXXXXXXX
    1996    Canada     XXXXXXXXXX     XXXXXXXXXX    452.033     XXXXXXXXXX    150.436    414.217     XXXXXXXXXX     XXXXXXXXXX
    1997    Canada     XXXXXXXXXX     XXXXXXXXXX    448.721     XXXXXXXXXX    167.164    433.751     XXXXXXXXXX     XXXXXXXXXX
    1998    Canada     XXXXXXXXXX     XXXXXXXXXX    451.738     XXXXXXXXXX    172.18    449.739     XXXXXXXXXX     XXXXXXXXXX
    1999    Canada     XXXXXXXXXX     XXXXXXXXXX    477.142    4.71975    182.813    464.042     XXXXXXXXXX     XXXXXXXXXX
    2000    Canada     XXXXXXXXXX     XXXXXXXXXX    510.32     XXXXXXXXXX    201.831    476.45    232.024     XXXXXXXXXX
    2001    Canada     XXXXXXXXXX     XXXXXXXXXX    540.224     XXXXXXXXXX    198.9    507.041     XXXXXXXXXX     XXXXXXXXXX
    2002    Canada     XXXXXXXXXX     XXXXXXXXXX    569.587    2.58575    194.764    554.109     XXXXXXXXXX     XXXXXXXXXX
    2003    Canada     XXXXXXXXXX     XXXXXXXXXX    604.554     XXXXXXXXXX    200.853    599.057     XXXXXXXXXX     XXXXXXXXXX
    2004    Canada     XXXXXXXXXX     XXXXXXXXXX    642.028     XXXXXXXXXX    209.74    653.533     XXXXXXXXXX     XXXXXXXXXX
    2005    Canada    100     XXXXXXXXXX    680.08     XXXXXXXXXX    221.372    714.13     XXXXXXXXXX     XXXXXXXXXX
    2006    Canada     XXXXXXXXXX     XXXXXXXXXX    742.935     XXXXXXXXXX    232.412    771.67     XXXXXXXXXX     XXXXXXXXXX
    2007    Canada     XXXXXXXXXX     XXXXXXXXXX    793.518     XXXXXXXXXX    245.655    844.511     XXXXXXXXXX     XXXXXXXXXX
    2008    Canada     XXXXXXXXXX     XXXXXXXXXX    903.149    2.39    244.009    917.525     XXXXXXXXXX     XXXXXXXXXX
    2009    Canada     XXXXXXXXXX     XXXXXXXXXX    987.484    0.35    226.385    956.081     XXXXXXXXXX     XXXXXXXXXX
    2010    Canada     XXXXXXXXXX    398.857     XXXXXXXXXX    0.5975    233.171    1047.18    310.236     XXXXXXXXXX
    2011    Canada     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    249.029    1158.51    329.305     XXXXXXXXXX
    2012    Canada     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    0.9725    255.67    1266.86     XXXXXXXXXX     XXXXXXXXXX
    2013    Canada     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    266.192     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    2014    Canada     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    277.613     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    2015    Canada     XXXXXXXXXX     XXXXXXXXXX    1391.71     XXXXXXXXXX    284.087     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1960    Denmark     XXXXXXXXXX    10.317     XXXXXXXXXX     XXXXXXXXXX    7.366    10.642    19.957     XXXXXXXXXX
    1961    Denmark     XXXXXXXXXX    10.618     XXXXXXXXXX    6.625    8.117    12.446    21.936     XXXXXXXXXX
    1962    Denmark     XXXXXXXXXX    11.527     XXXXXXXXXX    7    9.884    14.365    24.529     XXXXXXXXXX
    1963    Denmark     XXXXXXXXXX    13.178     XXXXXXXXXX    6.8125    11.073    16.671    27.369     XXXXXXXXXX
    1964    Denmark     XXXXXXXXXX    14.553     XXXXXXXXXX     XXXXXXXXXX    12.524    19.766    31.283     XXXXXXXXXX
    1965    Denmark     XXXXXXXXXX    16.023     XXXXXXXXXX    7    14.477    23.6    35.454     XXXXXXXXXX
    1966    Denmark     XXXXXXXXXX    16.946     XXXXXXXXXX    7    17.17    28.34    40.431     XXXXXXXXXX
    1967    Denmark     XXXXXXXXXX    17.661     XXXXXXXXXX     XXXXXXXXXX    18.66    32.928    44.605     XXXXXXXXXX
    1968    Denmark     XXXXXXXXXX    19.799     XXXXXXXXXX     XXXXXXXXXX    25.194    38.49    49.641     XXXXXXXXXX
    1969    Denmark     XXXXXXXXXX    22.64     XXXXXXXXXX    8.5    27.632    46.184    57.175    0.08357
    1970    Denmark     XXXXXXXXXX    25.171     XXXXXXXXXX    9.5    36.844    53.15    63.309     XXXXXXXXXX
    1971    Denmark     XXXXXXXXXX    27.303     XXXXXXXXXX    8.1875    40.686    61.2    66.705     XXXXXXXXXX
    1972    Denmark     XXXXXXXXXX    30.789     XXXXXXXXXX     XXXXXXXXXX    47.076    72.425    77.784     XXXXXXXXXX
    1973    Denmark     XXXXXXXXXX    37.549     XXXXXXXXXX     XXXXXXXXXX    54.565    88.983    93.702     XXXXXXXXXX
    1974    Denmark     XXXXXXXXXX    46.92     XXXXXXXXXX     XXXXXXXXXX    66.818    104.528    107.092     XXXXXXXXXX
    1975    Denmark     XXXXXXXXXX    50.03     XXXXXXXXXX     XXXXXXXXXX    66.969    119.699    120.02     XXXXXXXXXX
    1976    Denmark     XXXXXXXXXX    55.035     XXXXXXXXXX    10.28    80.582    137.012    131.319     XXXXXXXXXX
    1977    Denmark     XXXXXXXXXX    60.436     XXXXXXXXXX     XXXXXXXXXX    90.686    151.311    145.295     XXXXXXXXXX
    1978    Denmark     XXXXXXXXXX    65.314     XXXXXXXXXX    15.42    105.052    168.325    158.016     XXXXXXXXXX
    1979    Denmark     XXXXXXXXXX    77.321     XXXXXXXXXX     XXXXXXXXXX    118.807    188.537    172.898     XXXXXXXXXX
    1980    Denmark     XXXXXXXXXX    94.359     XXXXXXXXXX    16.9275    131.455    196.472    193.382     XXXXXXXXXX
    1981    Denmark     XXXXXXXXXX    114.263     XXXXXXXXXX    14.84    144.34    214.756    208.901     XXXXXXXXXX
    1982    Denmark     XXXXXXXXXX    128.194     XXXXXXXXXX     XXXXXXXXXX    162.201    231.681    217.834     XXXXXXXXXX
    1983    Denmark     XXXXXXXXXX    146.761     XXXXXXXXXX    12.81    185.382    269.003    249.383     XXXXXXXXXX
    1984    Denmark     XXXXXXXXXX    165.335     XXXXXXXXXX    11.7725    215.152    314.368    280.25     XXXXXXXXXX
    1985    Denmark     XXXXXXXXXX    179.578     XXXXXXXXXX    10.3325    241.496    378.08    327.055     XXXXXXXXXX
    1986    Denmark     XXXXXXXXXX    171.72     XXXXXXXXXX    9.225    270.88    427.336    405.797     XXXXXXXXXX
    1987    Denmark     XXXXXXXXXX    175.187     XXXXXXXXXX     XXXXXXXXXX    284.001    450.049    470.245     XXXXXXXXXX
    1988    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    8.5275    292.605    463.112    500.949     XXXXXXXXXX
    1989    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    9.5936    302.61    468.915    543.609     XXXXXXXXXX
    1990    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    10.893    309.302    475.237    577.449     XXXXXXXXXX
    1991    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    9.6995    312.973    475.512    579.107     XXXXXXXXXX
    1992    Denmark     XXXXXXXXXX    251.025     XXXXXXXXXX    11.0351    334.599    469.819    590.615     XXXXXXXXXX
    1993    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    10.4054    348.426    473.482    587.001     XXXXXXXXXX
    1994    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    6.1344    376.736    496.667    552.226     XXXXXXXXXX
    1995    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    6.0693    382.615    524.44    567.438     XXXXXXXXXX
    1996    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    3.8693    405.011    567.645    584.889     XXXXXXXXXX
    1997    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    3.6585    416.212    627.973    614.313     XXXXXXXXXX
    1998    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    4.1462    427.192    695.376    667.444     XXXXXXXXXX
    1999    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    3.3076    442.97    743.741    702.127     XXXXXXXXXX
    2000    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    4.9074    457.382    799.253    822.347     XXXXXXXXXX
    2001    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    4.6186    458.204    876.667    903.133     XXXXXXXXXX
    2002    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    3.4848    469.819    938.597    945.203     XXXXXXXXXX
    2003    Denmark     XXXXXXXXXX    429.272     XXXXXXXXXX     XXXXXXXXXX    480.032    1022.89    986.378     XXXXXXXXXX
    2004    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    526.853    1125.49    1066.61     XXXXXXXXXX
    2005    Denmark    100     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    580.241    1304.72    1217.09     XXXXXXXXXX
    2006    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    606.125    1464.61    1397.79     XXXXXXXXXX
    2007    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    4.3275    686.696    1599.86    1628.98     XXXXXXXXXX
    2008    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    697.379    1641.71    1831.41     XXXXXXXXXX
    2009    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    657.606    1738.67    1767.15     XXXXXXXXXX
    2010    Denmark     XXXXXXXXXX    538.321     XXXXXXXXXX     XXXXXXXXXX    717.728    1776.58    1765.35    0.429
    2011    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    743.6    1816.91    1710.41    0.464
    2012    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    765.454    1844.84    1674.25    0.456
    2013    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    779.085     XXXXXXXXXX     XXXXXXXXXX    0.44
    2014    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    841.417     XXXXXXXXXX     XXXXXXXXXX    0.443
    2015    Denmark     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    798.124     XXXXXXXXXX     XXXXXXXXXX    0.399
    1960    Finland     XXXXXXXXXX     XXXXXXXXXX    6850    6.75    3140     XXXXXXXXXX     XXXXXXXXXX    0.1279
    1961    Finland     XXXXXXXXXX     XXXXXXXXXX    7847    6.75    3280     XXXXXXXXXX     XXXXXXXXXX    0.1013
    1962    Finland     XXXXXXXXXX     XXXXXXXXXX    8389    7    3660     XXXXXXXXXX     XXXXXXXXXX    0.1152
    1963    Finland     XXXXXXXXXX     XXXXXXXXXX    9168    7    3500     XXXXXXXXXX     XXXXXXXXXX    0.1344
    1964    Finland     XXXXXXXXXX     XXXXXXXXXX    10218    7    4400     XXXXXXXXXX     XXXXXXXXXX    0.1363
    1965    Finland     XXXXXXXXXX     XXXXXXXXXX    11291    7    4900     XXXXXXXXXX     XXXXXXXXXX    0.1423
    1966    Finland     XXXXXXXXXX     XXXXXXXXXX    12650    7    5500     XXXXXXXXXX     XXXXXXXXXX    0.1518
    1967    Finland     XXXXXXXXXX     XXXXXXXXXX    13681    7    6500     XXXXXXXXXX     XXXXXXXXXX    0.1583
    1968    Finland     XXXXXXXXXX     XXXXXXXXXX    15318    7    7700     XXXXXXXXXX     XXXXXXXXXX    0.1569
    1969    Finland     XXXXXXXXXX     XXXXXXXXXX    17328    7    8500     XXXXXXXXXX     XXXXXXXXXX    0.1208
    1970    Finland     XXXXXXXXXX     XXXXXXXXXX    19585    7    9400     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1971    Finland     XXXXXXXXXX     XXXXXXXXXX    22284    8.5    10400     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1972    Finland     XXXXXXXXXX     XXXXXXXXXX    26230    7.75    12400     XXXXXXXXXX     XXXXXXXXXX    0.09378
    1973    Finland     XXXXXXXXXX     XXXXXXXXXX    30307    9.25    15100     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1974    Finland     XXXXXXXXXX     XXXXXXXXXX    35860    9.25    18500     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1975    Finland     XXXXXXXXXX     XXXXXXXXXX    43017    9.25     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1976    Finland     XXXXXXXXXX     XXXXXXXXXX    46735    9.25     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1977    Finland     XXXXXXXXXX     XXXXXXXXXX    52192    8.25     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1978    Finland     XXXXXXXXXX     XXXXXXXXXX    60009     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1979    Finland     XXXXXXXXXX     XXXXXXXXXX    70320     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    0.11118
    1980    Finland     XXXXXXXXXX     XXXXXXXXXX    80572     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1981    Finland     XXXXXXXXXX     XXXXXXXXXX    92752     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    0.1149
    1982    Finland     XXXXXXXXXX     XXXXXXXXXX    104972     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1983    Finland     XXXXXXXXXX     XXXXXXXXXX    118729     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX
    1984    Finland     XXXXXXXXXX     XXXXXXXXXX    137044    16.5025     XXXXXXXXXX     XXXXXXXXXX     XXXXXXXXXX    0
Answered Same Day Jul 19, 2021

Solution

Suraj answered on Jul 20 2021
152 Votes
Introduction: We are given three sets of data sets with same variable. The variables in the data set are described as follows:
Yea
Country     Country name
gdppc        Real GDP per capita
exports        Exports
money        Money Supply
stir        Short term interest rate
evenue    Government Revenue
thh        Total loans to households
tbus         Total loans to business
debtgdp    Public (government) debt to GDP ratio (Public debt divided by GDP)
In this assignment we need to run the regression using rgdppc as our dependent variable and rest all the variables as independent variables.
a)
The first regression output for the Exam 1.Summer2021.File1.xlsx is given as follows:
Table (1)
Table (2)
)
The goodness of fit of the regression model is described as how well the model fitted. This can be check by using the concept of coefficient of determination or R-squared value. Here, from the table (2) the R-squared value for first model is 0.3005. Which indicates that the independent variables explain about 30.05% variation in the dependent variable. This model does not seem to be good...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here