Question

In: Statistics and Probability

A real estate analyst estimates the following regression, relating a house price to its square footage...

A real estate analyst estimates the following regression, relating a house price to its square footage (Sqft):

PriceˆPrice^ = 48.36 + 52.50Sqft; SSE = 56,018; n = 50

In an attempt to improve the results, he adds two more explanatory variables: the number of bedrooms (Beds) and the number of bathrooms (Baths). The estimated regression equation is

PriceˆPrice^ = 28.71 + 40.44Sqft + 10.58Beds + 16.44Baths; SSE = 48,937; n = 50

[You may find it useful to reference the F table.]

a. Choose the appropriate hypotheses to determine whether Beds and Baths are jointly significant in explaining Price.

  • H0: β2 = β3 = 0; HA: At least one of the coefficients is greater than zero.

  • H0: β2 = β3 = 0; HA: At least one of the coefficients is nonzero.

  • H0: β1 = β2 = β3 = 0; HA: At least one of the coefficients is nonzero.

b-1. Calculate the value of the test statistic. (Round intermediate calculations to at least 4 decimal places and final answer to 3 decimal places.)

b-2. Find the p-value.

  • 0.025p-value < 0.05
  • 0.01p-value < 0.025
  • p-value < 0.01

  • p-value0.10
  • 0.05p-value < 0.10

c. At the 5% significance level, what is the conclusion to the test?

  • Reject H0Beds and Baths are jointly significant in explaining Price.
  • Reject H0Sqft Beds and Baths are jointly significant in explaining Price.
  • Do not reject H0 SqftBeds and Baths are not jointly significant in explaining Price.
  • Do not reject H0Beds and Baths are not jointly significant in explaining Price.

Solutions

Expert Solution


Related Solutions

A real estate analyst estimates the following regression, relating a house price to its square footage...
A real estate analyst estimates the following regression, relating a house price to its square footage (Sqft): PriceˆPrice^ = 48.21 + 52.11Sqft; SSE = 56,590; n = 50 In an attempt to improve the results, he adds two more explanatory variables: the number of bedrooms (Beds) and the number of bathrooms (Baths). The estimated regression equation is PriceˆPrice^ = 28.78 + 40.26Sqft + 10.70Beds + 16.54Baths; SSE = 48,417; n = 50 [You may find it useful to reference the...
Suppose the following data were collected relating the selling price of a house to square footage...
Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of brick. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average brick houses are more expensive than other types of houses at the 0.050.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else,...
Suppose the following data were collected relating the selling price of a house to square footage...
Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of wood. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average wood houses are more expensive than other types of houses at the 0.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else,...
Suppose the following data were collected relating the selling price of a house to square footage...
Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of wood. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average wood houses are more expensive than other types of houses at the 0.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else,...
(House Selling Price) The data below show the selling price, square footage, bedrooms, and age of...
(House Selling Price) The data below show the selling price, square footage, bedrooms, and age of houses that have sold in a neighborhood in the last six months. Selling price Square footage Bedrooms Age 64,000 1,670 2 30 59,000 1,339 2 25 61,500 1,712 3 30 79,000 1,840 3 40 87,500 2,300 3 18 92,500 2,234 3 30 95,000 2,311 3 19 113,000 2,377 3 7 115,000 2,736 4 10 138,000 2,500 3 1 142,500 2,500 4 3 144,000 2,479...
Determine the linear correlation coefficient between square footage and asking price. Square Footage, x Selling Price...
Determine the linear correlation coefficient between square footage and asking price. Square Footage, x Selling Price ($000s), y 2209 380.7 3323 396 1105 186.3 1953 334.5 3225 639.7 2741 365.7 3987 608 2147 367 2536 413.6 1632 286.2 1749 265.3 3882   700.2 r= ?
An analyst is assigned the task of evaluating a real estate investment project. Purchase price is...
An analyst is assigned the task of evaluating a real estate investment project. Purchase price is $700,000. Using the information in the table below, calculate the after-tax cash flow for the sale of the property. After-tax cash flow without property sale $33 546 Straight-line depreciation $18 700 Mortgage Payment $59 404 Cumulative Mortgage principle repayments until year 5 $20 783 80% financing at 10% interest rate Marginal income tax rate 31% Capital gains tax rate 20% Forecasted sales price $927...
The following data gives the selling price, square footage, number of bedrooms, and the age of...
The following data gives the selling price, square footage, number of bedrooms, and the age of a house in years. These houses have been sold in a specific neighborhood over the last six months. Selling Price ($) Square Footage Bedrooms Age (years) 84,000 1,670 2 30 79,000 1,339 2 25 91,500 1,712 3 30 120,000 1,840 3 40 127,500 2,300 3 18 132,500 2,234 3 30 145,000 2,311 3 19 164,000 2,377 3 7 155,000 2,736 4 10 168,000 2,500...
The following data give the selling price and square footage of houses that have sold in...
The following data give the selling price and square footage of houses that have sold in Bend, OR in the past 6 months. Selling Price ($) Square Footage 84,000 1,670 79,000 1,339 91,500 1,712 120,000 1,840 127,500 2,300 132,500 2,234 145,000 2,311 164,000 2,377 155,000 2,736 168,000 2,500 172,500 2,500 174,000 2,479 175,000 2,400 177,500 3,124 184,000 2,500 195,500 4,062 195,000 2,854 Graph the data to see whether a linear equation might describe the relationship between selling price and the...
A real estate association for a specific city puts the average price at which a house...
A real estate association for a specific city puts the average price at which a house was sold in a given year at $ 259 comma 109$259,109. Assume that the standard deviation of the house prices is ​$116 comma 088116,088. Suppose a researcher did a survey of a random selection of 3434 house sale prices in this year and obtained an average house price of $ 286 comma 489$286,489. ​What's the chance that such a survey would have resulted in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT