Presence/Absence coding

Why do we use presence/absence coding

In many domains, the data are available as sets of lists of attributes (a list by statistical individual). It might be a list of pharmaceutical properties for a list of plants, or a list of occurrences of species in a biotope. These lists cannot be manipulated by most statistical tools, and therefore, they first need to be transformed into a presence/absence table, where each cell has a 0 if the attribute is absent and a 1 if the attribute is present.

Presence/Absence coding in XLSTAT

Converting a table of attributes into a table of presences/absences showing the frequencies of the various elements for each of the lists has never been easier. You simply need to select the table in the XLSTAT tool for Presence/Abcense coding and the new table will be generated instantly.

Below you can find an example of presence/absence coding. Based on a table of two lists containing various elements, a presence/absence coding summarizes the presence of the elements in each list.

List 1 List 2

Table with presence and absence coding:

E1 E2 E3 E4
List 1 1 1 1 0
List 2 1 0 1 1


This analysis is available in the XLStat-Basic addin for Microsoft Excel

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