Your data analysis solution

Biserial correlations tutorial in Excel

2017-03-03
This tutorial shows how to compute a biserial correlation coefficient between a quantitative variable and a binary variable in Excel using XLSTAT.

Dataset to compute biserial correlations

An Excel sheet with both the data and the results can be downloaded by clicking here.

The data used in this tutorial correspond to concentrations of a particular molecule measured in blood samples of 30 mice, split into two different groups depending on their species. We want to use the biserial correlation to check whether there is an association between the concentration and the species. The biserial correlation requires that we have one binary variable and one continuous variable. The variance is assumed to be the same whatever the group to which an observation belongs. The biserial correlation is useful to evaluate the degree of association between a binary (or dichotomous) variable and a continuous variable. Its values range between -1 and 1. 0 corresponds to no association.

 

Setting up a biserial correlations analysis

Once XLSTAT-Pro is activated, select the Describing data / Biserial correlation, or click on the corresponding button of the Describing data toolbar.

 menu biserial correlation

Once you have clicked on the button, the dialog box appears.

 dialog box biserial correlation

Select the data on the Excel sheet. In the options tab we choose to test whether the biserial correlation is different from 0 or not using the Monte Carlo method.

 dialog box biserial correlation options

After you have clicked on the OK button, the computations start and the results are displayed.

Interpreting the results of a biserial correlation analysis

The first table corresponds to basic summary statistics for the various input variables. Then, a table displays the results including the biserial correlation and p-value of the test. We can see here that the correlation is close to zero (0.19) and not significantly different from 0 as the p-value is greater than 0.05.

 results biserial correlation test

The biserial correlation can also be computed using the spreadsheet formula XLSTAT_Biserial. The example below shows you how to use it to obtain the biserial correlation coefficient or the corresponding p-value (the example uses the p-value based on the large sample approximation, which is why it is not the same value as above)

 results biserial correlation sheet

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283