Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.cwix.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.glorb.com!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: mikharakiri_nospaum@yahoo.com
Newsgroups: comp.databases.theory
Subject: Re: Pearson-r in SQL
Date: 24 Dec 2004 13:02:06 -0800
Organization: http://groups.google.com
Lines: 24
Message-ID: <1103922126.809240.217240@z14g2000cwz.googlegroups.com>
References: <1103746401.990096.37280@f14g2000cwb.googlegroups.com>
   <j9myd.23$Tg5.117@news.oracle.com>
   <1103759349.210421.202020@z14g2000cwz.googlegroups.com>
   <HZoyd.28$Tg5.65@news.oracle.com>
   <1103777319.718876.232070@z14g2000cwz.googlegroups.com>
   <2jsls0lsibqh6pnslp5v0cl8dn95uom78g@4ax.com>
   <f6oms0heulhqar17hlfnbgqhdpgaj0s6bs@4ax.com>
   <qQJyd.43$ej3.65@news.oracle.com>
   <9r6ns0dmtb86l6mai11bv8lo50duh13ef9@4ax.com>
NNTP-Posting-Host: 64.164.3.232
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1103922132 2058 127.0.0.1 (24 Dec 2004 21:02:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 24 Dec 2004 21:02:12 +0000 (UTC)
In-Reply-To: <9r6ns0dmtb86l6mai11bv8lo50duh13ef9@4ax.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=64.164.3.232;
   posting-account=jduQMA0AAABKdEh0L1SEqrR3hnlHUlAG
Xref: dp-news.maxwell.syr.edu comp.databases.theory:29159


Matthias Klaey wrote:
> On Thu, 23 Dec 2004 16:45:54 -0800, "Mikito Harakiri"
> <mikharakiri@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.