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

Calculating a correlation matrix

Measure the correlation / association between 2 or more variables.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Correlation or Multivariate, and then click the statistics to show:
    Option Description
    Correlation Matrix Show the product-moment correlation coefficients.
    Rank Correlation Matrix Show the rank correlation coefficients.
    The analysis task pane opens.
  3. In the Variables list, select the variables.
  4. Optional: To highlight the coefficients depending on their sign and magnitude, select the Color maps check box.
  5. Optional: To show univariate descriptive statistics for each variable, select the Descriptives for each variable check box.
  6. Click Calculate.
Related concepts
Correlation coefficient
Color map
Related reference
Dataset layout
Available in Analyse-it Editions
Standard edition
Method Validation edition
Quality Control & Improvement 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
  •  Scatter plot
  •  Creating a scatter plot or scatter plot matrix
  •  Covariance
  •  Correlation coefficient
  •  Color map
  •  Calculating a correlation matrix
  •  Calculating a covariance matrix
  •  Inferences about association
  •  Study design
  •  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
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

Get Started

  • Download free trial
  • Sign In

© 2026 Analyse-it® Software, Ltd. All rights reserved.

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.