UNISTAT - the ultimate
Excel statistics add-in
Point Biserial Correlation in Excel with Unistat
The Unistat statistics add-in extends Excel with Point Biserial Correlation capabilities.
Further documentation is available at section 6.2.4 of the manual, Correlation Coefficients.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Point Biserial Correlation
| Cases | Mean | Standard Deviation | Standard Error | |
|---|---|---|---|---|
| Basal | 13 | 5.6515 | 0.4650 | 0.1290 |
| Energy | 13 | 8.0662 | 1.2381 | 0.3434 |
| Total | 26 | 6.8588 | 0.9352 | 0.1834 |
| Point Biserial Correlation | -0.7866 |
|---|---|
| 95% Confidence Interval | -0.8998 <>-0.5743 |
| t-Statistic | -6.2419 |
| Degrees of Freedom | 24.0000 |
| 1-Tail Probability | 0.0000 |