##

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. |