- View more resources from this publisherThe Virtual Textbook
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
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...