Excel在沥青路面厚度检测数据分析中的应用  

Application of Excel in Test Data Analysis of Asphalt Pavement Thickness

作　　者：郑卫华[1] 邵琦 柳伟[1] 

机构地区：[1]江西交通职业技术学院路桥工程系,南昌330013 [2]江西省交通科学研究院,南昌330038

出　　处：《交通科技》2012年第5期96-98,共3页Transportation Science & Technology

摘　　要：与钻孔取心和挖检相比,地质雷达检测是一种能够连续采样的路面厚度无损检测手段。但是,需要对大量的试验数据进行统计分析,人工处理费时,且容易出错。因此,以电子表格"Ex-cel"自编程序,统计分析路面厚度的平均值、标准差、代表值、变异系数等,探讨了一种路面厚度检测数据处理的有效途径。Compared to core drilling and digging experience,the geological radar detection technology is a consecutive sample non-destructive testing methods to measure thickness of the asphalt pavement.But a large amount of experimental data was required to analyze and calculate and manual processing is time-consuming and error-prone.Therefore,a program with Excel software was used to analyze average value,standard deviation,representative value,coefficient of variation,etc.and the effective data processing way of pavement thickness is discussed.

关 键 词：EXCEL 2003 路面厚度 数据分析 

分 类 号：U416.217[交通运输工程—道路与铁道工程]