liu.seSearch for publications in DiVA
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • oxford
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Resampling methods in Microsoft Excel (R) for estimating reference intervals
Linköping University, Department of Clinical and Experimental Medicine, Division of Microbiology and Molecular Medicine. Linköping University, Faculty of Medicine and Health Sciences. Region Östergötland, Center for Diagnostics, Department of Clinical Chemistry.
2015 (English)In: Biochemia Medica, ISSN 1330-0962, E-ISSN 1846-7482, Vol. 25, no 3, 311-319 p.Article in journal (Refereed) Published
Abstract [en]

Computer-intensive resampling/bootstrap methods are feasible when calculating reference intervals from non-Gaussian or small reference samples. Microsoft Excel(R) in version 2010 or later includes natural functions, which lend themselves well to this purpose including recommended interpolation procedures for estimating 2.5 and 97.5 percentiles. The purpose of this paper is to introduce the reader to resampling estimation techniques in general and in using Microsoft Excel(R) 2010 for the purpose of estimating reference intervals in particular. Parametric methods are preferable to resampling methods when the distributions of observations in the reference samples is Gaussian or can transformed to that distribution even when the number of reference samples is less than 120. Resampling methods are appropriate when the distribution of data from the reference samples is non-Gaussian and in case the number of reference individuals and corresponding samples are in the order of 40. At least 500-1000 random samples with replacement should be taken from the results of measurement of the reference samples.

Place, publisher, year, edition, pages
CROATIAN SOC MEDICAL BIOCHEMISTS , 2015. Vol. 25, no 3, 311-319 p.
Keyword [en]
reference interval; resampling method; Microsoft Excel; bootstrap method; biostatistics
National Category
Probability Theory and Statistics
Identifiers
URN: urn:nbn:se:liu:diva-122546DOI: 10.11613/BM.2015.031ISI: 000362855400001OAI: oai:DiVA.org:liu-122546DiVA: diva2:867833
Available from: 2015-11-06 Created: 2015-11-06 Last updated: 2017-12-01

Open Access in DiVA

fulltext(502 kB)204 downloads
File information
File name FULLTEXT01.pdfFile size 502 kBChecksum SHA-512
4faf7aad8fd56f55a5ebf9501893354b272000db8404fc7ba77d41e93d439de6d5db88944e41ee0718ba3166437aad59af963c87821aa5946e0c99f757ccf917
Type fulltextMimetype application/pdf

Other links

Publisher's full text

Authority records BETA

Theodorsson, Elvar

Search in DiVA

By author/editor
Theodorsson, Elvar
By organisation
Division of Microbiology and Molecular MedicineFaculty of Medicine and Health SciencesDepartment of Clinical Chemistry
In the same journal
Biochemia Medica
Probability Theory and Statistics

Search outside of DiVA

GoogleGoogle Scholar
Total: 204 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

doi
urn-nbn

Altmetric score

doi
urn-nbn
Total: 258 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • oxford
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf