Toolbox

Descriptive Statistics
- x-bar, median, s, max, min, skewness
- Cp, Cpk, ppm

Goodness of fit test for Normality
- Anderson-Darling Test
- Jarque-Bera Test

95%-confidence intervals for my and sigma (assuming Normality)

Graphs
- line plot (LP)
- dot plot  (DP)
- bar chart (BC)

Options
- combine line plot and dot plot or line plot and bar chart in one chart
- highlight potential outliers
- add table of descriptive statistics on chart sheet
- add data label (line plot) from worksheet
- add axis label (line plot) from worksheet
- generate graphs/results for several data variables in sequence
- generate graphs/results for several grouping (by)variables in sequence
- combine graphs/results of several data variables in one chart
- combine graphs/results of several grouping (by)variables in one chart
- define graph scale via menu

Details

- Potential Outliers:

Definition:
X is potential outlier if  X < q25 -1.5 * (q75 - q25)  or  X > q75 + 1.5 * (q75 - q25) with q25 (q75) being the 25%- 75%-)  Quantile of the selected data range (from a typical Box-and-Whisker Plot)

Procedure:
Potential outliers are determined iteratively: calculate percentiles based on the full data set, detect and eliminate potential outliers then recalculate percentiles for the remaining data, detect and eliminate potential outliers until no further potential outliers are detected. All data points detected are highlighted as potential outliers.

- BC, DP: Classification of data into interval
A value that falls onto an Interval end point is classified into the lower interval. A value X that falls onto the lower end point of the 1st Interval is classified into the 1st interval.

- BC: values displayed on the y-scale represent the interval mid points.

- BC, DP: The values for minimum and maximum entered in the userform 'Descriptive Statistics' refer to the smallest and largest interval end points.

- The values for minimum and maximum entered in the userform ‘Descriptive Statistics’ define the chart range as well as the lower (upper) end point of the first    (last)  interval in a BC or DP. Data points outside those values are not displayed in the graphs.

Mathematics

- Jarque-Bera statistic: a function of the skewness and kurtosis and for large n asympt. normal distributed

Examples

 Single variable Line chart, predefined y-scale, reference lines data Single variable Bar chart, predefined y-scale, reference lines data Single variable Bar chart stored in worksheet chart Single variable Dot plot, predefined y-scale, reference lines, statistics, outliers data chart Single variable Combined line/bar chart, predefined y-scale, reference lines,axis- and data lables, statistics, outliers data chart Multiple variables in one line chart chart Multiple variables multiple line charts above each other chart Multiple variables multiple line charts beside each other chart Multiple variables multiple bar charts above each other chart Multiple variables multiple bar charts beside each other chart

By variables
single variable
multiple variables 1
multiple variables 2