Purchase Solution

Linear regression

Not what you're looking for?

Ask Custom Question

A report on housing in metropolitan areas suggests a regression model relating the mean price of a housing unit to several factors, such as median income, average monthly rent of new units and vacancy rate. A sample of 25 cities was taken.
a) Write down the multiple regression equation.
b) Interpret the meaning of the intercept and regression coefficients.
c) Discuss the strength of the multiple regression model on the basis of the computer output. Did the estimated regression equation provide a good fit?
d) Discuss the significance of each of the regression coefficients.
e) How would you improve the model given a chance and taking into account tests for significance? What other independent variables you might include in the model?

SUMMARY OUTPUT
___________________
Regression Statistics
___________________
Multiple R 0.9165
R Square 0.8399
Adjusted R Square 0.8171
Standard Error 6.4514
Observations 25
ANOVA
__________________________________________________
df SS MS F Significance F
__________________________________________________
Regression 3 4586.2701 1528.7567 36.730 0.0001
Residual 21 874.0395 41.6209
Total 24 5460.3096
_________________________________________________

__________________________________________________
Coefficients Standard Error T-Stat P-value
__________________________________________________
Intercept -11.1091 32.7302 -0.339 0.7377
INCOME 2.0179 0.7323 2.756 0.0118
RENT 0.1812 0.0691 2.623 0.0159
VACANT -0.3143 0.0599 -0.524 0.6056

Attachments
Purchase this Solution
Solution Summary

Interprets linear multiple regression output.

Solution Preview

A report on housing in metropolitan areas suggests a regression model relating the mean price of a housing unit to several factors, such as median income, average monthly rent of new units and vacancy rate. A sample of 25 cities was taken.
a) Write down the multiple regression equation.
Y=-11.1091 + 2.0179 X1 + 0.1812 X2 - 0.3143 X3
Where
Y= mean price of housing unit
X1= Median income
X2= Average monthly rent of new units
X3= Vacancy rate

b) Interpret the meaning of the intercept and regression coefficients.
Y= mean price of housing unit
Intercept coefficient= -11.1091.
This is a constant in the intercept equation. This means that its value remains at -11.1091 for any combination of X1, X2 and X3.
The coefficient of X1(= Median income) is 2.0179
Thus for every unit rise in X1 (median income ) the mean price of housing unit (Y) ...

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

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

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Relationship of Linear Regression & Correlation

    622757 Relationship of Linear Regression & Correlation When is it appropriate to use linear regression? What is the relationship between linear regression and correlation?

  • Discuss the definition of linear regression

    595859 Discuss the definition of linear regression What is linear regression? Can you give an example? Answer: linear regression is a tool to check the relationship between two variables.

  • simple linear regression models

    169332 simple linear regression models Develop simple linear regression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually.

  • Simple Linear Regression and Multiple Regression.

    Simple Linear Regression and Multiple Regression.

  • Simple Regressions and Multiple Regressions

    How is regression used to generate prediction equations in SPSS? How are prediction equations used to make predictions? What is multiple linear regression? How are predictions made using multiple linear regression equations?

  • Advantages of Linear Regression in Complex Situations

    330240 Advantages of Linear Regression in Complex Situations How does a linear regression allow us to better estimate trends, costs, and other factors in complex situations? Linear regression estimates the line of best fit for any given data.

  • Regression analysis and simple linear regression

    The following results were obtained as part of a simple linear regression analysis. MSE = 25.485.

  • ABC Furniture Company Linear Regression

    626456 ABC Furniture Company Linear Regression See Attached Background: Linear Regression Forecasting and Decision Trees Why is Forecasting important? How can we use Linear Regression as a forecasting method?

  • Theory, analysis and interpretation of regression

    Since in regression we need to solve for the coefficients of the regression line, matrix method can be used to this end. In this way, linear algebra can help perform linear regression.

  • Linear Regression

    314352 Linear Regression What is the idea behind linear regression? What is it? Why do it? What are some limitations of linear regression? Linear regression is used as a model to a set of data.

View More Related Solutions