Statistics 101: Central Limit Theorem Simulation in Excel

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 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 great and must read series of spreadsheet designed to help out lost souls (like me) comprehend basic statistic concepts. You can find those spreadsheets and description HERE.


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

Members Only! To Continue Reading, Please Join Complementary Training Community »

Start Your Membership Today



Join Us Today And Claim 3 Bonuses

Standard Membership
$25 per month

OR

Go Annual and Get All Bonuses for FREE!



Join Us Today And Instantly Save $520

Premium Membership
$250 per year


I am a physical preparation coach from Belgrade, Serbia, grew up in Pula, Croatia (which I consider my home town). I was involved in physical preparation of professional, amateur and recreational athletes of various ages in sports such as basketball, soccer, volleyball, martial arts and tennis. Read More »
free-memeber-button
free-memeber-button