Question

In: Statistics and Probability

You work for a Realtor agency and part of the agency's job is to advise clients...

You work for a Realtor agency and part of the agency's job is to advise clients on the asking price. Based on your experience you know that buyers tend to focus on the size of the house, the number of bedrooms, number of bathrooms, and the age of house. You take a sample from the hundreds of houses that the agency sold over the past six months and plan to run a regression analysis in order to find out which variables significantly impact price and how.

(1) State the null and alternative hypothesis for each independent variable.

(2) Explain how you expect each independent variable to impact the dependent variable.

(3) Conduct regression analysis, find the final model in which only significant IVs remain.

(4) Recommend an asking price for a client whose house is 1800 squared feet, has 3 bedrooms, 2 bathrooms, and was constructed in 1980.

Price Size Bedrooms Baths Age
$235,000.00 1,530 3 2 6
$375,000.00 2,380 4 3 43
$199,950.00 720 2 1 2
$258,000.00 1,040 2 2 40
$96,500.00 484 1 1 43
$237,000.00 1,584 3 3 23
$829,000.00 2,701 5 3 7
$200,000.00 952 2 2 18
$328,500.00 1,098 3 3 75
$365,000.00 2,004 3 2 35
$116,000.00 640 2 1 41
$885,000.00 3,849 6 4 5
$250,000.00 2,010 3 2 84
$165,000.00 575 2 1 32
$159,900.00 984 2 2 43
$275,000.00 864 3 2 70
$144,900.00 1,330 3 2 73
$165,000.00 575 2 1 32
$175,000.00 575 2 1 32
$184,500.00 768 3 1 60
$115,000.00 575 1 1 40
$180,000.00 1,044 3 1 42
$140,000.00 720 2 1 40
$165,000.00 1,144 2 1 88
$149,900.00 831 3 1.5 71
$109,900.00 637 1 1 42
$218,400.00 1,248 3 2 30
$285,000.00 1,588 3 3 60
$345,000.00 1,322 4 2 11
$165,000.00 575 2 1 32
$175,000.00 906 2 2 43
$270,000.00 1,116 3 2 43
$165,000.00 402 1 1 32
$409,000.00 2,200 3 3 40
$175,000.00 937 1 2 40
$450,000.00 1,341 4 3 6
$170,000.00 852 3 2 69
$429,000.00 1,532 3 1 80
$380,000.00 1,116 3 1 61
$195,000.00 1,168 2 2 21
$320,000.00 1,130 2 1 50

Solutions

Expert Solution

(2)

From above scatter plot, we observed that Price and Size are strongly positively correlated i.e. if size increases price also increases. Similarly Price and no. of bedrooms are strongly positively correlated i.e. if no. of bedrooms increases price also increases. This is also observed for Price and no. of bathrooms but the strength is not good and direction is positive. However Price and Age are uncorrelated.

(3)

Minitab output:

Regression Analysis: Price versus Size, Bedrooms, Baths, Age

The regression equation is
Price = 10012 + 146 Size + 60790 Bedrooms - 21401 Baths - 1073 Age


Predictor Coef SE Coef T P
Constant 10012 45888 0.22 0.829
Size 145.63 35.53 4.10 0.000
Bedrooms 60790 20552 2.96 0.005
Baths   -21401 24084 -0.89 0.380
Age -1072.9 549.9 -1.95 0.059


S = 76956.7 R-Sq = 80.6% R-Sq(adj) = 78.4%


Analysis of Variance

Source DF SS MS F P
Regression 4 8.85394E+11 2.21348E+11 37.38 0.000
Residual Error 36 2.13204E+11 5922330990
Total 40 1.09860E+12

From above outputs, we see that p-values corresponding Size, Bedrooms are less than 0.05 and p-values corresponding Baths, Age are greater than 0.05. So Size and bedrooms are significantly present and moreover intercept term is also insignificant since its corresponding p-value less than 0.05.

Hence the final model is: Price = 145.63 Size + 60790 Bedrooms

(4)

Estimated price for a client whose house is 1800 squared feet, has 3 bedrooms, 2 bathrooms, and was constructed in 1980=45.63 *1800+ 60790*3=$264504.


Related Solutions

