View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default STDEV (1st, 2nd, 3rd) and excluding datapoints

On Jun 8, 6:37*pm, Tom wrote:
Excel 2003 SP3
3000+/- data points in a row-by-row listing (A2 through A3001)


It is called a column.

STDEV provides the 1st standard deviation.
1) Unless I'm missing something, how do I do 2nd and 3rd standard
deviation calculations?


2*STDEV(...) and 3*STDEV(...).

2) Some of my data is 'fringe' data. *That is, by eyeballing the data
I'm seeing some data that doesn't easily 'fit'. *
* * a) Can I eliminate the 'fringe' data somehow via a formula?
* * b) Can I analyze ONLY the 'fringe' data?
* * c) How do I quantify the 'fringe' data for exclusion or inclusion?


Elimination of "fringe" data is a debatable issue. Avoid doing it
unless and until you know more about statistics.

(You could google for the term "outliers". But again, it is a
debatable issue, especially for you.)