Purchase Solution

Regression Analysis: Predicted value

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution

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.

Solution Preview

Answer

B-Around 90,711 trillion BTUs

Hint:

From the excel ...

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.