Explore BrainMass
Share

Explore BrainMass

    Regression Analysis: Predicted value

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The regression analysis in the Excel file relates US annual energy consumption in trillions of BTUs to the independent variable US Gross Domestic Product (GDP) in trillions of dollars.

    Excel Output

    US Energy Consumption (in trillion BTUs)
    vs. Gross Domestic Product ($trillions)

    Regression Statistics
    Multiple R 0.9709
    R2 0.9426
    Adjusted R2 0.9394 F test results
    Standard Error 1,889 F value Signif. F
    Observations 20 295.51 0.0000

    Coefficients Std Error t Stat P-value
    Intercept 62,695 1,325 47.31 0.0000
    GDP ($trillions) 3,786 220 17.19 0.0000

    In a given war, if GDP is $7.4 trillion, expected energy consumption is:

    which one?

    A-Around 91,501 trillion BTUs

    B-Around 90,711 trillion BTUs

    C-Around 28,016 trillion BTUs

    D-Around 467,729 trillion BTUs.

    © BrainMass Inc. brainmass.com October 10, 2019, 2:06 am ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/regression-analysis-predicted-value-363438

    Attachments

    Solution Preview

    Answer

    B-Around 90,711 trillion BTUs

    Hint:

    From the excel ...

    Solution Summary

    The solution provides step by step method for the calculation of expected energy consumption from regression analysis output. Formula for the calculation is also included.

    $2.19