You're engaged in hypothesis testing and you'd like to learn about Excel's support for conducting statistical tests .
Excel provides support for conducting standard z-tests, t-Tests, and F-tests. Read the following discussion to learn more.
The built-in function
ZTEST computes the one-tailed z-test using the normal distribution. The syntax for this function is
cell ref is a cell reference containing an input dataset, μ is the value being tested, and σ is the population standard deviation. If σ is not known, it can be omitted, in which case the sample's standard deviation will be computed and used in the z-test calculation.
You can also compute two-tailed z-tests as follows:
=2 * MIN(ZTEST(
), 1 - ZTEST(
TTEST computes the one- or two-tailed t-test using Student's t-distribution. Further,
TTEST allows you the option of performing paired, two sample with equal variance, or two sample with unequal variance tests. The syntax for
cell ref 1
cell ref 2
cell ref 1 and
cell ref 2 are cell references to the two datasets under consideration and
tails is the number of tails to consider for the test (1 or 2).
type is a value of 1, 2, or 3, indicating the test type: paired, two sample equal variance, or two sample unequal variance, respectively.
FTEST computes the two-tailed F-test for two datasets. The syntax for