☰ Contents · Computing

Statistical functions

Lessons 15–16 · 2 lessons · N. I. Taylaqov (general editor), A. B. Akhmedov, M. D. Pardayeva, A. A. Abdug‘aniyev, U. M. Mirsanov. Informatics and Information Technologies, Grade 10, 1st edition. “Extremum-Press”, Tashkent, 2017
Answers are for parents and teachers.
1
What is =AVERAGE(6,8,10,12,14)?
2
What is the median of 2, 3, 3, 8, 14, 20?
3
What is =GEOMEAN(3,27)?
4
Write a formula that counts the scores above 70 in A1:A8.
5
With the scores 56, 72, 88, 91, 64, 77, 88, 95, 49, 80 and a pass mark of 60, find the number of students who did not pass.