Why your favorite spreadsheet software might be silently sabotaging your scientific research

When Spreadsheets Attack! · 14:30 · Video: Stand-up Maths · Watch at the source

In short: Matt Parker explores how common spreadsheet errors can compromise scientific integrity. By examining real-world cases like the Enron data and gene name misinterpretations, this video highlights the hidden risks of relying on automated formatting in research.

The video highlights the work of the European Spreadsheet Risks Interest Group, an organization dedicated to identifying and mitigating the dangers of spreadsheet errors. A primary example discussed is the prevalence of gene name errors in scientific literature, which often occur when software automatically misinterprets data formats.

Dr. Felienne Hermans is noted for her research into the Enron spreadsheets, illustrating how complex data sets can harbor significant, hidden mistakes. These examples serve as a cautionary tale for anyone using spreadsheets for serious analysis, demonstrating that even standard tools can introduce systemic inaccuracies if not carefully managed.

Opens the Intellect+ feed with this card first. Swipe up for the next one.

Sources

To cite this card, link to https://intellectplus.co.uk/app/science-when-spreadsheets-attack.

How we source, check and correct cards: Editorial standards.

General information, not professional advice. Spotted an error? Flag the card or see corrections and complaints.

Intellect Plus is a visual educational discovery platform for exploring fascinating facts and ideas. Brain Food, Not Brain Rot. What is Intellect Plus?

Related

Finding something worth knowing…