Listing all results (164)

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

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

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

Venn Diagrams

This series of interactive excel sheets explore calculating the probability of events from Venn diagrams. Another resource exploring the use of Venn ...

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=√(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...

Radians: Arcs and Sectors

This collection of interactive excel sheets look at radians, arc length, sector area, converting to and from degrees, and other related problems.

The first sheet displays a sector of a circle and corresponding...

Trigonometry: X=cosθ,Y=sinθ

This collection of interactive excel sheets looks at a circle of radius 1 and the corresponding values generated for cosθ and sinθ.

The first interactive sheet illustrates that for the unit circle, X = cosθ and Y =...

Volumes of Revolution

This collection of interactive excel sheets investigate volumes of revolution by integration.

The first sheet plots the function y= ax2...

Algebraic Equations

This excel file contains a series of sheets which generate different types of equations involving algebraic fractions. The different types include denominators which are single term, linear and quadratic expressions. The quadratic expressions all have 1 as the...

Pages

View all publishers