Remember Me?

#1
May 19th 05, 10:33 PM
 vmagal1 Posts: n/a
MODE FORMULA ERROR

When I try to use the mode function on a set of values, I get #N/A back as my

#2
May 19th 05, 11:24 PM
 Pat Flynn Posts: n/a

If the data set contains no duplicate data points, MODE returns the #N/A
error value.
Does your data contain duplicate data points? If not you want to look for
MEAN or MEDIAN.
Else post an example for us to look at.
Regards,
Pat

"vmagal1" wrote:

When I try to use the mode function on a set of values, I get #N/A back as my

#3
May 20th 05, 07:27 PM
 vmagal1 Posts: n/a

Well I figured out the problem. I was using the mode function on cells that
were calculated using a formula. I guess it didn't like that.

"Pat Flynn" wrote:

If the data set contains no duplicate data points, MODE returns the #N/A
error value.
Does your data contain duplicate data points? If not you want to look for
MEAN or MEDIAN.
Else post an example for us to look at.
Regards,
Pat

"vmagal1" wrote:

When I try to use the mode function on a set of values, I get #N/A back as my

#4
May 20th 05, 07:49 PM
 Harlan Grove Posts: n/a

vmagal1 wrote...
Well I figured out the problem. I was using the mode function on

cells that
were calculated using a formula. I guess it didn't like that.

....

Not the problem. If I enter the formula

=INT(1+5*RAND())

in A1:A20, MODE(A1:A20) works just fine, returning the mode of the
formula-generated values in A1:A20.

Far more likely your problem is due to number formatting that makes
many of your formulas appear to produce the same value when there are
actually differences. If I enter the formula

=5*RAND()+0.5

in B1:B20 and replace the formulas in A1:A20 with

A1:
=ROUND(B1,0)

and format A1:B20 as numbers with zero decimal places, A1:A20 and
B1:B20 appear identical, but MODE(A1:A20) returns a number while
MODE(B1:B20) returns #N/A.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Joshua Fandango Excel Discussion (Misc queries) 3 March 29th 05 01:27 PM Jambruins Excel Discussion (Misc queries) 2 February 24th 05 09:57 PM Mike R Excel Discussion (Misc queries) 6 January 15th 05 05:27 AM lbaskin Excel Discussion (Misc queries) 1 January 13th 05 03:05 AM peterfc2 Excel Worksheet Functions 0 November 8th 04 05:53 PM

All times are GMT +1. The time now is 11:15 AM.