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
Leave a Reply
You must be logged in to post a comment.