Two Correlations in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Two Correlations capabilities.
For further information visit UNISTAT User's Guide section 6.7.5. Two Correlations.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Sample Size and Power Estimation: Two Correlations
Sample Size
| Correlation Coefficient 1 | 0.7500 |
|---|---|
| Correlation Coefficient 2 | 0.9000 |
| Power of the Test | 0.9000 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| N1 Given (Optional) | 0.0000 |
| Estimated Sample Size | 87.3073 |
Sample Size and Power Estimation: Two Correlations
Power of the Test
| Sample Size 1 | 95.0000 |
|---|---|
| Sample Size 2 | 98.0000 |
| Correlation Coefficient 1 | 0.8400 |
| Correlation Coefficient 2 | 0.7800 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Power of the Test | |
| Z-Statistic | -0.7581 |
| 2-Tail Probability | 0.2242 |