how do I generate an array of correlated values

[Guest]

I want to generate a column of 3 CORREL values.
Each CORREL value will be derived by CORREL(A=1x4 array, B=3x4 array)
Can I do this by functions without using macros? Should be generic enough.
Example:
A=(10, 20, 30, 40)
B=(B1,
B2,
B3)
B1=(11, 12, 13, 14)
B2=(15, 16, 17, 18)
B3=(19, 20, 21, 22)
Result = (CORREL(A,B1),
CORREL(A,B2),
CORREL(A,B3))

 

[Michael R Middleton]

vishs -

Perhaps you could use the Correlation data analysis tool.

- Mike

www.mikemiddleton.com