PTTESTV macro

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

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

Syntax

PTTESTV(inprng1, inprng2, outrng, labels, alpha)

PTTESTV?(inprng1, inprng2, outrng, labels, alpha)

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.

Related Functions

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

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

Return to index