Using mathematical functions 11-13
UTPF Upper-Tail Snedecor’s F Probability given numerator
degrees of freedom and denominator degrees of freedom
(of the F distribution), evaluated at value. Returns the
probability that a Snedecor's F random variable is
greater than value.
UTPF(numerator, denominator, value)
UTPN Upper-Tail Normal Probability given mean and variance,
evaluated at value. Returns the probability that a normal
random variable is greater than value for a normal
distribution. Note: The variance is the square of the
standard deviation.
UTPN(mean, variance, value)
UTPT Upper-Tail Student’s t-Probability given degrees of
freedom, evaluated at value. Returns the probability that
the Student's t- random variable is greater than value.
UTPT(degrees, value)
Real-number functions
Some real-number functions can also take complex
arguments.
CEILING Smallest integer greater than or equal to value.
CEILING(value)
Examples
CEILING(3.2) returns 4
CEILING(-3.2) returns -3
DEG→RAD Degrees to radians. Converts value from Degrees angle
format to Radians angle format.
DEG→RAD(value)
Example
DEG→RAD(180) returns 3.14159265359, the
value of π.
FLOOR Greatest integer less than or equal to value.
FLOOR(value)
Example
FLOOR(-3.2) returns -4