Explore BrainMass
Share

# Prediction using Multiple Regression Analysis

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

SELLING SQUARE AGE
PRICE(\$) FOOTAGE BEDROOMS (YEARS)
64,000 1,670 2 30
59,000 1,339 2 25
61,500 1,712 3 30
79,000 1,840 3 40
87,500 2,300 3 18
92,500 2,234 3 30
95,000 2,311 3 19
113,000 2,377 3 7
115,000 2,736 4 10
138,000 2,500 3 1
142,500 2,500 4 3
144,000 2,479 3 3
145,000 2,400 3 1
147,500 3,124 4 0
144,000 2,500 3 2
155,500 4,062 4 10
165,000 2,854 3 3

Use the data and develop a regression model to predict selling price based on the square footage and number of bedrooms. Use this to predict the selling price of a 2,000-square-foot house with 3 bedrooms. Should the number of bedrooms be included in the model? Why or why not?

https://brainmass.com/statistics/regression-analysis/483800

#### Solution Preview

Please see the attachment for solution. Thanks.

In excel 2003 select Tools then Data analysis, in that select ...

#### Solution Summary

The solution explains the construction of a regression model to predict selling price based on the square footage and number of bedrooms.

\$2.19

## Key Data Regarding Multiple Regression Analysis

See attached file for full output.

Municipalities and states have been asked by the Department of Energy to assess their energy requirements for each of the alternative fuels. In particular, they have decided to focus initially on natural gas, given the enormity of U.S. reserves and its relative cleanliness.

Following are the data and output for selected municipalities in Illinois for 10 reporting periods (weeks). The dependent variable is consumption of natural gas in millions of cubic feet (Fuelcons) and the independent variables are the temperature (Temp), measured in degrees Fahrenheit, and a 'chill index' (Chill), which takes values from 0 to 30, and which includes other fuel consumption determinants besides temperature, such as wind speed and direction, and cloud cover.
Using the attached MegaStat output, identify and interpret the confidence and prediction intervals for given values of the independent variables

When the temperature = 44 degrees (Fahrenheit) and the chill index = 12

Round all entries to four decimal places.

predicted value =

Interpretation of the predicted value:

A. This is the point prediction of fuel consumption when the temperature = 44 degrees (Fahrenheit) and the chill index = 12

B. This is the fuel consumption we predict will occur 95% of the time when the temperature = 44 degrees (Fahrenheit) and the chill index = 12.

C. This is the fuel consumption amount we use to predict when the temperature will = 44 degrees (Fahrenheit) and the chill index will = 12.

D. This is our prediction of the standard error associated with a temperature = 44 degrees (Fahrenheit) and a chill index = 12.

E. This value has no practical interpretation, because global warming makes any predictions uncertain.

95% confidence interval = [ , ]

Interpretation of the 95% confidence interval:

A. This says we are 95% confident that the mean fuel consumption for all weeks will be between these values.

B. This says we are 95% confident that the mean fuel consumption in a single week having a temperature = 44 degrees (Fahrenheit) and a chill index = 12 will be between these values.

C. This says 95% of the fuel consumption values will be between these values.

D. This says we are 95% confident that the mean fuel consumption for all weeks having a temperature = 44 degrees (Fahrenheit) and a chill index = 12 will be between these values.

E. This confidence interval has no practical interpretation because of the uncertainty of global warming.

95% prediction interval = [ , ]

Interpretation of the 95% prediction interval:

A. This says we are 95% confident that the mean fuel consumption for all weeks will be between these values.

B. This says we are 95% confident that the mean fuel consumption in any single week having a temperature = 44 degrees (Fahrenheit) and a chill index = 12 will be between these values.

C. This says 95% of the fuel consumption values will be between these values.

D. This says we are 95% confident that the mean fuel consumption for all weeks having a temperature = 44 degrees (Fahrenheit) and a chill index = 12 will be between these values.

E. This confidence interval has no practical interpretation because of the uncertainty of global warming.

Please make this selection: A, B, C, D, or E

View Full Posting Details