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

Collect Data on Investments on Infrastructure development for at least 10 countries for the past three years (most recent past as available) from the World Bank data sources and Run a Multiple...

1 answer below »

Collect Data on Investments on Infrastructure development for at least 10 countries for the past three years (most recent past as available) from the World Bank data sources and Run a Multiple regression to examine the Effects of such Investments on GDP growth rate.

Be sure to explain the variables chosen and the results including testing of appropriate hypotheses.

Answered Same Day Apr 13, 2021

Solution

Komalavalli answered on Apr 13 2021
150 Votes
Sheet1
    Country Name    Year    IROA    IRAIL    GDP%
    AUS    2017    11863364266.724    2563852635.6123    2.3006106236
    AUS    2018    13676319910.035    3825342109.5036    2.9492857716                SUMMARY OUTPUT
    AUS    2019    14717863170.703    5025635392.8338    2.1609562954
    AUT    2017    444000000    1523000000    2.3995876033                Regression Statistics
    AUT    2018    515000000    1552000000    2.580120733                Multiple R    0.1233979191
    AUT    2019    463000000    1682000000    1.4187342725                R Square    0.0152270464
    CAN    2017    7042672778.2188    796508456.08292    3.1707298966                Adjusted R Square    -0.0577190983
    CAN    2018    7481340453.8651    918464900.30046    2.0136391873                Standard E
or    1.6056675796
    CAN    2019    6578805867.2592    1081557966.2789    1.656040845                Observations    30
    DNK    2017    1099470814.194    681496030.95338    1.7994088496
    DNK    2018    1065643190.3424    565612750.31146    2.7505537748                ANOVA
    DNK    2019    1083963934.9541    741057048.48478    0.9288324117                    df    SS    MS    F    Significance F
    FRA    2017    9169000000    1185026996.5348    1.1885725823                Regression    2    1.076352692    0.538176346    0.2087436767    0.8129007357
    FRA    2018    9084000000    1228171589.1218    3.949320891                Residual    27    69.6105461537    2.5781683761
    FRA    2019    9630130000    1351365856.2765    1.0544425507                Total    29    70.6868988457
    DEU    2017    12870000000    8614650000    6.9472007933
    DEU    2018    14240000000    9334770000    6.7497738325                    Coefficients    Standard E
or    t Stat    P-value    Lower 95%    Upper...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File