{"uid":"cap_4rq-OKpX2EnbrWBKzH1Hf","slug":"data-reconciliation-iqr-outlier-flags-secondary-measure-weighted-mean-ab327acb","name":"Data Reconciliation — IQR Outlier Flags + Secondary-Measure Weighted Mean","description":"Data reconciliation — IQR outlier flags + Secondary-measure weighted mean: IQR outlier flags + Secondary-measure weighted mean for supplied data reconciliation records (source_total, target_total). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-177?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_h7GGYQB6IuUCdZghd0SbI","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes up to 200 data reconciliation records (source_total vs target_total) using IQR-based outlier detection and secondary-measure weighted mean calculations, returning two independent analytical reports.","exampleAgentPrompt":"Can you run IQR outlier detection and a secondary-measure weighted mean on my reconciliation data — I have rows with row_id, date, dataset_group, source_total, and target_total values (up to 50 rows), and I want to flag outliers on the source_total field?","exampleUseCases":[{"title":"Outlier detection in monthly financial reconciliation","prompt":"I have 120 rows of monthly financial reconciliation data with source and target totals by dataset group and date — can you flag any IQR outliers and compute the weighted mean on the source_total field for me?"},{"title":"ETL pipeline data quality check","prompt":"After our ETL run, I've got 80 reconciliation records comparing source_total and target_total across two groups. Can you run IQR outlier flagging and a weighted mean analysis on the target_total field to see what looks off?"},{"title":"Cross-system data validation for audit","prompt":"We're prepping for an audit and need to verify our source vs target reconciliation records — I have 45 rows with dataset_group, date, source_total, and target_total. Can you run the IQR outlier and weighted mean reports on source_total?"}],"resultDescription":"Returns two independent analytical reports for the submitted reconciliation rows: (1) IQR-based outlier flags identifying which rows have source_total or target_total values outside the interquartile range, and (2) a secondary-measure weighted mean calculation across the dataset. Both reports are computed locally using shared analytical engines with no external lookups.","failureModes":["Submitting more than 200 rows returns an error — batch must be split","Missing required fields (row_id, dataset_group, date, source_total, target_total) cause validation failure","Dates not matching YYYY-MM-DD pattern are rejected","Numeric values outside ±1,000,000,000,000 are rejected","Fewer than 1 row submitted returns an error","IQR computation may be unreliable with very small datasets (fewer than 4–5 rows)"],"whenToPreferThis":"Choose this endpoint when you have up to 200 reconciliation records with source and target totals and need fast, local statistical analysis — specifically IQR-based outlier flagging and weighted mean computation — without requiring live lookups, predictions, or external data. Ideal for data quality checks, ETL validation, and audit preparation where deterministic statistical methods are sufficient and privacy or offline computation is preferred.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:53.310Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-iqr-outlier-flags-secondary-measure-weighted-mean-ab327acb"}