• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

multiple mode values in excel

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
AlHal2
Asked:
AlHal2
  • 4
1 Solution
 
barry houdiniCommented:
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
 
AlHal2Author Commented:
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
 
ExcelGuideConsultantCommented:
that would be 1

barryhoudini already gave the explanation why
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
AlHal2Author Commented:
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
 
AlHal2Author Commented:
I've requested that this question be closed as follows:

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

for the following reason:

Partially answered.
0
 
AlHal2Author Commented:
Partially answered
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now