Excel Reference 551
TREND TREND(known-y’s, known-x’s, new-x’s, constant)
returns the y values of given input values
(new-x’s) based on the regression of known-y’s on
known-x’s. If constant = false, the constant value
is zero.
TTEST TTEST(array1, array2, number-of-tails, type)
returns the p value of a t test, of type paired (1),
two-sample equal variance (2), or two-sample
unequal variance (3).
ZTEST ZTEST(array, x, sigma) returns the p value of a
two-tailed z test, where x is the value to test and
sigma is the population standard deviation.
Trigonometric Formulas
Function Name Description
ACOS ACOS(number) returns the arccosine (inverse
cosine) of number.
ACOSH ACOSH(number) returns the inverse hyperbolic
cosine of number.
ASIN ASIN(number) returns the arcsine (inverse sine)
of number.
ASINH ASINH(number) returns the inverse hyperbolic
sine of number.
ATA N ATAN(number) returns the arctangent (inverse
tangent) of number.
ATAN2 ATAN2(x, y) returns the arctangent (inverse
tangent) of the angle from the positive x axis.
ATANH ATANH(number) returns the inverse hyperbolic
tangent of number.
COS COS(angle) returns the cosine of angle.
COSH COSH(number) returns the hyperbolic cosine of
number.
DEGREES DEGREES(angle) returns the degree measure of
an angle given in radians.
PI PI() returns p accurate to 15 digits.
RADIANS RADIANS(angle) returns the radian measure of
an angle given in degrees.
SIN SIN(angle) returns the sine of angle.
SINH SINH(number) returns the hyperbolic sine of
number.
TAN TAN(angle) returns the tangent of angle.
TANH TANH(number) returns the hyperbolic tangent of
number.
