2018-07-08 9:10 GMT+02:00 Keith Medcalf <kmedc...@dessus.com>:

>
> sqlite>
> ​​
> select kurt(abs(random() % 7)) from generate_series where start=1 and
> stop=1e6;
> -1.25154453962449
>
> sqlite> select skew(abs(random() % 7)) from generate_series where start=1
> and stop=1e6;
> 0.00104535938599554
>
> The PRNG is pretty random.
>
> It is slightly concave (that is, anti-normal) (a "flat" distribution would
> have a kurtosis of -1.2) and the curve is slightly skewed above the average.
>

​At the moment it does not say much to me. But when I try the first
statement I get​:
    Error: no such table: generate_series

Am I overlooking something?

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to