# Most Surprising Finding: Lost Deals Are Systematically Valued at Exactly Zero ## The Counterintuitive Discovery The single most surprising finding in this dataset is that **all 2,473 "Lost" deals have a close_value of exactly $0**, while **all 4,238 "Won" deals have non-zero values** ranging from $38 to $30,288. This creates a stark binary pattern that defies normal business logic. ## Why This Is Counterintuitive In real-world sales operations, lost deals should retain their *potential* or *forecasted* value—the amount that *would have* been realized if won. Sales teams typically track: - Pipeline value (what deals are worth if closed) - Win rates by value tier - Revenue at risk when deals are lost Instead, this dataset shows: | Deal Stage | Deals | Non-Null Values | Explicit Zeros | Avg Value | |------------|-------|-----------------|----------------|-----------| | **Won** | 4,238 | 4,238 | 0 | $2,361 | | **Lost** | 2,473 | 2,473 | **2,473** | **$0** | | Engaging | 1,589 | 0 | 0 | null | | Prospecting | 500 | 0 | 0 | null | ## The Data Pattern From step-15, I confirmed that Lost deals contain **2,473 explicit zeros** (not nulls), meaning the system *actively records* zero rather than leaving the field empty. This is a deliberate data design choice. Meanwhile: - **Engaging** stage deals (1,589) have null values—which makes sense, as they're still in progress - **Prospecting** stage deals (500) also have null values—appropriate for early-stage opportunities - **Won** deals have 100% value population with realistic ranges ## Business Impact This zero-value convention makes it **impossible to analyze**: - What revenue was at risk when deals were lost - Whether high-value or low-value deals have different win rates - The true size of the sales pipeline before outcomes are known - Opportunity cost of lost business For example, from step-4, December 2017 shows 511 Won deals worth $1,131,573 and 140 Lost deals worth $0—but we cannot determine if those 140 lost deals represented $10K or $1M in missed revenue. ## What Remains Uncertain Without access to historical or forecasted values for lost deals, I cannot determine: - Whether this is a data collection flaw or intentional business rule - If lost deal values exist elsewhere in the system - The actual total addressable market size beyond the $10M in won revenue This finding fundamentally limits the dataset's analytical value for pipeline forecasting and risk assessment.