count-non-empty#1

declare %:private function excel:count-non-empty(
    $numbers as xs:anyAtomicType*
) as xs:integer

Function for average function. This function should not be used outside this module. It counts all non-empty arguments from the sequence. The string value of every argument is used for checking.

average#1

declare function excel:average(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Returns the average (arithmetic mean) of the arguments. Arguments can be empty values, otherwise must be castable to numeric. If sequence is empty then zero is returned. The sequence can be of any length.

count#1

declare function excel:count(
    $numbers as xs:anyAtomicType*
) as xs:integer

Counts the number of cells that contain numbers or values castable to numeric.

countblank#1

declare function excel:countblank(
    $cells as xs:anyAtomicType*
) as xs:integer

Counts the empty values in a sequence. The empty values are the ones with string value "". The value 0 is not counted.

max#1

declare function excel:max(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Returns the largest number in a sequence.

min#1

declare function excel:min(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Returns the smallest number in a sequence.

median#1

declare function excel:median(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Returns the median of the given numbers. The median is the number in the middle of a set of numbers. Half the numbers have values that are greater than the median, and half the numbers have values that are less than the median.

mode#1

declare function excel:mode(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Returns the most frequently occurring, or repetitive, value in a sequence. Arguments must be castable to numeric.

percentile#2

declare function excel:percentile(
    $numbers as xs:anyAtomicType*,
    $k_at as xs:anyAtomicType
) as xs:anyAtomicType

Returns the k-th percentile of values in a sequence. If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile. The function is computed by (max-min)*k + min

sum-deviations#2

declare %:private function excel:sum-deviations(
    $numbers as xs:anyAtomicType*,
    $average as xs:anyAtomicType
) as xs:anyAtomicType

Function for AVEDEV. This function should not be used outside this module. Computes formula sum(abs(x - average)) for every x in $numbers

avedev#1

declare function excel:avedev(
    $numbers as xs:anyAtomicType+
) as xs:anyAtomicType

Returns the average of the absolute deviations of data points from their mean. The formula is sum(abs(x - average_x))/n, where n is the count of x in the sequence.

add-all-cells#1

declare %:private function excel:add-all-cells(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Function for AVERAGEA. This function should not be used outside this module. This function adds all values that are castable to numeric.

averagea#1

declare function excel:averagea(
    $numbers as xs:anyAtomicType+
) as xs:anyAtomicType

Calculates the average (arithmetic mean) of the values in the sequence of arguments. Arguments can be of any type. The numbers are added, and the sum is divided by the size of entire sequence.

counta#1

declare function excel:counta(
    $numbers as xs:anyAtomicType*
) as xs:integer

Counts the number of values that are not empty. Empty values are the one with string value "".

large#2

declare function excel:large(
    $numbers as xs:anyAtomicType*,
    $k as xs:integer
) as xs:anyAtomicType

Returns the k-th largest value in a data set. If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.

maxa#1

declare function excel:maxa(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Returns the largest value in a list of arguments. In this implementation there is no difference between MAX and MAXA.

mina#1

declare function excel:mina(
    $numbers as xs:anyAtomicType*
) as xs:anyAtomicType

Returns the smallest value in a list of arguments. In this implementation there is no difference between MAX and MAXA.

rank#3

declare function excel:rank(
    $x as xs:anyAtomicType,
    $numbers as xs:anyAtomicType*,
    $order_ascending as xs:boolean
) as xs:decimal

Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.) RANK gives duplicate numbers the same rank.

rank#2

declare function excel:rank(
    $x as xs:anyAtomicType,
    $numbers as xs:anyAtomicType*
) as xs:decimal

This RANK function is same as the above, only that $order_ascending is set by default to false.

percentrank#2

declare function excel:percentrank(
    $numbers as xs:anyAtomicType*,
    $x as xs:anyAtomicType
) as xs:decimal

quartile#2

declare function excel:quartile(
    $numbers as xs:anyAtomicType*,
    $quart as xs:integer
) as xs:anyAtomicType

Returns the quartile of a data set.

small#2

declare function excel:small(
    $numbers as xs:anyAtomicType*,
    $k as xs:integer
) as xs:anyAtomicType

This function computes the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set. If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equals the largest value.

sumsq-deviations#2

declare %:private function excel:sumsq-deviations(
    $numbers as xs:anyAtomicType*,
    $average as xs:anyAtomicType
) as xs:anyAtomicType

Function for VAR, VARA, VARP, VARPA and SLOPE. This function should not be used outside this module. It computes formula sum((x - average_x)^2) for all x in $numbers.

var#1

declare function excel:var(
    $numbers as xs:anyAtomicType+
) as xs:anyAtomicType

vara#1

declare function excel:vara(
    $numbers as xs:anyAtomicType+
) as xs:anyAtomicType

varp#1

declare function excel:varp(
    $numbers as xs:anyAtomicType+
) as xs:anyAtomicType

varpa#1

declare function excel:varpa(
    $numbers as xs:anyAtomicType+
) as xs:anyAtomicType

sum-prob#1

declare %:private function excel:sum-prob(
    $prob_range as xs:anyAtomicType*
) as xs:anyAtomicType

Function for PROB function. This function should not be used outside this module. Computes the sum over a sequence of numbers. Checks if the values are between 0 and 1.

sum-prob-x#4

declare %:private function excel:sum-prob-x(
    $x_range as xs:anyAtomicType*,
    $prob_range as xs:anyAtomicType*,
    $range_lower_limit as xs:anyAtomicType,
    $upper_limit as xs:anyAtomicType
) as xs:anyAtomicType

Function for PROB function. This function should not be used outside this module. Checks the prob range and x range if they have the same number of values. Adds all probabilities corresponding to values between range_lower_limit and upper_limit.

prob#4

declare function excel:prob(
    $x_range as xs:anyAtomicType+,
    $prob_range as xs:anyAtomicType+,
    $range_lower_limit as xs:anyAtomicType,
    $upper_limit as xs:anyAtomicType
) as xs:anyAtomicType

Returns the probability that values in a range are between two limits.

prob#3

declare function excel:prob(
    $x_range as xs:anyAtomicType+,
    $prob_range as xs:anyAtomicType+,
    $range_lower_limit as xs:anyAtomicType
) as xs:anyAtomicType

This is the same as above, only that upper_limit is not specified. The probability is computed only for range_lower_limit.

sum-x-y-deviations#4

declare %:private function excel:sum-x-y-deviations(
    $x_numbers as xs:anyAtomicType*,
    $x_average as xs:anyAtomicType,
    $y_numbers as xs:anyAtomicType*,
    $y_average as xs:anyAtomicType
) as xs:anyAtomicType

slope#2

declare function excel:slope(
    $known_y as xs:anyAtomicType+,
    $known_x as xs:anyAtomicType+
) as xs:anyAtomicType

standardize#3

declare function excel:standardize(
    $x as xs:anyAtomicType,
    $mean as xs:anyAtomicType,
    $standard_dev as xs:anyAtomicType
) as xs:double