contrib/statmath/README.statmath


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

Statistical aggregate functions for PostgreSQL.

This module provides some aggregate functions for statistical 
mathematics. A new datatype holding two double precision 
floating point values is required by them. 

The aggregates are:

average(float8)         average value computed by

                                   n
                                  ___
                        _    1    \
                        x = ---    >  x
                             n    /__  i
                                  i=1


variance(float8         variance computed by

                                    n
                                   ___
                         2    1    \         _ 2
                        s  = ---    >  (x  - x) 
                             n-1   /__   i
                                   i=1


stddev(float8)          standard deviation computed by

                                 _____
                                /  2 
                        s =    /  s
                             \/


-- 
Jan Wieck <JanWieck@Yahoo.com>