The convention, as far as I am aware, is "Average" always refers to the "Mean Average" unless explicitly stated otherwise. Modes
and Medians are usually specific to certain arms of the calculati.
Having said that, probably a good idea to add the note to the docs regardless.
On 2014/07/30 09:38, Jonathan Moules wrote:
Hi List,
A question and possible suggestion.
Which type of average does avg() calculate? The documentation doesn't say -
https://www.sqlite.org/lang_aggfunc.html
I guess it's the mean, but it could be median or mode, so worth asking.
My suggestion would be to include an explicit statement in the docs saying
which it is to make it clearer for users.
Cheers,
Jonathan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
