Descriptive statistics
describeCompute descriptive statistics for a chosen column, optionally grouped, including mean, SD, median, quartiles, range, skewness, kurtosis, shape, and confidence interval for the mean.
Instructions
n, mean, SD, median, quartiles, range, skewness, kurtosis, shape and CI for the mean, for a column the user asked about (optionally by group). The user confirms the columns first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | No | Path to the data file: CSV, TSV, Excel (.xlsx/.xls) or Parquet. If the user attached the file to the chat, pass its path or name here (a file:// link, @name or #file:name also works); do not paste its contents. Relative names are found in the workspace folders. Files of millions of rows are fine. JSON/BSON and other NoSQL data are not tabular and are not supported. | |
| name | No | ||
| column | No | ||
| values | No | ||
| confidence | No | Confidence level for intervals. Default 0.95. | |
| group_column | No | ||
| confirmation_token | No | Only after the user has confirmed the proposed choices: the confirmation_token from the previous response. |