ga final presentation deck
TRANSCRIPT
![Page 1: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/1.jpg)
Airbnb | Seattle
By Christine
Where Traveling Meets Living
![Page 2: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/2.jpg)
![Page 3: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/3.jpg)
Data Sets
Seattle, WashingtonAirbnb Listings 2016
City of Seattle Demographic 2010
![Page 4: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/4.jpg)
What variables influence price?
Hypothesis:
For Demographics: If there are more gen x / gen y present in a region, then the price for listings will rise.
For Reviews: If there are more reviews for a listing, then the price for a listing will rise.
![Page 5: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/5.jpg)
Listings in the Seattle Area
![Page 6: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/6.jpg)
Listings in the Seattle Area
![Page 7: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/7.jpg)
DEMOGRAPHICS
![Page 8: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/8.jpg)
Total Listings: 3818
1. Downtown - 530 Listings-Avg. Price 154.41
2. Central - 369 Listings- Avg. Price 128.34
3. Magnolia/ Queen Anne - 367 Listings-avg. price 159.20
Listings by neighborhood and price
![Page 9: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/9.jpg)
Age Bins by Percentage of Population by Neighborhood
![Page 10: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/10.jpg)
Demographic by Price Statistics
![Page 11: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/11.jpg)
Analysis of price by demographic
Hypothesis: Incorrect
Evidence : Weak
R-Squared : explains 53.21% of the variation of outcomes around the mean.
Price of Airbnb listings
Presence of Gen X and Gen Y Decreased Price
Presence of Gen z, baby boomers, and silent increased price
![Page 12: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/12.jpg)
Reviews
![Page 13: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/13.jpg)
Panes Line Coefficients
Row Column p-value DF Term Value StdErr t-value p-value
Number Of Reviews
Price < 0.0001 140758 Price -0.0553620.0010769
-51.4085 < 0.0001
intercept 29.6654 0.170649 173.838 < 0.0001
trend lines:
![Page 14: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/14.jpg)
Review by price Statistics
![Page 15: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/15.jpg)
Analysis on price by reviews slide
Hypothesis: Incorrect
Rather the price of the listing could potentially be a contributing factor to determine the amount of reviews a listing receives.
Evidence: Fairly Strong
R-Squared: Explains very little of the Variation of outcome around mean
![Page 16: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/16.jpg)
Next StepsFor Demographics:
- Overgeneralization of areas that individually would otherwise be significantly different.
- Recent demographics data
For reviews:
-Consider outliers that may skew data for reviews
-Account for age of listings and the amount of reviews
![Page 17: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/17.jpg)
Q & a
![Page 18: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/18.jpg)
Extra slides
![Page 19: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/19.jpg)
Q & A
![Page 20: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/20.jpg)
![Page 21: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/21.jpg)
1. Capitol Hill %14.85
Total Listings: 3818
Listings per Neighborhood Group
2. Downtown %13.38
3. Central %9.66
4. Queen anne %7.73
5. Ballard %6.02
![Page 22: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/22.jpg)
HOW DOES THIS KNOWLEDGE BENEFIT AIRBNBPOTENTIAL SOLUTIONS
Airbnb already well established amongst millennials, because the company is built on the idea of designing for trust, maybe reach/attract a larger demographic.
![Page 23: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/23.jpg)
AVAILABILITY 365
![Page 24: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/24.jpg)
LISTINGS PER NEIGHBOURHOOD
![Page 25: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/25.jpg)
ROOM TYPE and NEIGHBORHOOD
![Page 26: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/26.jpg)
![Page 27: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/27.jpg)
Total Listings: 3818
1. Broadway
![Page 28: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/28.jpg)
SUPPLY & DEMAND
![Page 29: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/29.jpg)
Supply of Airbnb listings
Demand for Airbnb listings
![Page 30: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/30.jpg)
Demand for Airbnb listings
Supply of Airbnb listings
![Page 31: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/31.jpg)
Demand for Airbnb listings
Supply of Airbnb listings
![Page 32: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/32.jpg)
![Page 33: GA final presentation deck](https://reader034.vdocuments.us/reader034/viewer/2022042723/58e7985f1a28abc52e8b5d93/html5/thumbnails/33.jpg)