Histogram for Order Value Distribution — E-Commerce AOV & Basket Size
An order value distribution histogram buckets customer transactions by cart dollar size ($\$0\text{–}\$25, \$25\text{–}\$50, \dots$) to uncover modal basket value and free-shipping threshold clustering.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 |
Share of orders in bracket i: p_i = Orders_i / sum(Orders). Estimated GMV = sum(Midpoint_i * Orders_i).
Chart Design & Use-Case Tips
- 01Share of orders in bracket i: p_i = Orders_i / sum(Orders). Estimated GMV = sum(Midpoint_i * Orders_i).
- 02Set your free-shipping threshold 15% to 20% above the modal peak basket bin (e.g., if the peak bin is $50–$75, set free shipping at $75 or $85) to pull orders into the next bracket.
- 03Compare average order value (AOV) against modal basket size to see how whale orders skew your mean.
- 04Paste Shopify, Stripe, or WooCommerce order export buckets directly into the workbench.
Frequently Asked Questions
How do e-commerce brands use an order value histogram to set free shipping?+
By locating the tall modal peak of the histogram, merchants set the free-shipping threshold just above that peak, incentivizing shoppers to add one extra item to their cart.
Why is Modal Order Value different from Average Order Value (AOV)?+
A few $500+ bulk orders pull arithmetic AOV upward, whereas the histogram's peak bin shows what a typical everyday customer actually spends.
Can I use this for B2B SaaS contract size (ACV) distributions?+
Yes, relabel the brackets to '$1K–$5K', '$5K–$15K', '$15K–$50K', etc. to analyze enterprise deal size clustering.