View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Muk Muk is offline
external usenet poster
 
Posts: 10
Default How to measure signal to noise (S/N) of a set of data in Excel?

Hi,

I am dealing with sets of real data and as would be expected there are lots
of 'noise'. I would like to set a baseline so that calculations are
performed only on the data above the baseline. I know that the kurtosis
function shows how "peaked" the data is but I am looking for a data sieve
that ignores the random noise and accepts the real data (say anything five
times higher than random noise).

Thanks