Skip to content
Inferential Statistics

Inferential Statistics

ScreencastDescription
Probability distributions in ExcelGeneral forms and usage of probability distribution functions in Excel
Normal distributionsProbabilities and quantiles from normal distributions
StandardizationCentering and scaling of data
Outlier detectionMethods of detecting outliers
QQ plotsQQ plots against standard normal distribution
SimulationsRandom number generation in Excel. Sampling from distributions.
Sampling distributionsUsing simulations to demonstrate sampling distributions
Bootstrapping 1Estimating sampling distributions with bootstrapping
Bootstrapping 2Controlling bootstrap volatility. Smoothed bootstraps and when you’d use them.
The Central Limit TheoremDemonstration of the Central Limit Theorem
Confidence intervals 1Theory and demonstration
Confidence intervals 2Parametric confidence intervals for means and trimmed means
Confidence intervals 3Nonparametric/bootstrap confidence intervals