Question

Mabel, a real estate agent, is looking for a method of predicting the selling prices of...

  1. Mabel, a real estate agent, is looking for a method of predicting the selling prices of houses in Burnaby. Since the City of Burnaby appraises houses for the purpose of assessing taxes, she investigates a small sample of recently sold houses to see if there is a linear relationship between the appraised value and the selling price. Her data is in this table:

Appraised Value ($1,000’s)

Selling Price ($1,000’s)

250

257

190

250

220

288

185

162

270

285

500

541

240

221

The Excel regression output is shown below, with two cells missing.

Regression Statistics

Multiple R

0.955

R Squared

0.912

Adjusted R Squared

0.895

Standard Error

39.055

Observations

7.000

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

41.771

0.115

0.9127

-102.560

112.191

Appraised Value ($1,000’s)

0.147

7.203

0.0008

0.683

1.441

  1. What is the independent variable, and what is the dependent variable? [1 marks]

                                                    Independent Variable:                                                                             

Dependent Variable:                                                                                   

  1. Calculate the estimated regression line.   [3 marks]



  2. What is the meaning of the slope? Interpret it using the words of the problem. [1 marks]
  1. Predict the selling price (point estimate) for a house with an appraised value of $200,000. [1 marks]
  1. Interpret r2 using the words of the problem. [1 marks]




  1. Test at the 5% level of significance (95% level of confidence) if there is a linear relationship between the appraised value and the selling price in population by 4 approaches:

t crit / t test: [2 Mark]

p-value/alpha:      [1 mark]

confidence interval:    [1 marks]

Ftest/Fcrit: [2 marks]

Homework Answers

Answer #1

a)

independent variable = Appraised Value ($1,000’s)

dependent value = Selling Price

Y = 41.771 + 0.147 * X

.

b)

slope = 0.147

so, if increase the appraised value by 1 unit, then selling price will be increase by 0.147

..........

c)

for X = 200

y = 41.771 + 0.147*200

=71.171

..

R Squared = 0.912

so, 91.2% of data is explained by independent variable appraised value of selling price

.................

t stat = 7.203

t critical = 2.571

t stat > t critical, slope significant

p value = 0.0008 >0.05 , slope significant

lower limit = 0.683 , upper limit = 1.441

CI does not contain 0 , slope is significant

................

Please revert back in case of any doubt.

Please upvote. Thanks in advance.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
2: A real estate agent is interested in what factors determine the selling price of homes...
2: A real estate agent is interested in what factors determine the selling price of homes in Northwest Arkansas. She takes a random sample of 20 homes, and conducts a multiple regression analysis. The dependent variable is price of the home (in thousands of dollars), the square footage of the home, and whether the home is located in a new subdivision (0 = no; 1 = yes). The results of the multiple regression analysis are shown below. Answer the following...
The North Valley Real Estate data 2015 reports information on homes on the market. Let selling...
The North Valley Real Estate data 2015 reports information on homes on the market. Let selling price be the dependent variable and size of the home the independent variable. Determine the regression equation. Estimate the selling price for a home with an area of 2,200 square feet. Determine the 95% confidence interval for all 2,200 square foot homes and the 95% prediction interval for the selling price of a home with 2,200 square feet. Let days-on-the-market be the dependent variable...
A real estate agent compares the selling prices of homes in two suburbs of Seattle to...
A real estate agent compares the selling prices of homes in two suburbs of Seattle to see whether there is a significant difference in price. The results of the study are shown below. Suburb 1 Suburb 2 x¯ $63,255 $60,102 s $5,602 $4,731 n 35 40 1. Find the p-value for the test and round to 4 significant decimal places. 2. Find the 99% confidence interval for the difference in means. Put your answers in (a, b) form and round...
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...
Multiple linear regression results: Dependent Variable: Cost Independent Variable(s): Summated Rating Cost = -43.111788 + 1.468875...
Multiple linear regression results: Dependent Variable: Cost Independent Variable(s): Summated Rating Cost = -43.111788 + 1.468875 Summated Rating Parameter estimates: Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept -43.111788 10.56402 ≠ 0 98 -4.0810021 <0.0001 Summated Rating 1.468875 0.17012937 ≠ 0 98 8.633871 <0.0001 Analysis of variance table for multiple regression model: Source DF SS MS F-stat P-value Model 1 8126.7714 8126.7714 74.543729 <0.0001 Error 98 10683.979 109.02019 Total 99 18810.75 Summary of fit: Root MSE: 10.441273 R-squared: 0.432...
3. United Park City Properties real estate investment firm took a random sample of five condominium...
3. United Park City Properties real estate investment firm took a random sample of five condominium units that recently sold in the city. The sales prices Y (in thousands of dollars) and the areas X (in hundreds of square feet) for each unit are as follows         Y= Sales Price ( * $1000) 36 80 44 55 35 X = Area (square feet) (*100) 9 15 10 11 10 a. The owner wants to forecast sales on the basis of...
Statistical Methods of Business II – Case Study – Indiana Real Estate Ann Perkins, a realtor...
Statistical Methods of Business II – Case Study – Indiana Real Estate Ann Perkins, a realtor in Brownsburg, Indiana, would like to use estimates from a multiple regression model to help prospective sellers determine a reasonable asking price for their homes. She believes that the following four factors influence the asking price (Price) of a house: The square footage of the house (SQFT) The number of bedrooms (Bed) The number of bathrooms (Bath) The lot size (LTSZ) in acres She...
Do movies of different types have different rates of return on their budgets? Here is a...
Do movies of different types have different rates of return on their budgets? Here is a regression of US Gross ($M) on Budget ($M) and with an indicator variable Comedy that is 1 for comedies and 0 for adventure films. Dependent variable is: US Gross ($M) variable Coefficient SE(Coeff) t-ratio P-value R-squared = 41.8% Constant -13.9288 30.51 -0.457 0.6497 R-squared (adjusted) = 37.0% Budget ($M) 1.43487 0.3967 3.62 0.0007 s = 57.94 Budget*Comedy -0.616027 The 0.4009 -1.54 0.1300 49 degrees...
(1) A real estate agent says he can approximate the value of a house through the...
(1) A real estate agent says he can approximate the value of a house through the following equation: SP = 125,000 + 3000BR + 500BDR + 4000WC –6000P; where BR= # of bathrooms, BDR= # bedrooms, WC =Wine cellar and P=Pool. There are _____ zero-one variables in this regression model. Select one: a. 4 b. 3 c. 2 d. 1 (2) A researcher believes, among other things, the town one lives in within the state influences the likelihood of contracting...
Consider the following results of a multiple regression model of dollar price of unleaded gas (dependent...
Consider the following results of a multiple regression model of dollar price of unleaded gas (dependent variable) and a set of independent variables: price of crude oil, value of S&P500, price U.S. Dollars against Euros, personal disposal income (in million of dollars) : Coefficient t-statistics Intercept 0.5871 68.90 Crude Oil 0.0651 32.89 S&P 500 -0.0020 18.09 Price of $ -0.0415 14.20 PDI 0.0001 17.32 R-Square = 97% What will be forecasted price of unleaded gas if the value of independent...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT