| Table Name: | correlation |
| Table Number: | 5939 |
| Group: | Analytics |
| Description: | The correlations between 2 attributes of the eda |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| corr_type | LONG | int | DIRECT | Discrete-discrete / continuous-continuous / mix | ||||
| corr_value | FLOAT | real | Measure of relation between the values; range: -1 to 1. | Search (1) | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| num_of_rec | LONG | int | DIRECT | Number of records tested | Search (1) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| p_value | FLOAT | real | Significance of the correlation | Search (1) | ||||
| test_statistic | FLOAT | real | The value of the statistic test performed to evaluate the significance of the correlation (chi-square, t or f, depending on the correlation type). |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| correlation2eda | MTO | eda | eda2correlation | Each EDA may have some correlations | Search (1) | ||
| corr_x2eda_attr | MTO | eda_attr | attr_x2correlation | Attribute for X-axis | Search (1) | ||
| corr_y2eda_attr | MTO | eda_attr | attr_y2correlation | Attribute for Y-axis | Search (1) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| cx3ea5939 | corr_x2eda_attr | nonclustered located on PRIMARY |
| cy2ea5939 | corr_y2eda_attr | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 6001 | correlation_view | correlation, eda, eda_attr |
| correlation | |||