Introduction
B4P provides a broad range of advanced mathematics and statistics functions.
Procedures and Functions Provided:
checking numbers:
is integer
is integer or blank
is numeric
is numeric or blank
is strictly integer
is strictly integer or blank
is strictly numeric
is strictly numeric or blank
even numbers, odd numbers, whole numbers:
even
odd
whole
zebra
absolute value:
abs
rounding functions:
round
round down
round up
modulo:
mod
random
hex to decimal
distribute amount
Square Root:
cbrt
sqrt
power function:
pow
exponential functions:
10p
exp
logarithmic functions:
ln
log
trigonometric functions:
acos
acos deg
asin
asin deg
atan
atan deg
cos
cos deg
sin
sin deg
tan
tan deg
hyperbolic functions:
acosh
asinh
atanh
cosh
sinh
tanh
Arithmetic and Boolean Series Functions, Two parameter passing methods for series functions:
add
and
div
mul
or
sub
xnor
xor
min and max functions:
max
max ignore blanks
max ignore zero
max ignore zero
min
min ignore blanks
Vectorizable min and max functions:
vmax
vmax 123
vmax abc
vmax abc ignore case
vmax numeral
vmax string
vmax string ignore case
vmin
vmin 123
vmin abc
vmin abc ignore case
vmin numeral
vmin string
vmin string ignore case
min and max functions on strings:
max abc
max abc ignore case
max string
max string ignore case
min abc
min abc ignore blanks
min abc ignore both
min abc ignore case
min string
min string ignore blanks
min string ignore both
min string ignore case
min and max functions on numerals:
max 123
max 124 ignore zero
max numeral
max numeral ignore zero
min 123
min 123 ignore zero
min numeral
min numeral ignore zero
Limit values within lower and upper boundaries:
limit
count functions:
count
count ignore blanks
count ignore both
count ignore zero
Identity Matrix:
identity
matrix multiplication, matrix division:
mdiv
mmul
matrix inversion:
minv
matrix determinant:
mdet
linear equation:
linear
Make matrix horizontal:
horizontal
Make matrix vertical:
vertical
Flatten matrix:
flat
Put values diagonally into matrix:
diagonal
transpose matrix:
transpose
flip matrix:
flip horizontally
flip vertically
rotate matrix:
rotate left
rotate right
compose matrix
echo matrix
print matrix
basic statistics functions:
average
average ignore blanks
average ignore zero
deviation
deviation ignore blanks
deviation ignore zero
geometric mean
geometric mean ignore blanks
geometric mean ignore zero
harmonic mean
median
median ignore zero
parallel
product
product ignore blanks
product ignore zero
rms
rms ignore blanks
rms ignore zero
sum
variance
variance ignore blanks
variance ignore zero
quantile
quantile ignore zero
covariance and correlation:
correlation
covariance
gini coefficient, income disparity:
gini
gini ignore blanks
gini ignore zero
linear regression, exponential regression:
regression
interpolation:
linear interpolation
nearest neighbor interpolation
nearest right neighbor interpolation
polynomial interpolation
spline interpolation
histogram
conditional combination functions:
average if
average if any
average ignore blanks if
average ignore blanks if any
average ignore zero if
average ignore zero if any
count if
count if any
count ignore blanks if
count ignore blanks if any
count ignore both if
count ignore both if any
count ignore zero if
count ignore zero if any
deviation if
deviation if any
deviation ignore blanks if
deviation ignore blanks if any
deviation ignore zero if
deviation ignore zero if any
exclude if
exclude if any
geometric mean if
geometric mean if any
geometric mean ignore blanks if
geometric mean ignore blanks if any
geometric mean ignore zero if
geometric mean ignore zero if any
harmonic mean if
harmonic mean if any
include if
include if any
join if
join if any
join if any
join ignore blanks if
join ignore blanks if any
join ignore blanks if any
join unique if
join unique ignore blanks if
max 123 if
max 123 if any
max 123 ignore zero if
max 123 ignore zero if any
max abc if
max abc if any
max abc ignore case if
max if
max if any
max ignore blanks if
max ignore blanks if any
max ignore zero if
max ignore zero if any
max numeral if
max numeral if any
max numeral ignore zero if
max numeral ignore zero if any
max string if
max string if any
max string ignore case if
median if
median if any
median ignore zero if
median ignore zero if any
min 123 if
min 123 if any
min 123 ignore zero if
min 123 ignore zero if any
min abc if
min abc if any
min abc ignore blanks if
min abc ignore blanks if any
min abc ignore both if
min abc ignore both if any
min abc ignore case if
min abc ignore case if any
min abc ignore case if any
min if
min if any
min ignore blanks if
min ignore blanks if any
min ignore zero if
min ignore zero if any
min numeral if
min numeral if any
min numeral ignore zero if
min numeral ignore zero if any
min string if
min string if any
min string ignore blanks if
min string ignore blanks if any
min string ignore both if
min string ignore both if any
min string ignore case if
min string ignore case if any
min string ignore case if any
parallel if
parallel if any
product if
product if any
product ignore blanks if
product ignore blanks if any
product ignore zero if
product ignore zero if any
rms if
rms if any
rms ignore blanks if
rms ignore blanks if any
rms ignore zero if
rms ignore zero if any
sum if
sum if any
variance if
variance if any
variance ignore blanks if
variance ignore blanks if any
variance ignore zero if
variance ignore zero if any
compound annual growth rate:
cagr
internal rate of return:
irr
terminal value:
tv
discount:
discount
distribution over timeline:
distribute
distribute advance