[Nfb-science] excel question using the "if" function

[Christine Szostak]

Hi,
  This may be too simple for what you want, but it sounds like you could 
just sort based on the data points and if they fall lower or higher than 
your cut-off, you should be easily able to remove them.
Many thanks,
Christine


Christine M. Szostak
Graduate Student
Language Perception Laboratory
Department of Psychology, Cognitive Area
The Ohio State University
Columbus, Ohio
szostak.1 at osu.edu
----- Original Message ----- 
From: "cheryl fogle" <cfogle at unm.edu>
To: "'NFB Science and Engineering Division List'" <nfb-science at nfbnet.org>
Sent: Monday, September 06, 2010 4:11 PM
Subject: [Nfb-science] excel question using the "if" function


> Hi list.
>
> Can anyone who uses excel well write me off list at
> cfogle at unm.edu
>   I'm having some trouble setting up function arguments in excel to
> highlight values that are either less-than or greater-than the 95%
> confidence interval of the mean.  I already calculated the 95% confidence
> limits but with 360 data points, I want a way to make excel highlight 
> values
> that are outside of the range specified by the confidence function. This 
> is
> for several measurements and multiple samples.  So far I haven't found the
> info in the help file but will keep looking :)
>
> I'm trying to get a numerical solution that will allow me to quickly spot
> possible outliers.  My sighted colleagues are eyeballing scatter plots and
> though I can get the university to make tactile plots, it will take at 
> least
> a week and I'm looking for a more precise solution that will allow me to
> order the data in a manner that makes sense to me. Thanks.
>
> Cheryl Fogle
>
> _______________________________________________
> Nfb-science mailing list
> Nfb-science at nfbnet.org
> http://www.nfbnet.org/mailman/listinfo/nfb-science_nfbnet.org
> To unsubscribe, change your list options or get your account info for 
> Nfb-science:
> http://www.nfbnet.org/mailman/options/nfb-science_nfbnet.org/szostak.1%40osu.edu