Microsoft Office Tutorials and References

In Depth Information

**TINV**

TIN
TINV
returns the inverse of the t-distribution for the specified degrees of freedom.

=TINV(probability,degrees_freedom)

The
TINV
function is when you know the probability level you want to achieve and need to

generate
x.
TINV
uses an iterative technique for calculating the function. The default maximum

number of iterations is 100. If a result is not reached within those iterations, the #N/A value is

returned. You can change the number of iterations under Tools, Options, Calculation tab.

An example of a
TINV
function is
=TINV(.095,2)
which results in 0.071.

Is the probability associated with the two-tailed t-distribution.

PROBABILITY

The degrees of freedom to characterize the distribution.

DEGREES FREEDOM

TREND

TREND
returns the y-values along a linear trendline that best fits the values in a data set.

=TREND(known_y’s,known_x’s,new_x’s,const)

Using the least squares method, the
TREND
function determines the values that plot a straight

line based on a data set. In Figure 11.50, the trend values have been calculated. The
known_y

and
known_x
values are based on the formula
y=m*x+b
. Because the
new y
values (the values

that the function returns) are along the linear trendline that best fits your data (based on the

trend equation), the
new y
values do not match the
known y
values.

Because this function returns an array:

■
The result range must be selected
before
you begin the function.

■
The formula must be
array entered
by using Ctrl+Shift+Enter, instead of just Enter.

The known values for the known data points; the dependent variable.

KNOWN_Y’S

The known data points. If omitted assumed to be the array {1,2,3…} the

same size as the
known_y’s
.

KNOWN_X’S

Are the new x-values for which you want
TREND
to return corresponding

y-values. If omitted assumed to be the same as the
known_x’s
.

NEW_X’S

TRUE or FALSE indicating whether the y-intercept (
b) is = 0 (FALSE) or

not (TRUE).

CONST