Statistics and Probability

This sub-collection of resources from the Virtual Text Book collection contains nine resources designed for use on an interactive whiteboard to aid the teaching and learning of a variety of topics in ‘Algebra'. Each resource is an interactive Excel worksheet to encourage teacher-student interaction. The topics covered are:

• Product Moment Correlation Coefficient
• Discrete Random Variables: Coins
• Frequency Tables and Quantiles
• Histograms
• Normal Distribution
• Probability: Biased Coins
• Regression (Linear)
• Standard Deviation
• Venn Diagrams

Resources

Filter

Subject
Age
Type
Showing 9 result(s)

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

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

Pages

Share this resource