MATH221
Statistical Concepts: Probability Binomial Probability Distribution Calculating Binomial Probabilities Open a new Excel worksheet. Open spreadsheet In cell A1 type “success” as the label Under that in column A, type 0 through 10 (these will be in rows 2 through 12) In cell B1, type “one fourth” In cell B2, type “=BINOM.DIST(A2,10,0.25,FALSE)” [NOTE: if you have Excel 2007, then the formula is BINOMDIST without the period]
Then copy and paste this formula in cells B3 through B12
In cell C1, type “one half” In cell C2, type “=BINOM.DIST(A2,10,0.5,FALSE)”
Copy and paste this formula in cells C3 through C12
In cell D1 type “three fourths” In cell D2, type “=BINOM.DIST(A2,10,0.75, ...
