in reply to Correlation plots

Win

In order to find your real intention I'll rather ask:

From your post, I'd assume:

- You need a linear regression of an arbitary dataset
  which is in the form of [float(x),float(y)] x 100

- You have 10,000 of these datasets, which you'll pull subsequently
  from a database

- for each of the 100-coordinate data set (10,000), you'll compute some fit
  (a line slope + an intercept) and its corresponding R2 to this
  100-coordinate dataset?

- You'll store each of the (10,000) results, together with Record-ID, slope,
  intercept and R2 subsequently into a file (10,000 rows), which is
  your new table?

Just asking to be sure ... ;-)

Regards

mwa

Replies are listed 'Best First'.
Re^2: Correlation plots
by Win (Novice) on Oct 10, 2007 at 12:19 UTC
    You are correct with all your assumptions. Further, you may be interested to know that I do not want to pull out unique data coordinates for each plot. I am planning to take random samples from a base table and perform the correlation analysis for each of these random sample sets.