Statistics Paper - Condosales

Satisfactory Essays
Case Study: Condo Sales Case

A. Brief introduction to the case

This case involves an investigation of the factors that affect the sale price of oceanside condominium units. The sales data were obtained for a new oceanside condominium complex consisting of two adjacent and connecting eight-floor buildings. The complex contains 200 units of equal size (approximately 500 square feet each).

Variables • Dependent variable 1. Sale price: Y

• Independent variables 1. Floor height: x1 2. Distance from elevator: x2 3. View of the ocean: x3 4. End unit: x4 5. Furniture: x5

Issues identified • To build a regression model that accurately predicts the sale price of a condominium unit sold at auction. • Use graphs to demonstrate how each of the independent variables in the model affects price.

B. Case Analysis

1. Creating the deterministic regression model

Since there are five independent variables, there shall be 5 variables in our initial first order regression model:

E(y) = β0 + β1x1 + β2 x2 + β3 x3 + β4 x4 + β5 x5 + (

Using the data in the CD, we find the SPSS printout for the case as below:

Coefficients (a)

|Model | |Unstandardized Coefficients |Standardized |t |Sig. |
| | | |Coefficients | | |
| | |B |Std. Error |Beta | |
| | |B |Std. Error |Beta |
|1 |.789(a) |.623 |.604 |21.324 |

a Predictors: (Constant), distview, floorsq, furnish, endunit, distance, floorview, floordist, view, distsq, floor

ANOVA(b)

Model | |Sum of Squares |df |Mean Square |F |Sig. | |1 |Regression |147387.091 |9 |16376.343 |35.614 |.000(a) | | |Residual |91505.684 |199

You May Also Find These Documents Helpful

  • Powerful Essays

    Econ2206- Assignment 1

    • 980 Words
    • 8 Pages

    To investigate the effects of the land size (lotsize)and house size (sqrft) on the house price (price) in a particular suburb, the following model…

    • 980 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    Condo Sales Case

    • 870 Words
    • 4 Pages

    This case involves an investigation of the factors that affect the sale price of Oceanside condominium units. It represents an extension of an analysis of the same data by Herman Kelting (1979). Although condo sale prices have increased dramatically over the past 20 years, the relationship between these factors and sale price remain about the same. Consequently, the data provide valuable insight into today’s condominium sales market.…

    • 870 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Revere Street Case Study

    • 1710 Words
    • 7 Pages

    After many failed attempts to find a suitable property Alexander learned of a 4-unit apartment house located on the “back slope” of Beacon Hill. While prices in some neighborhoods had declined prices on the “back slope” continued to increase. The property was only partially developed with three 2- bedroom apartments and one 1- bedroom apartment. The asking price was $350,000 and it would cost approximately $165,000 to complete the renovations. He is planning to rent the three 2-bedroom apartments for $2,000 per month and the one 1-bedroom apartment for $1,600…

    • 1710 Words
    • 7 Pages
    Good Essays
  • Good Essays

    Peca, S. (2009). Real Estate Development and Investment: A Comprehensive Approach. Hoboken, NJ: John Wiley & Sons, Inc.…

    • 584 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The supply and demand simulation was a simulation of GoodLife Management, a property management firm controlling all of the seven apartment complexes in the city of Atlantis. For the 9 year period in the simulation the housing market had many ups and downs because of businesses moving into the area bringing an increased amount of jobs, the change in consumer preferences and company expectations, and the policy changes induced from the government.…

    • 1218 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Revere Street Case Study

    • 1117 Words
    • 5 Pages

    Mr. Alexander is a gentleman that is looking to build his investment portfolio through residential real estate. He is looking at investing in a 4-plex in a historical district located within Boston, Massachusetts. The building is located on Revere Street and has a listing price of $350,000. Mr. Alexander is evaluating the possible commitment to understand what he stands to gain from the annual cash flows while at the same time understanding the risks involved. The subject property is located within a historical district and is not yet capable of housing tenants. Property will require significant improvements prior to inhabitation. Client will be looking to secure a mortgage to facilitate the purchase of the property. All variables must be assessed and measured to provide Mr. Alexander with a recommendation to purchase said property and make any adjustments to the structure of the deal or to pass on deal all together. Our client also desires to live in the apartment building, and this must be taken into consideration both from a fundamental perspective as well as financial one.…

    • 1117 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    A difficult characteristic to understand about the housing market is how a price is given for a particular house. That price will be designated to that particular house alone. All houses have various pricing, so I can’t always assume that one will cost more or less than any other. The pricing for houses vary based on their characteristics. Each characteristic must be analyzed to determine its contribution or detraction toward the price. I have taken some of these characteristics and modeled the relationship between them and the price of real estate for a specific area.…

    • 1392 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    The sales rates are adjusted for differences in the property and the time of sale before being practical. A valuter uses sales comparison approach when there is accurate and complete data on comparable such as recent sales, similarity of comparables and stability of local market conditions, regional and nation economic factors (Appraisal Institute,…

    • 54 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    Here we have used single equation regression model, which carries two variables one is dependent and another one independent variable.…

    • 937 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    The research will use an ordinary least squares model in this research and make use of…

    • 296 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    TCSCK Investment Company 's scenario poses the question: Is there a significant difference in price between the condominiums closer to the city compared to those further away from the city? The dependent variable is the price of the condominiums and the independent variable is distance from the city.…

    • 1418 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Revere Street Solutions

    • 879 Words
    • 4 Pages

    * First, we should do market research on the target area. For example, we should figure out the demand and supply, the trading volume, and the environment in neighboring. After knowing these information, we should also estimate the possible trend of the property value.…

    • 879 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Simulation multiple times in order to gain complete data. The multiple regression model is explained…

    • 1710 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    Collison & Gallagher (1985), “Project Planning Aids Real Estate Appraisals”, The Appraisal Journal, Vol. 53, Iss.2, p.278-285…

    • 4155 Words
    • 17 Pages
    Powerful Essays
  • Satisfactory Essays

    Reyem Affair-Case Report

    • 619 Words
    • 3 Pages

    In order to obtain the optimum price that Reyem Affiar should pay for the two-bedroom condominium at 236 Ellery Street a regression model was required. A total of 456 data points( of the past 5 years) and 17 variables were provided , namely-Street Address, Unit, Area, Area Code, First Price, Last Price, Sale Price, First Date, Close Date, Days, Interior, Bed (rooms), Bath (rooms), Rooms, Condo, Tax and RC. A regression model analysis was carried out using SPSS with Sale Price as the dependant variable and the rest as independent variables.…

    • 619 Words
    • 3 Pages
    Satisfactory Essays