Question

In: Statistics and Probability

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
Regression 1 41,587.3
Residual Error 7
Total 8 51,984.6

a. How many apartment buildings were in the sample?

b. Write the estimated regression equation (to 2 decimals if necessary).
ŷ =  +  x

c. What is the value of sb1 (to 4 decimals)?

d. Use the F statistic to test the significance of the relationship at a .05 level of significance.

Compute the F test statistic (to 2 decimals).

What is the p-value?

What is your conclusion?
A) Conclude that the selling price is related to annual gross rents. B) Cannot conclude that the selling price is related to annual gross rents.Item 7

e. Predict the selling price of an apartment building with gross annual rents of $50,000 (to 1 decimal).
$ thousands.

Solutions

Expert Solution

Solution:

a)How many apartment buildings were in the sample?

We know df=n-1

8=n-1

n=9

So 9 apartment buildings were there in the sample.

b) Write the estimated regression equation.

Y = 20.0 + 7.25 X is the estimated regression equation.

c) What is the value of sb1?

The value of sb1=1.3624

d)Formula to find F statistic is given by

F statistic =SSR/(SSE/n-2)

Given:

Analysis of Variance
SOURCE DF SS
Regression 1 SSR=41587.3
Residual Error 7 SSE=10397.3
Total 8 SST=51984.6

So from the above table let us solve for F statistic.

F statistic =SSR/(SSE/n-2)

=41587.3/(10397.3/(9-1))

=28

P-value for 0.05 level of significance and df1=1 and df2=7 is 5.59 from the below table.

Conclusion:Since F statistic=28 is greater than F-critical value=5.59, we reject null hypothesis.

Therefore we conclude that the selling price is related to annual gross rent.

e)Predict the selling price of an apartment building with gross annual rents of $50,000

We know Y = 20.0 + 7.25 X

For X=50,000 the value of Y=20+(7.25*50)=380.5*1000=$380,500


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. 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 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 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...
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