What is the predicted sales price for a house

Assignment Help Finance Basics
Reference no: EM131113706

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?

Reference no: EM131113706

Questions Cloud

Who are the participants in restorative justice : Who are the participants in restorative justice? In a well-written paper, compare the stakeholders in traditional justice with those whose roles are crucial in restorative justice practices. Support your analysis with examples and at least two sch..
Compute the efficiency when the transformer delivers half : chalf its rated kVA at 0.85 power factor lagging.
Management style when he first joined recycled furnishings : Recycled Furnishings is a division of an international home furnishing company called Thor Enterprises. Recycled Furnishings makes glass sofas for outdoor use from recycled bottles and glass. The business has grown rapidly in the last thirty years an..
Evidence of managerial trends of high-performance : 1. What type of union strategy is PWC using? 2. Do you see evidence of the managerial trends of high-performance work practices, nonunion employee representation, and nonstandard work practices present in the case?
What is the predicted sales price for a house : What is the regression equation relating square footage to listing price? Using the regression equation that you designated in #3(d) above, what is the predicted sales price for a house of 2100 square feet?
The inventory of powhattan company amounts : On December 31, 2009, the inventory of Powhattan Company amounts to $800,000. During 2010, the company decides to use the dollar-value LIFO method of costing inventories.
Do problem 9 again assuming an american put option instead : Do problem 9 again assuming an American put option instead of a call option.
Find the per-unit voltage regulation : The core loss at rated voltage is 45 W, and the copper loss at rated load is 100 W. Neglect the exciting current of the transformer. Find the per-unit voltage regulation when the transformer is supplying full load at 110 V and 0.9 lagging power fa..
Common goal of coordinating supply : Discuss how a company can get sales and operations to work together with the common goal of coordinating supply and demand to maximize profitability.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Calculating average annual yield-total price increase

Prudence buys a bond in EUR when it issued by the French government and inflation linked. It offers a 2% yearly coupon. She holds it for five years.

  Northwood industries job

What will be the effect on company profit if you accept the Northwood Industries job? What qualitative factors should be considered in the decision as to whether or not to accept the job?

  Positronic products manufactures three lines of heavy

Positronic Products manufactures three lines of heavy equipment for electrical, chemical, and atomic research. Each of the three lines constitutes a third of the total sales of Positronic. The contribution margin ratio is 10 percent for the e..

  What is the cost of equity

Southern Home Cookin' just paid its annual dividend of $0.65 a share. The stock has a market price of $13 and a beta of 1.12. The return on the U.S. Treasury bill is 2.5 percent and the market risk premium is 6.8 percent. What is the cost of equit..

  Maximum loan by an employee of a c corporation

Determine the maximum loan taken by an employee of a C corporation.

  What would be the may balance of accounts receivable for

diamond window corporations sales half of which are for cashmarch april may140000 240000 160000a. estimate diamonds

  The effect of the portfolio on risk of a security

The effect of the portfolio on risk of a security

  Settling labor disputes and product liability suits

Bankruptcy plays no role in settling labor disputes and product liability suits. Such issues are outside the bounds of bankruptcy law.

  If a contractrsquos open interest declines during an

if a contractrsquos open interest declines during an actively traded day what does it suggest about the number of

  State business tax and license sites

The SBA page includes links to many other useful sites, such as the Small Business Resource Guide, state business tax and license sites, and more.

  Calculate net present value for a company

The tax rate is 30%, and 70% of franking credits are claimed by shareholders. Propfix requires a return of 15% pa after tax on its investments. Should they make the upgrade

  Social discount rate

The second discount rate is known as the social discount rate. It is based on judgments about the collective value that society attaches to a policy. Proponents argue that the social discount rate is preferred because it broadens the preferences cons..

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