• 文献检索
  • 文档翻译
  • 深度研究
  • 学术资讯
  • Suppr Zotero 插件Zotero 插件
  • 邀请有礼
  • 套餐&价格
  • 历史记录
应用&插件
Suppr Zotero 插件Zotero 插件浏览器插件Mac 客户端Windows 客户端微信小程序
定价
高级版会员购买积分包购买API积分包
服务
文献检索文档翻译深度研究API 文档MCP 服务
关于我们
关于 Suppr公司介绍联系我们用户协议隐私条款
关注我们

Suppr 超能文献

核心技术专利:CN118964589B侵权必究
粤ICP备2023148730 号-1Suppr @ 2026

文献检索

告别复杂PubMed语法,用中文像聊天一样搜索,搜遍4000万医学文献。AI智能推荐,让科研检索更轻松。

立即免费搜索

文件翻译

保留排版,准确专业,支持PDF/Word/PPT等文件格式,支持 12+语言互译。

免费翻译文档

深度研究

AI帮你快速写综述,25分钟生成高质量综述,智能提取关键信息,辅助科研写作。

立即免费体验

用于估计参考区间的Microsoft Excel®中的重采样方法。

Resampling methods in Microsoft Excel® for estimating reference intervals.

作者信息

Theodorsson Elvar

机构信息

Department of Clinical Chemistry and Department of Clinical and Experimental Medicine, Linköping University, Linköping, Sweden.

出版信息

Biochem Med (Zagreb). 2015 Oct 15;25(3):311-9. doi: 10.11613/BM.2015.031. eCollection 2015.

DOI:10.11613/BM.2015.031
PMID:26527366
原文链接:https://pmc.ncbi.nlm.nih.gov/articles/PMC4622197/
Abstract

Computer-intensive resampling/bootstrap methods are feasible when calculating reference intervals from non-Gaussian or small reference samples. Microsoft Excel® 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® 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.

摘要

当从非高斯分布或小样本参考样本计算参考区间时,计算机密集型重采样/自助法是可行的。2010版或更高版本的Microsoft Excel®包含一些自然函数,非常适合用于此目的,包括用于估计第2.5和第97.5百分位数的推荐插值程序。本文的目的是向读者介绍一般的重采样估计技术,特别是介绍如何使用Microsoft Excel® 2010来估计参考区间。当参考样本中的观测值分布为高斯分布,或者即使参考样本数量少于120时也可以转换为该分布时,参数方法比重采样方法更可取。当参考样本的数据分布为非高斯分布,且参考个体和相应样本数量约为40时,重采样方法是合适的。应从参考样本的测量结果中至少抽取500 - 1000个有放回的随机样本。

https://cdn.ncbi.nlm.nih.gov/pmc/blobs/ab61/4622197/37615eb9440e/bm-25-311-f3.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/ab61/4622197/a978667bfda1/bm-25-311-f1.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/ab61/4622197/270e4d9afdc6/bm-25-311-f2.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/ab61/4622197/37615eb9440e/bm-25-311-f3.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/ab61/4622197/a978667bfda1/bm-25-311-f1.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/ab61/4622197/270e4d9afdc6/bm-25-311-f2.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/ab61/4622197/37615eb9440e/bm-25-311-f3.jpg

相似文献

1
Resampling methods in Microsoft Excel® for estimating reference intervals.用于估计参考区间的Microsoft Excel®中的重采样方法。
Biochem Med (Zagreb). 2015 Oct 15;25(3):311-9. doi: 10.11613/BM.2015.031. eCollection 2015.
2
Valid analytical performance specifications for combined analytical bias and imprecision for the use of common reference intervals.使用通用参考区间时,合并分析偏倚和不精密度的有效分析性能规范。
Ann Clin Biochem. 2018 Sep;55(5):612-615. doi: 10.1177/0004563217752963. Epub 2018 Jan 30.
3
Reference Value Advisor: a new freeware set of macroinstructions to calculate reference intervals with Microsoft Excel.参考值顾问:一套新的免费宏指令集,用于使用Microsoft Excel计算参考区间。
Vet Clin Pathol. 2011 Mar;40(1):107-12. doi: 10.1111/j.1939-165X.2011.00287.x. Epub 2011 Feb 7.
4
A more flexible parametric estimation of univariate reference intervals: a new method based on the GS-distribution.单变量参考区间的一种更灵活的参数估计:基于GS分布的新方法。
Clin Chim Acta. 2007 Apr;379(1-2):71-80. doi: 10.1016/j.cca.2006.12.010. Epub 2006 Dec 22.
5
Confidence interval for quantiles and percentiles.分位数的置信区间。
Biochem Med (Zagreb). 2019 Feb 15;29(1):010101. doi: 10.11613/BM.2019.010101. Epub 2018 Dec 15.
6
Estimation of reference intervals from small samples: an example using canine plasma creatinine.基于小样本估计参考区间:以犬血浆肌酐为例
Vet Clin Pathol. 2009 Dec;38(4):477-84. doi: 10.1111/j.1939-165X.2009.00155.x. Epub 2009 May 15.
7
Combining Nordtest method and bootstrap resampling for measurement uncertainty estimation of hematology analytes in a medical laboratory.结合Nordtest方法和自助重采样用于医学实验室血液学分析物测量不确定度的评估。
Clin Biochem. 2017 Dec;50(18):1067-1072. doi: 10.1016/j.clinbiochem.2017.09.008. Epub 2017 Sep 18.
8
An add-in implementation of the RESAMPLING syntax under Microsoft EXCEL.微软EXCEL下RESAMPLING语法的插件实现。
Comput Methods Programs Biomed. 2000 Oct;63(2):99-104. doi: 10.1016/s0169-2607(00)00077-8.
9
Chromatographic peak resolution using Microsoft Excel Solver. The merit of time shifting input arrays.使用微软Excel求解器进行色谱峰分辨率。时间偏移输入数组的优点。
J Chromatogr A. 2008 Dec 5;1213(1):50-5. doi: 10.1016/j.chroma.2008.08.108. Epub 2008 Sep 4.
10
Resampling approach for determination of the method for reference interval calculation in clinical laboratory practice.临床实验室实践中用于确定参考区间计算方法的重采样方法。
Clin Vaccine Immunol. 2010 Aug;17(8):1217-22. doi: 10.1128/CVI.00112-10. Epub 2010 Jun 16.

