Reference no: EM131148627
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?
Attachment:- Learning_Team_Real_Estate_Data_Sheet.xlsx
|
The purpose motivating regulators to impose interest ceiling
: What was the purpose motivating regulators to impose interest ceilings on bank savings accounts? What effect did this eventually have on the money markets?
|
|
Prepare a consolidation worksheet for shark and fish
: Shark Company purchased 70% interest in Fish Company on July 1, 2014.- prepare a consolidation worksheet for Shark and Fish for the year ending December 31, 2014.
|
|
What business benefits were derived from adopting
: Was an ERP system associated with the business-process re-engineering? What business benefits were derived from adopting "best practices"?
|
|
What conditions is each type appropriate
: Explain the differences between the various types of purchasing organizations. Under what conditions is each type appropriate. Please ensure that your original response is at least 200 words and is supported with references.
|
|
What is your t-value for 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?
|
|
Discuss positive consequences of each of three strengths
: Discuss the plans, procedures, or other documents that were in place before the disaster in the General Information section of the template. Summarize what occurred during the response in the scenario in the General Information section of the temp..
|
|
A balance sheet and income statement
: A financial statement analysis of the 2014 and 2015 data complete with a horizontal analysis, a vertical analysis and the appropriate financial statement ratios.
|
|
Prepare the mde manufacturing budget
: he product costs are the direct materials, direct labor, and manufacturing overhead that a manufacturer uses to make its products. Product costs are sometimes known as inventorial costs in some industries
|
|
What are main weaknesses associated with type of analysis
: What are main weaknesses associated with type of analysis? Using an appropriate financial platform (such Financial Analysis Made Easy - FAME; OSIRIS; Morning Star; Annual Reports etc.), obtain financial relevant information.
|