Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 89 - 2619_PlusGPT V2.1_C-7
P. 89

    Statistical Functions

                     These functions are used to analyse data and calculate statistical measures. Some of the statistical
                     functions are given below:
                           Functions                            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
                                            It returns the average of the given numbers in  Input: =AVERAGE(12,3,6)
                      AVERAGE(range)
                                            a 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’s CatCh uP

                       Write the output of the following:

                       1.  =MIN (5,7,8)         _____________              2.  =AVERAGE(12,3,6)        _____________
                       3.  =COUNT(4,8,12)       _____________

                                Let’s BaCk-uP

                           A cell or a range of cells that you want to use in your calculation is called reference.
                           Formulas in Excel 2016 begin with an equal to (=) sign.
                           Excel calculates consecutive operators with the same level of precedence from left to right.
                           Excel 2016 allows users to create custom formulas to perform calculations on the data.
                           A cell reference is a cell address that can be used in a formula to denote a specific cell.

                           A group of selected cells is called a range.
                           Functions are pre-defined formulas in Excel to perform simple and complex calculations.
                            Different categories  of functions  are Statistical  functions,  Mathematical  functions,  Logical
                          functions, Text functions and Date and Time functions.

                                                                                Formulas and Functions in Google Sheets  87

| 84 85 86 87 88 89 90 91 92 93 94 |