Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Principal component analysis (PCA)

Calculating principal components

Reduce the dimensionality of multidimensional data using PCA.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Multivariate, and then click Principal Components.
    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 a plot of the cumulative variance explained by each principal component, select the Scree plot check box.
  6. Click Calculate.
  7. To save the computed principal component scores back to the dataset for further analysis, on the Analyse-it ribbon tab, click Save Variable > Scores and select the number of dimensions to store.
Related concepts
Principal components
Scree plot
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
  •  Principal component analysis (PCA)
  •  Principal components
  •  Scree plot
  •  Calculating principal components
  •  Biplot
  •  Monoplot
  •  Creating a biplot
  •  Creating a correlation monoplot
  •  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.