Zorich Consulting & Training

Statistical Application Software

Home Page

FREE STATISTICAL SOFTWARE IS AVAILABLE, BELOW We offer powerful MS Excel spreadsheets designed to simplify activities in Manufacturing, QA, & R&D.  Each commercial spreadsheet is formally validated; all of them are "GMP" and "Part 11" compliant. VALIDATION PROTOCOLS & SIGNED VALIDATION REPORTS        ARE PROVIDED FREE TO COMMERCIAL CUSTOMERS. Our Validation Protocols/Reports have successfully withstood the scrutiny of auditors from FDA, FDB, TUV, BSI, KEMA/DEKRA, & NSAI. None of the spreadsheets contain macros or other code-based add-ins.  The purchase price entitles you to make as many copies for use by as many employees on as many computers as desired, all within a single company at 3 sites (e.g., home office, a pilot plant, & a Mexican mfg. facility).                                (Click here for a list of current prices.) Our statistical clients (for seminars, consulting services, and/or software) have included many start-ups and a few major corporations, including Becton Dickinson, Boston Scientific, and Siemens.  Our spreadsheets have been purchased for use at over 60 companies in the USA, Mexico, & Mauritius.  Working "demo" copies of our validated products are available for download, below; in addition, two "freeware" programs are provided for sampling plan analysis.

About Us

Client List

Quality Systems

Seminars

NORMALITY TESTS & NORMALITY TRANSFORMATIONS        (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

New Version, December 2011 --- Provides easy-to-use ways to determine if your data is normally distributed.  If the program indicates that your data is non-normal, it provides 14 different "transformations" to normality for you to consider. The program includes 10 different "tests of normality", including Anderson-Darling's A2*, Cramer-von Mises' W2*, Shapiro-Francia's W' (a large-sample-size extension of the Wilks-Shapiro test), Watson's U2*, Gan-Koehler's K2, Skewness, Kurtosis, Kuiper's V*, Lilliefors' Kolmogorov-Smirnov D*, and Chi-square.  Histograms and probability plots (with 95% confidence intervals [ a.k.a., "prediction bands"] & correlation coefficients) are automatically generated for all 14 transformations. A formal customizable printable test report is automatically generated, including test results, raw data, and transformed data.

VARIABLES DATA SPC          (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

Updated 2012 --- XbarR, XbarS, XmR, & other types of Statistical Process Control Charts are automaticly generated, along with a histogram chart, raw-data-points chart, capability indices, and a preformatted customizable printable report.  SPC Charts automaticly identify out-of-control points.

COUNT DATA SPC         (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

P and U Statistical Process Control Charts are automaticly generated, along with a pareto chart and a preformatted customizable printable report.  SPC Charts automaticly identify out-of-control points.

RELIABILITY STATISTICS BASICS       (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

Revised & Expanded 2011 -- Calculation of component reliability using K-factors, stress/strength analysis, failure analyses, with applications for "normally distributed" data as well as data from unknown distributions.  Calculations are simplified with easy-to-use interfaces & expanded ranges of inputs, compared to tables typically available.

RELIABILITY PLOTTING       (demo file --- click the appropriate link below to start downloading          XLS format (Excel 2003 or earlier)              XLSX format (Excel 2007 or later)

Major Revision 2011--2012, with 100 additional transformation pairings. Calculation of component % reliability at a given % confidence, using "Reliability plotting", which is also known as "probability plotting", "rectification", etc.  Reliability plotting can also be used to confirm data as being "normally distributed" or can be used to identify what data transformation is needed. Mouse click the following link to read more about RELIABILITY PLOTTING.

POWER CURVES FOR T-TESTS       (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

REVISED 2010 --- Four types of power curves are provided (as opposed to the one type provided in most other stat-packages):  Power vs. Sample Size,  Power vs. Hypothesized Difference, Power vs. Alpha, and Power vs. Population Standard Deviation. Simple user interface.

STATISTICAL ANALYSIS OF GAGES        (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

Powerful tools for quantifying measurement uncertainty. Methods include Gage R&R (up to 3 persons, 3 gages, 3 replicates, and 10 parts), Gage Correlation (up to 3 gages), Gage Bias, Gage Linearity, Spec/Inaccuracy Ratios, and Guardbanding. An essential tool for setting product spec limits that take into consideration the uncertainty in the measurement process.

MDD-PLUS C=0 SAMPLING PLANS        (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

File provides sampling plans that meet the requirements of Annex IV, Section 6, of the version of the MDD that had been in place up thru 2009. File outputs the smallest sample size that has no more than a 5% chance of passing QC (as required by the MDD). Automaticly created OC curve and SampleSize vs. LotSize curve. For lot sizes up to 10,000.

C=0 ATTRIBUTE SAMPLING PLANS       (demo file --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

File outputs include two different types of OC curves, and the AOQL for the chosen plan. Instead of relying on a sample-size table, this program calculates the exact absolute smallest sample size that gives the desired protection level for a given exact size lot.  For lot sizes up to 1000, only.

SELF-MADE SAMPLING PLANS       (FREE-ware --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

Examine OC curves for your own custom sampling plans. Use either binomial or hypergeometric calculations.  Now be able to explain the "valid statistical rationale" of sampling plans you already use.

SEQUENTIAL SAMPLING PLAN ANALYSIS        (FREE-ware --- click the appropriate link below to start downloading)           XLS format (Excel 2003 or earlier)           XLSX format (Excel 2007 or later)

Provides an analysis & planning tool for sample sizes in situations where lots undergo sequential inspections (e.g., 1st by Manufacturing, 2nd by QC, & finally by QA).

FREE, STATISTICS-RELATED ARTICLES by John Zorich  (mouse-click title to download):     Reasonable Confidence Limits for Binomial Proportions (2010 in MD&DI Magazine)     This article introduces a new type of confidence interval for proportions (or percentages);     the new interval is called a "Reasonable Confidence Interval".     The Pre-history of Probability (2000 seminar given to the local ASQ Statistics Group)