引用本文的文献

1
A reference interval study of serum 25-Hydroxyvitamin D among an African elderly population.一项针对非洲老年人群体血清 25-羟维生素 D 的参考区间研究。
Afr Health Sci. 2022 Dec;22(4):220-228. doi: 10.4314/ahs.v22i4.27.
2
Knockout of liver fluke granulin, Ov-grn-1, impedes malignant transformation during chronic infection with Opisthorchis viverrini.肝片形吸虫颗粒蛋白(Ov-grn-1)基因敲除阻碍华支睾吸虫感染慢性期的恶性转化。
PLoS Pathog. 2022 Sep 22;18(9):e1010839. doi: 10.1371/journal.ppat.1010839. eCollection 2022 Sep.
3
Reference ranges for clinical electrophysiology of vision.

本文引用的文献

1
The theory of reference values: an unfinished symphony.参考值理论:一部未完成的交响乐。
Clin Chem Lab Med. 2013 Jan;51(1):47-64. doi: 10.1515/cclm-2012-0682.
2
Reference Value Advisor: a new freeware set of macroinstructions to calculate reference intervals with Microsoft Excel.参考值顾问:一套新的免费宏指令集,用于使用Microsoft Excel计算参考区间。
Vet Clin Pathol. 2011 Mar;40(1):107-12. doi: 10.1111/j.1939-165X.2011.00287.x. Epub 2011 Feb 7.
3
Statistical data analysis in the computer age.计算机时代的统计数据分析。
视觉临床电生理学的参考范围。
Doc Ophthalmol. 2021 Oct;143(2):155-170. doi: 10.1007/s10633-021-09831-1. Epub 2021 Apr 21.
4
Developing BIOTEL: A Semi-Automated Spreadsheet for Estimating Telomere Length and Biological Age.开发BIOTEL:一种用于估算端粒长度和生物学年龄的半自动电子表格。
Front Genet. 2019 Feb 19;10:84. doi: 10.3389/fgene.2019.00084. eCollection 2019.
5
Confidence interval for quantiles and percentiles.分位数的置信区间。
Biochem Med (Zagreb). 2019 Feb 15;29(1):010101. doi: 10.11613/BM.2019.010101. Epub 2018 Dec 15.
Science. 1991 Jul 26;253(5018):390-5. doi: 10.1126/science.253.5018.390.
4
The IFCC recommendation on estimation of reference intervals. The RefVal program.国际临床化学和检验医学联合会关于参考区间估计的建议。RefVal程序。
Clin Chem Lab Med. 2004;42(7):710-4. doi: 10.1515/CCLM.2004.121.
5
Need for revisiting the concept of reference values.需要重新审视参考值的概念。
Clin Chem Lab Med. 2000 Jul;38(7):589-95. doi: 10.1515/CCLM.2000.085.
6
Nonparametric estimation of reference intervals by simple and bootstrap-based procedures.通过简单和基于自助法的程序对参考区间进行非参数估计。
Clin Chem. 2000 Jun;46(6 Pt 1):867-9.
7
RefVal: a program implementing the recommendations of the International Federation of Clinical Chemistry on the statistical treatment of reference values.参考值:一个实施国际临床化学联合会关于参考值统计处理建议的程序。
Comput Methods Programs Biomed. 1995 Dec;48(3):247-56. doi: 10.1016/0169-2607(95)01697-x.
8
RefVal for windows--migrating to the Windows environment with the help of Visual Basic.适用于Windows的RefVal——借助Visual Basic迁移到Windows环境。
Clin Chim Acta. 1993 Dec 15;222(1-2):19-21. doi: 10.1016/0009-8981(93)90088-l.
9
International Federation of Clinical Chemistry, Scientific Committee, Clinical Section. Expert Panel on Theory of Reference Values (EPTRV). The theory of reference values. Part 5. Statistical treatment of collected reference values. Determination of reference limits.国际临床化学联合会,科学委员会,临床分会。参考值理论专家小组(EPTRV)。参考值理论。第5部分。收集的参考值的统计学处理。参考限的确定。
Clin Chim Acta. 1984 Feb 14;137(1):97F-114F.
10
The theory of reference values Part 5. Statistical treatment of collected reference values. Determination of reference limits.参考值理论 第5部分。收集到的参考值的统计学处理。参考限的确定。
J Clin Chem Clin Biochem. 1983 Nov;21(11):749-60.