Sunday, 7 December 2014

Getting Average ignoring Zero (0)

Consider the fact that if we include data points with 0 while getting the average.This would give incorrect result. As count would also increase resulting low average. Example take out the average of 0 and 20 this would give 10. Actually it should be 20.

The best way to use average formula is passing the criteria  "<>0" i.e where data is not equal to zero.


No comments:

Post a Comment