Aggregate

CORR

PostgreSQL

Menghitung koefisien korelasi Pearson antara dua variabel. Hasil antara -1 (korelasi negatif sempurna) dan 1 (korelasi positif sempurna).

Tipe hasil: double precision

Syntax

SQL

CORR(Y, X)

Ynumericwajib

Variabel dependen

Xnumericwajib

Variabel independen

SQL

1 SELECT CORR(sales, price) AS price_sales_correlation
2 FROM products;

Mengukur hubungan antara harga dan penjualan.

Hasil

price_sales_correlation
-0.756234567890

CORR

Snowflake

CORR

BigQuery

1	SELECT CORR(sales, price) AS price_sales_correlation
2	FROM products;