北方农业学报 ›› 2015, Vol. 43 ›› Issue (6): 174-174.

• 专题调查与述评 • 上一篇    下一篇

用Excel列表计算秩相关系数和综合营养状态指数

李章安 廖超平 刘厚康   

  1. 开县环境监测站,重庆开县405400
  • 出版日期:2015-12-20 发布日期:2015-12-20
  • 通讯作者: 李章安
  • 作者简介:李章安(1973-),男,重庆开县人,高级工程师,主要从事环境监测、环境影响评价及环境科学技术等研究。

Calculation of rank correlation coefficient and comprehensive nutrition state index using Excel list

LI Zhangan, LIAO Chaoping, LIU Houkang (Kaixian Environmental Monitoring Station,Kaixian 405400,China)   

  • Online:2015-12-20 Published:2015-12-20

摘要: Spearman秩相关系数法和湖泊(水库)综合营养状态指数法的计算公式应用非常普遍,用日常办公所用的Microsoft Office Excel电子表格以列表的方式来计算这两个公式,既简便、通俗,更能大大提高计算效率和结果的准确性。

Abstract: Spearman rank correlation coefficient method and lakes(reservoirs) comprehensive nutrition state index method using formula is very common. Microsoft Office Excel spreadsheet used in the daily office was used to list to calculate the two formulas, which was simple,popular and can greatly improve the calculation efficiency and accuracy of the results.

中图分类号: 

  • R181.3