Explore BrainMass

Regression Analysis: Predicted value

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.


Solution Preview


B-Around 90,711 trillion BTUs


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.