MIN

Source

Min returns the smallest (arithmetic mean) of the values in array.

Argument Type Description
array Array Array of numbers.

Returns Float The smallest of the values in array.


RADIANS

Source

Radians returns the angle converted from degrees to radians.

Argument Type Description
number Float Int The input number.

Returns Float The angle in radians.


FLOOR

Source

Floor returns the greatest integer value less than or equal to a given value.

Argument Type Description
number Int Float Input number.

Returns Int The greatest integer value less than or equal to a given value.


PERCENTILE

Source

Percentile returns the nth percentile of the values in a given array.

Argument Type Description
array Array Array of numbers.
numb Int A number which must be between 0 (excluded) and 100 (included).
method String, optional “rank” (default) or “interpolation”.

Returns Float The nth percentile, or null if the array is empty or only null values are contained in it or the percentile cannot be calculated.


LOG10

Source

Log10 returns the decimal logarithm of a given value.

Argument Type Description
number Int Float Input number.

Returns Float The decimal logarithm of a given value.


SIN

Source

Sin returns the sine of the radian argument.

Argument Type Description
number Int Float Input number.

Returns Float The sin, in radians, of a given number.


LOG2

Source

Log2 returns the binary logarithm of a given value.

Argument Type Description
number Int Float Input number.

Returns Float The binary logarithm of a given value.


VARIANCE_POPULATION

Source

PopulationVariance returns the population variance of the values in a given array.

Argument Type Description
array Array Array of numbers.

Returns Float The population variance.


TAN

Source

Tan returns the tangent of a given number.

Argument Type Description
value Int Float A number.

Returns Float The tangent.


AVERAGE

Source

Average Returns the average (arithmetic mean) of the values in array.

Argument Type Description
array Array Array of numbers.

Returns Float The average of the values in array.


DEGREES

Source

Degrees returns the angle converted from radians to degrees.

Argument Type Description
number Float Int The input number.

Returns Float The angle in degrees.l


RANGE

Source

Range returns an array of numbers in the specified range, optionally with increments other than 1.

Argument Type Description
start Int Float The value to start the range at (inclusive).
end Int Float The value to end the range with (inclusive).
step Int Float, optional How much to increment in every step, the default is 1.0.

Returns None


ACOS

Source

Acos returns the arccosine, in radians, of a given number.

Argument Type Description
number Int Float Input number.

Returns Float The arccosine, in radians, of a given number.


RAND

Source

Rand return a pseudo-random number between 0 and 1.

Argument Type Description
max Float Int, optional Upper limit.
min Float Int, optional Lower limit.

Returns Float A number greater than 0 and less than 1.


STDDEV_SAMPLE

Source

StandardDeviationSample returns the sample standard deviation of the values in a given array.

Argument Type Description
array Array Array of numbers.

Returns Float The sample standard deviation.


SUM

Source

Sum returns the sum of the values in a given array.

Argument Type Description
array Array Array of numbers.

Returns Float The sum of the values.


MEDIAN

Source

Median returns the median of the values in array.

Argument Type Description
array Array Array of numbers.

Returns Float The median of the values in array.


ABS

Source

Abs returns the absolute value of a given number.

Argument Type Description
number Int Float Input number.

Returns Float The absolute value of a given number.


ROUND

Source

Round returns the nearest integer, rounding half away from zero.

Argument Type Description
number Int Float Input number.

Returns Int The nearest integer, rounding half away from zero.


STDDEV_POPULATION

Source

StandardDeviationPopulation returns the population standard deviation of the values in a given array.

Argument Type Description
array Array Array of numbers.

Returns Float The population standard deviation.


ATAN2

Source

Atan2 returns the arc tangent of y/x, using the signs of the two to determine the quadrant of the return value.

Argument Type Description
number1 Int Float Input number.
number2 Int Float Input number.

Returns Float The arc tangent of y/x, using the signs of the two to determine the quadrant of the return value.


COS

Source

Cos returns the cosine of a given number.

Argument Type Description
number Int Float Input number.

Returns Float The cosine of a given number.


PI

Source

Pi returns Pi value.

Argument Type Description

Returns Float Pi value.


VARIANCE_SAMPLE

Source

SampleVariance returns the sample variance of the values in a given array.

Argument Type Description
array Array Array of numbers.

Returns Float The sample variance.


ATAN

Source

Atan returns the arctangent, in radians, of a given number.

Argument Type Description
number Int Float Input number.

Returns Float The arctangent, in radians, of a given number.


ASIN

Source

Asin returns the arcsine, in radians, of a given number.

Argument Type Description
number Int Float Input number.

Returns Float The arcsine, in radians, of a given number.


POW

Source

Pow returns the base to the exponent value.

Argument Type Description
base Int Float The base value.
exp Int Float The exponent value.

Returns Float The exponentiated value.


EXP2

Source

Exp2 returns 2 raised to the power of value.

Argument Type Description
number Int Float Input number.

Returns Float 2 raised to the power of value.


CEIL

Source

Ceil returns the least integer value greater than or equal to a given value.

Argument Type Description
number Int Float Input number.

Returns Int The least integer value greater than or equal to a given value.


LOG

Source

Log returns the natural logarithm of a given value.

Argument Type Description
number Int Float Input number.

Returns Float The natural logarithm of a given value.


EXP

Source

Exp returns Euler’s constant (2.71828…) raised to the power of value.

Argument Type Description
number Int Float Input number.

Returns Float Euler’s constant raised to the power of value.


MAX

Source

Max returns the greatest (arithmetic mean) of the values in array.

Argument Type Description
array Array Array of numbers.

Returns Float The greatest of the values in array.


SQRT

Source

Sqrt returns the square root of a given number.

Argument Type Description
value Int Float A number.

Returns Float The square root.