View Single Post
  #1   Report Post  
learner
 
Posts: n/a
Default How to find value that is bigger or smaller than 2SD?

I am new to excel, my question may be silly for you. But I really don't know
how to do it and hope to get your help.

I need to do statistic analysis of my data table which has lots of columns.
First of all, in each column, I want to find and highlight the value that is
bigger than mean+two times standard derivation, or smaller than mean-2*
standard derivation. Do you have any suggestions about how to do it?

Thanks alot,

ming