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.
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. 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. Output Range Enter the reference for the upper-left cell of the output table.