Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Reference interval

Estimating a reference limit or interval

Estimate the reference limit or reference interval using a quantile estimator.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Diagnostic, and then under the Reference Interval heading, click the estimator.
    The analysis task pane opens.
  3. In the Y drop-down list, select the variable.
  4. In the Type drop-down list, select:
    Option Description
    Reference interval Estimate lower and upper reference limits that a stated proportion of values are between.
    Reference limit Estimate a single reference limit that a stated proportion of values are less than.
  5. In the Proportion inside interval/Proportion less than edit box, type the reference level as a percentage.
  6. In the Method drop-down list, select the computation method.
  7. In the Confidence interval edit box, type the confidence level as a percentage, or type - to suppress the confidence interval, and then in the drop-down list, select the confidence bounds.
  8. Optional: To split the reference values by factors such as gender or age:
    1. On the Analyse-it ribbon tab, in the Reference Interval group, click Partition
    2. In the Factors list, select the factor variables.
    3. In the Partitions list, select a partition.

      The tasks change to the analysis options for that partition.

    4. Optional: By default, the analysis options are the same for each partition, set the specific analysis options for the partition as required.
    5. Repeat steps 8.c through 8.d for each partition.
  9. Click Calculate.
Related concepts
Reference limits
Related tasks
Transforming the reference distribution
Testing the normality of a reference distribution
Related reference
Dataset layout
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
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.