| Excel在水质分析标准曲线及回归方程截距检验计算中的应用 |
| |
| 引用本文： | 杜海波.Excel在水质分析标准曲线及回归方程截距检验计算中的应用[J].水文,2011,31(3):88-89,81. |
| |
| 作者姓名： | 杜海波 |
| |
| 作者单位： | 甘肃省临洮水文水资源勘测局,甘肃临洮,730500 |
| |
| 摘 要： | 在水质分析标准曲线及回归方程截距检验的统计计算工作中,为解决日常工作中经常遇到的计算容易出错、各种计算方法及过渡数据有效位数的人为取舍对计算结果的一致性影响较大等问题,就如何应用计算机Excel计算模板快速准确地完成上述有关计算工作进行探讨;阐述了应用Excel计算模板的方法原理,介绍了计算模板的建立、验证、应用、保存、借用等实用经验;在相关计算工作的快速准确及提高工作效率等方面得到了满意的结果。
|
| 关 键 词： | Excel 计算模板 水质分析 标准曲线 截距检验 |
Application of Excel in Standard Curve and Regression Equation Intercept Test Calculation for Water Quality Analysis |
| |
| DU Haibo.Application of Excel in Standard Curve and Regression Equation Intercept Test Calculation for Water Quality Analysis[J].Hydrology,2011,31(3):88-89,81. |
| |
| Authors: | DU Haibo |
| |
| Institution: | DU Haibo(Lintao Hydrology and Water Resources Survey Bureau of Gansu Province,Lintao 730500,China) |
| |
| Abstract: | In calculation of the standard curve and intercept test for water quality analysis,in order to solve the problems such as calculation error-prone and the influence of the various calculation methods and artificial choosing the effective digit of transition data on the consistency of the calculated results,it was discussed how to use Excel module to make quick and accurate calculation.The method of applying Excel calculation module was described,and establishment,validation,application,preservation,borrowing... |
| |
| Keywords: | Excel calculation module water quality analysis standard curve intercept test |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
