Pizza Tips Regression Modeling

Excel Analytics & Regression Modeling

Demo

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.

STAR Summary

  • 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).
  • 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.

Notes

Delivery records were joined to NOAA daily weather; missing distance and time-of-day controls limit causal interpretation.

Other Projects