FTESTV

Macro Sheets Only

Performs a two-sample F-test.

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

Syntax

FTESTV(inprng1, inprng2, outrng, labels)
FTESTV?(inprng1, inprng2. outrng, labels)

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.

• If labels is TRUE, then the first row or column of inprng1 and inprng2 contain labels.
• If labels is FALSE or omitted, all cells in inprng1 and inprng2 are considered data. Microsoft Excel generates appropriate data labels for the output table.

Related Functions

List of Statistical Functions