Journal of Northern Agriculture ›› 2015, Vol. 43 ›› Issue (6): 174-174.

Previous Articles     Next Articles

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

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.

CLC Number: 

  • R181.3