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.

RandFriends is available to download from here.

A student asked me how to make a Pivot Table in Excel 2007 and group by a field. So I just drew up this simple video. I thought I’d release it..

Enjoy.. It is so easy!

View the screencast below: