### Lecture 18: Normal distribution excel exercise

##### Lecture Details :

(Long-26 minutes) Presentation on spreadsheet to show that the normal distribution approximates the binomial distribution for a large number of trials.

Watch the next lesson: https://www.khanacademy.org/math/probability/statistics-inferential/normal_distribution/v/ck12-org-normal-distribution-problems-qualitative-sense-of-normal-distributions?utm_source=YT&utm_medium=Desc&utm_campaign=ProbabilityandStatistics

Missed the previous lesson?

https://www.khanacademy.org/math/probability/statistics-inferential/normal_distribution/v/introduction-to-the-normal-distribution?utm_source=YT&utm_medium=Desc&utm_campaign=ProbabilityandStatistics

Probability and statistics on Khan Academy: We dare you to go through a day in which you never consider or use probability. Did you check the weather forecast? Busted! Did you decide to go through the drive through lane vs walk in? Busted again! We are constantly creating hypotheses, making predictions, testing, and analyzing. Our lives are full of probabilities! Statistics is related to probability because much of the data we use when determining probable outcomes comes from our understanding of statistics. In these tutorials, we will cover a range of topics, some which include: independent events, dependent probability, combinatorics, hypothesis testing, descriptive statistics, random variables, probability distributions, regression, and inferential statistics. So buckle up and hop on for a wild ride. We bet you're going to be challenged AND love it!

About Khan Academy: Khan Academy offers practice exercises, instructional videos, and a personalized learning dashboard that empower learners to study at their own pace in and outside of the classroom. We tackle math, science, computer programming, history, art history, economics, and more. Our math missions guide learners from kindergarten to calculus using state-of-the-art, adaptive technology that identifies strengths and learning gaps. We've also partnered with institutions like NASA, The Museum of Modern Art, The California Academy of Sciences, and MIT to offer specialized content.

For free. For everyone. Forever. #YouCanLearnAnything

Subscribe to KhanAcademy’s Probability and Statistics channel:

https://www.youtube.com/channel/UCRXuOXLW3LcQLWvxbZiIZ0w?sub_confirmation=1

Subscribe to KhanAcademy: https://www.youtube.com/subscription_center?add_user=khanacademy

##### Course Description :

Statistics: The average | Descriptive statistics,Sample vs. Population Mean,Variance of a population,Sample variance,Standard -deviation,Alternate variance formulas - Introduction to Random Variables - Probability density functions - Binomial Distribution - Expected Value: E(X) - Expected value of binomial distribution - Poisson process - Law of large numbers - Normal distribution excel exercise - Introduction to the normal distribution - ck12.org normal distribution problems: Qualitative sense of normal distributions - ck12.org normal distribution problems: z-score - ck12.org normal distribution problems: Empirical rule - k12.org exercise: Standard normal distribution and the empirical - ck12.org: More empirical rule and z-score practice - Central limit theorem - Sampling distribution of the sample mean - Standard error of the mean - Sampling distribution example problem - Confidence interval - Mean and variance of Bernoulli distribution example - Bernoulli distribution mean and variance formulas - Margin of error - Confidence interval example - Small sample size confidence intervals - Hypothesis testing and p-values - One-tailed and two-tailed tests - Z-statistics vs. T-statistics - Small sample hypothesis test - T-statistic confidence interval - Large sample proportion hypothesis testing - Variance of differences of random variables - Difference of sample means distribution - Confidence interval of difference of means - Clarification of confidence interval of difference of means - Hypothesis test for difference of means - Comparing population proportions