17.7.1.1 The Principal Component Analysis Dialog Box

Video Image.png See more related video:Principal Component Analysis


Recalculate

Specify the way to recalculate and update the result if there is any change in the input data or settings.

None The output will not be connected to the source data, and any change will not result in an update of the result. Also, settings can not be changed to recalculate the result.
Auto The result automatically updates when source data changes. Settings can be changed to recalculate the result.
Manual The result will not automatically update when source data changes. You must manually activate the update by clicking the Recalculate button Button Recalculate Manual.png in the Standard toolbar. Settings can also be changed to recalculate the result.

Input

Select data for the Principal Component Analysis.

Independent Variables Select data to specify the independent variables. Data in each column corresponds to a variable and each row to an observation.
Observation Labels Select data to specify label for observation, the labels will be show in the Score Plots and Biplots in result. Note that the label column will be set as categorical if Text column.

Settings

Specify the settings in the Principal Component Analysis.

Analyze Select the matrix type to analyze for Principal Component Analysis.
  • Correlation
    Use correlation matrix to analyze for Principal Component Analysis.
  • Covariance
    Use covariance matrix to analyze for Principal Component Analysis.
Number of Components to Extract Specify the number of principal components to extract. This should be between 1 and the number of variables.
Standardize Scores Determine whether to standardize scores. For listwise exclusion of missing values, scores will be standardized as unit variance. For pairwise exclusion, scores will be scaled by the square root of the eigenvalue. Scores data in Score Plot and Biplot will be standardized if Standardize Scores is checked.
Excluding Missing Values Specify the way to exclude missing values for analysis.
  • Listwise
    An observation containing one or more missing values will be excluded in the analysis.
  • Pairwise
    An observation is excluded only in the calculation of covariance or correlation between two variables if missing values exist in either of the two variables for the observation.

Descriptive Statistics

Specify whether to perform basic statistics for input data.

Simple Descriptive Statistics Specify whether to perform simple statistics on input data including the mean, standard deviation and number of observations in the analysis for each variable.
Correlation Matrix Specify whether to calculate correlation matrix. Note that the method to calculate the correlation matrix depends on the method chosen for Exclude Missing Values.

Quantities to Compute

Specify results to calculate in the Principal Component Analysis.

Eigenvalues Specify whether to output eigenvalues including the proportion and the cumulative proportion. And Bartlett's Test result is shown when the analysis matrix is covariance matrix.
Eigenvectors Specify whether to output eigenvectors for specified principal components by Number of Components to Extract.
Scores Specify whether to output scores for specified principal components by Number of Components to Extract. Note that it will be checked and disabled when Score Plot or Biplot is checked in the Plots group.

Plots

Specify whether to show plots in the Principal Component Analysis.

Scree Plot Specify whether to show the Scree Plot for eigenvalues.
Component Plot Specify whether to show 2D or 3D plots for principal components.
  • Component Plot Type
    Specify to plot a 2D or 3D components plot
  • Select Principal Components to Plot
    • Principal Component for X/Y/Z Axis
      Specify the principal component for the X/Y/Z axis in component plots.
  • Loading Plot
    Specify whether to show the Loading Plot for eigenvectors.
  • Score Plot
    Specify whether to show the Score Plot for scores.
  • Biplot
    Specify whether to show the Biplot for eigenvectors and scores.

Output

Specify the destination of output results for the Principal Component Analysis.

PCA Report Specify the sheet for the Principal Component Analysis report. The default value is a new sheet in the workbook of input data.
Score Data Specify the sheet for scores. The default value is a new sheet in the workbook of input data. Note that it will be disabled if Scores is unchecked in the Quantities to Compute group.