Microsoft Office Tutorials and References
In Depth Information
TTEST
TTEST
TTEST returns the probability associated with t-test.
=TTEST(array1,array2,tails,type)
Sometimes called Student’s t-test, this function is used to determine whether two samples are
likely to have come from the same two underlying populations that have the same mean. In
Figure 11.52, the probability that the two samples came from different populations with the
same mean is 25%.
Is the first data set.
ARRAY1
Is the second data set.
ARRAY2
Is an indication whether to return a one-tailed distribution or two-tailed
distribution.
TAILS
Is the type of t-test to perform: 1 indicates paired; 2 indicates two-sample
equal variance; 3 indicates two-sample unequal variance.
TYPE
Figure 11.52
Both the TAILS and
TYPE arguments
should be integers.
A
Choose 1 or 2 tails.
B
Choose type
1, 2, or 3.
VAR VAR returns an estimate for the variance of a population, based on a sample data set.
=VAR(number1,number2,...)
Figure 11.53 shows a sample data set of 20 people and the time they spend (one way)
commuting to work from a specific suburb. The VAR function provides an estimate of the variance
for all the commuters from that suburb.
You can specify up to 30 arguments for the VAR function. The arguments
can be cell references, arrays, or range names. Blank cells or cells
containing text are ignored. Cells that contain a zero (0) are included
in the VAR calculation.
NUMBER N
Search JabSto ::




Custom Search