Excel File Edit View Insert Format Tools Data Window Help M PS ) $ 64% Mon 4:13 PM Q OF ... AutoSave . OFF 3 CH 6 and 7 Excel Bonus # 2 (3) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 16 AA = E = ap Wrap Text v General Insert v Delete v 2" AY- O. Paste E Merge & Center v $ ~ % " Conditional Format Cell Format Sort & Find & Ideas Sensitivity Formatting as Table Styles Filter Select C2 * X V fx A B C D E F G H I K L 1 Name: 2 Due Date:Sunday, October 11 I'll not accept late assignment. 5 Formulas from Chapter 6 Example Problems Probability x = number of sucesses n = number of trials 35% of the population support a new regulation, if a random Binomial Distribution p = probability of success sample of 10 voters is polled, what is the probability that.. =BINOM.DIST(x,n,p,False) exactly 3 of them support the proposition? P(x = 3) =BINOM.DIST(x,n,p, True) 3 or fewer of them support the proposition? P(x53 =1-BINOM.DIST(x,n,p, True) more than 3 of them support the proposition? P(x24) 11 To find EXACTLY x, it is NOT CUMULATIVE, use FALSE 12 To find x or FEWER, it is CUMULATIVE (from left to right), use TRUE 13 To find x or GREATER, take 1 - Cumulative Formula, using x-1. Ex: P(x 2 4), use x=3.... =1-BINOM.DIST(3,10,0.35, True) 14 15 16 17 Source: Dr. Annie Ngo, Miracosta College, Oceanside, CA 18 19 20 21 22 23 24 25 CH6 Binomial Chapter 7 + - + 110% TOM ? x 4542 5 2479 Ow P EPIC GAMESExcel File Edit View Insert Format Tools Data Window Help M PS ) $ 64% Mon 4:14 PM Q OE ... AutoSave . OFF 3 CH 6 and 7 Excel Bonus # 2 (3) a a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 16 AA E = 87 V ap Wrap Text v General Insert v Ex Delete v 2 NAY - O. Paste BI U E Merge & Center v $ ~ % " 08 20 Conditional Format Cell Formatting as Table Styles Format Sort & Find & Ideas Sensitivity Filter Select C17 * X V fx A C D E F G H K 2 Formulas from Chapter 7 Example Problems z-values in a standard normal distribution If x is distributed normally with u = 100 and =STANDARDIZE(x,mean, standard_dev) 0 = 50, what is the z-value for x = 250? 6 Normal Distribution A population is normally distributed with: =NORM.DIST(x,mean,standard_dev,False) H = 100 and o = 20 8 =NORM. DIST(x,mean,standard_dev, True) Find P(x 130) 10 =NORM. DIST(x,mean,standard_dev,True)-NORM.DIST(x,mean,standard_dev,True) Find P(90 0.6)... When the z-score is given 13 =NORM.S. DIST(z, True)-NORM.S.DIST(z, True) Find P(-1
