Using Excel’s Summary Statistics

January 12, 2009 by  
Filed under Demo

Sometimes it is nice to use software to generate summary statistics. It’s quick and easy. And appropriate when your assumptions and the software’s assumptions agree.

Here’s a demo of how to use Excel’s Analysis Toolpak to get descriptive statistics.

How To Activate Excel Analytics

January 12, 2009 by  
Filed under Demo

Microsoft Excel has a wonderful collection of statistical procedures that typically come with the product but are not installed. Provided as an add-on, the Analysis ToolPak lets you easily obtain descriptive statistics (means, standard deviations, etc.) with only a few clicks.

In this demo, I show you how to install the Analysis ToolPak, and how to create a scatterplot of data.

How load Excel Analytic ToolPak