Statistics 1 - Normal Distribution

Rating
3 Ratings
175 Downloads 1653 Views Updated: Thursday, July 14, 2016 - 6:43am
Share with a friend
Facebook
Twitter
Pinterest
LinkedIN
email
sharethis

The following sheet explore the normal distribution function. Norm Dist 1 - explores the how mean and standard deviation effect the normal distribution function Norm Dist 2 - explores the probability distribution for a symmetrical two tailed event Norm Dist 3 - explores the probability of a general two tailed event You will need to allow macros to run when using most of the sheets available here. This can be checked by opening Excel and clicking :- Tools Macros Security and choosing Medium or Low security. Some sheets require you have Analysis ToolPak installed

Presentation

Reviews

SML_Member's picture
SML_Member
July 2016
SML_Member's picture
SML_Member
January 2016
SML_Member's picture
SML_Member
December 2011
A very useful spreadsheet for teaching the Normal Distribution, especially calculating probabilities. It is a very visual way of quickly displaying the area under the curve which a particular probability requires. I also like the fact that you can change the values of the mean and standard deviation, it will be a great starter to get students to sketch the distribution for different values on mini whiteboards and use this spreadsheet to display the correct answer. A lot of possibilities, thank you for sharing.