Question

In: Statistics and Probability

The regression model below examines factors that impact the DV home sale price among recently sold...

  1. The regression model below examines factors that impact the DV home sale price among recently sold homes in a suburban community. The IV is total rooms within the home, and the EVs include 1) total bedrooms, 2) total bathrooms, 3) whether the home has a basement or not, and 4) the total number of days the home was on the market prior to its sale. Please answer the following regarding the regression output below:

    A) Identify the variables that are statistically significant predictors (at the .05 percentlevel) of a home’s sale price. [3]

    B) Of the variables you identified in Part A, what statistics did you examine todetermine each variable’s statistical significance? Explain the thresholds used to determine statistical significance. [3]

    C) Explain what the coefficient for the EV “Total Bathrooms” means. [3]D) Explain what the coefficient for the EV “Days on Market” means. [3]E) What does the model’s R-square of .33 mean? [3]

Solutions

Expert Solution

Answer:

(A)

Here, the regression for which p - value is less than 0.05, those regression or independent variables are significant in nature.

Here Total Rooms and bathrooms are the only significant factor here.

(B)

To evaluate the statistical significance of each variable, we can evaluate the t- value and the

p - value.

Here critical value of t - statistic is critical = t0.05,90 = 1.9867

and either we can evaluate p = value (critical) = 0.05

so those variables who has absolute t value l t l < tcritical , those are not significant in nature.

(C)

Here Coefficient for the EV "Total bathrooms" mean that "If we increase one bathroom in the house that will increase the sale price of home by $ 43553.03".

(D)

Here coefficient for the EV "Days of Market " means that "if there is an increase of number of days the house was in the market prior to sale that will decrease its sales price by $ 72.53.

(E)

Here R- square of 0.33 mean that 33% of the variation in the sales price of the house is explained by the variation in the independent variables.


Related Solutions

​​​​​Below is the regression of units sold on the average price of the product. Regression Statistics...
​​​​​Below is the regression of units sold on the average price of the product. Regression Statistics Multiple R 0.2461 R Square 0.2000 Adjusted R Square 0.1649 Standard Error 26.128 Observations 20 ANOVA Df SS MS F Significance F Regression 1 3080.89 3080.89 4.51 0.0478 Residual 18 12288.31 682.68 Total 19 15369.20 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 614.9300 51.2343 12.002 0.0000 507.2908 722.5692 X -109.1120 51.3623 -2.124 0.0478 -217.0202 -1.2038 What is the estimated regression...
1. The regression equation below describes a multivariable linear regression model for average salary among faculty...
1. The regression equation below describes a multivariable linear regression model for average salary among faculty who received initial K Award funding in 2000-2003 (Jagsi, et al, JAMA, June 13, 2012—Vol 307, No. 22, Table 3) Average Salary = 166 094 + 13,399*Male + 48,205*(Full Professor) + 17,007*(Associate Professor) + 60,379*(Surgical Specialties) – 10,190*(Hospital-based Specialties) – 1,317*(Specialties for Children, Women and Families) + 393*(Number of Publications – 30) +31,232*(Leadership position) – 361*(Percent Research Time) +19,070*(Moderate Paying Specialty) + 51,204*(High-paying Specialty)...
A sample of 24 recently sold. The variables are: the sale price in $/10000 (Y), the size of the home in sq. ft./1000 (X1), and the number of rooms (X2).
  29.5 1.5 7 27.9 1.175 6 25.9 1.232 6 29.9 1.121 6 29.9 0.988 6 30.9 1.24 7 28.9 1.501 6 35.9 1.225 6 31.5 1.552 6 31 0.975 5 30.9 1.121 6 30 1.02 5 36.9 1.664 8 41.9 1.488 7 40.5 1.376 6 43.9 1.5 7 37.5 1.256 6 37.9 1.69 6 44.5 1.82 8 37.9 1.652 6 38.9 1.777 8 36.9 1.504 7 45.8 1.831 8 25.9 0.998 7 A sample of 24 recently sold. The...
A Realtor examines the factors that influence the price of a house in Arlington, Massachusetts. He...
A Realtor examines the factors that influence the price of a house in Arlington, Massachusetts. He collects data on recent house sales (Price) and notes each house’s square footage (Sqft) as well as its number of bedrooms (Beds) and number of bathrooms (Baths). A portion of the data is shown in the accompanying table. Price Sqft Beds Baths 840,000 2,768 4 3.5 822,000 2,500 4 2.5 ⋮ ⋮ ⋮ ⋮ 307,500 850 1 1 Click here for the Excel Data...
Use a model to describe the factors that impact on the health of an individual.
Use a model to describe the factors that impact on the health of an individual.
Recently, you sold 500 shares of stock for $16.60 a share. the sale was a short...
Recently, you sold 500 shares of stock for $16.60 a share. the sale was a short sale with an initial margin requirement of 70 percent. The maintenance margin is 35 percent. The stock is currently trading at $17.80 a share. What is your current short position in this stock?
Your firm recently sold an asset and financed the sale of the asset. The firm took...
Your firm recently sold an asset and financed the sale of the asset. The firm took back a $170,000 loan on the equipment sale with monthly payments and 8% interest. The loan was a 5-year loan. Your firm now needs cash and desires to sell the loan. If investors require 12% rate of return to invest in this type of loan and 6 payments have been made on the loan, how much will your firm receive from the sale of...
Use the “home” data to build a regression model that predicts market as a function of...
Use the “home” data to build a regression model that predicts market as a function of square feet. Give a 99% confidence interval for the value of one square foot. (select the closest answer) Home Market Value House Age Square Feet Market Value 33 1,812 $90,000.00 32 1,914 $104,400.00 32 1,842 $93,300.00 33 1,812 $91,000.00 32 1,836 $101,900.00 33 2,028 $108,500.00 32 1,732 $87,600.00 33 1,850 $96,000.00 32 1,791 $89,200.00 33 1,666 $88,400.00 32 1,852 $100,800.00 32 1,620 $96,700.00 32...
Use the “home” data to build a regression model that predicts market as a function of...
Use the “home” data to build a regression model that predicts market as a function of square feet. Is the coefficient for square feet significant at a .05 level? Home Market Value House Age Square Feet Market Value 33 1,812 $90,000.00 32 1,914 $104,400.00 32 1,842 $93,300.00 33 1,812 $91,000.00 32 1,836 $101,900.00 33 2,028 $108,500.00 32 1,732 $87,600.00 33 1,850 $96,000.00 32 1,791 $89,200.00 33 1,666 $88,400.00 32 1,852 $100,800.00 32 1,620 $96,700.00 32 1,692 $87,500.00 32 2,372 $114,000.00...
A realtor in Arlington, Massachusetts, is analyzing the relationship between the sale price of a home...
A realtor in Arlington, Massachusetts, is analyzing the relationship between the sale price of a home (Price in $), its square footage (Sqft), the number of bedrooms (Beds), and the number of bathrooms (Baths). She collects data on 36 sales in Arlington in the first quarter of 2009 for the analysis. A portion of the data is shown in the accompanying table. Price Sqft Beds Baths 728000 2399 4 2.5 569077 1731 3 1.5 831833 2800 4 3.0 689000 2200...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT