PDA

View Full Version : Eliminate noise in data points



xingmao
10-10-2007, 03:30 PM
I got Column A and B with all my data points. However, there are noise in the datas(twice the average value of data in Column B). I found the average value of data in column B and put the value in Column C.

How do I ignore the noise in Column B and the corresponding Column A as i need further calculation using the datas in those 2 columns.

Thanks

p45cal
10-10-2007, 04:57 PM
see whether the TRIMMEAN function might help you

adjusted post:
On second thoughts, it might not be much use. Sorry.