Reference Value Advisor is a set of macroinstructions for Excel that compute reference intervals using the standard and robust methods with and without generalized Box-Cox data transformation. It also allows to study the effect of continuous covariates on reference intervals.
It can be freely used.
- For any series of data presented in an Excel column, the software:
- computes the limits by the nonparametric method (when n≥40), and by parametric and robust method from native and generalized Box-Cox transformed values;
- when possible, gives the 90% confidence interval for the two limits. These intervals quantify the imprecision of the reference interval limits;
- tests the normality of distributions according to Anderson-Darling
- tests the symmetry of distributions required by the robust method
- detects possible outliers according to Tukey and to Dixon-Reed tests;
- shows the distribution of values (dot-plot and histograms) and QQ plots for visual inspection;
- gives some observations according to EP28
A reference interval can change with covariates (age, weight,…) leading to a reference interval to each value of the covariates (reference bands) instead of a single reference interval.
The software computes:
- parametric reference bands for continuous covariates
— with and without Box-Cox transformation
— for homoscedastic and heteroscedastic models (the length of the reference interval is free to change with the covariates),
- the confidence intervals for these bands
- provide a test for the usefulness of the Box-Cox transformation,
- a graphical validation of the building of such bands
- nonparametric reference bands for a single covariate (experimental).
If you used this software for your article, do not hesitate to cite the companion paper :
Geffré A, Concordet D, Braun JP, Trumel C.
Reference Value Advisor: a new freeware set of macroinstructions to calculate reference intervals with Microsoft Excel, Vet Clin Pathol. 2011 40(1) 107-112. file available here
Reference Value Advisor V 2.1 is fully compatible with Office 2010 and 2013.
Reference Value Advisor V 2.1 is composed of six files:
- A pdf file entitled “Installation Guide” that contains an explanation of the procedure to install the macro. Please, read it carefully.
- a pdf file “Reference guide for RefValAdv” explains how to interpret the results given by the macro.
- the Excel file “RefValAdvV21” contains all the macros
- Example is an example Excel file
- Licence is an ASCII file containing the licence.
- Corrected bugs is an ASCII file containing the corrected bugs.
These six files are zipped in a single file.
Last upgrade: december 9th 2015