MODE

Posted on 24-01-2020 , by: admin , in , 0 Comments

mode

NumberDivisorRemainder 
1252 =MOD(C4,D4)
2076 =MOD(C5,D5)
1830 =MOD(C6,D6)
921 =MOD(C7,D7)
2473 =MOD(C8,D8)

What Does It Do ?
This function calculates the remainder after a number has been divided by another number.

Syntax
=MOD(Number,Divisor)

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.
OrderGarmetSize
001Blouse10
002Skirt10
003Shirt8
004Blouse10
005Skirt12
006Dress8
007Shirt10
008Blouse10
009Dress8
010Shirt10
011Dress12
012Skirt12
013Skirt10
014Shirt10
015Dress8
016Shirt10
017Blouse10
018Blouse8
019Dress10
020Skirt8
Most frequently ordered size : 10
 =MODE(D33:D52)
Count of size 8 : 6
 =COUNTIF(D33:D52,”8″)
 
Count of size 10 : 11
 =COUNTIF(D33:D52,”10″)
 
Count of size 12 : 3
 =COUNTIF(D33:D52,”12″)
 

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!

share:

Leave a comment