Skip to site navigation

Basic statistical measures in Excel 2010

../../document_library/excel-statistics.zip

Description

This course is an introductory level course aimed at those who would like to learn how to write formulae and use functions in Excel for basic statistical purposes. It aims to introduce you to built-in Excel statistical functions and introduce you to  building formulae by hand. The course covers major descriptive measures, some basic plots and introduces the elements of regression analysis.

Note that this course can be completed by people using Excel 2007.  There are some differences between the two versions but most features are the same.

Pre-requisites:

Good basic understanding of Windows and some basic familiarity with Excel is an advantage.  Attendees should be comfortable with basic descriptive statistical techniques.

Outline:

  • Entering formulae in Excel
  • Using the Excel function wizard
  • Measures of location
  • Measures of diffusion
  • Measures of shape
  • Frequency
  • Correlation
  • Histograms
  • Scatter plots
  • Pie charts

Delivery:  Self-paced

Trainer led sessions are no longer available for Excel 2010, see Excel 2013.
The resources listed below can be used for self-paced learning.Resources: