Explore BrainMass
Share

# 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.

https://brainmass.com/statistics/regression-analysis/regression-analysis-predicted-value-363438