This function type relates to descriptive statistical analysis. Statistical functions can be used across all calculation types (regular, text, option, table, historical).

The sprint testing examples below assume that the following values are entered for number fields named Sprint 1 through to Sprint 5. 

Sprint 1 = 4.434
Sprint 2 = 4.597
Sprint 3 = 4.561
Sprint 4 = 4.482
Sprint 5 = 4.545
  • count: counts the number of items given
count(5,3,2,9,19,24) = 6
count("football", "cricket", "swimming") = 3
  • max: calculates the maximum value of a range
max(39, 41, 40, 28, 34) = 41

max(Sprint 1, Sprint 2, Sprint 3, Sprint 4, Sprint 5) = 4.597
  • min: calculates the minimum value of a range
min(120, 124, 119, 134, 129) = 119

min(Sprint 1, Sprint 2, Sprint 3, Sprint 4, Sprint 5) = 4.434
  • mean: calculates the mean value of all values within a range
mean(Sprint 1, Sprint 2, Sprint 3, Sprint 4, Sprint 5) = 4.5238
  • median: returns the median value of a range
median(Sprint 1, Sprint 2, Sprint 3, Sprint 4, Sprint 5) = 4.545
  • nthmax: returns the nth largest value of a range, with n being any positive whole number
  • nthmin: returns the nth smallest value of a range, with n being any positive whole number
  • sem: calculates the standard error of the mean from a range of values
  • stddev: calculates the standard deviation of a range of values
  • var: calculates the variance of a range of values