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 `=ZTEST(`

`cell ref`

`,`

μ`,`

σ`)`

where * 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(`

`cell ref`

`,`

μ`,`

σ`), 1 - ZTEST(`

`cell ref`

`,`

μ`,`

σ`))`

.

The function `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 `TTEST`

is `=TTEST(`

`cell ref 1`

`,`

`cell ref 2`

`,`

`tails`

`,`

`type`

`)`

, where * cell ref 1* and

`cell ref 2`

`tails`

`type`

`FTEST`

computes the two-tailed F-test for two datasets. The syntax for `FTEST ...`

Start Free Trial

No credit card required