Statistical Analysis with Excel

Data Analysis with Microsoft Excel

This outline has been prepared to help you to:

  • Manage and code data for analysis in Excel including recoding, computing new values and dealing with missing values;
  • develop an understanding of Excel Statistical Functions;
  • learn to write complex statistical formulae in Excel worksheets.

The course is aimed at those who have a good understanding of the basic use of Excel and sound statistical understanding.

It is assumed that you have attended the Introduction to Excel Formulae & Functions course or have a good working knowledge of all the topics covered on that course. In particular, you should be able to do the following:

  • Edit and copy formulae
  • Use built-in functions such as Sum, Count, Average, SumIf, CountIf and AutoSum
  • Use absolute and relative cell referencing
  • Name cells and ranges

You should also have some familiarity with basic statistical measures and tests.  If you are uncertain about the statistical knowledge assumed by the course you may wish to use the list of key terminology and symbols to revise.

Excel has a number of useful statistical functions built in, but there are also some caveats about its statistical computations.  For this reason and to facilitate more flexibility, in this course we demonstrate some handcrafted techniques as well  First we look  at some techniques to help you manage data, then descriptive statistics, and measures of association (covering correlation and regression).  We move on to some special Excel functions using the goal seeking and solver techniques and then we introduce the Analsysis ToolPak, which we demonstrate by way of a single factor Anova.

Request for In House or Individual Training

VERIFIED & SECURED
BY: RapidSSL SHA256 CA
SSL Valid: Nov 07, 2016 - Nov 07, 2017