Descriptive Statistics

Overview | How to | Example

Overview

Displays the following descriptive statistics for a given set of data:

• Mean - represents the center of the data and is equals to sum of all observations divided by the number of observations

• Std Dev - Standard deviation measures the degree of dispersion of the data from the mean. The greater the value, the greater the spread

• Variance - equals to the square of standard deviation

• Count - number of observations

• Sum - sum of all observations

• Min - smallest value of the data

• 1st quartile - 25% of the data are less than or equal to this value

• Median - 50% of the data are less than or equal to this value

• 3rd quartile - 75% of the data are less than or equal to this value

• Max - largest value of the data

• Range - different between the largest and smallest value of the data

• Mean 95% CI-L and Mean 95% CI-U - lower and upper confidence interval limits for the mean

• Sigma 95% CI-L and Mean 95% CI-U - lower and upper confidence interval limits for the standard deviation

• Median 95% CI-L and Mean 95% CI-U - lower and upper confidence interval limits for the median

How to

At the Excel Menu (For Excel 2007, go to Add-ins first)

1. Choose ProcessMA > Statistics > Descriptive Statistics

2. In Variable, select the column containing the data

3. Click OK

Example

You collected data on time (in minutes) to resolve a customer enquiry in a call centre. You want to describe this set of data.

1. Open data worksheet by choosing ProcessMA > Tools > Data

2. Choose ProcessMA > Statistics > Descriptive Statistics

3. In Variable, select BJ - Time

4. Click OK

Results & Interpretation

The call center takes a average of 7.0430 minutes to resolve a customer enquiry.

Copyright © ProcessMA