Resources by DISCUS
Displaying 1 - 9 of 9
Binomial Distribution
The workbook contains a number of simulations designed to aid students understanding of the Binomial distribution.
Binomial distribution: simulated tossing a coin ten times. The probability of achieving 0,1,2… heads is calculated and displayed in a frequency table and a bar chart. The...
Continuous Distribution
The activities in this workbook are designed to help students understand the Normal distribution, the student's t-distribution, the Chi-squared distribution, the F-distribution, the Exponential distribution, the Beta distribution, the Gamma distribution and the Weibull distribution.
For each distribution...
Descriptive Statistics
This resource is designed to help students understand:
• Different averages: the mean and the median.
• Measures of spread: the standard deviation and the interquartile range.
• Statistical diagrams: histograms and boxplots.
Self teaching notes and questions are contained on the work...
DISCUS consists of eight Excel workbooks and a set of associated photocopiable work cards covering the topics: Descriptive Statistics, Probability, Binomial Distributions, The Poisson Distribution, Continuous Distributions, Sampling, Regression and Hypothesis Testing. The materials are designed to be used off the...
Hypothesis Testing
The activities in this workbook cover the ideas of statistical significance, type I and type II errors and the power of a test. The relationship between power and significance in the context of tests of means is considered and the final spreadsheet shows how to conduct a chi-squared test of association in a...
Probability
The workbook contains two simulations designed to help students to understand what is meant by a random process and to give some idea of the likelihood of particular events occurring.
...
Regression
These activities cover bivariate data which includes regression and correlation.
[b]Least squares regression[/b] spreadsheet is designed to help students get a feel for drawing a line of best fit through a set of points and to begin to understand the concept of regression. Students are given a set of six...
Sampling
The activities in this workbook are designed to help students to understand what happens when a sample is taken, how to calculate the confidence interval for a mean and what this interval represents.
The first three spreadsheets consider samples taken from a normal distribution, a uniform distribution and an...
The Poisson Distribution
The workbook contains a number of simulations designed to aid students understanding of the Poisson distribution.
[b]Queuing simulation:[/b] is designed to introduce the Poisson distribution through a realistic application, that of simulating a supermarket checkout queue. Students choose the number of people...