> Hi All,
>
> I would like to know if there is any predefined function in firebird to
> calculate the covariance and variance similar to Excel's 'COVAR'
> and 'VAR'
> functions
> Thanks
>
> Meena.

no - you'd have to read the dataset back to the client and do this type of
analysis. I would not think that UDfunctions are a good option (nor
available) here since they would need the entire dataset to operate over.
After all - that's what excel is doing - it has the whole dataset in a sheet
in memory in order to do this calc.
Alan