Listing all results (186)

Product Moment Correlation Coefficient

This series of interactive excel sheets explore the product moment correlation coefficient (PMCC). Another title can be found in our Virtual Textbook: Secondary collection.

The first sheet generates a set of bi-variate data and plots them on a...

Discrete Random Variables - Coins

This series of interactive excel sheets explore discrete random variables, in particular those of coins and dice.

The first sheet offers a reminder of Pascal’s Triangle.

The second sheet plots the probability distribution for the number of heads obtained for a changeable (between 1 and 10) number of...

Frequency Tables and Quantiles

This excel resource contains a series of interactive sheets exploring frequency tables and quartiles.

The first sheet calculates the mean from a frequency table. The second calculates an estimate for the mean from a grouped frequency table. New examples for both sheets can be generated at the click of a...

Normal Distribution

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...

Probability: Biased Coins

This excel program illustrates the effect of introducing bias when throwing coins.

The first interactive excel sheet simulates the outcome of throwing a coin ten times. The probability of each outcome is plotted and shown in a table, alongside the cumulative probability. The probability of obtaining a head...

Regression (Linear)

This is a series of interactive excel sheets exploring linear regression.

The first sheet plots a scatter diagram and line of best fit for a small set of bivariate data. The mean and product moment correlation coefficient is also calculated.

The second sheets displays a summary of the formulae used to...

Standard Deviation

This is a series of interactive excel sheets that explore the different methods for calculating standard deviation.

The first sheet helps demonstrate the method for finding the standard deviation from population data by summing the squared deviations from the mean. The second sheet shows the alternative...

Venn Diagrams

This series of interactive excel sheets explore calculating the probability of events from Venn diagrams. Another resource exploring the use of Venn diagrams can be found in our Virtual Textbook: Secondary collection.

The first...

aSin(x) + bcos(x)

This group of interactive excel worksheets look at the series of identities of the form

aSin(x) ± bCos(x) and aCos(x) ± bSin(x),

where a=RCos(α), b = RSin(α), R=√(a2+b2) and α=tan-1(b/a)....

Modelling: Depth of Water in a Tidal River

This excel file looks at using the sine curve to model the water depth in a tidal river.

The first interactive sheet shows how the Earth’s orbit around the Sun can be modelled by the sine curve. One or two cycles can be displayed. The second sheet shows how the sine curve can model a cycle which takes 24...


View all publishers