Reference Value Advisor: a new freeware set of macroinstructions to calculate reference intervals with Microsoft Excel


A. Geffré, Department of Clinical Sciences, Ecole Nationale Vétérinaire, 23 Chemin des Capelles, 31076 Toulouse Cedex 3, France


Abstract: International recommendations for determination of reference intervals have been recently updated, especially for small reference sample groups, and use of the robust method and Box–Cox transformation is now recommended. Unfortunately, these methods are not included in most software programs used for data analysis by clinical laboratories. We have created a set of macroinstructions, named Reference Value Advisor, for use in Microsoft Excel to calculate reference limits applying different methods. For any series of data, Reference Value Advisor calculates reference limits (with 90% confidence intervals [CI]) using a nonparametric method when n≥40 and by parametric and robust methods from native and Box–Cox transformed values; tests normality of distributions using the Anderson–Darling test and outliers using Tukey and Dixon–Reed tests; displays the distribution of values in dot plots and histograms and constructs QQ plots for visual inspection of normality; and provides minimal guidelines in the form of comments based on international recommendations. The critical steps in determination of reference intervals are correct selection of as many reference individuals as possible and analysis of specimens in controlled preanalytical and analytical conditions. Computing tools cannot compensate for flaws in selection and size of the reference sample group and handling and analysis of samples. However, if those steps are performed properly, Reference Value Advisor, available as freeware at, permits rapid assessment and comparison of results calculated using different methods, including currently unavailable methods. This allows for selection of the most appropriate method, especially as the program provides the CI of limits. It should be useful in veterinary clinical pathology when only small reference sample groups are available.