MODE Function (Functions in Excel)

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 :

This figure is of no benefit to the shopkeeper as there are no garmets of this size!

Related Posts by Categories