Reference no: EM131111373
Real Estate Regression Exercise
Directions: Use the real estate data you used for your Week 2 learning team assignment. Analyze the data and explain your answers.
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?
(f) Using the regression equation that you designated in #3(d) above, what is the predicted sales price for a house of 2100 square feet?
|
What probability is that any two of them share same birthday
: Analyze the data and explain which one would be the better medication for both a sore throat and a fever. Explain what the probability is that any two of them share the same birthday.
|
|
What are the steps to find the source code
: What is the purpose of the World Wide Web Consortium and what work does it perform? What are the benefits of diagramming your site before you begin coding? What are the benefits of using a text editor to create a website?
|
|
Prepare the journal entries to record income tax expense
: Prepare the journal entries to record income tax expense, deferred income taxes, and income taxes payable for 2014 and 2015. Assume taxable income was $980,000 in 2015.
|
|
Calculate the future value of the single cash
: For each of the cases shown in the following table, calculate the future value of the single cash flow deposited today at the end of the deposit period if the interest is compounded annually at the rate specified.
|
|
What is coefficient of correlation between square footage
: What is the Coefficient of Correlation between square footage and listing price? Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not?
|
|
Responsibilities of mac sub layer
: a. Name and explain the responsibilities of each MAC sub layer. b. Explain the following MAC layer terms: MSDU, MPDU, and Convergence.
|
|
Find and change the duration parameter to make the rabbit
: The method will open in the Editor area. Find and change the duration parameter to make the rabbit jump more quickly or more slowly.
|
|
Find the prediction equation for managerial success
: Refer to Exercise 9.42 (p. 503). in which managerial success, y, was modeled as a function of the number of contacts a manager makes with people outside his or her : work unit, x, during a specific period of time. The data are repeated in the tabl..
|
|
Development of broadband wireless
: Describe the evolution of WiMAX. Why is WiMAX technology important for the continuing development of broadband wireless?
|