| | 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. | |
