hockeyfan
05-05-2008, 05:44 PM
I have a matrix of numbers in A2:C10 on one work sheet.
In another I want to do a correlation matrix, that will look like this
1 2 3
4 5 6
7 8 9
The cells that will hold the correlations are B2:d4
1. =Correl("A3:A10","A2:A9") -Is A a lagging indicator of A?
2. =Correl("A3:A10","B2:B9") -Is A a lagging indicator of B?
3. =Correl("A3:A10","C2:C9") -Is A a lagging indicator of C?
4. =Correl("B3:B10","A2:A9") -Is B a lagging indicator of A?
5. =Correl("B3:B10","B2:B9") -Is B a lagging indicator of B?
6. =Correl("B3:B10","C2:C9") -Is B a lagging indicator of C?
7. =Correl("C3:C10","A2:A9") -Is C a lagging indicator of A?
8. =Correl("C3:C10","B2:B9") -Is C a lagging indicator of B?
9. =Correl("C3:C10","C2:C9") -Is C a lagging indicator of C?
I hope I explained that OK... So basically I am having trouble doing this... Its a nightmare to do with loops and R1C1 formulas, does anyone have any good ideas?
In another I want to do a correlation matrix, that will look like this
1 2 3
4 5 6
7 8 9
The cells that will hold the correlations are B2:d4
1. =Correl("A3:A10","A2:A9") -Is A a lagging indicator of A?
2. =Correl("A3:A10","B2:B9") -Is A a lagging indicator of B?
3. =Correl("A3:A10","C2:C9") -Is A a lagging indicator of C?
4. =Correl("B3:B10","A2:A9") -Is B a lagging indicator of A?
5. =Correl("B3:B10","B2:B9") -Is B a lagging indicator of B?
6. =Correl("B3:B10","C2:C9") -Is B a lagging indicator of C?
7. =Correl("C3:C10","A2:A9") -Is C a lagging indicator of A?
8. =Correl("C3:C10","B2:B9") -Is C a lagging indicator of B?
9. =Correl("C3:C10","C2:C9") -Is C a lagging indicator of C?
I hope I explained that OK... So basically I am having trouble doing this... Its a nightmare to do with loops and R1C1 formulas, does anyone have any good ideas?