Solved

# multiple mode values in excel

Posted on 2012-09-14
244 Views
Suppose I have these 3 series of numbers.
1546221
121323
323121

Which number would the Excel choose as the mode and why?
How can I replicate this methodology in Asp.net 3.5 with VB 2008?
0
Question by:AlHal2

LVL 50

Expert Comment

If you use MODE (or MODE.SNGL in Excel 2010) worksheet function it wouldn't choose any of those - MODE gives you #N/A if there are no duplicate numbers. If 2 or more numbers have the same number of instances it just picks the first instance in the range so if you have

123
345
123
345

Excel picks 123

regards, barry
0

Author Comment

Sorry I didn't make clear.  In each row the numbers are separate.

1,5,4,6,2,2,1 Excel mode is 1
1,2,1,3,2,3   Excel Mode is 1
3,2,3,1,2,1   Excel Mode is 3
0

LVL 17

Accepted Solution

that would be 1

barryhoudini already gave the explanation why
0

Author Comment

What about the second part of my question?  Suppose I have one of the above series in a 1D array.  How do I get the same mode as Excel using vb 2008 in asp.net 3.5?
0

Author Comment

I've requested that this question be closed as follows:

Accepted answer: 0 points for AlHal2's comment #a38398416

for the following reason:

0

Author Closing Comment

0

## Featured Post

### Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …