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.

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 Equation
Y = 20.0 + 7.21 X

(a)

How many apartment buildings were in the sample?

(b)

Write the estimated regression equation.

ŷ =

(c)

What is the value of

sb1?

(d)

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

State the null and alternative hypotheses.

H0: β1 ≥ 0
Ha: β1 < 0H0: β1 = 0
Ha: β1 ≠ 0    H0: β0 = 0
Ha: β0 ≠ 0H0: β0 ≠ 0
Ha: β0 = 0H0: β1 ≠ 0
Ha: β1 = 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

State your conclusion.

Do not reject H0. We conclude that the relationship between selling price (in thousands of dollars) and annual gross rents (in thousands of dollars) is significant.Reject H0. We conclude that the relationship between selling price (in thousands of dollars) and annual gross rents (in thousands of dollars) is significant.     Reject H0. We cannot conclude that the relationship between selling price (in thousands of dollars) and annual gross rents (in thousands of dollars) is significant.Do not reject H0. We cannot conclude that the relationship between selling price (in thousands of dollars) and annual gross rents (in thousands of dollars) is significant.

(e)

Predict the selling price (in thousands of dollars) of an apartment building with gross annual rents of $55,000.----------

$  thousand

Solutions

Expert Solution

Answer: 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 Equation

Y = 20.0 + 7.21 X

Solution:

a)How many apartment buildings were in the sample?

df = n-1

8 = n-1

Sample size, n = 9

b) Write the estimated regression equation.

ŷ = 20.0 + 7.21 X

c) What is the value of sb1?

From the given data output,

Standard error of b1,Sb1 = 1.3626

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

State the null and alternative hypotheses.

H0: β1 = 0

Ha: β1 ≠ 0

e) Predict the selling price (in thousands of dollars) of an apartment building with gross annual rents of $55,000.

X = 55 (in thousands of dollars)

ŷ = 20.0 + 7.21 X

ŷ = 20.0 + 7.21 * 55

ŷ = 416.55 (in thousands of dollars).


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