Correlation (descriptive)
correlationMeasure the strength and direction of a relationship between two numeric columns, returning r or ρ, confidence intervals, and a least-squares line without a p-value.
Instructions
Strength and direction of the relationship between two numeric columns (r or ρ, CI, least-squares line), WITHOUT a p-value. To test whether a relationship is significant, use a hypothesis_test analysis with test "correlation". The user confirms the columns first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| x | No | ||
| y | No | ||
| 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. | |
| method | No | pearson | |
| x_name | No | ||
| y_name | No | ||
| x_column | No | ||
| y_column | No | ||
| confidence | No | Confidence level for intervals. Default 0.95. | |
| confirmation_token | No | Only after the user has confirmed the proposed choices: the confirmation_token from the previous response. |