Skip to contents

DuckDB function covar_samp

Source: R/duckdb-funs.R
covar_samp.Rd

Returns the sample covariance for non-NULL pairs in a group.

Usage

covar_samp(y = DOUBLE, x = DOUBLE)

Arguments

y

DOUBLE

x

DOUBLE

Value

DOUBLE

SQL examples

(SUM(x*y) - SUM(x) * SUM(y) / COUNT(*)) / (COUNT(*) - 1)