Binomial distribution

[gko_87]

Someone with statistical knowledge kindly help me interpret into excel the example here: The formula i try is not giving the the expected value.

http://stattrek.com/probability-dist...?tutorial=stat

Here is my excel file:

Sample.xlsxSample.xlsx

[JohnTopley]

Try

=(FACT(C6)/(FACT(C7)*(FACT(C6-C7)))*(C8^C7)*(1-C8)^(C6-C7))

[gko_87]

Thanks John. That worked.