Portfolio Project
Pizza Tips Regression Modeling
Excel Analytics & Regression Modeling
Context
Tip income swung wildly across neighborhoods and housing types, but drivers had no data-backed story to explain the variation.
Approach
- Merged 1,251 delivery tickets with NOAA weather, then cleaned the data in Power Query.
- Ran a multiple regression in Excel: Tip = f(cost, delivery time, rain, max/min temperature).
Impact
- Order cost explains about 38% of tip variance; every extra $10 on the bill lifts the tip by about $1.10.
- Apartment customers tip 28% less than house residents (p < 0.001).
- Weather and delivery time showed no significant effect on tip size.
