Archived Material (Maths and Stats)

Statistics with Excel: Part 1

This content has been archived! For the latest version please visit:

If you need help with understanding statistics with Excel, then the video (below) is for you. In it, Joseph Schmuller explains the fundamental concepts of descriptive and inferential statistics and shows you how to apply them using Microsoft Excel. 

Topics include:

  • Understanding data types and variables
  • Calculating probability
  • Understanding mean, median, and mode
  • Calculating variability
  • Organising and graphing distributions
  • Sampling distributions
  • Making estimations
  • Testing hypothesis: mean testing, z- and t-testing, and more
  • Analysing variance
  • Performing repeated measure testing
  • Understanding correlation and regression