Normal Distribution

5
0
4
0
3
0
2
0
1
0
0
Rate this resource

This interactive excel file contains a series of normal distribution curves to investigate.

The first sheet displays the standard normal curve. The mean and variance can be adjusted and compared to the original graph in order to show the effect this has on the shape of the curve.

The second sheet calculates the area under a standard normal distribution curve. The value of the upper limit, z, can be adjusted to explore how this effects the area. The following sheet calculates the area under the curve bounded between adjustable limits, z1 and z2. The final interactive sheet calculates the area of the two tails under the normal distribution curve.

The final sheet contains six questions based on the normal distribution Z ~ N (0, 12). The solutions and graphs can be revealed, and a set of six new questions created.

Note
This program was designed by be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on users’ machine.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Show downloads

Published by

Actions

Share this resource

Lists that tag this content