View Single Post
  #1   Report Post  
stevekanc stevekanc is offline
Junior Member
 
Posts: 3
Default 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