by Andy | Oct 25, 2012 | Tutorials
One again, one of my students had a query best answered by using my screen capture software, here’s the video. Essentially, they wished to know how to add error bars using Standard Error in Excel, previous attempts had failed. The answer is to calculate your own...
by Andy | Oct 11, 2010 | Tutorials
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...
by Andy | Oct 2, 2010 | Computers, Tutorials
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]
