 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006MODE
XL2002 SP3 Win XP HE i have a problem with MODE function which seems to return an incorrect value. "MODE(number1,number2,...) Number1, number2, ... are 1 to 30 arguments for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas." My array is much larger than 30 values. Could it be the reason for the incorrect value returned by MODE? If so, is there an alternative function to calculate it dynamically--without using the static ANOVA tables, etc.? tx! -- An array reference such as A1:A100 is a single argument. SO that is NOT the problem Have you tried it with a small dataset for which MODE can be found manually? How do you know you are getting the wrong value? best wishes  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > XL2002 SP3 > Win XP HE [quoted text clipped - 15 lines] > > tx! It's obvious I am getting the wrong value but if it's not the 30 data points then I myself must be doing something wrong. I'll have to look at it more closely on a different smaller dataset as you suggest. I'll post here again. Thanks Signature> An array reference such as A1:A100 is a single argument. SO that is > NOT the problem Have you tried it with a small dataset for which MODE > can be found manually? How do you know you are getting the wrong > value? best wishes Want to send me (my private email address) a sample file ? best wishes SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > It's obvious I am getting the wrong value but if it's not the 30 data > points then I myself must be doing something wrong. [quoted text clipped - 8 lines] >> can be found manually? How do you know you are getting the wrong >> value? best wishes I might. Let me check on it 1st. Thanks for the offer. Signature> Want to send me (my private email address) a sample file ? > best wishes
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.