Aggregate

CORR

Snowflake

Menghitung koefisien korelasi Pearson antara dua variabel numerik. Nilainya berkisar dari -1 (korelasi negatif sempurna) hingga +1 (korelasi positif sempurna).

Tipe hasil: FLOATDiperbarui: 6 Jan 2026

Syntax

SQL

CORR(y, x)

Parameter

ynumericwajib

Variabel dependent (Y)

xnumericwajib

Variabel independent (X)

Contoh Penggunaan

Korelasi Harga dan Penjualan

SQL

1 SELECT
2   ROUND(CORR(units_sold, price), 3) as price_sales_corr
3 FROM products;

Mengukur korelasi antara harga dan jumlah unit terjual. Nilai negatif berarti harga naik, penjualan turun.

Hasil

-0.72

Korelasi Multiple Variables

SQL

1 SELECT
2   ROUND(CORR(revenue, marketing_spend), 3) as revenue_marketing,
3   ROUND(CORR(revenue, num_employees), 3) as revenue_employees,
4   ROUND(CORR(revenue, customer_count), 3) as revenue_customers
5 FROM company_metrics;

Menganalisis korelasi revenue dengan berbagai faktor bisnis.

Hasil

REVENUE_MARKETING	REVENUE_EMPLOYEES	REVENUE_CUSTOMERS
0.85	0.62	0.91

Korelasi per Kategori

SQL

1 SELECT
2   category,
3   COUNT(*) as sample_size,
4   ROUND(CORR(rating, price), 3) as rating_price_corr
5 FROM products
6 GROUP BY category
7 HAVING COUNT(*) >= 30;

Menganalisis apakah produk mahal cenderung mendapat rating lebih tinggi per kategori.

Fungsi Terkait

STDDEVVARIANCECOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISCSTDDEV_POPSTDDEV_SAMPVAR_POPVAR_SAMPMEDIANMODE

Kembali ke Snowflake Functions

1	SELECT
2	ROUND(CORR(units_sold, price), 3) as price_sales_corr
3	FROM products;

1	SELECT
2	ROUND(CORR(revenue, marketing_spend), 3) as revenue_marketing,
3	ROUND(CORR(revenue, num_employees), 3) as revenue_employees,
4	ROUND(CORR(revenue, customer_count), 3) as revenue_customers
5	FROM company_metrics;

1	SELECT
2	category,
3	COUNT(*) as sample_size,
4	ROUND(CORR(rating, price), 3) as rating_price_corr
5	FROM products
6	GROUP BY category
7	HAVING COUNT(*) >= 30;