Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 56 - Data_Science_Part_A C12
P. 56

    3.10.8 Statistical Functions

            Statistical Functions take numeric argument(s) and produce results accordingly. Following are the different types of
            statistical functions:
                                                           Table 3.3: A

                Function                                           Description
             AVERAGE( )      Produces the average (mean) of the given arguments.

                             E.g.,=AVERAGE(10,20,30) will display 20
                             =AVERAGE(A1,A2,A3) Displays the average of the cells A1, A2 and A3
                             =AVERAGE(A1:A10) Displays the average of the cells from the range A1 to A10

             MAX( )          Produces the largest value from the given range of cells.
                             E.g., =MAX(10,20,15,25) will display 25

                             =MAX(A1:A5) Displays the largest value from cell A1 to A5.
                             =MAX(B2:C4) Displays the largest value of cells B2, B3, B4,C2, C3 and C4.

             MIN( )          Produces the smallest value from the given set of values/range of cells. E.g., = MIN(10,20,15,25) will
                             display 10
                             =MIN(A1,A2,A3) Displays the smallest value of cells A1, A2 & A3.

                             =MIN(B2:C3) Displays the smallest value of cells B2, B3, C2 & C3.

             COUNT( )        Produces     the    number     of     arguments    enclosed     in    small    brackets.
                             E.g., = COUNT(1,2,15,25,3,6) will display 6
                             =COUNT(A1:A20) Displays output: 20 (If all cells i.e., A1 to A20 contain values).

            3.10.9 Logical Functions

            Logical Functions in LibreOffice Calc check the data and return the result TRUE if the condition is true, and FALSE if not.
            Consider the syntax of logical functions and examples of their applications in the process of working with the LibreOffice
            Calc program.
                                                           Table 3.4: A

              Function                                           Description
             OR          Produces TRUE if any condition enclosed in the bracket is TRUE, otherwise it produces FALSE.
                         E.g., =OR(5>3, 4<5, 4>15) will display TRUE.
                         =OR(3>6; 2<1) will display FALSE.

             AND         Produces TRUE if all the conditions enclosed in the bracket are TRUE, otherwise displays FALSE.

                         E.g.,=AND (5>3, 4<5, 4>15) will display FALSE. (As one of the conditions is FALSE)
                         =AND(5>3, 4<5) will display TRUE.

             IF          If the condition in the statement is TRUE, it will display the TRUE part otherwise it will display the FALSE
                         part.
                         E.g., =IF(4>5,4,5) will display 5 since the condition is FALSE.

               54   Touchpad Data Science-XII

| 51 52 53 54 55 56 57 58 59 60 61 |