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