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. You can use a t-test to determine whether two sample means are equal. Use this test when you are relative certain that the population variances are unequal. Because the result of the calculation is usually not an integer, use the nearest integer to obtain a critical value from the t table. 1 Range Enter the cell reference for the first range of data you want to analyze.