# 17.3.4.2 The Pair-Sample T-Test on Rows Dialog Box

## Supporting Information

To open the Pair-Sample t-Test on Rows dialog box:

• With a worksheet active, click Statistics: Hypothesis Testing: Pair-Sample t-test on Rows.

## Recalculate

Recalculate Controls recalculation of analysis results None Auto Manual For more information, see: Recalculating Analysis Results

## Input Data

1st Data Range Specify data range(multiple columns) of the first sample. Each row represents a data variable. Specify data range(multiple columns) of the second sample. Each row represents a data variable.

## Test Options

Test Mean The hypothetical mean to be tested (0 if testing equality of means). The alternate hypothesis: Mean1 - Mean2 <> Test Mean Difference Used for two-tailed two-sample test. Mean1 and Mean2 differ. Mean1 - Mean2 > Test Mean Difference Used for an upper-tailed two-sample test. Test Mean1 is greater than Mean2. Mean1 - Mean2 < Test Mean Difference Used for a lower-tailed two-sample test. Test Mean1 is less than Mean2.

## Outputs

For help with the range controls, see: Output Results

T-statistic Select to output the t-statistic, and you can specify the column for the values. Each row represents the t-statistic of the data in the row. Select to output the degree of freedom, and you can specify the column for the values. Each row represents the degree of freedom of the data in the row. Select to output the p-value, and you can specify the column for the values. Each row represents the p-value of the data in the row. Select to output the flag of decision and specify the column for the values. the value equals to 1 indicates that the difference of the means is significant at the 0.05 level, 0 indicates that the means are not significant different at the 0.05 level