|
【函数初级201203班】第3讲D组作业上交
【函初201203班]- D03:stone1969(1109590007)
=COUNTIFS(E12:G12,">60")
作业二 | 至少用二种方法统计表1中1班级考生所有成绩都及格的考生人数: | =COUNTIFS($A$12:$A$21,$A$12,$E$12:$E$21,">60",$F$12:$F$21,">60",$G$12:$G$21,">60")
=SUMPRODUCT(($A$12:$A$21=$A$12)*($E$12:$E$21>60)*($F$12:$F$21>60)*($G$12:$G$21>60))
=RANK(H12,$H$12:$H$21)
=SUMPRODUCT((($H$12:$H$21)*($A$12:$A$21=A12)>H12)*1)+1
作业五 | 用二种方法,统计表1中1班男生的平均年龄,年龄4舍5入为整数: | =SUMPRODUCT(($A$12:$A$21=$A$12)*($C$12:$C$21=$C$12),$D$12:$D$21)/SUMPRODUCT(($A$12:$A$21=$A$12)*($C$12:$C$21=$C$12))
=SUMPRODUCT(($A$12:$A$21=$A$12)*($C$12:$C$21=$C$12),$D$12:$D$21)/COUNTIFS($A$12:$A$21,$A$12,$C$12:$C$21,$C$12) |
|