Q5) Refer to the data given below and answer the following questions using appropriate tunction formula: 1Name Attondance Dates Qui Qui 2 Al 20 Ahmed 6 Sadaf Har A Pere 1 ol 2 Note Blank in the attendance dates show that atudent was unregistered. Uae cell references in all the functions. a) Calculate the number of classes in which Hans wes unregistered. b) Evaluate by formula. the average marks obotained by Zia in the quizzes. c) Calculate the total number of classes in which Ahmed was registered as well as in which he was unregistered. d) Display the minimum marks obtained by any student in any of the quizzes. e) Calculate the average of best four quizzes of AlL f) Evaluate the 2 highest marks obtained by any student in any of the quizzes. 9) Compute the number of students in the class. h) Count the number of cells with a value greater than or equal to 4 and less than or equal to 9. - lalele
Q5) Refer to the data given below and answer the following questions using appropriate tunction formula: 1Name Attondance Dates Qui Qui 2 Al 20 Ahmed 6 Sadaf Har A Pere 1 ol 2 Note Blank in the attendance dates show that atudent was unregistered. Uae cell references in all the functions. a) Calculate the number of classes in which Hans wes unregistered. b) Evaluate by formula. the average marks obotained by Zia in the quizzes. c) Calculate the total number of classes in which Ahmed was registered as well as in which he was unregistered. d) Display the minimum marks obtained by any student in any of the quizzes. e) Calculate the average of best four quizzes of AlL f) Evaluate the 2 highest marks obtained by any student in any of the quizzes. 9) Compute the number of students in the class. h) Count the number of cells with a value greater than or equal to 4 and less than or equal to 9. - lalele
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 1GP
Related questions
Question
Transcribed Image Text:Q5) Refer to the data given below and answer the following questions using
appropriate tunction formula:
1Name
Attondance Dates
Qui
Qui 2
Al
20
Ahmed
6 Sadaf
Har
A
Pere 1 ol 2
Note Blank in the attendance dates show that atudent was unregistered.
Uae cell references in all the functions.
a) Calculate the number of classes in which Hans wes unregistered.
b) Evaluate by formula. the average marks obotained by Zia in the quizzes.
c) Calculate the total number of classes in which Ahmed was registered as
well as in which he was unregistered.
d) Display the minimum marks obtained by any student in any of the
quizzes.
e) Calculate the average of best four quizzes of AlL
f) Evaluate the 2 highest marks obtained by any student in any of the
quizzes.
9) Compute the number of students in the class.
h) Count the number of cells with a value greater than or equal to 4 and less
than or equal to 9.
-
lalele
Expert Solution
Step 1
“Since you have posted a question with multiple sub-parts, we will solve first three subparts for you. To get the remaining sub-parts solved, please repost the complete question and mention the sub-parts to be solved.”.
Given data
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,