JSON IQR stats on field

Client

Compute Q1, median, Q3, and IQR on a numeric column—robust spread stats that resist outliers better than mean alone.

Learn more: JSON IQR statistics

Compute quartiles (Q1, median, Q3) and interquartile range (IQR) on a numeric field across JSON rows—robust spread stats that resist outliers better than mean alone.

Numeric field

Rows should include the chosen field as a number. Non-numeric or missing values are skipped or reported per tool behavior—clean the column first when QA matters.

IQR interpretation

IQR = Q3 − Q1 describes the middle spread. Pair with running average or column stats tools when you also need means and counts on the same dataset.

Privacy

Statistics are calculated locally from pasted JSON.

About JSON IQR stats on field

Q1, median, Q3, and IQR per column—local. Parsing and transforms run in your browser—Toolcore does not upload your JSON for this operation.

How to use

Paste a JSON array (or follow the two-array example on join tools). Use Load example when shown, or prefill with ?q= / ?qb= on the tool URL.

Input and limits

Fix JSON syntax errors before expecting output. Very large arrays may slow the tab—trim samples during exploration, then scale up locally.

Loading…

Nearby workflows on Toolcore

  • JSON running sum field — Expanding sum per row—browser. Useful once JSON parses on this page.
  • JSON running average field — Running mean per row—local. Useful once JSON parses on this page.
  • JSON formatter — JSON format online: pretty-print, minify, validate, escape, download . Useful once JSON parses on this page.
  • JSON count field nulls — Count null or missing values for one row field—metadata. Useful once JSON parses on this page.

Common use cases

  • Summarize spread on a numeric score column with quartiles resistant to outliers.
  • Compare IQR across JSON samples before trusting a mean from running-average tools.
  • Document robust stats in QA notes from pasted API rows.

Common mistakes to avoid

  • Non-numeric field values

    Strings and nulls skew or skip stats—coerce or filter the column first.

  • Single-row arrays

    Quartiles need enough points to be meaningful—very small samples produce edge cases.

  • Choosing a categorical field

    IQR applies to numeric columns—use count or group tools for categories.

FAQ

What statistics are returned?

Typically Q1, median, Q3, and interquartile range on the chosen numeric field.

Is data sent to Toolcore?

No—stats are computed locally.

Can I prefill JSON?

Yes—?q= / ?qb= for the array; enter the field name on the page.

More tools

Related utilities you can open in another tab—mostly client-side.