Train The Trainer

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Tuesday, 21 May 2013

Statistics 101: Central Limit Theorem Simulation in Excel

Posted on 05:34 by Unknown

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. I suggest watching lectures by Khan Academy and then playing with the spreadsheet. Modifying various numbers and seeing how that affects the output might give you deeper understanding of this fundamental concept behind all inferential statistics. I believe I still lack some of the nuts and bolts to get, so I might listen to my own advice and check the Khan videos. 






 If you find any errors please be free to notify me.
Click HEREto download the Excel spreadsheet. 


Email ThisBlogThis!Share to XShare to Facebook
Posted in Download, statistics | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • 6 weeks running program for soccer players
    This is an article I wrote couple of months ago for one website, but it never got published, so I decided to publish it on my b...
  • Guest Article: Biological Planning, Organizing, and Programming for Physical Preparation. Part 2
    BIOLOGICAL PLANNING, ORGANIZING, AND  PROGRAMMING FOR PHYSICAL PREPARATION Part 2 Click HERE for part 1 Planning Working Backwards Many coa...
  • Research Review – Effects of different pushing speeds on bench press
    Research Review – Effects of different pushing speeds on bench press Rob Shugg from Kinetic Performance brought this very interesting study ...
  • Interview with Steve Magness
    Interview with Steve Magness In the last couple of years blog by Steve Magness “ Science of Running ” was more than the source of casual re...
  • Coincidence or not? Back to soccer
    While I was working on the 8-weeks pre-season plan for soccer  I have been contacted by the head coach of FC RAD , Marko Nikolić offering me...
  • MOTORIČKA ANALIZA ODBOJKAŠKE IGRE
    Seminarski rad koji sam napisao negde u Aprilu 2010. godine pre nego sam napisao Planning and programming of training in sport games . Neki ...
  • Periodization Confusion?
    I have recently been reading Transfer of Training  (Volume 2) by Dr Anatoly Bondarchuk an...
  • Interview with Mike Boyle
      Interview with Mike Boyle There are four coaches that were highly influential on my physical preparation philosophy and practice. The firs...
  • Planning the Strength Training. Part 1
    Planning the strength training From novice to elite CHARACTERISTICS OF THE LIFTER According to Mark Rippetoe, the author of Practical Progra...
  • Mike Tuchscherer's Progressive Powerlifting DVD
    First off I am sorry I am for leaving this blog without posts recently. I will try to update it more frequently and maybe start a training j...

Categories

  • analysis
  • Basketball
  • Biomechanics
  • conditioning
  • dashboards
  • Download
  • ELEIKO
  • energy system development
  • Excel
  • Fasting
  • fun
  • general vs. specific
  • Good Reads
  • Guest Article
  • GymAware
  • HRV
  • IE20-10
  • injuries
  • interview
  • Italian
  • links
  • martial arts
  • MMA
  • monitoring
  • Muscles
  • Notice
  • Nutrition
  • Olympic lifting
  • On Serbian
  • Performance Analysis
  • periodization
  • Philosophy
  • Physical Therapy
  • Physiology
  • planning
  • powerlifting
  • Product
  • programming
  • Psychology
  • R
  • Random Thoughts
  • Research
  • Review
  • Roberto Sassi
  • RPE
  • RSA
  • runnings
  • screen cast
  • soccer
  • statistics
  • strength training
  • team sports
  • Theory
  • videos
  • visit
  • volleyball
  • Warm-up
  • wellness questionnaire

Blog Archive

  • ▼  2013 (54)
    • ►  December (7)
    • ►  November (8)
    • ►  October (4)
    • ►  September (6)
    • ►  August (8)
    • ►  July (3)
    • ►  June (2)
    • ▼  May (5)
      • Self-Experiment in Frequent training. Part 1
      • The man behind AccelerWare®: Interview with Stewar...
      • Interview with Julen Castellano
      • Statistics 101: Two-Sample Hypothesis Testing
      • Statistics 101: Central Limit Theorem Simulation i...
    • ►  April (2)
    • ►  March (7)
    • ►  February (1)
    • ►  January (1)
  • ►  2012 (55)
    • ►  December (4)
    • ►  November (4)
    • ►  October (9)
    • ►  September (9)
    • ►  August (6)
    • ►  July (6)
    • ►  June (5)
    • ►  May (2)
    • ►  April (2)
    • ►  March (5)
    • ►  February (3)
  • ►  2011 (48)
    • ►  December (3)
    • ►  November (2)
    • ►  October (4)
    • ►  September (2)
    • ►  August (2)
    • ►  July (1)
    • ►  June (9)
    • ►  May (12)
    • ►  April (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (9)
  • ►  2010 (42)
    • ►  December (11)
    • ►  November (5)
    • ►  October (19)
    • ►  September (7)
Powered by Blogger.

About Me

Unknown
View my complete profile