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.

End of semester

You have learned about some basic concepts in education research this semester and hope they are useful in your thesis writing later. The lectures ended last Thursday, and this week you have a break before taking the exam next week. It will be an oral exam, and I'm sure it will be more effective than the written one.

All the materials you need to study for the exam have been posted in this blog. If you still have questions about them you may ask me by writing them in the comment box.

I'm going to post some other things related to research, but they are not the materials of the lectures and will not be tested next week. The posts after this one are for the students who are writing skripsi.

Wish you lots of luck for the exam.