检索规则说明:AND代表“并且”;OR代表“或者”;NOT代表“不包含”;(注意必须大写,运算符两边需空一格)
检 索 范 例 :范例一: (K=图书馆学 OR K=情报学) AND A=范并思 范例二:J=计算机应用与软件 AND (U=C++ OR U=Basic) NOT M=Visual
机构地区:[1]长江大学,湖北荆州434023 [2]武汉地质矿产研究所,武汉430223
出 处:《华南地质与矿产》2010年第1期1-6,共6页Geology and Mineral Resources of South China
基 金:国家自然科学基金(40673001);长江大学科研发展基金;中国地调局地质大调查项目(200214200013)资助
摘 要:应用Microsoft Excel软件中"数据分析"工具之T-检验,对杭州地区不同环境介质的铅同位素组成(206Pb/207Pb比值)进行了均值相等假设检验。通过T-检验,揭示了杭州市哪些环境介质具有相似或不同的铅同位素组成。结果表明,汽车尾气铅具有独特的铅同位素组成而不同于其它环境介质;汽车尾气铅对环境的污染导致环境中铅同位素组成逐渐偏离原值,如城区表土污染最为严重,其206Pb/207Pb比值已与土壤的残渣显示有显著差异,西湖表层沉积淤泥也与深部沉积柱样品有明显的不同。大气和水与多个环境介质具有相似的铅同位素比值,说明大气与水在环境中能与多种环境介质进行同位素物质交换,对污染的扩散起了重要的作用;茶叶与大气有相似的铅同位素比值,说明大气(降尘)对茶叶铅有较大的贡献。而运河沉积物与城区表土铅同位素比值高度一致则说明运河沉积物可能就是来自城区流失的表土。通过实例,介绍了Excel中T-检验在地球化学研究中的应用。The T-test of "date analysis" tool in Microsoft Excel is applied to discriminate the lead isotopic composition(206Pb/207Pb ratio) of different environment media in Hangzhou city on the precondition of mean equal hypothesis.The results show that lead isotopic composition of automobile exhaust is very different from other environmental media.The environment pollution by automobile exhaust is reflected by the lead isotopic composition of the former is gradually apart from the original value,such as the 206Pb/207Pb of urban surface soil is significant different from the soil residue,and so does the surface sediment mud of West Lake to the deep sedimentary column.Air and water have got similar lead isotopic composition with various environmental medium,which means it maybe the agent for isotope exchanging and pollution diffusion.On the other hand,tea and the atmosphere are somewhat get the similar lead isotope ratio which showed the atmosphere(dust) have a great contribution to the lead composition of the tea leaves.Meanwhile,the lead isotope composition of canal sediments and the city surface soil have a high degree of agreement,which illustrated that the canal sediments may be come from the loss of city topsoil.The application of T-test of Excel in geochemistry is totally exampled in our work.
正在载入数据...
正在载入数据...
正在载入数据...
正在载入数据...
正在载入数据...
正在载入数据...
正在载入数据...
正在链接到云南高校图书馆文献保障联盟下载...
云南高校图书馆联盟文献共享服务平台 版权所有©
您的IP:216.73.216.3