Re:The Norway Problem
by mattkrause on Saturday April 03, 2021 @09:56AM
(#26681062)
The analysis itself isn’t (usually) happening in Excel.
A lot of tools operate on CSV files. People use Excel to peek at the results or prepare input for other tools, and that’s how the date coercion slips in.
Sometimes, people do use it to collate the results of small manual experiments, where a database might be overkill. Even so, the data is usually analyzed elsewhere (R, graphPad, etc).
Re:The Norway Problem
by imtringued on Sunday April 04, 2021 @01:24PM
(#26691249)
>A lot of tools operate on CSV files.
The mistake was to believe that Excel can operate on CSV files. It doesn't support them in any meaningful way. It supports them in a "I can sort of pretend that I support CSV files" way.
What is a good alternative to working with CSV files than Excel? Excel sure isn't ideal but it's always there as part of the MS Office suite, so I've never looked for anything esle.
Re:The Norway Problem
by BlueTemplar on Sunday April 04, 2021 @09:24AM
(#26689216)
And yet, we are still being taught to use an Excel (2003) spreadsheet for data analysis... (Because that's what most businesses are still using !)
No one in their right mind uses a spreadsheet for data analysis. Good for working out your ideas but not in a production environment. I figure excel was chosen as this the utility the scientists were most familiar with.
The proper tool for the job would be a database. I recall reading about a utility, a highly customized database with an interface that looks just like a spreadsheet.