g_cor(G;S;X;Y)
Returns the correlation coefficient of two sets of values within a given group.
Function type
Vector only
Syntax
g_cor(G;S;X;Y)
Input
Argument | Type | Description |
---|---|---|
G |
any | A space- or comma-separated list of column names Rows are in the same group
if their values for all of the columns listed in If If any of the columns listed in |
S |
integer | The name of a column in which every row evaluates to a 1 or 0, which determines
whether or not that row is selected to be included in the calculation If
If any of the values in
|
X |
any numeric type | A column name Rows where |
Y |
any numeric type | A column name containing the data that will be operated on by the group
summarization function when calculating the correlation coefficient Rows where
|
Return Value
For every row in each group defined by G
(and for those rows where
S
=1, if specified), g_cor
returns
a decimal value corresponding to the correlation coefficient of the values in the column
listed in X
and the values in the column listed in Y
that
are in the same group as that row.
If no rows have valid (non-N/A) values for both X
and Y
,
the result is N/A.
Sample Usage
<base table="pub.doc.samples.ref.func.g_func_sample_usage_two_values"/> <willbe name="g_cor_1" value="g_cor(state;include;value1;value2)"/> <willbe name="g_cor_2" value="g_cor(state city;include;value1;value2)"/>