Reference no: EM131266134
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:- grouplistingshawaii_teama.rar
|
Market fail in the presence of an externality
: a.) It is possible for an activity to have both positive and negative externality. Identify three activities that result in both positive and negative externality and carefully explain the positive and negative externality that results. b.) Why do..
|
|
What amount should nasa report as a balance
: During 2012, NASA Co. produced a new line of computers that carry a three-year warranty against manufacturer's defects. What amount should NASA report as a balance of the Warranty Liability account at December 31, 2014
|
|
Identify the various ways of entering the global marketplace
: Identify the various ways of entering the global marketplace. - What are some of the advantages and potential disadvantages of entering a joint venture?
|
|
Independence of irrelevant alternatives
: Consider the sequential elimination rule. Does this rule satisfy transitivity (i.e. is the social preference generated by this rule always transitive), Pareto, Independence of Irrelevant Alternatives, and Anonymity?
|
|
Does the scatterplot indicate observable correlation
: Does your Coefficient of Correlation seem consistent with your answer to #2 above? Why or why not? What proportion of the variation in listing price is determined by variation in the square footage? What proportion of the variation in listing pri..
|
|
Fundamental lessons the ten principles of economics
: As part of a marketing research committee for your organization, you have been assigned the task of preparing a 700-word research paper about current microeconomic thought and theory.
|
|
Provide a list of threats against the model
: I want you to provide a list of threats against the model. The list should include which element of the mnemonic they represent (spoofing, tampering, etc.).
|
|
List elements involved in developing a global marketing mix
: List the basic elements involved in developing a global marketing mix. - Describe at least three situations where an American company might want to keep the product the same but alter the promotion.
|
|
Current microeconomic thought and theory
: As part of a marketing research committee for your organization, you have been assigned the task of preparing a 700-word research paper about current microeconomic thought and theory.
|