- 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)
- line plot (LP)
- dot plot (DP)
- bar chart (BC)
- 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
- add reference lines (nominal, tolerances) to graph via menu
- Potential Outliers:
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.
- Jarque-Bera statistic: a function of the skewness and kurtosis and for large n asympt. normal distributed
|Single variable ||Line chart, predefined y-scale, reference lines ||data||chart ||results |
|Single variable ||Bar chart, predefined y-scale, reference lines ||data||chart |
|Single variable||Bar chart stored in worksheet ||data ||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||results|
|Multiple variables || in one line chart ||data ||chart||results|
|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|
multiple variables 1
multiple variables 2