Question

In: Math

The commercial division of a real estate firm is conducting a regression analysis of the relationship...

  1. The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained.

Analysis of Variance SOURCE DF Regression 1 Error 7 Total 8

Predictor Coef Constant 20.000 X

Adj SS 41587.3

51984.1

SE Coef T-value 3.2213 6.21 1.3626 5.29

(a) How many apartment buildings are in the sample?
(b) What is the value of b1.
(c) Write the estimated regression equation.
(d) Use the F statistic to test the significance of the relationship at a 0.05 level of

significance.
(e) Predict the selling price of an apartment with gross rents of $50 000.

Solutions

Expert Solution

(a) (3 marks) How many apartment buildings are in the sample?

df = 8

We know that df = n - 1 = 9 - 1 = 8

Therefore, there are 9 apartment buildings in the sample.

(b) (4 marks) What is the value of b1.

The value of b1 is 6.21

(c) (6 marks) Write the estimated regression equation.

The estimated regression equation is:

y = 20.000 + 6.21*x

(d) (6 marks) Use the F statistic to test the significance of the relationship at a 0.05 level of

significance.

The p-value for f statistic = 5.29 is 0.0550.

Since the p-value (0.0550) is greater than the significance level (0.05), we cannot reject the null hypothesis.

Therefore, we cannot conclude that the relationship is significant at a 0.05 level of significance.

(e) (3 marks) Predict the selling price of an apartment with gross rents of $50 000.

The estimated regression equation is:

y = 20.000 + 6.21*x

Put x = 50

y = 20.000 + 6.21*50

y = 330.5 (in thousands of dollars))

Or Selling price = $330500


Related Solutions

The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y = 20.0 + 7.25 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X   7.250 1.3624 5.29 Analysis of Variance SOURCE DF SS...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. Analysis of Variance SOURCE DF Adj SS Regression 1 41587.3 Error 7 Total 8 51984.1 Predictor Coef SE Coef T-Value Constant 20.000 3.2213 6.21 X 7.210 1.3626 5.29 Regression...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between x, annual gross rents (in thousands of dollars), and y, selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. Analysis of Variance SOURCE DF Adj SS Regression 1 41587.3 Error 7 Total 8 51984.1 Predictor Coef SE Coef T-Value Constant 20.000 3.2213 6.21 X 7.210 1.3626 5.29 Regression...
The commercial division of a real estate firm is conducting a regression analysis of the relationship...
The commercial division of a real estate firm is conducting a regression analysis of the relationship between , annual gross rents (in thousands of dollars), and , selling price (in thousands of dollars) for apartment buildings. Data were collected on several properties recently sold and the following computer output was obtained. The regression equation is Y= 20.0 +7.25 X Predictor Coef SE Coef T Constant 20.000 3.2213 6.21 X 7.250 1.3625 5.29 Analysis of Variance SOURCE DF SS Regression 1...
The commercial division of a real estate firm conducted a study to determine the extent of...
The commercial division of a real estate firm conducted a study to determine the extent of the relationship between annual gross rents ($1000s) and the selling price ($1000s) for apartment buildings. Data were collected on several properties sold. The data is... df SS MS F Significance F Regression 1 41976.4 Residual 7 Total 8 52373.2 Coefficients Standard Error t Stat P-value Intercept 19 3.2213 6.21 Annual Gross Income 7.75 1.457806668 5.31620562 (a) How many apartments are there? (b) Write the...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales prices and the various characteristics of apartments and buildings. The variables collected from a random sample of 25 compartments are as follows: Sale price: The sale price of the apartment (in €) Apartments: Number of apartments in the building Age: Age of the building (in years) Size: Apartment size (area in square meters) Parking spaces: Number of car parking spaces in the building Excellent...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales...
A real estate agent in Athens used regression analysis to investigate the relationship between apartment sales prices and the various characteristics of apartments and buildings. The variables collected from a random sample of 25 compartments are as follows: Sale price: The sale price of the apartment (in €) Apartments: Number of apartments in the building Age: Age of the building (in years) Size: Apartment size (area in square meters) Parking spaces: Number of car parking spaces in the building Excellent...
Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year...
Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year forecast of free cash flows for this​ division: Year 1 Year 2 Year 3 Year 4 Free cash flow −$124,000 $11,000 $98,000 $248,000 Assume cash flows after year 4 will grow at 3% per​ year, forever. If the cost of capital for this division is 14%​, what is the continuation value in year 4 for cash flows after year​ 4? What is the value...
Bay Properties is considering starting a commercial real estate division. It has prepared the following? four-year...
Bay Properties is considering starting a commercial real estate division. It has prepared the following? four-year forecast of free cash flows for this? division: Year 1 Year 2 Year 3 Year 4 Free cash flow ?$152,000 $12,000 $84,000 $211,000 Assume cash flows after year 4 will grow at 4% per? year, forever. If the cost of capital for this division is 10%?, what is the continuation value in year 4 for cash flows after year? 4? What is the value...
Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year...
Bay Properties is considering starting a commercial real estate division. It has prepared the following​ four-year forecast of free cash flows for this​ division: year 1 year 2 year 3 year 4 Free Cash Flow -132,000 15,000 85,000 239,000 Assume cash flows after year 4 will grow at 5 % per​ year, forever. If the cost of capital for this division is 8 %​, a. what is the continuation value in year 4 for cash flows after year​ 4? b....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT