Page 88 - PlusGPT_V2.1_C7_Flipbook
P. 88

Statistical Functions

                        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 a    Input: =AVERAGE(12,3,6)
                   AVERAGE(range)
                                        range.                                              Output: 7

                                        It returns the count of the number of values in the  Input: =COUNT(4,8,12)
                   COUNT(range)
                                        selected range.                                    Output: 3

                  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


                  86    Premium Edition-VII
   83   84   85   86   87   88   89   90   91   92   93