Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,368,974
Community Members
 
Community Events
168
Community Groups

Average and median of values across issues

Hi Team,

I want to understand to average and median formula of values across issues on Time In Status

Regards,

 

Median and Average.JPG

1 answer

0 votes

Welcome to the Atlassian Community!

"Average" is a widely misused word in English.  There are three averages you might be talking about when you use it - mean, median and mode.  Most of us will mean "mean average" when we use it though, and that's what the time-in-status means.

  • A mean average is "add up all the numbers and divide by the number of numbers you added up"
  • A median average is "put the numbers in order and pick out the one in the middle"
  • A mode average is "the number that occurs the most often in the data"

Consider a sequence like 1, 1, 3, 7, 21 - mean = 6.6, median 3, mode 1.

They all have different uses and tell you different things about your data set.  When used together, they can tell you a lot more.  For example, if you look at the "average UK income", the mode won't tell you a lot, but looking at the mean and median immediately screams that there's a massive rich/poor gap.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Atlassian Community Events