Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 30 - 2632_CodeMind
P. 30

    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.

                                                                                  Formulas and Functions in Excel  29

| 25 26 27 28 29 30 31 32 33 34 35 |