各类食品铅含量安全评价检测数据

铅是一种有毒的重金属，如果铅超标可以对人的呼吸系统，消化系统，循环系统，神经系统，内分泌系统都造成严重的损害。本数据可以对各类食品中铅含量的情况进行安全性评价，为政府部门监管提供依据，避免因铅超标使用而产生食品安全问题，进一步保障消费者的食品安全。1.数据采集：采集样品编号、受理日期、检验数量、样品名称、项目、方法、最大限定值、报告值、单位等信息；2.数据处理：(1)是否超出标准值，报告值为未检出(定量限：0.04mg/kg)、报告值小于最大限定值的为未超出，反之为超出，具体使用IF、OR的函数；(2)各类食品中铅含量监测总数,为数据统计范围内总检验数量；(3)各类食品中铅含量检出问题项次数，通过SUMIF函数将超出标准值的检验数量求和；(4)各类食品中铅含量问题发现率=各类食品中铅含量检出问题项次数/各类食品中铅含量监测总数。

Lead is a toxic heavy metal. Excessive lead exposure can cause severe damage to the human respiratory, digestive, circulatory, nervous, and endocrine systems. This dataset enables safety evaluation of lead content in various food products, providing a scientific basis for government regulatory work, preventing food safety incidents caused by excessive lead levels, and further safeguarding consumer food safety.

1. Data Collection: Collect information including sample number, acceptance date, quantity of tested samples, sample name, test item, test method, maximum allowable limit, reported value, and unit.

2. Data Processing:
(1) Standard Limit Exceedance Judgment: Samples with a reported value of "not detected" (quantitation limit: 0.04 mg/kg) or a reported value lower than the maximum allowable limit are classified as non-exceeding the standard; otherwise, they are classified as exceeding the standard. The IF and OR functions are specifically utilized for this judgment.
(2) Total Monitoring Count of Lead Content in Various Foods: Refers to the total number of tested samples within the data statistics scope.
(3) Number of Problematic Items Detected for Lead Content in Various Foods: Obtained by summing the number of tests that exceed the standard limit using the SUMIF function.
(4) Problem Detection Rate of Lead Content in Various Foods = Number of problematic items detected for lead content in various foods / Total number of lead content monitoring samples for various foods.

搜集汇总

数据集介绍

特点

该数据集提供了各类食品中铅含量的检测数据，旨在评估食品的安全性，为政府部门监管提供依据，保障消费者食品安全。数据包含107条记录，更新频次为按需更新，适用于食品安全监管和风险评估场景。