Real Estate Question

Question Details:

I need someone to carefully read the full assignment instructions and complete all parts step-by-step for RED 362 Assignment 3 (Real Estate Development Fundamentals).

Deadline: Must be completed by 7:00 AM (strict)

What you need to do:

  • Answer all True/False questions with brief explanations
  • Choose a single-family home priced between $600k$700k
  • Collect 50+ comparable recent home sales from the same area (last 612 months)
  • Clean the data and keep at least 40 valid observations
  • Build a full Excel dataset including:
    • price, beds, baths, square feet, lot size, year built, days on market
    • at least 2 dummy variables (ex: garage, pool, renovated, etc.)
  • In Excel:
    • Compute summary statistics (mean, min, max)
    • Create a scatterplot (price vs. square feet) with a linear trendline
    • Run a simple regression (price vs. square feet)
    • Run a multiple regression (add beds, baths, dummy variables, etc.)
    • Calculate predicted prices and residuals
    • Create a residual plot
  • Provide clear written explanations:
    • Interpret regression coefficients (in plain English)
    • Compare predicted vs actual prices
    • Discuss which variables matter
    • Identify patterns or outliers
  • Write a 4-paragraph memo explaining:
    • dataset and variables
    • key regression findings
    • estimated value of the subject property vs actual price
    • at least 3 limitations of the analysis

Final deliverables:

  • One clean, organized PDF with all answers, charts, and explanations
  • One Excel file with the full dataset and calculations
  • Clearly labeled sections and easy-to-follow formatting
  • No shortcuts full work required
  • PLEASE READ THE ASSIGNMENT INSTRUCTIONS VERY CAREFULLY

WRITE MY PAPER

Comments

Leave a Reply