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
complexemptyfieldmatrixnumeric.absnumeric.acosnumeric.addnumeric.allnumeric.anynumeric.argmaxnumeric.argminnumeric.array_binary.addnumeric.array_binary.atan2numeric.array_binary.dividenumeric.array_binary.hypotnumeric.array_binary.maximumnumeric.array_binary.minimumnumeric.array_binary.multiplynumeric.array_binary.powernumeric.array_binary.subtractnumeric.array_compare.equalnumeric.array_compare.greater_equalnumeric.array_compare.greater_thannumeric.array_compare.less_equalnumeric.array_compare.less_thannumeric.array_compare.not_equalnumeric.array_mask.logical_andnumeric.array_mask.logical_notnumeric.array_mask.logical_ornumeric.array_mask.logical_xornumeric.array_reduce.allnumeric.array_reduce.anynumeric.array_reduce.argmaxnumeric.array_reduce.argminnumeric.array_reduce.countnumeric.array_reduce.count_truenumeric.array_reduce.maximumnumeric.array_reduce.meannumeric.array_reduce.mediannumeric.array_reduce.minimumnumeric.array_reduce.productnumeric.array_reduce.quantilenumeric.array_reduce.rmsnumeric.array_reduce.std_populationnumeric.array_reduce.std_samplenumeric.array_reduce.sumnumeric.array_reduce.valid_countnumeric.array_reduce.variance_populationnumeric.array_reduce.variance_samplenumeric.array_selectnumeric.array_unary.absnumeric.array_unary.acosnumeric.array_unary.asinnumeric.array_unary.atannumeric.array_unary.ceilnumeric.array_unary.cosnumeric.array_unary.coshnumeric.array_unary.expnumeric.array_unary.expm1numeric.array_unary.floornumeric.array_unary.is_finitenumeric.array_unary.is_infnumeric.array_unary.is_nannumeric.array_unary.is_neg_infnumeric.array_unary.is_pos_infnumeric.array_unary.lognumeric.array_unary.log1pnumeric.array_unary.log10numeric.array_unary.negatenumeric.array_unary.reciprocalnumeric.array_unary.roundnumeric.array_unary.signnumeric.array_unary.sinnumeric.array_unary.sinhnumeric.array_unary.sqrtnumeric.array_unary.squarenumeric.array_unary.tannumeric.array_unary.tanhnumeric.array_wherenumeric.asinnumeric.atannumeric.atan2numeric.ceilnumeric.correlationnumeric.cosnumeric.coshnumeric.countnumeric.count_truenumeric.covariancenumeric.cumulative_integralnumeric.cumulative_integratenumeric.differentiatenumeric.dividenumeric.equalnumeric.expnumeric.expm1numeric.floornumeric.greater_equalnumeric.greater_thannumeric.hypotnumeric.integratenumeric.interpolatenumeric.is_finitenumeric.is_infnumeric.is_nannumeric.is_neg_infnumeric.is_pos_infnumeric.less_equalnumeric.less_thannumeric.lognumeric.log1pnumeric.log10numeric.logical_andnumeric.logical_notnumeric.logical_ornumeric.logical_xornumeric.madnumeric.maxnumeric.maximumnumeric.meannumeric.mediannumeric.minnumeric.minimumnumeric.multiplynumeric.negatenumeric.not_equalnumeric.powernumeric.productnumeric.quantilenumeric.ranknumeric.reciprocalnumeric.resamplenumeric.rmsnumeric.roundnumeric.selectnumeric.signnumeric.sinnumeric.sinhnumeric.sqrtnumeric.squarenumeric.stdnumeric.std_populationnumeric.subtractnumeric.sumnumeric.tannumeric.tanhnumeric.valid_countnumeric.variance_populationnumeric.variance_samplenumeric.whererecordvector
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.