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 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.
Something went wrong, please try again later.
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.
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£0.00