Cell formula functions

Find the functions you can use in sheet formulas and consult the documented contract and operands of each one.

How to use this family

Enter the name in the cell or use Insert formula. The families array_unary, array_binary, array_compare, array_mask and array_reduce work on declared forms. Logical masks can come from a comparison. A reduction returns a summary; a transformation keeps the form according to the contract. Open the syntax for references, ranges, types and units.

Function index

complex

Builds a complex number.

Arguments
real imaginary
Shape rule
data_only
Unit rule
Units declared by whoever prepares the inputs.
Provider
viewer.scientific_worksheet · SCIENTIFIC_WORKSHEET_API_v1

Try in cell with =complex(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

empty

Builds an empty operand.

Shape rule
data_only
Unit rule
Units declared by whoever prepares the inputs.
Provider
viewer.scientific_worksheet · SCIENTIFIC_WORKSHEET_API_v1

Try in cell with =empty(). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

field

Reads a field from a public result.

Arguments
result field_name
Shape rule
data_only
Unit rule
Units declared by whoever prepares the inputs.
Provider
viewer.scientific_worksheet · SCIENTIFIC_WORKSHEET_API_v1

Try =field(numeric.statistics(vector(1,2,3)),"mean"). The mean field returns 2.

Back to the list

matrix

Builds a matrix from data and dimensions.

Arguments
values rows columns
Shape rule
data_only
Unit rule
Units declared by whoever prepares the inputs.
Provider
viewer.scientific_worksheet · SCIENTIFIC_WORKSHEET_API_v1

Try in cell with =matrix(vector(1,2,3,4),2,2). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.abs

Absolute value.

Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.abs(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.acos

Arccosine.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.acos(0.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.add

Sum of the operands.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.add(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.all

Checks whether all logical elements are true.

Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.all(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.any

Checks whether at least one logical element is true.

Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.any(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.argmax

Position of the maximum.

Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.argmax(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.argmin

Position of the minimum.

Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.argmin(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.add

Sum of the operands.

Signature
numeric.array_binary.add(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.add(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.atan2

Angle computed from the two coordinates, preserving the quadrant.

Signature
numeric.array_binary.atan2(y, x)
Arguments
y x
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.atan2(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.divide

Quotient.

Signature
numeric.array_binary.divide(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
divide
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.divide(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.hypot

Euclidean norm, square root of the sum of the squares of the two inputs.

Signature
numeric.array_binary.hypot(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.hypot(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.maximum

Maximum. In binary combinations it is the element-wise maximum.

Signature
numeric.array_binary.maximum(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.maximum(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.minimum

Minimum. In binary combinations it is the element-wise minimum.

Signature
numeric.array_binary.minimum(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.minimum(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.multiply

Product.

Signature
numeric.array_binary.multiply(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
multiply
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.multiply(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.power

Power with base and exponent.

Signature
numeric.array_binary.power(base, exponent)
Arguments
base exponent
Shape rule
equal_shape_or_scalar
Unit rule
power
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.power(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_binary.subtract

Difference between the first and second operands.

Signature
numeric.array_binary.subtract(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_binary.subtract(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_compare.equal

True when the two values coincide.

Signature
numeric.array_compare.equal(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_compare.equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_compare.greater_equal

Greater-than-or-equal comparison.

Signature
numeric.array_compare.greater_equal(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_compare.greater_equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_compare.greater_than

Strictly-greater comparison.

Signature
numeric.array_compare.greater_than(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_compare.greater_than(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_compare.less_equal

Less-than-or-equal comparison.

Signature
numeric.array_compare.less_equal(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_compare.less_equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_compare.less_than

Strictly-less comparison.

Signature
numeric.array_compare.less_than(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_compare.less_than(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_compare.not_equal

Inequality comparison.

Signature
numeric.array_compare.not_equal(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_compare.not_equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_mask.logical_and

Conjunction of masks.

Signature
numeric.array_mask.logical_and(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_mask.logical_and(numeric.greater_than(vector(1,2,4),1),numeric.less_than(vector(1,2,4),4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_mask.logical_not

Logical complement.

Signature
numeric.array_mask.logical_not(mask)
Arguments
mask
Shape rule
same_as_input
Unit rule
dimensionless
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_mask.logical_not(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_mask.logical_or

Disjunction of masks.

Signature
numeric.array_mask.logical_or(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_mask.logical_or(numeric.greater_than(vector(1,2,4),1),numeric.less_than(vector(1,2,4),4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_mask.logical_xor

True when the two logical operands differ.

Signature
numeric.array_mask.logical_xor(left, right)
Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_mask.logical_xor(numeric.greater_than(vector(1,2,4),1),numeric.less_than(vector(1,2,4),4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.all

Checks whether all logical elements are true.

Signature
numeric.array_reduce.all(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.all(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.any

Checks whether at least one logical element is true.

Signature
numeric.array_reduce.any(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.any(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.argmax

Position of the maximum.

Signature
numeric.array_reduce.argmax(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.argmax(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.argmin

Position of the minimum.

Signature
numeric.array_reduce.argmin(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.argmin(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.count

Count of the elements.

Signature
numeric.array_reduce.count(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.count(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.count_true

Count of the true elements.

Signature
numeric.array_reduce.count_true(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.count_true(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.maximum

Maximum. In binary combinations it is the element-wise maximum.

Signature
numeric.array_reduce.maximum(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.maximum(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.mean

Arithmetic mean of the admitted values.

Signature
numeric.array_reduce.mean(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.mean(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.median

Median of the admitted values.

Signature
numeric.array_reduce.median(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.median(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.minimum

Minimum. In binary combinations it is the element-wise minimum.

Signature
numeric.array_reduce.minimum(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.minimum(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.product

Product of the series values.

Signature
numeric.array_reduce.product(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
power_by_count
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.product(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.quantile

Value for the requested probability.

Signature
numeric.array_reduce.quantile(values, probability)
Arguments
values probability
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.quantile(vector(1,2,4),0.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.rms

Root mean square.

Signature
numeric.array_reduce.rms(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.rms(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.std_population

Standard deviation of the observed population.

Signature
numeric.array_reduce.std_population(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.std_population(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.std_sample

Sample standard deviation.

Signature
numeric.array_reduce.std_sample(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.std_sample(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.sum

Sum of the values of the series.

Signature
numeric.array_reduce.sum(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.sum(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.valid_count

Count of the valid values.

Signature
numeric.array_reduce.valid_count(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.valid_count(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.variance_population

Variance of the observed population.

Signature
numeric.array_reduce.variance_population(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
square
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.variance_population(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_reduce.variance_sample

Sample variance.

Signature
numeric.array_reduce.variance_sample(values)
Arguments
values
Shape rule
axis_reduction
Unit rule
square
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_reduce.variance_sample(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_select

Selection according to a mask.

Signature
numeric.array_select(values, mask)
Arguments
values mask
Shape rule
mask_matches_values
Unit rule
Keep the relevant unit.
Result shape
vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_select(vector(1,2,4),numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.abs

Absolute value.

Signature
numeric.array_unary.abs(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.abs(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.acos

Arccosine.

Signature
numeric.array_unary.acos(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.acos(0.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.asin

Arcsine.

Signature
numeric.array_unary.asin(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.asin(0.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.atan

Arctangent.

Signature
numeric.array_unary.atan(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.atan(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.ceil

Ceiling (round up to an integer).

Signature
numeric.array_unary.ceil(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.ceil(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.cos

Cosine.

Signature
numeric.array_unary.cos(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.cos(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.cosh

Hyperbolic cosine.

Signature
numeric.array_unary.cosh(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.cosh(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.exp

Natural exponential.

Signature
numeric.array_unary.exp(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.exp(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.expm1

Natural exponential minus one.

Signature
numeric.array_unary.expm1(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.expm1(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.floor

Floor (round down to an integer).

Signature
numeric.array_unary.floor(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.floor(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.is_finite

Finite-value indicator.

Signature
numeric.array_unary.is_finite(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.is_finite(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.is_inf

Infinity indicator.

Signature
numeric.array_unary.is_inf(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.is_inf(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.is_nan

NaN indicator.

Signature
numeric.array_unary.is_nan(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.is_nan(numeric.divide(0,1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.is_neg_inf

Negative-infinity indicator.

Signature
numeric.array_unary.is_neg_inf(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.is_neg_inf(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.is_pos_inf

Positive-infinity indicator.

Signature
numeric.array_unary.is_pos_inf(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.is_pos_inf(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.log

Natural logarithm.

Signature
numeric.array_unary.log(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.log(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.log1p

Natural logarithm of one plus the value.

Signature
numeric.array_unary.log1p(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.log1p(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.log10

Base-10 logarithm.

Signature
numeric.array_unary.log10(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.log10(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.negate

Negative of the value.

Signature
numeric.array_unary.negate(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.negate(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.reciprocal

Multiplicative inverse.

Signature
numeric.array_unary.reciprocal(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
reciprocal
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.reciprocal(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.round

Rounding.

Signature
numeric.array_unary.round(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.round(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.sign

Sign of the value.

Signature
numeric.array_unary.sign(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.sign(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.sin

Sine.

Signature
numeric.array_unary.sin(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.sin(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.sinh

Hyperbolic sine.

Signature
numeric.array_unary.sinh(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.sinh(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.sqrt

Square root.

Signature
numeric.array_unary.sqrt(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
square_root
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.sqrt(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.square

Square.

Signature
numeric.array_unary.square(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
square
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.square(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.tan

Tangent.

Signature
numeric.array_unary.tan(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.tan(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_unary.tanh

Hyperbolic tangent.

Signature
numeric.array_unary.tanh(operand)
Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_unary.tanh(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.array_where

Element-wise choice according to a mask.

Signature
numeric.array_where(mask, true_values, false_values)
Arguments
mask true_values false_values
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.array_where(numeric.greater_than(vector(1,2,4),1),vector(8,9,10),vector(1,2,3)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.asin

Arcsine.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.asin(0.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.atan

Arctangent.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.atan(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.atan2

Angle computed from the two coordinates, preserving the quadrant.

Arguments
y x
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.atan2(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.ceil

Ceiling (round up to an integer).

Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.ceil(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.correlation

Pairing of aligned series.

Signature
numeric.correlation(x, y)
Arguments
x y
Shape rule
same_length
Unit rule
Dimensionless output.
Result shape
scalar_fields
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.correlation(vector(1,2,3),vector(2,4,7)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.cos

Cosine.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.cos(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.cosh

Hyperbolic cosine.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.cosh(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.count

Count of the elements.

Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.count(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.count_true

Count of the true elements.

Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.count_true(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.covariance

Covariance of two paired series.

Signature
numeric.covariance(x, y)
Arguments
x y
Shape rule
same_length
Unit rule
multiply
Result shape
scalar_fields
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.covariance(vector(1,2,3),vector(2,4,7)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.cumulative_integral

Cumulative integral.

Arguments
x y
Shape rule
same_length_xy
Unit rule
multiply
Result shape
vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.cumulative_integral(vector(1,2,3),vector(2,4,7)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.cumulative_integrate

Cumulative integral.

Signature
numeric.cumulative_integrate(x, y)
Arguments
x y
Shape rule
same_length_xy
Unit rule
multiply
Result shape
vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.cumulative_integrate(vector(1,2,3),vector(2,4,7)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.differentiate

Derivative with respect to the abscissa.

Signature
numeric.differentiate(x, y)
Arguments
x y
Shape rule
same_length_xy
Unit rule
differentiate
Result shape
vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.differentiate(vector(1,2,3),vector(2,4,7)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.divide

Quotient.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
divide
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.divide(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.equal

True when the two values coincide.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.exp

Natural exponential.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.exp(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.expm1

Natural exponential minus one.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.expm1(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.floor

Floor (round down to an integer).

Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.floor(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.greater_equal

Greater-than-or-equal comparison.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.greater_equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.greater_than

Strictly-greater comparison.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.greater_than(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.hypot

Euclidean norm, square root of the sum of the squares of the two inputs.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.hypot(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.integrate

Integral with respect to the abscissa.

Signature
numeric.integrate(x, y)
Arguments
x y
Shape rule
same_length_xy
Unit rule
multiply
Result shape
scalar
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.integrate(vector(1,2,3),vector(2,4,7)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.interpolate

Interpolated evaluation at the requested points.

Signature
numeric.interpolate(x, y, target_x)
Arguments
x y target_x
Shape rule
same_length_xy
Unit rule
preserve_y
Result shape
target_vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.interpolate(vector(1,2,3),vector(2,4,7),vector(1.5,2.5)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.is_finite

Finite-value indicator.

Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.is_finite(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.is_inf

Infinity indicator.

Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.is_inf(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.is_nan

NaN indicator.

Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.is_nan(numeric.divide(0,1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.is_neg_inf

Negative-infinity indicator.

Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.is_neg_inf(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.is_pos_inf

Positive-infinity indicator.

Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.is_pos_inf(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.less_equal

Less-than-or-equal comparison.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.less_equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.less_than

Strictly-less comparison.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.less_than(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.log

Natural logarithm.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.log(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.log1p

Natural logarithm of one plus the value.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.log1p(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.log10

Base-10 logarithm.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.log10(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.logical_and

Conjunction of masks.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.logical_and(numeric.greater_than(vector(1,2,4),1),numeric.less_than(vector(1,2,4),4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.logical_not

Logical complement.

Arguments
mask
Shape rule
same_as_input
Unit rule
dimensionless
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.logical_not(numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.logical_or

Disjunction of masks.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.logical_or(numeric.greater_than(vector(1,2,4),1),numeric.less_than(vector(1,2,4),4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.logical_xor

True when the two logical operands differ.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.logical_xor(numeric.greater_than(vector(1,2,4),1),numeric.less_than(vector(1,2,4),4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.mad

Median absolute deviation from the median.

Signature
numeric.mad(values)
Arguments
values
Shape rule
vector
Unit rule
Keep the relevant unit.
Result shape
scalar_fields
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.mad(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.max

Maximum of the series.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.max(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.maximum

Maximum. In binary combinations it is the element-wise maximum.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.maximum(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.mean

Arithmetic mean of the admitted values.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.mean(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.median

Median of the admitted values.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.median(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.min

Minimum of the series.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.min(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.minimum

Minimum. In binary combinations it is the element-wise minimum.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.minimum(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.multiply

Product.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
multiply
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.multiply(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.negate

Negative of the value.

Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.negate(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.not_equal

Inequality comparison.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible_to_dimensionless
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.not_equal(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.power

Power with base and exponent.

Arguments
base exponent
Shape rule
equal_shape_or_scalar
Unit rule
power
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.power(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.product

Product of the series values.

Arguments
values
Shape rule
axis_reduction
Unit rule
power_by_count
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.product(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.quantile

Value for the requested probability.

Arguments
values probability
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.quantile(vector(1,2,4),0.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.rank

Ranks of the elements.

Signature
numeric.rank(values)
Arguments
values
Shape rule
vector
Unit rule
Dimensionless output.
Result shape
vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.rank(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.reciprocal

Multiplicative inverse.

Arguments
operand
Shape rule
same_as_input
Unit rule
reciprocal
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.reciprocal(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.resample

Resampling on the new coordinates.

Signature
numeric.resample(x, y, target_x)
Arguments
x y target_x
Shape rule
same_length_xy
Unit rule
preserve_y
Result shape
target_vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.resample(vector(1,2,3),vector(2,4,7),vector(1.5,2.5)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.rms

Root mean square.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.rms(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.round

Rounding.

Arguments
operand
Shape rule
same_as_input
Unit rule
Keep the relevant unit.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.round(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.select

Selection of the elements admitted by the mask.

Arguments
values mask
Shape rule
mask_matches_values
Unit rule
Keep the relevant unit.
Result shape
vector
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.select(vector(1,2,4),numeric.greater_than(vector(1,2,4),1)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.sign

Sign of the value.

Arguments
operand
Shape rule
same_as_input
Unit rule
Dimensionless output.
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.sign(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.sin

Sine.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.sin(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.sinh

Hyperbolic sine.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.sinh(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.sqrt

Square root.

Arguments
operand
Shape rule
same_as_input
Unit rule
square_root
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.sqrt(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.square

Square.

Arguments
operand
Shape rule
same_as_input
Unit rule
square
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.square(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.std

Sample standard deviation.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.std(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.std_population

Standard deviation of the observed population.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.std_population(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.subtract

Difference between the first and second operands.

Arguments
left right
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.subtract(2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.sum

Sum of the values of the series.

Arguments
values
Shape rule
axis_reduction
Unit rule
Keep the relevant unit.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.sum(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.tan

Tangent.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.tan(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.tanh

Hyperbolic tangent.

Arguments
operand
Shape rule
same_as_input
Unit rule
dimensionless_input_output
Result shape
same_as_input
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.tanh(1.5). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.valid_count

Count of the valid values.

Arguments
values
Shape rule
axis_reduction
Unit rule
Dimensionless output.
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.valid_count(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.variance_population

Variance of the observed population.

Arguments
values
Shape rule
axis_reduction
Unit rule
square
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.variance_population(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.variance_sample

Sample variance.

Arguments
values
Shape rule
axis_reduction
Unit rule
square
Result shape
axis_reduced
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.variance_sample(vector(1,2,4)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

numeric.where

Element-wise choice between two inputs according to the mask.

Arguments
mask true_values false_values
Shape rule
equal_shape_or_scalar
Unit rule
compatible
Result shape
common_shape
Provider
math.numeric · NUMERIC_API_v1

Try in cell with =numeric.where(numeric.greater_than(vector(1,2,4),1),vector(8,9,10),vector(1,2,3)). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

record

Builds a field-based operand (record).

Arguments
name value...
Shape rule
data_only
Unit rule
Units declared by whoever prepares the inputs.
Provider
viewer.scientific_worksheet · SCIENTIFIC_WORKSHEET_API_v1

Try in cell with =record("datum",7). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list

vector

Builds a vector.

Arguments
value...
Shape rule
data_only
Unit rule
Units declared by whoever prepares the inputs.
Provider
viewer.scientific_worksheet · SCIENTIFIC_WORKSHEET_API_v1

Try in cell with =vector(1,2,3). Check the result and, for a vector or matrix, free the adjacent cells.

Back to the list