Multiple Bid Fair Price Range Calculator
Enter up to 10 contractor bids to calculate the statistically fair price range, identify outliers, and determine a recommended budget target.
Formulas Used
Quartiles: Q1 = 25th percentile, Q2 = 50th percentile (median), Q3 = 75th percentile using linear interpolation.
Interquartile Range (IQR): IQR = Q3 − Q1
Outlier Fences: Lower = Q1 − (k × IQR), Upper = Q3 + (k × IQR), where k = sensitivity multiplier (default 1.5).
Valid Bids Mean (μ): μ = Σ(valid bids) / n
Standard Deviation (σ): σ = √[ Σ(xᵢ − μ)² / n ]
Fair Price Range: [max(validMin, μ − σ), min(validMax, μ + σ)]
Recommended Target: 0.6 × median + 0.4 × mean (of valid bids)
Budget with Contingency: Target × (1 + contingency% / 100)
Coefficient of Variation: CV = (σ / μ) × 100%
Spread: ((max − min) / min) × 100%