Correlation in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Correlation capabilities.
For further information visit UNISTAT User's Guide section 6.7.4. Correlation.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Sample Size and Power Estimation: Correlation
Sample Size
| Correlation Coefficient | 0.5000 |
|---|---|
| Power of the Test | 0.9900 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Estimated Sample Size | 63.8890 |
Sample Size and Power Estimation: Correlation
Power of the Test
| Sample Size | 12.0000 |
|---|---|
| Correlation Coefficient | 0.8660 |
| Confidence Level | 0.9500 |
| 1 or 2 Tailed Test | 2.0000 |
| Power of the Test | |
| Z-Statistic | 1.9813 |
| 2-Tail Probability | 0.9762 |