ADD TO TES PRO

# Statistics 1 - Normal Distribution - KS4 and S1

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.

Need help viewing resource files?

## Reviews (2)

Please provide a rating.

Cancel
Comment Report or delete comment Rating

Gives a clear demonstration of the effect of changing the mean and standard deviation for a normal distribution. Thank you.

from jpurves, 02 April 2013
(report comment) 4 out of 5

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.

from laura.reeshughes, 10 December 2011
(report comment) 4 out of 5
Report a problem with this resource