Correlation
Aggregation functions correlation
syntax
- corr(a, b)
- corr(a, b, relation)
definition
- corr(a, b) results in the correlation coefficient of attributes a and b.
- corr(a, b, relation) results in the correlation coefficient of attributes a and b, grouped by relation. The Domain unit of the resulting attribute is the Values unit of the relation.
The Value type of the resulting Data item is float32 or float64.
A row in which a or b is Null is left out of every sum that the coefficient is computed from. A coefficient that an older version of GeoDMS calculated from data with nulls has to be recalculated.
applies to
- attribute a and b with Numeric Value type
- relation with value type of the group CanBeDomainUnit
conditions
- The value type of the arguments a and b must match.
- The domain of arguments a, b and relation must match.
Condition 2 is checked with and without relation: a configuration that pairs attributes of two different domain units is an error. The same holds for Covariance and Modus_weighted.
example
1. parameter<float32> corrNrInhabitantsTemp :=
corr(float32(City/NrInhabitants), City/avgDailyTemperature); result = -0.89948
2. attribute<float32> corrNrInhabitantsTempRegion (Region) :=
corr(
float32(City/NrInhabitants)
,City/avgDailyTemperature
,City/RegionNr
);
| City/NrInhabitants | City/avgDailyTemperature | City/Region_rel |
|---|---|---|
| 550 | 12 | 0 |
| 525 | 11 | 1 |
| 300 | null | 2 |
| 500 | 11 | 1 |
| 200 | 14 | 3 |
| 175 | null | null |
| null | 14 | 3 |
domain City, nr of rows = 7
| corrNrInhabitantsTempRegion |
|---|
| null |
| null |
| null |
| null |
| null |
domain Region, nr of rows = 5