种间关联参数在Microsoft Excel 2003中的实现——Spearman秩相关分析

Application of Microsoft Excel 2003 in calculating parameters on interspecific association——Spearman rank correlation coefficient

种间关联分析是认识植物群落的重要基础。针对种间关联参数计算过程复杂、繁琐、易错等特点,以Spearman秩相关分析为例,提出利用Microsoft Excel 2003的基本功能进行数据处理,快速高效地计算出Spearman秩相关值参数,对其他常用的种间关联参数的计算具有推广性。

Interspecific association is the important way to realize the characteristics of phytocoenology. Aiming to the complexity and fallibility in calculating the parameters of interspecifie association, taking the rank correlation coefficient as an example, the author applied the basic function of Microsoft Excel 2003 to deal with the data and count spearman rank correlation coefficient fast and effectively, which is deserved to popularize in any other parameters of interspeeifie association.