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
Search JabSto ::

Custom Search