Module statistical 

Statistical formula functions: AVERAGEIF, AVERAGEIFS, COUNTBLANK, COUNTIF, COUNTIFS, MEDIAN, MODE, LARGE, SMALL, RANK.

Functions

fn_averageif

AVERAGEIF(range, criteria, [average_range])

fn_averageifs

AVERAGEIFS(average_range, criteria_range1, criteria1, …)

fn_countblank

COUNTBLANK(range) - count empty cells in a range

fn_countif

COUNTIF(range, criteria)

fn_countifs

COUNTIFS(range1, criteria1, range2, criteria2, …)

fn_large

LARGE(array, k) - k-th largest value

fn_median

MEDIAN(args…) - median of numeric values

fn_mode

MODE(args…) - most frequently occurring value

fn_rank

RANK(number, ref, [order]) - rank of a number in a list. order=0 or omitted: descending (largest=1). order=nonzero: ascending (smallest=1).

fn_small

SMALL(array, k) - k-th smallest value