About the t-Test: Two-Sample Assuming Equal Variances dialog box

Variable 1 Range

Enter the cell reference for the first range of data you want to analyze. The range must consist of a single column or row of data.

Variable 2 Range

Enter the cell reference for the second range of data you want to analyze. The range must consist of a single column or row of data.

Hypothesized Mean Difference

Enter the number that you want for the shift in sample means. A value of 0 (zero) indicates that the sample means are hypothesized to be equal.

Labels

Select if the first row or column of your input ranges contains labels. Clear this check box if your input ranges have no labels; Microsoft Excel generates appropriate data labels for the output table.

Alpha

Enter the confidence level for the test. This value must be in the range 0...1. The alpha level is a significance level related to the probability of having a type I error (rejecting a true hypothesis).

Output Range

Enter the reference for the upper-left cell of the output table. Excel automatically determines the size of the output area and displays a message if the output table will replace existing data.

New Worksheet Ply

Click to insert a new worksheet in the current workbook and paste the results starting at cell A1 of the new worksheet. To name the new worksheet, type a name in the box.

New Workbook

Click to create a new workbook and paste the results on a new worksheet in the new workbook.