Build a predictive model for property transaction

Assignment Help Marketing Management

Reference no: EM133342832

Case: You work for a real estate company in Seattle, WA. Part of your business is to buy undervalued properties in the market, renovate them, and resell later at higher prices. Your job is to evaluate what properties on the market are worthy of buying. Accounting for all incomes, such as commissions and reselling markups, and costs, such as inspection, renovation, property management, etc., it is profitable for your company to buy a property if its predicted transaction price is at least 12% higher than its asked price.

(1) Worksheet "2014Transactions" records the historical property transaction data of some 118 properties from May to December 2014 in Bellevue, WA, 98005. Variable "Transaction_Price" records the transaction price for each transaction.

Use linear regression to build a predictive model for property transaction prices in Bellevue. Report the formulae for your predictive model. (Hint: use transaction price as the dependent variable, and other relevant variables as the independent variables)

(2) You will use your predictive model to decide whether to buy some of the available properties on the market in that area. Worksheet "PropertiesOnMarket" records the information for all the 25 available properties. Variable "Asked_price" records the asked prices for the properties.

You will advise your company to buy a property if its predicted transaction price is at least 12% higher than its asked price.

Which properties in these 25 properties you will recommend your company to buy? (Hint: use your predictive model from question (1) to predict the transaction prices for these 25 properties, then compare them with their asked prices)

Reference no: EM133342832

Questions Cloud

Purpose of fall prevention project : How can one write a conclusion statement that reiterates the rationale and purpose of a fall prevention project?

Types of incidents : Identify a difficult or traumatic time in your past where you were helped by another person's empathy or communication.

Discuss the rationale for using the paid search : Discuss the Rationale for using the Paid search marketing tactic for Carbonwise company (include all the given points) Write the Purpose of using this tactic

Clinical laboratory improvement act : What can happen if a laboratory result is incorrect due to technician error? Describe the Clinical Laboratory Improvement Act and how it is related to case

Build a predictive model for property transaction : Use linear regression to build a predictive model for property transaction prices in Bellevue - available properties on the market in that area

Identification of population in selected community : Briefly describe the selected community and practice setting, the determinants of health, and health problems that are magnified.

Which channels is pepsi max using to communicate : Which channels is Pepsi Max using to communicate its marketing messages? Rank order your impression of how effective they are and justify your answer

Discuss ways in which this target consumer may be similar : discuss and indicate their geo-demographics, psychographics and behavioral insights. (Provide reference and citations)

Introduction the internet as a criminal enabler : Shapiro, L.R. (2023a). Introduction: The Internet as a criminal enabler. In Cyberpredators and their prey (pp. 1-16). Boca Raton, FL: CRC Press.

User Account

All Pages