Maintenance Notice

Due to necessary scheduled maintenance, the JMIR Publications website will be unavailable from Wednesday, July 01, 2020 at 8:00 PM to 10:00 PM EST. We apologize in advance for any inconvenience this may cause you.

Who will be affected?

Previously submitted to: JMIR Medical Education (no longer under consideration since Aug 19, 2021)

Date Submitted: Aug 16, 2021
Open Peer Review Period: Aug 16, 2021 - Aug 19, 2021
(closed for review but you can still tweet)

NOTE: This is an unreviewed Preprint

Warning: This is a unreviewed preprint (What is a preprint?). Readers are warned that the document has not been peer-reviewed by expert/patient reviewers or an academic editor, may contain misleading claims, and is likely to undergo changes before final publication, if accepted, or may have been rejected/withdrawn (a note "no longer under consideration" will appear above).

Peer review me: Readers with interest and expertise are encouraged to sign up as peer-reviewer, if the paper is within an open peer-review period (in this case, a "Peer Review Me" button to sign up as reviewer is displayed above). All preprints currently open for review are listed here. Outside of the formal open peer-review period we encourage you to tweet about the preprint.

Citation: Please cite this preprint only for review purposes or for grant applications and CVs (if you are the author).

Final version: If our system detects a final peer-reviewed "version of record" (VoR) published in any journal, a link to that VoR will appear below. Readers are then encourage to cite the VoR instead of this preprint.

Settings: If you are the author, you can login and change the preprint display settings, but the preprint URL/DOI is supposed to be stable and citable, so it should not be removed once posted.

Submit: To post your own preprint, simply submit to any JMIR journal, and choose the appropriate settings to expose your submitted version as preprint.

Warning: This is an author submission that is not peer-reviewed or edited. Preprints - unless they show as "accepted" - should not be relied on to guide clinical practice or health-related behavior and should not be reported in news media as established information.

Spreadsheets as a tool for statistical calculations: suggestions for a sounder approach

  • Robert Lundqvist

ABSTRACT

In many workplaces, tables, bar charts and run charts abound. The tools used are mostly common spreadsheet systems such as Microsoft Excel. These systems are used for different kinds of tasks. They are flexible and powerful, but there are also drawbacks. Many of these lie on a general level and result mostly in waste of time and resources, but other issues can definitely result in severe errors. There are still valid reasons to use spreadsheets for statistical purposes: licenses are available at low costs and some statistical functions are present. Despite their shortcomings, spreadsheets will not be replaced in any foreseeable future. They are used both for administrative and "analytical" purposes. In research, spreadsheets are also commonly used to share data. The goal is to point at some simple routines in common spreadsheets which still are not that commonly known, specifically those called pivot tables in Microsoft Excel. Better spreadsheet skills and knowledge of how to set up pivot tables could make it possible for both experienced analysts and staff with less statistical training to make everyday basic calculations with little effort and without specialized software. Moreover, since these routines require data to be set up in way in line with how data must be organized in statistical software, future use of such systems software is simplified. Furthermore, the necessary training can be achieved with limited resources. So _everyone_ should have pivot tables as part of their everyday skills.


 Citation

Please cite as:

Lundqvist R

Spreadsheets as a tool for statistical calculations: suggestions for a sounder approach

JMIR Preprints. 16/08/2021:32945

DOI: 10.2196/preprints.32945

URL: https://preprints.jmir.org/preprint/32945

Download PDF


Request queued. Please wait while the file is being generated. It may take some time.

© The authors. All rights reserved. This is a privileged document currently under peer-review/community review (or an accepted/rejected manuscript). Authors have provided JMIR Publications with an exclusive license to publish this preprint on it's website for review and ahead-of-print citation purposes only. While the final peer-reviewed paper may be licensed under a cc-by license on publication, at this stage authors and publisher expressively prohibit redistribution of this draft paper other than for review purposes.