Microsoft Office Tutorials and References
In Depth Information
Syntax
Figure 14.5.
Figure 14.5. MODE.MULT
MODE.MULT is challenging to use.
is challenging to use.
In row 14 of Figure 14.5 , a nonarray formula counts how many results the
MODE.MULT function will return. Using =COUNT(MODE.MULT(B3:B12)) is
probably the best way to go.
To return the first mode, you can use
=MODE.SNGL(range)
To see whether there is a two-way tie, use
=IF(COUNT(MODE.MULT(range))>1,INDEX(MODE.MULT(range),2),"")
To see whether there is a three-way tie, use
=IF(COUNT(MODE.MULT(range))>2,INDEX(MODE.MULT(range),3),"")
You can continue this pattern for as many possible modes as you might ex-
pect. In an N-row data set, there might be as many as N/2 possible modes!
Search JabSto ::




Custom Search