ASSIGNMENT

Regression Analysis on Real Estate



Table of Contents

Introduction3

Body3

Correlation between Rent and Vacancy5

Multiple Regressions5

Forecasting of Vacancy6

Forecasting of Vacancy Rate9

Forecasting of Vacancy Rate (t-1)10

Forecasting of Rent12

Conclusion15

Regression Analysis on Real Estate

Introduction

In this study we have applied the regression analysis to forecast two variables, Rent and VacRate, for the year 2011-16 periods. Both the variables are interdependent variables, it is the variable you have control over, what you can choose and manipulate. It is usually what you think will affect the dependent variable. In some cases, you may not be able to manipulate the independent variable. It may be something that is already there and is fixed, something you would like to evaluate with respect to how it affects something else, the dependent variable like colour, kind, time.

In order to forecast the Rent and Vacrate variables we first have to predict the vacancy variable, after that we have forecasted the Rent with the help of Vacancy. Vacancy Rate can be estimated through the formula given in the Excel sheet; we have taken the hypothetical values through that formula and then forecasted the values of Rent. And finally in the last we have forecasted the VacRate variable with the help of all the predictors. We have applied the statistical technique of regression to forecast the variables (Levine, 2009, Pp: 23-54).

Body

Regressions are a form of statistical analysis frequently used to test causal hypotheses in social science research. A simple way of thinking about regressions is to try, given a scatter plot of data, to fit the best line to run through, and thereby describe, those data. Regressions are useful because that line can tell researchers a lot more about whether the data support a hypothesis than just the scatter plot alone.

Descriptive Statistics

N

Minimum

Maximum

Mean

Std. Deviation

Rent

37

33.00

96.37

58.9854

18.97438

Output

37

19964.00

40014.00

2.9338E4

7263.41437

EmploymentFBS

37

1.68E5

3.10E5

2.4124E5

41149.23614

TakeUP

37

1648.00

6100.00

4.0127E3

1299.63578

Vacancy

37

5103.00

14702.00

1.0644E4

2538.07698

Stock

37

63161.00

95628.00

7.9431E4

11001.80023

VacRate

37

7.71

16.96

13.3251

2.32499

Valid N (listwise)

37

The table above shows the descriptive statistics for the overall data set, it gives us a clear picture. Overall there are 37 observation taken from the year 1980 - 2016, it can be said that the average rent for the mentioned time period is 58.95 £, whereas the average Vacancy rate for the time period is 13.325. The average output for the city of London is 29338 million pounds. The graphs of the data set variables suggest that the data is normally distributed and they posses the assumptions of normality.

The key variables in the data set are described below.

City Rent

Annual real rent in pounds per square feet.

City Output

Total Output of London city in million pounds.

City employment

Financial and Business Service employment

City TakeUp

Total Annual TakeUp

City Vacancy

End of year Vacancy in thousands square feet.

City Stock

End of year Total Stock.

Correlation between Rent and Vacancy

Correlations

Rent

Vacancy

Rent

Pearson Correlation

1

.025

Sig. (2-tailed)

.882

N

37

37

Vacancy

Pearson Correlation

.025

1

Sig. (2-tailed)

.882

N

37

37

The above table shows the correlation between rent and Vacancy, the results suggests that there exist a significant relationship between the two variables. Although the relationship is not too strong as the magnitude suggest there is only 25% relationship between the variables. The magnitude of significant value i.e. 0.882 suggests that the variables are not significantly different.

Multiple Regressions

Bivariate regressions are useful, but usually when we want to ...