You are the manager of an investment fund. Your job is to advise clients on what...
You are the manager of an investment fund. Your job is to advise clients on what portfolio best suits their needs, given their characteristics. You have four different client types. I. A 23 year old woman (Vanessa), who has just begun a long and hopefully successful career as a nurse. II. A couple (Eddy and Eliza), both 41 years of age and have two young children. Both earn high incomes and wish to retire at the age of 60. III....
You work for a small advertising agency in Greengrass, N.Y. The agency’s principal advertising clients are...
You work for a small advertising agency in Greengrass, N.Y. The agency’s principal advertising clients are automobile dealers and automobile repair shops. The agency has a good record of placing advertisements for its clients in both real-space and on the internet. Last week, you were considering buying a used car, and you found a web-site called “CarValues.com.” The web site contains a database of information about used vehicles on the market. The (searchable) database contains dealer-written factual descriptions of the...
You are currently part of a university work experience program. Your job placement is at the...
You are currently part of a university work experience program. Your job placement is at the municipal transit centre. Your supervisor is responsible for the recording and distribution of monthly transit passes to authorized vendors throughout the city. The vendors pay €50 per bus pass and sell them for €55. Your job is to prepare a monthly reconciliation of the transit passes including the quantity sold, the number actually distributed, the unsold passes, and the cash proceeds. You are unable...
Bob is your clients and you advise him in his portfolio selections and investment decisions. According...
Bob is your clients and you advise him in his portfolio selections and investment decisions. According to your analysis, Bob has a degree of risk aversion of 3.1. The risk-free rate is currently 2%, the expected return on the market portfolio is 8.7%, and the volatility of the market portfolio is 19%. Advise Bob on his optimal capital allocation by giving the weight (in percentage) to put in the risky market portfolio. {Give your answer as a percentage with 2...
Identify and explain the benefits of having a finance or mortgage broker advise clients of available...
Identify and explain the benefits of having a finance or mortgage broker advise clients of available loan products. (Identify and categorise key lending products available in the finance and mortgage industry).
Question 3 Ted’s Travel Agency provides travel services for walk-in retail clients and for corporate clients....
Question 3 Ted’s Travel Agency provides travel services for walk-in retail clients and for corporate clients. It is the largest privately owned travel agency in the greater Toronto area. Ted Thompson has been the owner since its first day of business. Many clients are walk-ins who live within a fivekilometre radius of the office, and others hear about the agency from friends and will drive from much farther away. The agency also has a large and growing component of business...
In your work as an accountant you advise a client, Avon Pty. Ltd. (Avon), on various...
In your work as an accountant you advise a client, Avon Pty. Ltd. (Avon), on various matters. Avon entered into a $500,000 one year contract in June 2016 with Central Queensland University (a registered Research Service Provider) to undertake research and development for Avon. The contract was to run from July 2016 to June 2017. Avon wants your advice about tax offsets and how this expense could be treated by the ATO in the 2016-17 tax year.
2. You work for an organisation that provides counselling for clients with a history of substance...
2. You work for an organisation that provides counselling for clients with a history of substance abuse. A funding opportunity is available, but to be eligible for the funding you have to be able to provide short-term accommodation for your clients while they participate in an accredited rehabilitation program. While you are not able to provide accommodation or treatment, you consider you are in a good position to provide the counselling. What are the motives for collaborating and what services,...
Assume that you work for a state agency and you are charged with generating additional sales...
Assume that you work for a state agency and you are charged with generating additional sales tax revenue. You have obtained the own-price elasticities of demand for the following goods: Coffee -0.25 Restaurant meals -2.60 Fresh green peas -2.80 a. If you had to impose a tax on only one of these three goods, which would you choose (and why) in order to maximize tax revenue? b. Would the tax incidence tend to fall more on the consumer or the...
magine that you are representing the staff in the health care agency where you work. In...
magine that you are representing the staff in the health care agency where you work. In anticipation of a possible outbreak of a deadly new strain of flu, the administration has decreed that all staff must present documentation of adequate immunity against this new flu before gaining access to any patient care settings. The required flu vaccine and immunity test have only been developed and marketed in the past year. As the staff representative concerned for the rights and safety...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT