Correlation Matrix in RExcel using RandFriends

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...

Beta-diversity of cold-water coral reefs

Lea-Anne Henry, Andrew J Davies and J Murray Roberts Spatial heterogeneity in coral reef communities is well documented. This “species turnover” (beta diversity) on shallow warm-water reefs strongly conforms to spatial gradients in the environment as well as spatially...

Pivot Tables in Excel 2007.. Easy!

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: [PLAYER=pivot_table.m4v]