Tutorials

These are links to tutorials that you may find useful as a Learning Analytics Fellow. If you have a suggestion for another tutorial (either you have one to suggest, or have a request for a particular kind of tutorial), please add it or let Kris know (ksgorman@umich.edu).

Statistics

Mean, Median, Standard Deviation

Khan Academy Unit on Descriptive Statistics

Wikipedia Article on Descriptive Statistics

Wikipedia Article on Standard Deviation

Linear Regression and Correlation Coefficients

Khan Academy Unit on Regression

Wikipedia Article on Fitting a Line to Points

Wikipedia Article on Correlation Coefficient

Excel

Many of the features of Excel are exactly the same for PCs and Macs, but because the features are often located in different places, we've tried to provide both Mac and PC tutorials. Many of these features can also be done on a Mac with the free plug-in StatPlus http://www.analystsoft.com/en/products/statplus/

Sorting and filtering data

Windows - Sorting data in Excel

Windows - Anatomy of Excel: Sorting and Filtering

Mac - Excel 2011 for Mac: Sorting and Filtering (screencast)

Creating histograms

Windows - Creating a Histogram in Excel 2010 (screencast)

Mac - (Part 1) Making a frequency table; (Part 2) Making a Histogram in Excel from frequency data (screencasts)

Creating scatterplots with trendlines

Windows - How to make a basic scatterplot in Excel 2007 (screencast)

Windows - Excel 2010 Scatter Diagram with Trendline (screencast)

Mac - Creating Scatterplots in Excel 2011 (PDF)

Formulas for calculating mean, median and standard deviation