Statistics add-in software for statistical analysis in Excel

Statistical Reference Guide

The statistical reference guide describes the statistical procedures available in Analyse-it.

  • Distribution
    Distribution analysis describes the distribution of a variable and makes inferences about population parameters.
  • Compare groups
    Compare Groups examines independent samples and makes inferences about the differences between them.
  • Compare pairs
    Compare Pairs examines related samples and makes inferences about the differences between them.
  • Contingency tables
    Contingency analysis describes and visualizes the distribution of categorical variables, and makes inferences about the equality of proportions, independence of the variables, or agreement between variables.
  • Correlation and association
    Correlation analysis explores the association between two or more variables and makes inferences about the strength of the relationship.
  • Principal component analysis (PCA)
    Principal component analysis (PCA) reduces the dimensionality of a dataset with a large number of interrelated variables while retaining as much of the variation in the dataset as possible.
  • Factor analysis (FA)
    Factor analysis (FA) explores the underlying factors (latent variables) among a large number of interrelated variables.
  • Item reliability
    Item reliability is the consistency of a set of items (variables); that is to what extent they measure the same thing. When a set of items are consistent, they can make a measurement scale such as a sum scale.
  • Fit model
    Fit model describes the relationship between a response variable and one or more predictor variables.
  • Method comparison / Agreement
    Method comparison measures the closeness of agreement between the measured values of two methods.
  • Measurement systems analysis (MSA)
    Measurement systems analysis is the study of a measurement system to ensure it can meet requirements.
  • Reference interval
    A reference interval (sometimes called a reference range or normal range) describes the range of values of a measured quantity in healthy individuals.
  • Diagnostic performance
    Diagnostic performance evaluates the ability of a qualitative or quantitative test to discriminate between two subclasses of subjects.
  • Survival/Reliability
    Survival/reliability analyzes the time until an event of interest occurs.
  • Control charts
    Control charts determine if a process is in a state of statistical control.
  • Process capability
    Capability analysis measures the ability of a process to meet specifications when the process is in statistical control.
  • Pareto analysis
    Pareto analysis identifies the most important quality-related problems to resolve in a process.
  • Study Designs
    List of study design requirement and dataset layout for each analysis type.

  •  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
  •  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.