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
   28   29   30   31   32   33   34   35   36   37   38