What proportion of the variation in listing price

Assignment Help Other Subject
Reference no: EM131187633

You are consulting for a large real estate firm.  You have been asked to construct a model that can predict listing prices based on square footages for homes in the city you've been researching.  You have data on square footages and listing prices for 100 homes.

1. Which variable is the independent variable (x) and which is the dependent variable (y)?

2. Click on any cell.  Click on Insert→Scatter→Scatter with markers (upper left).

To add a trendline, click Tools→Layout→Trendline→Linear Trendline

Does the scatterplot indicate observable correlation?  If so, does it seem to be strong or weak?               In what direction?

3. Click on Data→Data Analysis→Regression→OK.   Highlight your data (including your two headings) and input the correct columns into Input Y Range and Input X Range, respectively.  Make sure to check the box entitled "Labels".

(a) What is the Coefficient of Correlation between square footage and listing price?

(b) Does your Coefficient of Correlation seem consistent with your answer to #2 above?  Why or why not?

(c) What proportion of the variation in listing price is determined by variation in the square footage?  What proportion of the variation in listing price is due to other factors?

(d) Check the coefficients in your summary output. What is the regression equation relating square footage to listing price?

(e) Test the significance of the slope. What is your t-value for the slope?  Do you conclude that there is no significant relationship between the two variables or do you conclude that there is a significant relationship between the variables?

Reference no: EM131187633

What is the california stalking laws

What is the California Stalking laws? Should we have this law? Should anything be added to the California Stalking Law? Is this law effective? Example of a California Stalki

Identify the risks associated with the supplier expansion

Write a 1,050- to 1,400-word paper in which you do the following: Identify the risks associated with the supplier expansion. Document those risks in the Risk Project Log templ

Governments should regulate and monitor the internet

Governments should regulate and monitor the internet in the name of notional security and the fight against terrorism.To what extent do you agree or disagree with that state

Discuss how each risk factor is a risk factor

Discuss any three risk factors associated with the development of cardiovascular diseases. Do not just list the risk factor. You need to actually note each factor and discuss

Discuss your basic understanding of this emerging issue

Discuss your basic understanding of this emerging issue and of the research findings. Criticize aspects of this emerging issue and present your assigned side of the debate in

Write a critique paper about the given post

Post an evaluation of the use, or lack thereof, of EBP in a recent clinical experience. Identify which aspects of the care delivered, if any, were based on evidence and prov

The strategic planning process

The strategic planning process is a key to determining how healthcare services will be delivered. List and explain the key players for building the strategic plan. Comment on

Description of probability and nonprobability sampling

Post a description of the types of probability and non-probability sampling you selected. Then describe two strengths and two weaknesses of each type of sampling. Finally, i


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd