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!ngpeer.news.aol.com!news.compuserve.com!news-master.compuserve.com!not-for-mail From: Matthias Klaey Newsgroups: comp.databases.theory Subject: Re: Pearson-r in SQL Date: Fri, 24 Dec 2004 01:25:10 +0100 Organization: Klaey Computing AG Lines: 36 Message-ID: References: <1103746401.990096.37280@f14g2000cwb.googlegroups.com> <1103759349.210421.202020@z14g2000cwz.googlegroups.com> <1103777319.718876.232070@z14g2000cwz.googlegroups.com> <2jsls0lsibqh6pnslp5v0cl8dn95uom78g@4ax.com> NNTP-Posting-Host: zux167-174.adsl.green.ch Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: ngspool-d02.news.aol.com 1103847913 28738 80.254.167.174 (24 Dec 2004 00:25:13 GMT) X-Complaints-To: newsmaster@compuserve.com NNTP-Posting-Date: Fri, 24 Dec 2004 00:25:13 +0000 (UTC) X-Newsreader: Forte Agent 2.0/32.652 Xref: dp-news.maxwell.syr.edu comp.databases.theory:29139 On Thu, 23 Dec 2004 15:00:51 -0800, Gene Wirchenko wrote: >"-CELKO-" wrote: > >>Add more data to the set, drop the columns with NULLs and now I can get >>a result. For example with four more rows: >> >>(3kg, 6m) >>(5kg, 10m) >>(7kg, 14m) >>(1kg, 2m) >> >>my known values are linear. But I have those other rows of partial >>data that should reduce my confidence that I really have (r = 1). I > > Why? The partial data does not say anything either way. > >>just don't know what the SQL products like CA-Ingres are doing with >>this, nor what statistics would do with it. > > I would toss it. It is not valid data. [...] What if the cost of getting one measurement was, say 37000 Dollars? Even if you could get only the x result and not the desired (x, y) pair, due to some experimental mishap? Are you really ready to throw away such valuable information just because it does not fit the formula? Greetings Matthias Kläy -- www.kcc.ch