UNISTAT - the ultimate
Excel statistics add-in
Pearson Correlation in Excel with Unistat
The Unistat statistics add-in extends Excel with Pearson Correlation capabilities.
Further documentation is available at section 6.2.1 of the manual, Correlation Coefficients.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Pearson Correlation
For Introversion and Attitude
| Pearson Correlation | 0.8185 |
|---|---|
| 95% Confidence Interval | 0.3897 <> 0.9556 |
| t-Statistic | 4.0294 |
| Degrees of Freedom | 8.0000 |
| 1-Tail Probability | 0.0019 |
For Introversion and Score
| Pearson Correlation | 0.0000 |
|---|---|
| 95% Confidence Interval | -0.6296 <> 0.6296 |
| t-Statistic | 0.0000 |
| Degrees of Freedom | 8.0000 |
| 1-Tail Probability | 0.5000 |
For Attitude and Score
| Pearson Correlation | 0.1178 |
|---|---|
| 95% Confidence Interval | -0.5528 <> 0.6958 |
| t-Statistic | 0.3355 |
| Degrees of Freedom | 8.0000 |
| 1-Tail Probability | 0.3730 |