Portfolio Project
Pizza Tips Regression Modeling
Excel Analytics & Regression Modeling
Adjust inputs and estimate a tip using the regression model.
- Use the delivery slider to load an example ticket (or enter values directly).
- Edit order cost and other inputs (housing, time, weather) to test scenarios.
- Click “Estimate Tip” to see the prediction.
- Use “Reset” to return to defaults.
Links
STAR Summary
- Situation
- Tips varied a lot by neighborhood and housing type. I wanted to see what actually drives them.
- Task
- Owned the end-to-end build, from implementation through the final deliverable.
- Action
-
- 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).
- Result
-
- Order cost was the strongest predictor of tip size in the regression.
- Housing type (apartment vs. house) showed a statistically significant difference in this sample.
- Weather and delivery time didn’t show a meaningful effect on tip size.
