室间比对是验证检测实验室检测能力的一种有效方法,目前常采用分割样品设计、四分位稳健统计技术,对参加比对试验的实验室检测能力状况进行判断(计算ZB值和ZW值),当参加比对的实验室较多时,往往有大量数据需要处理,不仅费时费力,而且容易出错,利用Excel中的PERCEN-TILE、MEDIAN Room comparison is an effective way to verify the testing ability of testing laboratories. At present, the segmentation sample design and quartile robust statistical techniques are often used to judge the laboratory testing ability of participating in the comparison test (calculate ZB value and ZW Value), when more laboratories to participate in comparison, often have a lot of data to be processed, not only time-consuming and laborious, but also prone to error, the use of Excel PERCEN-TILE, MEDIAN