Normal distribution excel exercise | Probability and Statistics | Khan Academy

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

Missed the previous lesson?

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:

[nathandrums]

You mention your 9 week old son in this video....and now makes him at least 14 years old! How time flies!! God bless you and your family and thank you for sharing these videos!

[khanacademy]

Thanks. That explains it. Reminder to self: test spreadsheet before recording video :)

[ns]

Those saw toothed pattern were because of impossibility of that particular outcome. For example n=22 can never take you to position 11. It will always lead you to even numbered position. This is because any two numbers with sum=22 will have even difference. Even parity.
Great video. I respect Salkhan. Learning too many things from him.

[shekelboi]

Statistics and probability course, unit 4, lesson 7 feels like we are jumping into a topic that has some prerequisites which weren't previously explained.

[SohailSaleem]

Awesome channel to learn statistics in easy and time efficient way.

[alokkumarmishra]

This video is older than a decade but I hope that you will answer this.
Sir, could you please tell why did we take an interval of 1 feet( half feet on either side of the point) while calculating the probability of landing on lets say, 6 feet, via normal distribution chart. Also, since we know that we can not land on 5 feet, we could have taken a 1 feet interval on both the sides of the 6 feet point. Why does the result depends on the interval used for integration? Please clarify. Please refer to 19:00 .
PS: Your videos are absolute gold, they are helping a lot in my college projects and I have started to develop interest in statistics.Thank You very much.

[twofacenear]

ur son is going to be very smart coz ur an awesome teacher

[prabhjyotsingh]

If both Normal and Poisson distribution are an approximation of binomial distribution then what is the difference between them?

[branng]

Looks like there're actually two errors Sal,

1. Excel cannot store numbers larger than i.e. FACT(170) is the largest factorial it can store
2. The sawtooth patterns occur when we have non-integer right/left moves (rows 9 & 10) i.e. when trying to evaluate non-integer factorials (which Excel doesn't do intrinsically. Require the gamma function which needs to be programmed in).

[mahmoudosama]

I think the weired behavior you find in plottintg the difference between the Binomial and Normal probabilities is because you can not make the number of moves odd number. I like your channel.

[milesyounghamilton]

Can you do a video on how to actually make the curve on excel?

[indiansoftwareengineer]

Please put this video after introduction to normal distribution.
Videos are not properly ordered.
First is normal distribution Excel sheet video then introduction to normal distribution.
Please update playlist orderings.

[ExploreMath-jnef]

Really useful channel! By the way, I have a question about some details of the using method in excel. When I input a number K for the Steps, how can I make that there are 2K valid data ranged from -K to K? For example, when I input a number 20 in the Step blank, and there will be data from -20 to 20 of end position below immediately.

[head]

12:19 Your son is 11 years old now! May Allah bless you and your family😊

[luciferkhusrao]

So, this is how the concept of gradient descent comes into play.

[Watergeek]

um do you think you can do a video bout control charts? I didn't see a video for it on the channel.

[slanguagefreak]

it seems there is something wrong with using odd numbers. It seems to be working fine with the even ones

[ritesh.r]

Hi Sir,
Thanks for this video and it's really helpful.
But i have really serious doubt on approximation of normal as Binomial(or vice versa). I think that this only gonna happen when both probabilities are equal in case of binomial distribution and argument behind this is that Bell curve is symmetric about mean. So when you have equal probability in case of Binomial Distribution, your choosing(choosing x out of n or choosing n-x out of n) becomes symmetrical and then Binomial can be easily approximated as Normal Distribution.
Let me know if I am wrong.

[fatpanda]

how do you use the normal distribution function in excel?

[danishji]

Can someone explain how binomial distribution for large number of trials turns to Normal or Poisson ? How are they different?