# Compute statistics

The Compute statistics step provides key statistical measures for your numeric data, such as median and quintiles. It's crucial for understanding the distribution of your data and identifying important thresholds or benchmarks. These operations collectively enable you to transform raw data into meaningful insights, prepare your dataset for various types of visualizations, and create a more comprehensive and informative dashboard.

### Step parameters

* `Column` **column(string)\***: Select the column to compute statistics on.
* `Group By Columns` **string(array)** **(optional)**: Select columns to group the data by before calculating statistics.
* `Basic statistics` checkbox\["count", "average", "min", "max", "median"]: Choose a basic statistic to compute.
* Advanced statistics: checkbox\["standard deviation", "variance", "first quartile", "last quartile", "first decile", "last decile", "first centile", "last centile"]: Choose an advanced statistic to compute
* `Custom Quantiles` checkbox: Specify custom quantiles to calculate, including label, nth value, and order.

### Example

**Input**

<figure><img src="/files/wpZFlkb4MMPjiSGG2UFc" alt=""><figcaption><p>Compute - Compute statistic input</p></figcaption></figure>

**Configuration**

```json
{
    "column": "sales",
    "group_by": [],
    "basic_statistics": ["count", "max", "min", "average"],
    "adv_statistics": ["standard_deviation"]
    "cust_quant": []
}
```

**Output**

<figure><img src="/files/MjTWzQe7kNn2avlZnO7a" alt=""><figcaption><p>Compute- Compute statistic output</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs-v3.toucantoco.com/data-management-in-datahub/datasets-in-toucan/preparing-data/overview-of-youprep-tm/compute/compute-statistics.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.