Correlations, Group By Type?

[sakonnet]

I have data for several different types of land

Variable1 Variable2 Variable3 TypeOfLand
30 250 300 Desert
40 670 200 Forest
10 30 400 Forest
20 500 800 Arctic
20 180 270 Desert
....


I'd like to know if there's a way using PivotTables or any other
function to product the following automatically

CorrelationBetweenVar1and2
CorrelationBetweenVar2and3 CorrelationBetweenVar1and3
Desert
Forest
Arctic
Swamp
Lakeside
....

In other words, I'd like to run a correlation between two variables,
but I'd like for it to be grouped by type.

Will be very grateful for any input!

Regards,
Sak

 

[Herbert Seidenberg]

Use this array formula as a template
=CORREL(IF(Land="Arctic",Variable1),IF(Land="Arctic",Variable2))
or see:
http://www.savefile.com/files/1686640