Skip to content

First Best-Fit Line :Increasing Real Estate Management Profits: Harnessing Data Analytics (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025

✅ Answers

  1. In how many cities are Watershed’s client’s properties located?
    ✔ 14
    ❌ 10
    ❌ 20
    ❌ 34

  2. Average nightly rental price difference between Palo Alto and Chapel Hill
    ✔ The average nightly rental price in Palo Alto is approximately $200 greater than the average nightly rental price in Chapel Hill.
    ❌ More than $300 greater
    ❌ Approximately the same
    ❌ Approximately $100 greater

  3. Average nightly rental price difference by property type (1-bedroom vs 2-bedroom house)
    ✔ The average nightly rental price in a 1-bedroom apartment is about $200 less than the average nightly rental price in a 2-bedroom house
    ❌ About $300 less
    ❌ About $400 less
    ❌ About $100 less

  4. City with the greatest difference between average nightly rental prices for houses vs. apartments
    ✔ San Diego, CA
    ❌ Miami, FL
    ❌ Charleston, SC
    ❌ New York, NY

  5. Exclude any data points before Excel modeling?
    ✔ NO
    ❌ Yes

📄 Summary

Question Answer Notes / Summary
Q1 14 Properties are located in 14 cities.
Q2 ~$200 Palo Alto’s avg nightly rental ~$200 higher than Chapel Hill.
Q3 ~$200 1-bedroom apartments ~$200 less than 2-bedroom houses.
Q4 San Diego, CA Greatest price difference between houses vs apartments.
Q5 NO No data points excluded before Excel modeling.