STDEV down, but not across, two cols??

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I don't understand Standard Deviation very well - I was just told to use
this function. Up 'til now, I've only had one column of numbers. Now I
have two columns of five data points each. Each set across is one pair (two
measurements of the same item).

I don't think they want the STDEV between the paired points included in the
calculations, only between the individual pairs. So how do I reduce this to
only five data points and still get a valid STDEV? Or have I asked an
irrational question because I don't know STDEV?

ED
 
standard deviation is the parameter for the spread of the data. If the data is distributed in what is called "normal" distribution 95% data will be between mean plus or minus 2 times standard deviation. standarad deviation is for one set of data whether in one column or in 2 columns. when you talk of pairs perhaps you are thinking of "correlation". read some elementary statistics book in your library. regards.
 
Back
Top