How to Make a T

1. Start Microsoft Excel. Press 'CTRL N' to create a new workbook.
2. Type 'Data1' and 'Data2' in cells 'A1' and 'B1,' respectively. You may replace these with your preferred variable names.
3. Enter your first set of data in column 'A,' starting from cell 'A2.'
4. Enter your second set of data in column 'B,' starting from cell 'B2.' Make sure that both columns have the same number of cells. For instance, if column 'A' contains five entries, column 'B' should also have five entries.
5. Highlight all non-empty cells (including the variables) and then press 'CTRL SHIFT F3.'
6. Select the cell below the last number in column 'A.' Type '=T.TEST' and then press 'CTRL A.' This opens a dialog box where you can enter parameters for the function.
7. Enter 'Data1' and 'Data2' into the 'Array1' and 'Array2' boxes, respectively.
8. Enter 1 into the 'Tail' box if you'd like to use one-tailed distribution. Otherwise, enter 2.
9. Enter the kind of test you'd like to perform in the 'Type' box. Use any of the values below.1 - Paired t-test2 - Two-sample equal variance3 - Two-sample unequal variance
10. Click on 'OK' to view the result of your formula.