Explore BrainMass

Multiple Regression Analysis

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

For this case we are going to look at housing starts again, but this time we are going to add another variable to the equation. The historical values below give interest rates, lumber prices (dollars per board-foot) and number of starts. We will compute a multiple regression equation using these variables, with starts as the DV. Interest and price are the IVs. Once you have computed the multiple regression equation, answer the following questions.

What is the regression formula that you computed? It should be of the form

Y = a1*X1 + a2*X2 + b


* Y = number of housing starts
* X1 = interest rates
* a1 = regression coefficient of interest rates
* X2 = lumber prices
* a2 = regression coefficient of lumber prices
* b = constant.

What would the approximate number of housing starts be at the following interest rates and lumber prices:

9.0% at $1.00 per board foot

8.5% at $1.50 per board foot

5.5% at $1.25 per board foot

4.5% at $0.90 per board foot

3.7% at $1.00 per board foot

2.3% at $0.75 per board foot.

As before, you'll need to use the regression equation to calculate the number of starts. Don't try to "guess" the answers using the historical data.

Historical values: Housing Starts in Relation to Interest Rates and Lumber Prices

Interest Rate Price Per Board Foot Housing Starts

11% $1.25 8,500

11% $1.00 9,000

11% $0.90 9,200

11% $0.75 9,500

10% $1.25 9,700

10% $1.00 10,000

10% $0.90 10,300

9% $1.25 22,000

9% $1.00 24,000

8% $1.25 39,000

8% $0.90 45,000

8% $0.75 52,000

If you were the owner of a business in the housing construction sector how would this information affect your decisions?

© BrainMass Inc. brainmass.com October 17, 2018, 1:12 am ad1c9bdddf

Solution Summary

A detailed Multiple Regression Analysis has been performed on the given data. This solution provides students with a clear perspective of the underlying statistical aspects of Multiple Regression Analysis.

Similar Posting

Use of Simple-Linear and Multiple Regression Analysis

1. Can you think of an example where analysis of simple-linear and multiple regression analysis can be used? How is regression analysis being used in the financial industry, or how should it be used to formulate strategies?
2. What are examples in which regression analysis is used for forecasting?
3. What is correlation analysis? How can correlation analysis be used in a business decision or examples specifically related to strategy formulation and implementation?
4. What are some primary and secondary sources of data that may be used in correlation and regression analysis?
5. What is the difference between correlation and causation? Give examples

View Full Posting Details