17.7.1.1 The Principal Component Analysis Dialog Box

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 in the Standard toolbar. Settings can also be changed to recalculate the result.

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.

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.

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.

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.

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.

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.