excel统计方法（Excel statistical method）.docVIP

excel统计方法（Excel statistical method） For teachers, it is often necessary to use Excel for student achievement statistics, and will be stumped by a number of common problems. The main problem is: how different levels of statistical number, how, how to rank percentile scores and how to convert different red failing grades in school remain unchanged, this paper focuses on the solution of these problems and techniques are analyzed and discussed. We assume that the reader has the basic operation of excel has a certain basis, have mastered how to sum, average and how to use the automatic filling handle copy formula, this article does not make detailed introduction to these general operations, discussed only for some of the more difficult operating skills. Two, excel statistical student achievement of four problems Suppose that in statistical student achievement, we need to figure out the relevant results shown in figure 1. Figure 1 student achievement statistics required results chart Here, if the number of students, names, grades and rows of 15 have been lost in advance, you need to let excel statistics other relevant data results. At this point, the most difficult problems in the performance statistics and their location in the diagram are as follows: Question 1: how do you count the number of students in different grades (Figure a16~e16)? Question 2: how do students schedule their grades on the premise of keeping student numbers in order (Figure f2~f13)? Question 3: how do you convert the percentile system into different grades? (Rank 1 and rank 2) in the diagram Question 4: how do you display red marks for failing grades? (red display section, that is, the twelfth line) Three, to solve the statistical problems of student achievement four methods In the following, we discuss the solutions and techniques for the four difficult problems mentioned above. 1. Statistics the number of students with different grades It is a very common requirement to calculate the number of st