Page 33 - TP_Play_V2.1_class6
P. 33
Statistical Functions
Function Purpose Example
It returns the largest value in the given Input: =MAX(4,16,12,9)
MAX(range)
range. Output: 16
It returns the smallest value in the given Input: =MIN(4,16,12,9)
MIN(range)
range. Output: 4
It returns the average of the given numbers Input: =AVERAGE(12,3,6)
AVERAGE(range)
in a range. Output: 7
Let's use the statistical functions in Excel 2016. Perform the given steps to use the statistical functions:
Step 1 Type the given data in the Excel 2016 worksheet.
Step 2 Type =MAX(C3:G3) function
in the cell H3 to find the
maximum marks.
Step 3 Press the Enter key.
Using MAX function
When you press the Enter key, the
maximum marks appear in the cell H3. Using the AutoFill feature find the maximum marks of
each student. Similarly, we can find the minimum marks by using the MIN() function in column I.
Step 4 Type =AVERAGE(C3:G3) function in the cell J3 to find the average of marks.
Step 5 Press the Enter key from the keyboard.
Using AVERAGE function
When you press the Enter key, the average of marks appears in the cell J3. Using the AutoFill
feature, we can calculate the average of marks of each student.
Calculating average of marks
Logical Functions
Function Purpose Example
It checks whether the given condition Percentage = 80
IF(condition, met, and returns value1 if the condition Input: =IF(Percentage >=
value1, value2) evaluates to true, and returns value2 if the 50, “Passed”, “Failed”)
condition evaluates to false. Output: Passed
Formulas and Functions 31

