Re: [Wiki-research-l] Spreadsheet autoformatting errors, MRIs, and more reasons for open research

I found the first one (Excel errors) very interesting, in particular, because much of the coverage highlighted that a spreadsheet application is the wrong tool and that researchers should ditch it in favor of R or Python. This makes sense. However, it is rarely as easy as that much repeated sentence makes it sound. There are reasons why scientists use spreadsheets, and they may be ignored. Some ideas: - Excel is well known. An unfamiliar tool may do even more damage. - Import and Export are rather easy (preview) in in Excel or Calc. This concerns usecases like cleaning data, sharing data, quickly eyeballing… - Along the lines: Eyeballing! An underestimated topic said Tuckey, too, quite a while ago! (Exploratory Statistics). If you know the syntax, you can easily create diagrams in R. But a GUI is easier and quicker to use and leads probably to fewer errors. Totally absent from (most) statistical packages is conditional highlighting of cells. All in all: Exploratory statistics are important but much undeserved by (open source) software. In my opinion, yes, let's ditch Spreadsheets! But only after we can support the needs that is satisfies. Jan PS.: Some years ago, I did some minor qualitative research on use of statistical programs. If there is interest, I dig it up again. PPS.: For the eyeballing, Polestar is great ( https://github.com/vega/polestar ) and open source. 2016-08-28 21:02 GMT+02:00 Pine W <wiki.pine(a)gmail.com>om>: -- Jan Dittrich UX Design/ User Research Wikimedia Deutschland e.V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 http://wikimedia.de Imagine a world, in which every single human being can freely share in the sum of all knowledge. That‘s our commitment. Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207.