Mean, median and mode

1. 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   Register To Reply

2. Hello Brandon,

Excel contains the following formulas to do this. This example is for column "A". Sincerely,
Leith Ross  Register To Reply

3. 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  Register To Reply

4. Works like a charm! Thanks a million!  Register To Reply

5. 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   Register To Reply

6. 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  Register To Reply

7. 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!  Register To Reply