In this tutorial: Introduction > Getting Started > Your skills rating > Save the File > Calculating Basic Statistics > Sort and Filter >
Standard Deviation >
Apparent Motion Scatter Graph > Skills list >
All pages in this tutorial
In the previous session, you saw how Excel can be used to manipulate and present data, and create charts and two-axes graphs. In this session, we shall look at how you can use Excel to analyse data by calculating basic statistics, using Standard Deviation calculations as error bars, adding a line of best fit to a scatter graph, and sorting and filtering data.
By the end of this session, you should be able to:
© 2012 Learning Technologies for Medical Sciences,
School of Medical Sciences Education Development,
Webmaster. Managed by Mrs Rebecca McCready.
Academic IT Skills tutorials and materials by Rebecca McCready (Newcastle University) is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
Permissions beyond the scope of this license may be available at MedIT.Exercises@ncl.ac.uk.