Paste FILE Clipboard G A1 1 234 5 5555 EEE 56069 10 11 12 13 14 15 16 17 18 HOME A Calibri B I U V B N S n INSERT P(X= 2) P(X22) P(X 3) - 11 Font C PAGE LAYOUT HyperGeometric Distribution 50 20 5 A A A 0.3641 D 0.9241 FORMULAS E HyperGeometric Distribution - Excel F DATA Alignment REVIEW Wrap Text Merge & Center G H VIEW % Assume that X is a hypergeometric random variable with N-50, S = 20, and n=5. Use Excel's function options to find the following probabiliities. Complete the following analysis. Do not hard code values in your calculations for N, S, and n. Number 1 Conditional Format as Cell Cells Formatting Table Styles Styles J K L 1 ? Editing M N Compute the HyperGeometric probabilities by using the X value and E9 thru E11. Compute the HyperGeometric probabilities by using the X value and E9 thru E11. Compute the HyperGeometric probabilities by using the X value and E9 thru E11. 1 6 X Sign In X O 4

Assume that X is a hypergeometric random variable with N=50,S=20, and n=5. Use Excel's function options to find the following probabilities