Microsoft Office Tutorials and References
In Depth Information
TTEST returns the probability associated with t-test.
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.
Is the second data set.
Is an indication whether to return a one-tailed distribution or two-tailed
Is the type of t-test to perform: 1 indicates paired; 2 indicates two-sample
equal variance; 3 indicates two-sample unequal variance.
Both the TAILS and
should be integers.
Choose 1 or 2 tails.
1, 2, or 3.
VAR VAR returns an estimate for the variance of a population, based on a sample data set.
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.