Statistical Analysis & Method Validation in ExcelThe 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.

From the Statistical Reference Guide for Analyse-it 6.24.0: https://analyse-it.com/docs/user-guide/statistical-analyses

Statistical Reference Guide v6.24.0

Administrator's Guide

User's Guide

Tutorials