Excel对学生成绩的频度分析的研究

A Study of Frequency Analysis of Student Grades by Using Excel

数据频度分析是Excel的重要功能之一,Excel对学生成绩频度分析有四种方法:COUNTIF函数、COUNTIFS函数、FREQUENCY函数和数据透视表。四种方法均能方便快捷的完成对成绩数据的频度分析,完美高效地解决成绩统计问题。

Data frequency analysis is one of the important functions of Excel. Four different methods can be used of frequency analysis of student grades:COUNTIF function, COUNTIFS function, FREQUENCY function and Pivot Table.Both four methods can be fast and convenient for frequency analysis of student grades, helps to solve the problem of grades statistics effectively.