Nice, easily accessible (and modifiable) simulation! Minor tweak: around 1 min in, when describing the histogram of the population, it's showing a uniform distribution rather than a Normal distribution. In other words, you're showing how the CLT leads to a Normal distribution of means peaking around the populatiomn mean, even from a "flat" population distribution (which is kind-of amazing....!)
This is a very helpful and clear explanation of CLT and how to test it in Excel.
Nice, easily accessible (and modifiable) simulation!
Minor tweak: around 1 min in, when describing the histogram of the population, it's showing a uniform distribution rather than a Normal distribution. In other words, you're showing how the CLT leads to a Normal distribution of means peaking around the populatiomn mean, even from a "flat" population distribution (which is kind-of amazing....!)
Great example, much appreciated!
Small correction: RANDBETWEEN(1,990) not RANDBETWEEN(2,991). INDEX searches for position 1 to 990, not row 1 to 990.
thank you, I was looking for an pratical example
Thanks, Even i was looking for Practical example.