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

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

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