Share
Explore BrainMass

Conduct a Regresssion Analysis

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

Which of the following is the lowest level at which the independent variable is significant?

Energy Consumption and GDP
Source

0.94
0.10
0.05
0.01

Which of the following statements is true?

Energy Consumption and GDP
Source

The y-intercept of the regression line is 62,695 trillion BTUs.
The x-intercept of the regression line is $62,695 trillion.
In the event that a thermonuclear war completely halts all economic activity and the US GDP drops to zero, energy consumption will sink to 62,695 trillion BTUs.
None of the above.

Attachments

Solution Preview

Null hypothesis H0: rho=0
Alternative hypothesis ha: rho is not equal to 0 ---- It means there is a significant relationship between variables.

The following table was obtained by using EXCEL. You can see it in the Sheet 1.

---------------------------------------------------------------------------------------------------
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.970868872
R Square 0.942586368
Adjusted R ...

Solution Summary

This solution consists of details of conducting a regression analysis by Excel.

$2.19