zscore

zscore(X)

X is a vector/matrix.

If X is a vector, return the zscore for all elements of X.

If X is a matrix, the zscore calculation is conducted within each column of X.

As with all aggregate functions, NULL values are not included in the calculation.

Please note that the calculation uses sample standard deviation instead of population standard deviation.

zscore(1 2 3 4 5);
// output
[-1.264911,-0.632456,0,0.632456,1.264911]

m=matrix(1 2 3, 4 5 6);
m;

zscore(m);