从常规实验室数据中简单估计参考区间

IF 0.1 Q4 OTORHINOLARYNGOLOGY Laboratoriumsmedizin-Journal of Laboratory Medicine Pub Date : 2016-01-22 DOI:10.1515/labmed-2015-0104
Georg F. Hoffmann, R. Lichtinghagen, W. Wosniok
{"title":"从常规实验室数据中简单估计参考区间","authors":"Georg F. Hoffmann, R. Lichtinghagen, W. Wosniok","doi":"10.1515/labmed-2015-0104","DOIUrl":null,"url":null,"abstract":"Abstract: According to the recommendations of the IFCC and other organizations, medical laboratories should establish or at least adapt their own reference intervals, to make sure that they reflect the peculiar characteristics of the respective methods and patient collectives. In practice, however, this postulate is hard to fulfill. Therefore, two task forces of the DGKL (“AG Richtwerte” and “AG Bioinformatik”) have developed methods for the estimation of reference intervals from routine laboratory data. Here we describe a visual procedure, which can be performed on an Excel sheet without any programming knowledge. Patient values are plotted against the quantiles of the standard normal distribution (so-called QQ plot) using the NORM. INV function of Excel. If the examined population contains mainly non-diseased persons with approximately normally distributed values, the respective dots form a straight line. Very often the values are rather lognormally distributed; in this case the straight line can be detected after logarithmic transformation of the original values. Values, which do not match with the assumed theoretical distribution, deviate from the linear shape and can easily be identified and eliminated. Using the reduced data set, the mean value and standard deviation are calculated and the reference interval (μ±2σ) is estimated. The method yields plausible results with simulated and real data. With the increasing number of results, which do not match with the model, it tends to underestimate the standard deviation. In all cases, where the QQ plot does not yield a substantial linear part, the proposed method is not applicable.","PeriodicalId":49926,"journal":{"name":"Laboratoriumsmedizin-Journal of Laboratory Medicine","volume":"192 1","pages":""},"PeriodicalIF":0.1000,"publicationDate":"2016-01-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"20","resultStr":"{\"title\":\"Simple estimation of reference intervals from routine laboratory data\",\"authors\":\"Georg F. Hoffmann, R. Lichtinghagen, W. Wosniok\",\"doi\":\"10.1515/labmed-2015-0104\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Abstract: According to the recommendations of the IFCC and other organizations, medical laboratories should establish or at least adapt their own reference intervals, to make sure that they reflect the peculiar characteristics of the respective methods and patient collectives. In practice, however, this postulate is hard to fulfill. Therefore, two task forces of the DGKL (“AG Richtwerte” and “AG Bioinformatik”) have developed methods for the estimation of reference intervals from routine laboratory data. Here we describe a visual procedure, which can be performed on an Excel sheet without any programming knowledge. Patient values are plotted against the quantiles of the standard normal distribution (so-called QQ plot) using the NORM. INV function of Excel. If the examined population contains mainly non-diseased persons with approximately normally distributed values, the respective dots form a straight line. Very often the values are rather lognormally distributed; in this case the straight line can be detected after logarithmic transformation of the original values. Values, which do not match with the assumed theoretical distribution, deviate from the linear shape and can easily be identified and eliminated. Using the reduced data set, the mean value and standard deviation are calculated and the reference interval (μ±2σ) is estimated. The method yields plausible results with simulated and real data. With the increasing number of results, which do not match with the model, it tends to underestimate the standard deviation. In all cases, where the QQ plot does not yield a substantial linear part, the proposed method is not applicable.\",\"PeriodicalId\":49926,\"journal\":{\"name\":\"Laboratoriumsmedizin-Journal of Laboratory Medicine\",\"volume\":\"192 1\",\"pages\":\"\"},\"PeriodicalIF\":0.1000,\"publicationDate\":\"2016-01-22\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"20\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Laboratoriumsmedizin-Journal of Laboratory Medicine\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1515/labmed-2015-0104\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q4\",\"JCRName\":\"OTORHINOLARYNGOLOGY\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Laboratoriumsmedizin-Journal of Laboratory Medicine","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1515/labmed-2015-0104","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q4","JCRName":"OTORHINOLARYNGOLOGY","Score":null,"Total":0}
引用次数: 20

摘要

摘要:根据IFCC和其他组织的建议,医学实验室应建立或至少调整自己的参考区间,以确保它们反映各自方法和患者群体的特点。然而,在实践中,这一假设很难实现。因此,DGKL的两个工作组(“AG Richtwerte”和“AG Bioinformatik”)开发了从常规实验室数据估计参考区间的方法。在这里,我们描述了一个可视化过程,它可以在没有任何编程知识的情况下在Excel表上执行。使用NORM,根据标准正态分布的分位数(所谓的QQ图)绘制患者值。Excel的INV函数。如果被检查的人口中主要包含大致为正态分布值的非患病人群,则相应的点形成一条直线。这些值通常是对数正态分布;在这种情况下,对原始值进行对数变换后可以检测到直线。与假设的理论分布不匹配的值偏离了线性形状,可以很容易地识别和消除。利用简化后的数据集,计算均值和标准差,估计参考区间(μ±2σ)。该方法对模拟数据和实际数据都能得到合理的结果。随着与模型不匹配的结果越来越多,它往往会低估标准偏差。在所有情况下,如果QQ图不产生实质性的线性部分,则所提出的方法不适用。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
查看原文
分享 分享
微信好友 朋友圈 QQ好友 复制链接
本刊更多论文
Simple estimation of reference intervals from routine laboratory data
Abstract: According to the recommendations of the IFCC and other organizations, medical laboratories should establish or at least adapt their own reference intervals, to make sure that they reflect the peculiar characteristics of the respective methods and patient collectives. In practice, however, this postulate is hard to fulfill. Therefore, two task forces of the DGKL (“AG Richtwerte” and “AG Bioinformatik”) have developed methods for the estimation of reference intervals from routine laboratory data. Here we describe a visual procedure, which can be performed on an Excel sheet without any programming knowledge. Patient values are plotted against the quantiles of the standard normal distribution (so-called QQ plot) using the NORM. INV function of Excel. If the examined population contains mainly non-diseased persons with approximately normally distributed values, the respective dots form a straight line. Very often the values are rather lognormally distributed; in this case the straight line can be detected after logarithmic transformation of the original values. Values, which do not match with the assumed theoretical distribution, deviate from the linear shape and can easily be identified and eliminated. Using the reduced data set, the mean value and standard deviation are calculated and the reference interval (μ±2σ) is estimated. The method yields plausible results with simulated and real data. With the increasing number of results, which do not match with the model, it tends to underestimate the standard deviation. In all cases, where the QQ plot does not yield a substantial linear part, the proposed method is not applicable.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
CiteScore
0.80
自引率
0.00%
发文量
1
审稿时长
>12 weeks
期刊介绍: Information not localized
期刊最新文献
A new approach to the interpretation of B-type natriuretic peptide concentration in children with congenital heart disease Digital competence in laboratory medicine German Congress of Laboratory Medicine: 17th Annual Congress of the DGKL and 4th Symposium of the Biomedical Analytics of the DVTA e. V Frontmatter XVth International Congress on Pediatric Laboratory Medicine, Munich, Nov 27–28, 2021; Poster Presentation Abstracts
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
现在去查看 取消
×
提示
确定
0
微信
客服QQ
Book学术公众号 扫码关注我们
反馈
×
意见反馈
请填写您的意见或建议
请填写您的手机或邮箱
已复制链接
已复制链接
快去分享给好友吧!
我知道了
×
扫码分享
扫码分享
Book学术官方微信
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术
文献互助 智能选刊 最新文献 互助须知 联系我们:info@booksci.cn
Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。
Copyright © 2023 Book学术 All rights reserved.
ghs 京公网安备 11010802042870号 京ICP备2023020795号-1