chris111
10-12-2010, 07:26 AM
Hi Guys,
I have a two dimensional array "signals" that is 20 by 200 (roughly).
I want to calculate the correlation of various columns to each other. For example, I want to calculate the correlation of column 1 to column 2... how do I specify it..?
I am trying
Correl = Application.WorksheetFunction.Correl(signals(1), signals(2))
However this isn't working (presumably because i'm treating it as a 1-D array).. Any ideas?
I have a two dimensional array "signals" that is 20 by 200 (roughly).
I want to calculate the correlation of various columns to each other. For example, I want to calculate the correlation of column 1 to column 2... how do I specify it..?
I am trying
Correl = Application.WorksheetFunction.Correl(signals(1), signals(2))
However this isn't working (presumably because i'm treating it as a 1-D array).. Any ideas?