Re: Pearson-r in SQL

Matthias Klaey wrote:
> On Thu, 23 Dec 2004 16:45:54 -0800, "Mikito Harakiri"
> <mikharakiri_at_iahu.com> wrote:
> >The values
> >
> >(3kg, NULL)
> >(5kg, NULL)
> >(7kg, NULL)
> >(NULL, 1m)
> >(NULL, 2m)
> >(NULL, 3m)
> >(NULL, 4m)
> >
> >are orthogonal. There is no corellation is this data set whatsoever.
> >
>
> You are using here the word "orthogonal" in a sense that I don't
know.
> Could you please give a mathematical definition?

It's a typo. I meant "independent". If you replace NULLs with 0s the first and the second set of points are (affine) independent in R^2. Received on Fri Dec 24 2004 - 22:02:06 CET