Normal Distribution Excel Exercise

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

Category:

Education

Tags:

• statistics
• normal
• distribution
• binomial
• CC_6_SP_5_d
• CC_7_SP_2

[branng]

Looks like there're actually two errors Sal,

1. Excel cannot store numbers larger than 9.99999999999999E+307 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).

[khanacademy]

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

[JasonGoldstein78]

How did you set up the spreadsheet to look like that?

[twofacenear]

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

[mdakin]

Can you use Google docs spreadsheets instead of excel? Therefore students don't have to have office to use these files, Excel is an expensive tool, and I am not sure how well Openoffice handles these files.

[DrOemza]

my 9 week year old son is watching..lol

[zeronebula100]

can you please make a video of the gaussian curvature

[2309matthew]

khan you are the man! thanks for your explanation it is very understandable for a subject that is so confusing.

[grafleinsdorf]

The formula written down in the beginning is actually the density, while it is said that is the "probability to get any x". Maybe it is a didactic trick since it might give the right intuition, but strictly speaking it it false, the probability to get any specific real number is always zero. The probability is obtained by integration over the density.

Just nitpicking...

[V2PRC]

I have trouble downloading the xls file. The website cannot be opened. What's going on?

[brendam44]

can you help me please what is the a way to divide large numbers. 246400/4488