open.conted.ox.ac.uk (beta)

Open Educational Resources

Data Handling and Spreadsheet Skills - Focus on Psychology Online Tutorial

This is a link to an online tutorial by Rebecca McCready at Newcastle University. It covers a range of tools and techniques using MS Excel to manage, manipulate, interpret and display data, focusing on techniques commonly used in Psychology, although generally useful to other subjects too. In particular, this tutorial covers using basic statistical functions; recoding data; filtering and sorting; Standard Deviation; transposing values; creating charts; y-error bars and extrapolated trendlines.

Date created: 
Friday, November 2, 2012