No video
Central Limit Theorem - Explanation with Excel Download
Рет қаралды 10,746
Күн бұрынDownload the complete solution Excel file: drive.google.c...
The Central Limit Theorem explains a lot about sampling in statistics. How do we know what size of sample (n) to use and still be confident that the sample is representative of the population?
The Central Limit Theorem proposes that when we sample a population the greater the sample size will result in the mean of the samples being increasingly normally distributed. It will also reduce the spread of data (standard deviation).
In this spreadsheet exercise we have a population of 990 random numbers. we then test the Central Limit Theorem by charting a distribution curve for sample sizes of n=4, n=10 and n=30 to compare the difference.
@rangjungyeshe Жыл бұрын
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....!)
@mikefletcher8047 10 ай бұрын
This is a very helpful and clear explanation of CLT and how to test it in Excel.
@nelsondealcantaracruzjunio6813 3 жыл бұрын
thank you, I was looking for an pratical example
@Muuip 2 жыл бұрын
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.
@sureshm430 2 жыл бұрын
Thanks, Even i was looking for Practical example.
The Organic Chemistry Tutor
Рет қаралды 793 М.
Khan Academy
Рет қаралды 2,1 МЛН