Median/Mode/Mean computation

Posted in 2017

FRANK — Wed, 29 Mar 2017 22:41:53 — source: IIUG Forums & Mailing Lists

Hi , Guys, IDS11.70 FC8 We need calculate median,mode and mean values on some data sets . Mean is easy to get by builtin avg(), but any tips to get Median and Mode function(seems there are no such builtin functions there) ? Thanks Frank . --001a1149126452fd76054be64813

↪ replying to FRANK

Spokey Wheeler — Wed, 29 Mar 2017 22:49:58 — source: IIUG Forums & Mailing Lists

http://members.iiug.org/forums/ids/index.cgi/noframes/read/21170 = <http://members.iiug.org/forums/ids/index.cgi/noframes/read/21170>; > On 29 Mar 2017, at 23:41, FRANK <yunyaoqu@gmail.com> wrote: >=20 > Hi , Guys,=20 > IDS11.70 FC8=20 >=20 > We need calculate median,mode and mean values on some data sets .=20 > Mean is easy to get by builtin avg(), but any tips to get Median and = Mode=20 > function(seems there are no such builtin functions there) ?=20 >=20 > Thanks=20 > Frank=20 >=20 > ..=20 >=20 > --001a1149126452fd76054be64813=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

↪ replying to Spokey Wheeler

Andreas Legner — Thu, 30 Mar 2017 09:45:54 — source: IIUG Forums & Mailing Lists

https://www.ibm.com/support/knowledgecenter/search/Sample%20user-defined%20= aggregates?scope=3DSSGU8G=5F12.1.0 I.e. searching Informix knowledge center for: Sample user-defined=20 aggregates ... might provide entry points too.