Overall rating 4 out of 54 (2 ratings)
Last updated 02 April 2013, created 01 July 2008, viewed 3,938
The following sheet is an activity that explores the normal distribution function. Ideal for KS4 and Post16 students. Norm Dist 1 - explores how the mean and standard deviation effect the normal distribution function Norm Dist 2 - explores the probability distribution for a symmetrical two tailed ev More…ent 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.
Please provide a rating.
Gives a clear demonstration of the effect of changing the mean and standard deviation for a normal distribution. Thank you.
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.
TES Editorial © 2013 TSL Education Ltd. All pages of the Website are
reproduce, duplicate, copy, sell, resell or exploit any material on the
Website for any commercial purposes. TSL Education Ltd Registered in England (No 02017289) at 26 Red Lion Square, London, WC1R 4HQ