computing z-scores
Martin Mueller <martinmueller@northwestern.edu>
From: Martin Mueller <martinmueller@northwestern.edu>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2018-05-24T15:15:59Z
Lists: pgsql-hackers, pgsql-general
You construct a z-score for a set of values by subtracting the average from the value and dividing the result by the standard deviation. I know how to do this in a two-step procedure. First, I compute the average and standard deviation. In a second run I use the formula and apply it to each value. Is there a way of doing this in a single-step procedure or can you chain the two parts together in one query? This goes beyond my SQL competence. Martin Mueller