"Here below is a data table: [pic] Now we want to count the following information for each class: .."

mars RaqForum 25 No.
368 View • 2 Years ago

7.3 Fill aggregation value in the first row of the same group of data

desktop and excel data processing cases(180)

Here below is a data table:

imagepng

Now we want to count the following information for each class: number of students with score above 90, number of failed students, and the average score after removing the highest and lowest scores, and then fill the results in the first row of each class (calculate in cell D1):

	A
1	=E(‘A1:C19’).derive(:ScoreAbove90,:Failed,:AverageScore)
2	=A1.group(Class).run(~(1).ScoreAbove90=~.select(Score>=90).len(),~(1).Failed=~.select(Score<60).len(),~(1).AverageScore=~.sort(Score).m(2:-2).avg(Score))
3	return A1.new(ScoreAbove90,Failed,AverageScore)