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

[cheryl fogle]

Yes, sorting by ascending and manually separating data points is an option.
Though I wanted to run a function because I have both width and thickness
measurements and thought the program might be faster at that task. 

-----Original Message-----
From: nfb-science-bounces at nfbnet.org [mailto:nfb-science-bounces at nfbnet.org]
On Behalf Of Christine Szostak
Sent: Monday, September 06, 2010 3:09 PM
To: NFB Science and Engineering Division List
Subject: Re: [Nfb-science] excel question using the "if" function

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 


_______________________________________________
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/cfogle%40unm.ed
u