Microsoft Excel will automatically determine the size of the output area and display a message if the output table will replace existing data. New Worksheet Click to insert a new worksheet into the current workbook and paste the results into 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 into cell A1 of a new worksheet in the new workbook. Labels Select if the first row or column of your input range contains labels.
Alpha Enter the confidence level for the test.
Hypothesized Mean Difference Enter the number that you want for the shift in sample means. 1 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. 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.