# Re: Pearson-r in SQL

From: -CELKO- <jcelko212_at_earthlink.net>

Date: 24 Dec 2004 08:22:00 -0800

Message-ID: <1103905320.061284.271100_at_c13g2000cwb.googlegroups.com>

Date: 24 Dec 2004 08:22:00 -0800

Message-ID: <1103905320.061284.271100_at_c13g2000cwb.googlegroups.com>

>> If you want to keep them, I would first calculate a linear

regression

with the remaining pairs, say y = a + b*x, and then fill in the
expected values, .. <<

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
set. Or even use a Median, as a better measure of central tendency
within a set.

But I honestly do not know what the preferred method is.
Received on Fri Dec 24 2004 - 17:22:00 CET