Google Documents Spreadsheet Formula for median?

[Covered_In_Bees]

Hello all!

See the subject, basically.

Is there a formula for a Google spreadsheet that calculates the mean of a given range of cells? Don’t need anything complicated, this is a simple project.

There are HARMEAN, GEOMEAN and TRIMMEAN, but none of them return a correct value after I double check their work. Hell, the last one I don’t even know how to correctly enter the values.

If you have an even number of values, the mean is the average of the two in the middle, correct? Gotta make sure I’m not doing it wrong.

[RitterSport]

@Covered_In_Bees

Hello all!

See the subject, basically.

Is there a formula for a Google spreadsheet that calculates the mean of a given range of cells? Don’t need anything complicated, this is a simple project.

There are HARMEAN, GEOMEAN and TRIMMEAN, but none of them return a correct value after I double check their work. Hell, the last one I don’t even know how to correctly enter the values.

If you have an even number of values, the mean is the average of the two in the middle, correct? Gotta make sure I’m not doing it wrong.

AVERAGE as in:

=AVERAGE(A1:A5)

[thelurkinghorror]

=AVERAGE() just like Excel. I wish both had “synonyms.”

[Covered_In_Bees]

Well I’m an idiot.

I mean "median. :smack::o
EDIT: :smack::smack::smack::smack:

[Gukumatz]

Edited thread title from “mean” to “median.” Also added extra padding.

• Gukumatz

[thelurkinghorror]

Isn’t it just =MEDIAN() ?

If not I can try to figure out a formula.

[Covered_In_Bees]

Well I’m still an idiot.

=MEDIAN() worked.

I swear I did a search in the help topics for “median” and nothing came up! In either case, this thread inspired a new one that I strongly urge you to contribute to.