Utilize Excel software to analyze a set of data by making statistical calculations. The instructor shows how to find the standard deviation, mean, minimum, maximum, margin of error, confidence intervals, and range using Excel commands. He also mentions how he formats the spreadsheet to help scholars with that skill as well.

Concepts

intervals, mean, maximums, minimums, standard deviation

Show More Show Less

Additional Tags

math

Show More Show Less

Instructional Ideas

• Have your classes collect data based on a question of interest to analyze using Excel

Classroom Considerations

• Learners need access to Excel software
• Assumes an understanding of basic statistics calculations

• This video is hosted on YouTube

Pros

• Shows each calculation as a step-by-step process that is easy to follow
• Describes the meaning of the formulas entered in the cells

Cons

• None

Common Core

HSS-IC.B.4