I’m finding it much simpler and convenient to use R now the excellent R and Friends package is available. Here is a brief outline how to do very rapid correlation matrices in R and get the data back into Excel.
[flowplayer src=’http://www.anddavies.co.uk/wp-content/uploads/2010/10/matrix-Desktop.m4v’ splash=’http://www.anddavies.co.uk/wp-content/uploads/2010/10/matrix-poster.jpg’]
RandFriends is available to download from here.