Curated and Reviewed by
Lesson Planet
This Spreadsheet Tutorial 4: t-Test activity also includes:
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!
4 Views
2 Downloads
Concepts
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