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.
