{"uid":"cap_aB--QgONT5OAevxvv85an","slug":"data-reconciliation-numeric-distribution-secondary-measure-weighted-ec62e396","name":"Data Reconciliation — Numeric Distribution & Secondary-Measure Weighted Mean","description":"Data reconciliation — Numeric distribution + Secondary-measure weighted mean: Numeric distribution + 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-082?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_5pPFF2A4JKBvj1BaOvFB0","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":"Computes numeric distribution statistics and a secondary-measure weighted mean for data reconciliation records comparing source and target totals, returning two reports for up to 200 rows.","exampleAgentPrompt":"Can you run numeric distribution and weighted mean analysis on my reconciliation data? I have rows with source_total and target_total values grouped by dataset_group across dates — analyze the source_total field, I'll send up to 50 rows.","exampleUseCases":[{"title":"Finance reconciliation discrepancy review","prompt":"I have a set of reconciliation records from last quarter with source_total and target_total for each transaction row — can you compute the numeric distribution and weighted mean of the source_total field across all 80 rows so I can spot where the spread is concentrated?"},{"title":"Data pipeline audit by group","prompt":"We have reconciliation data across two groups, 'invoices' and 'payments', with source and target totals for each day in October — run distribution and weighted mean analytics on the target_total field for all 120 rows so we can see which group has the most variance."},{"title":"ETL validation summary report","prompt":"After our ETL run, I want to check if source_total values are distributed normally across the 60 reconciliation records we loaded — can you give me the numeric distribution stats and weighted mean report for the source_total field?"}],"resultDescription":"Returns two analytical reports: (1) a numeric distribution report showing the spread and distribution characteristics of the selected field (source_total or target_total) across the supplied rows, and (2) a secondary-measure weighted mean report computed from the reconciliation data. Both reports are generated locally without external lookups, covering up to 200 input rows per call.","failureModes":["More than 200 rows submitted — request rejected, reduce row count","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Date field not matching YYYY-MM-DD pattern — schema validation failure","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — rejection","Invalid field selector (must be 'source_total' or 'target_total') — error","Payment not provided or insufficient USDC — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you need both a numeric distribution analysis and a weighted mean computed together on reconciliation data in a single low-cost call ($0.01 USDC for two reports). It is ideal for data engineering, ETL validation, or finance reconciliation workflows where you need to compare source and target totals across up to 200 rows without relying on external services or prediction models.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:38.837Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-numeric-distribution-secondary-measure-weighted-ec62e396"}