Mean, median and mode

Is there a good/easy formula to use when trying to find the mean, median and mode for a column? If so, can someone post it? I'd like to make it as easy as possible (obviously!).

Thanks

Hello Brandon,

Excel contains the following formulas to do this. This example is for column "A".

Please Login or Register  to view this content.

Sincerely,
Leith Ross

mean is average mean from statistical functions so for column c
=AVERAGE(C:C)
oh there was i looking them up and lr beat me to it again

Works like a charm! Thanks a million!

OK, so it worked REALLY well but of course a twist is now thrown into the mix.

Suppose my numbers are in column L. If the report is marked as unsigned it will have a U in column K and L will read as -38,000 or other very high number. This number skews my data.

Is there a if/then statement I can add to the =AVERAGE to say if column K = U then do not add this data into the average?

Thanks

You can use an "array formula" like this

=IF(K2:K100<>"U",IF(L2:L100,L2:L100)))

needs to be confirmed with CTRL+SHIFT+ENTER

That doesn't seem to be doing the trick. In line 46808 I put this in:

=IF(M2:M46807<>"U",IF(N2:N46807,N2:N46807))

N is the column with the number of days. Column M has the status (signed, unsigned, incomplete). I just want the signed documents to be averaged. I guess I could sort them by letter and just do the math but automation would be a lot more cool

Thanks!