AW: [HACKERS] Standard Deviation function.

Поиск
Список
Период
Сортировка
От Andreas Zeugswetter
Тема AW: [HACKERS] Standard Deviation function.
Дата
Msg-id 01BD9069.FC98A570@zeugswettera.user.lan.at
обсуждение исходный текст
Список pgsql-hackers
>> I had asked you how to calculate this and the variance early last
>> year.  One (I think the variance) was two-pass because of the need
>> for the average, but I thought the StdDev would work with the struct.

>Variance is just square of std. dev, no?

No !   Stdev is divided by count, Variance by (count - 1)

It was some time ago, but I thing there is a running function that
can be calculated with one pass. I might be able to dig it up somewhere.
I had it in an excel sheet for learning purposes.

Andreas



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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: [HACKERS] NEW POSTGRESQL LOGOS
Следующее
От: dg@illustra.com (David Gould)
Дата:
Сообщение: Re: [HACKERS] Standard Deviation function.