17.1.12.1 The Partial Correlation Coefficient Dialog Box


Contents

Supporting Information

Results Log Output

Results Log Output

Select to output results to the Results Log.

Recalculate

Recalculate

Controls recalculation of analysis results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input

Variables

Specify the input data for variables of interest.

For help with range controls, see: Specifying Your Input Data

Controlling Variables

Specify the data for control variables; effects of control variables will be excluded when measuring the relationship of above variables.

Exclude Missing Values

Pairwise When computing correlation between two columns, the corresponding two entries will be excluded if there is a missing value.
Listwise Exclude the entire row for all datasets if there are any missing values.

Show Significance in Result Table

Show Significance in Result Table

In the report worksheet, Show Significance in Result Table.

Flag Significant Correlations

Flag Significant Correlations

Mark the Partial Correlation Coefficient value significant at the 0.05 level with asterisk in Result Table.

Indicate the Partial Correlation Coefficient value is significant at the 0.05 level by showing in red in the Correlations Sheet.

Output

For help with the range controls, see: Output Results

Result Table Specify target worksheet for output of report worksheet.
Correlations Sheet Specify target worksheet for output of Partial Correlation Coefficients.