Computing biserial correlations with XLSTAT

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 specie. We want to use the biserial correlation to check whether there is an association between the concentration and the specie. 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


About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey


Like us on Facebook Facebook

Get in Touch

  • Email:
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414