Page 27 - Trackpad_ipro 4.1_Class8
P. 27
Statistical Functions
Function Purpose Example
Input: =MAX(4,16,12,9)
MAX(range) Returns the largest value in the given range
Output: 16
Returns the smallest value in the given Input: =MIN(4,16,12,9)
MIN(range)
range Output: 4
Returns the average of the given numbers Input: =AVERAGE(12,3,6)
AVERAGE(range)
in the range Output: 7
It returns the count of the number of values Input: =COUNT(4,8,12)
COUNT(range)
in the selected range Output: 3
To use the statistical functions in Excel, follow these 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 marks appears in cell I3. Using the AutoFill
feature, we can calculate the average of the marks for each student.
Spreadsheet—Functions and Charts 25

