How to compute t value using t-test in MS Excel

There are several ways of computing t-test. You can do it manually, or use softwares to get the t value, such as SPSS and MS Excel. Here I'll tell you how to use MS Excel to compute the t value.

• Write two sets of scores in MS Excel.
• Click the function button (fx).

• You will see pop-up box with a search box inside.

• Write t test in the search box, and click Go.

• Click T TEST in the box and click OK.
• You will see these four boxes: array 1 (for the first set of scores), array 2 (for the second set of scores), tails (the direction of the difference), and type (the type of sample).

• Enter the correct information in the boxes, and click OK.

• Now you have the result.