Excel在单孔声波测试数据统计及分析中的应用  

Application of Excel in Statistics and Analysis of Single-hole Sound Wave Test Data

作　　者：李俊 Li Jun(Tianjin Land Resources and House Vocational College,Tianjin 300270)

机构地区：[1]天津国土资源和房屋职业学院不动产管理学院,天津300270

出　　处：《天津职业院校联合学报》2022年第9期111-116,共6页Journal of Tianjin Vocational Institutes

摘　　要：如何快速、准确的完成大量数据的处理分析统计工作,是一个较现实和急需解决的问题。本文通过对某大型工程项目勘察中,利用Excel对单孔声波数据的统计分析方法及经验的总结,可实现数据的快速、准确、可视化处理等,亦方便了整体参数修改、资料校核等工作,极大地提高了整体工作效率,可为类似工作提供一种借鉴思路。Process and analyzingnumerous data quickly and accurately is a realistic and urgent problem.In this paper,through a survey of a large engineering project,by using statistical analysis and experience summary of single-hole sound wave data by Excel,it can not only realize rapid,accurate and visual processing of data,but also facilitate the overall parameter modification,data checking and other works,which greatly improves the overall work efficiency,and can provide a reference for similar work.

关 键 词：EXCEL应用 单孔声波 统计分析 透视表 

分 类 号：TV222.2[水利工程—水工结构工程]