SQL z-score 구하기

SQL을 통해서 표준화점수 구하기

$$ z-score = \frac{X_i - Mean(X)}{std(X)} $$

Key : 평균, 표준편차는 하나의 값이니까, croos join으로 해결 group by 처럼 되면 안됨.

SELECT (T1.values - stats.average) / stats.s AS zvalue
FROM  [TABLE] T1 
cross join
(select sttdev(values) as s, avg(values) as average from [TABLE]) stats;

SQL, z-score, z점수, 표준화점수

GustavoGandon60, 2026/10/01 08:55

I question one thing though: is 표준화점수 always that straightforward?

Real name:

E-Mail:

Enter your comment:

Please fill all the letters into the box to prove you're human. Y M᠎ S H X Please keep this field empty:

Subscribe to comments

SQL z-score 구하기

Discussion