Re:Don't use Excel for data analysis
by bradreaves2 on Saturday July 13, 2024 @08:48AM
(#40953797)
OP is citing a post about genomics research data sharing, where they have identifiers that are exceptionally vulnerable to Excel’s date inference and conversion algorithm.
OP’s post is probably still a good idea for researchers, where something like SPSS offers better protection for datasets, albeit with a higher learning curve.
For the rest of us, so long as we pay attention, Excel is an incredibly underrated analysis approach.
The problem is so bad in the discipline they changed how they name things: https://www.theverge.com/2020/8/6/21355674/human-genes-renam...
OP’s post is probably still a good idea for researchers, where something like SPSS offers better protection for datasets, albeit with a higher learning curve.
For the rest of us, so long as we pay attention, Excel is an incredibly underrated analysis approach.