Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Tutorials

Correlation / PCA tutorial

Learn how to visualize the relationships between the variables and the similarities between observations.

To illustrate the concepts, we will use data from a New York magazine article that examines the most livable neighborhoods in New York. In the original article, written by Nate Silver, neighborhoods were scored using 12 factors. Then, the scores for each factor were combined into an overall score and ranking for each neighborhood. For more information, see NY magazine story “ The Most Livable Neighborhoods in New York”and Junk Charts story “ The scatter plot matrix: a great tool”.

If you prefer you can watch a video of this tutorial.

In this tutorial you will perform the following tasks:

  1. Understanding the relationship between variables
  2. Reducing the dimensionality of the data
  3. Understanding the relationship between variables (revisited)
  4. Understanding the similarities between observations
  5. Grouping the observations
  6. Adding additional variables
  7. Adding additional observations
  8. Publishing the plot

  •  Tutorials
  •  Distribution tutorial
  •  Correlation / PCA tutorial
  •  Understanding the relationship between variables
  •  Reducing the dimensionality of the data
  •  Understanding the relationship between variables (revisited)
  •  Understanding the similarities between observations
  •  Grouping the observations
  •  Adding additional variables
  •  Adding additional observations
  •  Publishing the plot
  •  Compare groups means tutorial
  •  Association in 2-way contingency tables tutorial
  •  Simple linear regression tutorial
  •  Bland-Altman method comparison tutorial
  •  Estimating the precision of a measurement procedure (CLSI EP05-A3)
  •  Evaluating the linearity of a measurement procedure (CLSI EP06-A)
  •  Verifying the precision of a measurement procedure against a performance claim and estimating the bias (CLSI EP15-A3)
  •  Pareto charts tutorial
  •  Process control charts tutorial
  •  Process capability tutorial



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.