Ken Blake, Ph.D.


Excel Stats Minicourse

Quite a bit of basic statistical analysis can be done with Excel, the ubiquitous and affordable spreadsheet software from Microsoft. The links below will show you how to activate Excel 2010's Data Analysis ToolPak add-in and use it to calculate and interpret each of five handy inferential statistics. The course features easy-to-follow YouTube videos and downloadable practice datasets. You'll also find discussion of some important concepts that will help you learn how to pick the right statistic for the job. Everything is free. If you end up redistributing this material in some way, all I ask is that you say where you got it.

Lesson 1: Activating the Data Analysis ToolPak in Excel (Better do this first).
Lesson 5: Comparing the percentages of two variables. A pivot table and a chi-square test.

Lesson 2: Comparing observed percentages to percentages you specify. The one-sample chi-square test.

Lesson 6: Measuring linear association between two variables. Regression.
Lesson 3: Comparing an average to an average you specify. The one-sample t-test.

Lesson 7: Choosing the right statistic for the job (Don't skip this).
Lesson 4: Comparing the averages of two variables. The two-sample t-test.
Lesson 8: How inferential statistics work.