View Single Post
  #1   Report Post  
N.C. Arens
 
Posts: n/a
Default Variance calculation

MS Excel 11.0 continues to have the same problem it has had forever. For
reasons I haven't been able to work out, it occasionally returnes negative
variance or some positive value that is completely wrong. Based on the
formula used to calculate variance as described in the documentation, a
negative value is impossible. What gives?