Question

In: Math

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 estimated regression equation
(c) Use the t-test to determine whether the selling price is related to annual gross rents. Use a=0.05
(d) Use the f-test to determine whether the selling price is related to annual gross rents. Use a=0.05
(e) Predict the selling price of an apartment building with gross annual rents of $52500

Solutions

Expert Solution

a)

here as degree of freedom of residual n-2=7

hence number of apartments =n+2=7+2=9

b)

frm above estimated regression equation: Yhat =19+7.75*x

where Yhat is estimated selling price corresponding to x , annual gross income.

c)null hypothesis:Ho: =0

alternate hypothesis :Ha:0

here for 0.05 level and 7 degree of freedom crtiical value= -/+ 2.365

as test statistic for slope 5.316 is in critical region we reject null hypothesis

and conclude that  selling price is related to annual gross rents

d)

here null hypothesis: Ho: price and annual gross rents are indepednent

alternate hypothesis: Ha: there is a relation between  price and annual gross rents

for (1,7) degree of freedom in numerator and denominator at 0.05 level crtiical value =5.591

here test statisitc F =MS(regresion)/MS(residual)=(41976.4/1)/((52373.2-41976.4)/7)=28.262

as test statistic f is in critical region we reject null hypothesis

and conclude that  selling price is related to annual gross rents

e)

predicted selling price =(19+7.75*52.5) ($1000s) =425.875  ($1000s) or $425875


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...
A real estate study was conducted in the Washington, DC, area to determine if certain variables...
A real estate study was conducted in the Washington, DC, area to determine if certain variables are related to the sales price of a townhouse. As part of his investigation, he ran the following multiple regression model: Sales Price = β0 + β1(Square Feet) + β2(Distance) + εi where the deviations εi were assumed to be independent and normally distributed with mean 0 and standard deviation σ. The two explanatory variables are the square footage of the townhouse and the...
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....
A study is conducted to determine the extent to which drinking alcohol impairs driving ability. Forty...
A study is conducted to determine the extent to which drinking alcohol impairs driving ability. Forty volunteers are each tested twice on a computer simulated driving course, once while sober and once while intoxicated. The tests took place over two days and the order of the treatments were randomly assigned to each volunteer. One of the variables measured is the response time (in seconds) to a certain stimuli. The mean difference in response times measured while intoxicated versus sober is...
Gulf Real Estate Properties, Inc., is a real estate firm in southwest Florida. The company monitors...
Gulf Real Estate Properties, Inc., is a real estate firm in southwest Florida. The company monitors condominium sales by collecting data on location, list price, sale price, and the number of days it takes to sell each unit. Each condo is classified as Gulf View if it is located directly on the Gulf of Mexico or No Gulf View if it is located on the bay or a golf course. The data set contains sales data for 40 Gulf View...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT