Hedonic Pricing Project Excel Regression, Data Collection &…

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 tomorrow morning (no later than 79 AM preferred so I can review before submission)

What you need to do:

  • Answer all 10 True/False questions with brief explanations
  • Choose a single-family home priced between $600,000$700,000 (not condo/townhome/multifamily)
  • Collect 50+ recently sold comparable homes from the same area (same ZIP or within ~12 miles, last 612 months)
  • Clean the dataset and keep at least 40 valid observations
  • Build a full Excel dataset including:
    • price
    • beds
    • baths
    • interior square feet
    • lot size (if available)
    • year built
    • days on market
    • at least 2 dummy variables (ex: garage, pool, renovated, etc.)

Excel Work Required:

  • 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 (include sqft, beds, baths, and at least one dummy variable)
  • Calculate predicted prices and residuals
  • Create a residual plot

Written Analysis Required (in PDF):

  • Interpret regression coefficients in plain English
  • Compare predicted vs actual prices
  • Discuss which variables are important/unimportant
  • Identify patterns or outliers
  • Write a 4-paragraph memo explaining:
    • dataset (location, size, variables)
    • key regression findings
    • estimated value of the subject property vs actual price
    • at least 3 limitations of the analysis

Final Deliverables:

  • 1 clean, organized PDF with all answers, charts, and explanations
  • 1 Excel file with the full dataset and all calculations
  • Clearly labeled sections and easy-to-follow formatting
  • Must follow assignment instructions exactly (professor is strict)

Only accept if you can complete everything accurately and on time.

WRITE MY PAPER

Comments

Leave a Reply