| Results Log Output |
Select to output results to the Results Log. |
|---|
| Recalculate |
Controls recalculation of analysis results
For more information, see: Recalculating Analysis Results |
|---|
| Input |
Enter your input data. For help with range controls, see: Specifying Your Input Data |
|---|
| Pearson | Compute Pearson product moment correlation coefficient. |
|---|---|
| Spearman | Compute Spearman Rank correlation coefficient. |
| Kendall | Compute Kendall correlation coefficient. |
| Scatter plots | Produce scatter plots for each pair of variables. |
|---|---|
| Add Confidence Ellipse | Plot a confidence ellipse. |
| Confidence Level for Ellipse(%) | Specify the confidence level for ellipses. |
| 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. |
For help with the range controls, see: Output Results
| Plot Data | Specify target worksheet for output of scatter/ellipse data. |
|---|---|
| Plots | Specify target report worksheet for output of scatter plots with confidence ellipse. |
| Result Table | Specify target worksheet for output of report worksheet. |
| Pearson Sheet | Specify target worksheet for output of Pearson Correlations. |
| Spearman Sheet | Specify target worksheet for output of Spearman Correlations. |
| Kendall Sheet | Specify target worksheet for output of Kendall Correlations. |
| Show Significance in Result Table |
In the report worksheet, Show Significance in Result Table. |
|---|
| Flag Significant Correlations |
Mark the Correlation Coefficient value significant at the 0.05 level with asterisk in Result Table; Highlight the Correlation Coefficient value significant at the 0.05 level with red color in Pearson/Spearman/Kendall Sheet. |
|---|