TTESTM

Macro Sheets Only

Performs a two-sample Student's t-Test for means, assuming equal variances.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

TTESTM(inprng1, inprng2, outrng, labels, alpha, difference)
TTESTM?(inprng1, inprng2, outrng, labels, alpha, difference)

Inprng1 is the input range for the first data set.

Inprng2 is the input range for the second data set.

Outrng is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Labels is a logical value.

Alpha is the confidence level for the test. If omitted, alpha is 0.05.

Difference is the hypothesized difference in means. If omitted, difference is 0.

Related Functions

PTTESTM Performs a paired two-sample Student's t-Test for means

PTTESTV Performs a two-sample Student's t-Test, assuming unequal variances

List of Statistical Functions