Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Statistical Reference Guide
  • Reference interval

Transforming the reference distribution

Transform the reference values to achieve a normal distribution.

You must have already completed the task:
  • Estimating a reference limit or interval

You should transform the data when the distribution does not match the assumptions of the quantile estimator. If you cannot transform the distribution to meet the assumptions of the estimator you should consider using another estimator.

  1. Activate the analysis report worksheet.
  2. On the Analyse-it ribbon tab, in the Reference interval group, click Transform, and then click the transformation.
    The analysis task pane Transform panel opens.
  3. Set the transform parameters:
    • If the transform is the logarithm, in the Base edit box, type the base of the logarithm or enter - for the natural logarithm.
    • If the transform is Box-Cox, in Shift and Lambda edit boxes, type the parameters, or to estimate them from the data, click Estimate unknown parameter.
    • If the transform is exponential, in the Gamma edit box, type parameter.
    • If the transform is 2-stage exponential/modulus, in the Gamma and Kappa edit boxes, type parameters.
  4. Click Recalculate.
Available in Analyse-it Editions
Method Validation edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Reference limits
  •  Estimating a reference limit or interval
  •  Histogram
  •  Box plot
  •  Normal probability (Q-Q) plot
  •  Testing the normality of a reference distribution
  •  Transforming the reference distribution
  •  Transferring reference limits
  •  Study design
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



Version 6.15
Published 18-Apr-2023
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy
Copyright 2026 Analyse-it Software, Ltd.
Statistical analysis and method validation software for Microsoft Excel.
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.