computing z-scores

Поиск
Список
Период
Сортировка
От Martin Mueller
Тема computing z-scores
Дата
Msg-id 2CC1AFF5-BB3A-499D-8969-C5B3388ED534@northwestern.edu
обсуждение исходный текст
Ответы Re: computing z-scores
Re: computing z-scores
Re: computing z-scores
Список 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
standarddeviation. I know how to do this in a two-step procedure. First, I compute the average and standard deviation.
Ina 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
goesbeyond my SQL competence. 
 

Martin Mueller    


В списке pgsql-general по дате отправления: