I think the Standard Deviation uses the mean, while the Coefficient of
Dispersion uses the median. I need to be able to calculate both the
Standard Deviation and the COD.

In your scouring, did you find anywhere a function that returns the
median (middle) of a set of numbers? I think the only way for Firebird
to calculate a median is for someone to add this function to the engine
itself. The only way I can do it is with a stored procedure that goes
through the numbers a couple of times (once to count them) and then once
to sort them and find the middle. It would be great if a 'median'
function could be added to the engine.

Todder

csswa wrote:

> I have scoured the udf dlls and searched the net, and it looks like I
> will have to tackle stdev calculations myself. I'm no guru when it
> comes to statistical maths (thanks to that sucking void in my head
> where my high-school studies used to be) but it looks do-able thanks
> to the existing square root udf. If I'm about to spend a few hours
> pursuing a function that can't be done, feel free to warn me of my
> folly right about now...
>
> Regards,
> Andrew Ferguson
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> <http://rd.yahoo.com/M=213858.1879370.3379539.1261774/D=egroupweb/S=1705115386:HM/A=763352/R=0/*http://www.classmates.com/index.tf?s=5085>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]