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