ProControl® - Applied Statistics for Laboratories and Industry

Navigation:

ProControl^® 6.3

Applied Statistics in Excel for Laboratories and Industry

in Deutsch:en Español:Validation, Calibration, Spiking, Uncertainty in Measurements, Trend Analysis, Trend Forecast, Uncertainty in Forecast , Stability, Shelf Life, Maintenance

Version 6.3 provides a ProControl "Ribbon-Bar"
Evaluation at one click - at once

ProControl-AtOnce: 5 control buttons (main group) guide to the results!

Have an inside look to ProControl^® 6.3 !
Just order the trial version Limited Edition, NOW for free!
For a 14 days trial period you have all functions & features available to evaluate your data!
All you need to do is: Send us your Online-request, just applying our ordering form!

Functions and Command Bars - ProControl^®AtOnce

Ribbon-Bar Excel 14.0 (12.0/ 16.0/ 15.0)

ProControl^®-AtOnce Menu-Controls
A click on the picture opens the screenshot in a new browser tab.

Quick-Access Menu - Excel since Version 12.0

Views - 1^st Group of Icons
Unhide/Hide results of measurements in replicates - Characteristics and statistical comparison tests

All results for values in columns - All results in lines and cells of the 'ProControl-evaluation sheet'
Characteristics - Number of values, arithmetical mean and standard deviation of each series of replicates
IRE - Interval of random error - critical limits of normal distributed measured values
CI - Confidence interval of the mean values μ of replicates - critical limits of arithmetical mean values as characteristics
CI - Confidence interval of the standard deviation σ - critical limits of standard deviations as characteristics
Outlier tests - Grubbs'-test, test of the kurtosis
F-test array - testing variances of two data series, any pair of series is tested
t-test array - testing mean values of two data series, applies for both homogeneous and inhomogeneous variances

Evaluations and Functions - 2^nd Group of Icons (Main Group)

Five main command buttons instantly guide you through evaluations and to the results.

Testing the standard normal distribution - sample values assorted and displayed as normal probability plot
Outlier tests - macro controlled searching and marking of outliers (P=99%, α=1%)
ANOVA - Analysis of variances - macro controlled searching and marking of inhomogeneous data series
Regression - Calibrations 1. / 2. Order., strictly accord. to DIN 32 645 / ISO 8466
- Regression outliers according to DEV

Regression-AtOnce - 1^st- 4^th Order / Weighting
- Calibration-AtOnce
  - Characteristics, charts, ISO/DIN compliant , mathematically accurately determined
  - Analytical results including uncertainty of measurement
  - even valid for standard addition including uncertainty of measurement
  - with a special Command Bar for user control in each sheet of the Add-On.
- Trend-AtOnce: Trend Analysis & Predictions, Uncertainty included, i.e. a real risk based approach
  - Evaluate stability to be guaranteed: expected minimum-, mean- and maximum time to run beyond specified limits of measurements
  - evaluate specification limits to be guaranteed: suitable and valid specifications that meet one's approval for the required stability period (minimum, mean, maximum) at a well defined acceptable risk for each party involved - that's what we call risk based approach
  - with a special Command Bar for user control in each sheet of the Add-On.

Views - Overall Statistics - 3^rd Group of Icons
Unhide-/Hide of Results in Summary.

Proved Results of Measurements as grouped
Proved Characteristics of Repeatability and Reproducibility.

Statistical process control - Characteristics of Control Charts, action limits-, warning limits to be displayed

Control Charts - Charts acc. to Shewhart, approval charts, capability studies
- x,MR(2)-Charts - Measurements and Moving Ranges
  applies to single measurements - individuals or mean as well - as any further information to precision characteristics is not available
- x,s-Charts - Means and standard deviations
  apply to measurements' replicates which include precision data
  - With a special Command Bar for user control in each sheet of the Add-On, which dynamically meets the current evaluation mode
  - evaluation mode, example 1:
  - evaluation mode, example 2:

Characteristics (Overall) - collaboratory studies accord. to ISO 5725 - Statistics applies to all pooled data considered as homogeneous population
An Add-On suitable for interlaboratory studies or proficiency testing according to AOAC, ICUMSA, CIPAC, IUPAC & ISO 5725 is available at request.
Bartlett-test & ANOVA (simple analysis of variance) - Homogeneity of variances & mean values for pooled data at current grouping, preliminary study introducing Control Charts

Controls and Settings - 4^th Group of Icons

Significance level to change - error level, significance: default α=1%, button pressed sets α=5%, free option to set 0 < α < 1 except for outlier testing
Columns L-O unhide - default 10 columns' display to be extended to 14 (35 ProControl-plus)
Exit ProControl - exit the ProControl application, closing ProControl control bar and worksheets and restore previous user's settings for Excel application.

Your contact for ProControl^®: Dr. Stefan Schömer