Student Learning: Technology
Spreadsheets 7 - Excel
Here is a video by Jim Grange from Youtube.
Video source: t-test in Microsoft Excel
- Explanation of what a t-test is...
- How to do a t-test
- Selecting Array 1 and Array 2 of your conditions
- Deciding on a 1-tail or 2-tail test (depending on your hypothesis)
- Type (data representing the same participants or different participants)
- Explanation the t-test equation
- Eplanation of the t-test result
- p-value (probability value)