UNISTAT - the ultimate
Excel statistics add-in
Sample Size and Power Estimation: Correlation in Excel with Unistat
The Unistat statistics add-in extends Excel with Sample Size and Power Estimation: Correlation capabilities.
Further documentation is available at section 6.7.4 of the manual, Sample Size and Power > Correlation.
Sample output
Here we provide annotated example report 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 |