The Analysis ToolPak in Excel comes with tools for Descriptive Analysis and creation of Histogram, but they are "static" tools and need to be re-run everytime there is a change in the data. This tool provides a "dynamic" version, where the statistics and histogram are generated as soon as there is a change in the source data. It generates the report for only one column of data.

Download

.xls file(30 KB)

How to Use

There are two sheets in the file. The sheet "Data" holds the source data in the first column and the statistics are available on the sheet "Statistics". Simply key in or paste your data into Column A of the first sheet and view the report on the second. The statistics are the same as those generated by Analysis Toolpak. A note of caution, however, do not delete Column A on the sheet "Data". To bring in new data, clear the contents in the column A and paste the data.

The following screenshots shows the data and report for a sample data set of 20 measurements.