.

MODE Function Dictionary

Function Dictionary Function Examples Function Categories

MODE            
 
 
Value1 Value2 Value3 Value4 Value5 Mode
20 50 10 10 40 10  =MODE(C4:G4)
40 20 40 10 40 40  =MODE(C6:G6)
10 10 99 20 20 10  =MODE(C8:G8)
20 20 99 10 10 20  =MODE(C9:G9)
10 20 20 99 10 10  =MODE(C10:G10)
10 20 30 40 50 #N/A  =MODE(C12:G12)
What Does It Do ?              
This function displays the most frequently occurring number in a group of numbers.
For it to work correctly there must be at least two numbers which are the same.
If all the values in the group are unique the function shows the error #N/A.
When there is more than one set of duplicates, the number closest to the beginning
of the group will be used. (Which is not really an accurate answer!)
Syntax                
=MODE(Range1,Range2,Range3... through to Range30)
Formatting              
No special formatting is needed.
Example                
The following table shows garments sold in a clothes shop.
The shopkeeper wants to keep track of the most commonly sold size.
The =MODE() function has been used to calulate this.
Order Garmet Size
001 Blouse 10     Most frequently ordered size :  10
002 Skirt 10  =MODE(D33:D52)
003 Shirt 8
004 Blouse 10
005 Skirt 12   Count of size 8 :  6
006 Dress 8  =COUNTIF(D33:D52,"8")
007 Shirt 10
008 Blouse 10   Count of size 10 : 11
009 Dress 8  =COUNTIF(D33:D52,"10")
010 Shirt 10
011 Dress 12   Count of size 12 : 3
012 Skirt 12  =COUNTIF(D33:D52,"12")
013 Skirt 10
014 Shirt 10
015 Dress 8
016 Shirt 10
017 Blouse 10
018 Blouse 8
019 Dress 10
020 Skirt 8
Note                
If the =AVERAGE() function had been used the answer would have been : 9.7
This figure is of no benefit to the shopkeeper as there are no garmets of this size!

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download