Computer demonstrations
This section contains computer demonstrations illustrating the topics introduced in the unit element 'EMa2 - Applied Statistics'. These demonstrations were created as part of the project.
In most cases you will have to confirm `Enable macros' when opening the spreadsheet.
There are also plenty of demonstrations available online. I have listed links to some of them in section Other useful links.
Probability
- Door contest: demonstration [Excel]
- Ball drawing and coin tossing: demonstration [Excel]
Probability distributions
- Distribution approximation (Binomial by Poisson and Normal): demonstration [Excel]
- Normal distribution and its quantiles: demonstration [Excel]
- T-distribution: demonstration [Excel]
Poisson processes
- Particle detector: demonstration [Excel] slides with theory [PowerPoint]
Central Limit Theorem
- Distribution of the sum of random variables: demonstration [Excel]
- Distribution of sample means: demonstration [Excel]
Hypothesis testing
- Testing hypothesis about sample mean: demonstration [Excel]
Correlation and regression
- Sampling data with given correlation coefficient: demonstration [Excel]