The concept of mean and standard deviation - Interactive (Excel)

The aim is to enhance the appreciation of the concept of mean and standard deviations through interactive visualisation using spreadsheets. Two normal distributions are plotted. One is fixed so that it becomes a reference distribution, which helps to see the effect of changing the mean and the standard distribution on the other.

Suggestions
use:

1. mean = 0, stdev = 1 (standard normal distribution)
2. mean = 5, stdev = 1
3. mean = 10, stdev = 1
4. mean = 5, stdev = 2, 3, 5 etc

Note: stdev = standard deviation ( the square root of variance)

Note: mean is a measure of location (central tendency of data), whereas standard deviation is a measure of the spread of data; in other words standard deviation is the square root of the average deviation from the mean.