Engineers-Excel.com

Descriptive Statistics

Description| How it works



Excel has tools for Descriptive Analysis and creation of Histograms, but they are "static" tools and need to be re-run everytime there is a change in the data. This app 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.

Data

Descriptive Statistics Report

Also See:

Sequences and Series

Technical Stock Analysis

Batch Scheduler

Calculus of a Single Variable