Re: Pearson-r in SQL
Date: 24 Dec 2004 08:22:00 -0800
Message-ID: <1103905320.061284.271100_at_c13g2000cwb.googlegroups.com>
Thank you *very much* for the references -- I can now do something over
Christmas instead of watching parades and sappy movies on television :)
I did not use the AVG() because I wanted to see if anyone had an
arguement for changes to SUM() and/or COUNT(). Yes, the "^2" is not
Standard SQL, but there are several vendor versions, such as POWER (x,
2) or SQR(x).
I am an old FORTRAN programmer, so I tend to write (x*x) too much. We
used to do that to avoid converting integers to float in the early
days.
>> If you want to keep them, I would first calculate a linear
I thought about that, but I was worried that this would force the
missing values toward a correlation, whereas an average would be more
representative of each set of values without influence from the other
regression
with the remaining pairs, say y = a + b*x, and then fill in the
expected values, .. <<
But I honestly do not know what the preferred method is.
Received on Fri Dec 24 2004 - 17:22:00 CET