Descriptive Statistics

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Many customers call and ask if Excel or the QI Macros Statistical Software can calculate descriptive statistics on their data like standard deviation, variance and confidence intervals. The answer is yes.

Excel's Descriptive Statistics

Excel can calculate some descriptive statistics for your data but its interfaces are difficult to understand. In Excel click on Tools, Data Analysis and Descriptive Statistics to get this input window.

Excel calculates a separate set of statistics for each column or row of your data. If you want to calculate statistics for all of your data, make sure your data is only in one row or column. Excel's output looks like this:

Excel's Function Key

You can use Excel's function key (fx) to calculate some statistics.

However, you may have to perform some preliminary calculations on your own and set up inputs of the calculation in a spreadsheet. For example, if you wanted to calculate confidence intervals for a set of data you would need to perform the following steps:

Calculate n, average, standard deviation and alpha for your data. Input these values into a spreadsheet, then label a cell "Confidence Interval" and click on the fx key to insert a function into the cell formula.

Click okay and define the inputs.

QI Macros Descriptive Statistics

Watch Descriptive Statistics in Excel Video using the QI Macros

The QI Macros descriptive statistics is much easier to use and we have added a few additional calculations of our own. Just click and drag over your data to select it, then click on QI Macros, Anova and Analysis Tools, Descriptive Statistics.

The QI Macros output contains all of the descriptive statistics included in Excel's output plus it also contains data normality tests, histograms, box plots and other charts.

Save yourself time and frustration, use the QI Macros Anova and Analysis tools for your statistical needs.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!