Calculating Standard Deviation Using Excel

Excel at your work with a lesson featuring spreadsheets. A video walks pupils slowly through how to solve standard deviation and variance using Excel in two different ways. 

3 Views 3 Downloads
CCSS: Adaptable
Instructional Ideas

  • Have classmates use Excel and other spreadsheet software to complete the practice problem, so they can compare the two
Classroom Considerations

  • Pupils should have prior knowledge of how to do this by hand before watching the video
  • Does not assume any Excel knowledge
  • The third in a series of seven statistics videos
Pros

  • Step-by-step instructions demonstrate multiple ways to fill in each cell
Cons

  • Only solves one practice problem
Common Core