Make Sure You Understand What Your Data Mean :Increasing Real Estate Management Profits: Harnessing Data Analytics (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025
In how many cities are Watershed’s client’s properties located? ✔ 14 ❌ 10 ❌ 20 ❌ 34
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
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
City with the greatest difference between average nightly rental prices for houses vs. apartments ✔ San Diego, CA ❌ Miami, FL ❌ Charleston, SC ❌ New York, NY
Exclude any data points before Excel modeling? ✔ NO ❌ Yes
Summary Table
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.