基于Excel的统计分析系统在期刊编辑部审稿中的应用

Application of the statistical analysis system based on Excel in journal review

期刊审稿过程中非统计专业审稿人很难对统计结果进行审核,导致论文中的统计学错误很多。基于Excel的统计分析系统,不需要专业的统计学知识,只要了解一般统计学常识就能方便使用,特别适合期刊编辑部编辑和审稿人员审核稿件中常见的统计学问题。实际应用结果表明,该系统非常实用,对减少期刊论文中的统计错误大有裨益。

It is difficult for reviewers who are not professional in statistics to examine statistical results in manuscripts; therefore, lots of statistical mistakes might remain in the papers even after peer review. We develop a statistical analysis system based on Microsoft Excel. People who understand general knowledge of statistics can use it well. Journal editors and reviewers can use this system to examine and verify common statistical problems in manuscripts and do not need to master advanced professional knowledge of statistics. The system is very practical and can be applied by a wide range of journal editorial departments to reduce statistical errors in the papers.