Data source and field selection (click to expand/collapse)
Assumptions: comma-delimited, UTF-8, header present. Rows with empty/non-numeric sale or valuation are ignored. Rows with sale_price ≤ 0 are excluded.
Results
Nothing yet! Drop a CSV above and click Compute metrics.
Help and method notes
- Ratio = valuation / sale_price
- COD = 100 * median(|ratio − median_ratio|) / median_ratio
- PRD = mean(ratio) / (sum(valuation) / sum(sale_price))
- PRB: OLS of ratio ~ a + b*ln(sale_price); HC3 robust SE; p-value via normal approximation.
- VEI computed per spec group rules (2/4/10 groups by N), proxy = 0.5*sale + 0.5*(valuation/median_ratio).