Selective Calculation of Mean & Mode
I am trying to calculate average (Mean & Mode) values for a range of numbers but ignoring numbers that are out of character for the dataset.
Example:
Sales per time period: 2,2,4,5,3,76,2,45
How can I identify 76 and 45 as being out of anticpated range of numbers?
Hope you can help,
thanks Steve
|