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