Gnumeric has a nice tool for calculating correlations, but is limited in terms of specifying your output. It looks like this, Figure 8-7 :
Correlations | pressure | distance | height pressure | 1 | | distance | 0.9841073| 1 | height | 0.7633996| 0.7239509| 1
I would like to generate pairs like this:
pressure pressure 1 pressure distance - pressure height - distance pressure 0.9841073 distance distance 1 distance height - height pressure 0.7633996 height distance 0.7239509 height height 1
I'm fine with 1's and blanks, but it would be nice if I could avoid them. It doesn't have to be within a spreadsheet.