Statistics 101: Central Limit Theorem Simulation in Excel

Understanding Central Limit Theorem is of EXTREME importance in statistics. This concept usually sets the boundary line between people who understand statistics and people who don’t.

What is confusing about this topic is usually terminology – mean of the sampling distribution of the mean, standard deviation of the sampling distribution of the mean – you get the point. What I wanted to do is to make this thing easier to comprehend by using Will Hopkins approach by using simulations. Will Hopkins created a great and must-read series of spreadsheets designed to help out lost souls (like me) comprehend basic statistical concepts. You can find those spreadsheets and description HERE.

What was lacking in Hopkins spreadsheets was a simulation of a central limit theorem. Thus I have created this spreadsheet using his famous template.

Related Articles

Analyzing Time-Series of Individual Data

If you haven’t been living in a cave for the last couple of years, you definitely noticed an increase in data collection, data mining and visualization. HRV tracking, jump output tracking, estimating 1RMs from velocity-load data, game statistics, performance analysis, various testing statistics, body weight, Run Keeper, Run Tracker, and all that quantified-self movement.


Your email address will not be published. Required fields are marked *

Cancel Membership

Please note that your subscription and membership will be canceled within 24h once we receive your request.