The University of Waikato - Te Whare Wānanga o Waikato
Student Learning
Waikato Home Waikato Home > Student Life > Student Learning  > Help with technology
Staff + Student Login

Student Learning: Technology

Spreadsheets 7 - Excel

Here is a video by Jim Grange from Youtube.

Video source: t-test in Microsoft Excel

This video includes:
  1. Explanation of what a t-test is...
  2. How to do a t-test
  1. Selecting Array 1 and Array 2 of your conditions
  2. Deciding on a 1-tail or 2-tail test (depending on your hypothesis)
  3. Type (data representing the same participants or different participants)
  1. Explanation the t-test equation
  2. Eplanation of the t-test result
  1. p-value (probability value)