Page 31 - ThinkGPT_V2.1_C6_Flipbook
P. 31
Statistical Functions
Function Purpose Example
Input: =MAX(4,16,12,9)
MAX(range) It returns the largest value in the given range.
Output: 16
Input: =MIN(4,16,12,9)
MIN(range) It returns the smallest value in the given range.
Output: 4
AVERAGE It returns the average of the given numbers in a Input: =AVERAGE(12,3,6)
(range) range. Output: 7
It returns the count of the number of values in Input: =COUNT(4,8,12)
COUNT(range)
the selected range. Output: 3
Let us use the statistical functions in Excel. To use the statistical functions, follow the given steps:
1 Type the following
data in the Excel
worksheet.
2 Type =MAX(B3:F3) function to find the
maximum marks and press the Enter key.
When you press the Enter key, the maximum marks appear in cell G3. Using the AutoFill feature,
find the maximum marks of each student. Similarly, we can find the minimum marks by using the
MIN() function.
3 Type =AVERAGE(B3:F3) function to find
the average of marks and press the Enter key.
When you press the Enter key, the average of the marks appears in cell I3. Using the AutoFill
feature, we can calculate the average of the marks of each student.
Suppose you could use Excel to set and track your personal goals. What goals would you
set, how would you measure your progress, and how would you use charts to visualise your
achievements?
Formulas and Functions in Excel 29

