The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST function. If only you'd known about this function before having to make the lengthy computations!

Concepts

statistics, data analysis, technology resources

Show More Show Less

Instructional Ideas

• Team up with a math teacher and science teacher to create a cross-curricular lesson
  

Classroom Considerations

• Fourth of five installments in the Spreadsheet Data Analysis unit, the lesson builds on knowledge from previous tutorials 
• It is helpful if learners have familiarity with the t-test
  

Pros

• Includes an exercise for independent practice
• Directions and instructions are easy to understand and clear

Cons

• None