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
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".
Sincerely,Please Login or Register to view this content.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks