Tools/materials: Dell Yue Ling 5000, win 10, Excel20 19.
1. Open the excel table and enter two columns of data, name and score.
2. Create the fractional frequency field and set the interval, 70-80, 80-90 and 90 or more.
3. if the score is between 70 and 80, enter = countifs (B2: b2 1, "> 70", B2: b2 1, "& lt80"), count which regions, select all the data in the regions, and press enter to get the frequency result.
4. if the score is 80 to 90, enter = countifs (B2: b2 1, "> 80", B2: b2 1, "& lt90") and press enter to get the result.
5. if the statistics are greater than or equal to 90 points, enter = countifs (B2: b2 1, "> =90") and press enter to get the result, and count the number of people with three scores.