Page 27 - Trackpad_ipro 4.1_Class8
P. 27

Statistical Functions

                       Function                          Purpose                                Example

                                                                                      Input: =MAX(4,16,12,9)
                     MAX(range)        Returns the largest value in the given range
                                                                                      Output: 16

                                       Returns the smallest  value in the given  Input: =MIN(4,16,12,9)
                     MIN(range)
                                       range                                          Output: 4
                                       Returns the average of the given numbers  Input: =AVERAGE(12,3,6)
                   AVERAGE(range)
                                       in the range                                   Output: 7

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

                 To use the statistical functions in Excel, follow these 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 marks appears  in cell  I3. Using the  AutoFill
                 feature, we can calculate the average of the marks for each student.





                                                                             Spreadsheet—Functions and Charts    25
   22   23   24   25   26   27   28   29   30   31   32