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
   - add reference lines (nominal, tolerances) to graph 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
datachart
results
Single variable
Bar chart, predefined y-scale, reference lines
datachart
 
Single variable Bar chart stored in worksheet 
data
chart 
Single variable
Dot plot, predefined y-scale, reference lines, statistics, outliers
datachart 
Single variable
Combined line/bar chart, predefined y-scale, reference lines,axis- and data lables, statistics, outliers datachart 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 

                                                                                                                               
   
 
  By variables
         single variable
         multiple variables 1
         multiple variables 2