Hi,
I'm trying to build a simple correlation matrix. I have 3 named
arrays - Array1, Array2 & Array3. I can do this by putting the array
names in the functions explicitly without problem, but I don't know
how to do this when the name of an array is held in a cell.
Easy and works:
=Correl(Array1,Array1) =Correl(Array1,Array2) =Correl(Array1,Array3)
=Correl(Array2,Array1) =Correl(Array2,Array2) =Correl(Array2,Array3)
=Correl(Array3,Array1) =Correl(Array3,Array2) =Correl(Array3,Array3)
What I'd like to do is put the array names Array1, Array2 and Array3
in cells surrounding the matrix and reference those cells to get the
names:
Array1 Array2 Array3
Array1 =Correl(?,?) =Correl(?,?) =Correl(?,?)
Array2 =Correl(?,?) =Correl(?,?) =Correl(?,?)
Array3 =Correl(?,?) =Correl(?,?) =Correl(?,?)
The tables above probably won't survive email so I'm not going to
worry too much about formatting. Hopefully the idea/question is clear.
How do I reference a cell that holds a name and then use the contents
of that cell as an argument to the correlation function?
Thanks,
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
