AutoSave O OFF A A FDC ... Chapter 5 - Probabilities (1) - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments fx Define Name v Ey Trace Precedents Calculate Now 5 Trace Dependents led Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Create from Selection Show Watch Calculation Calculate Sheet Time Reference Options Function Used Trig Functions Remove Arrows v Formulas Checking Window D53 X V fx 0 Q R S T U V W A B C D E F G H 1 K L M N 33 4.) Create a probability distribution table showing each possible value of X: 34 5.) Using the SUMPRODUCT formula, calculate 35 X P(X=X) the expected value and standard deviation. 36 O 0.000244141 E(X) = 37 0.00292968 38 0.016113281 SD(X) = 39 W I 0.05371093 40 0.120849609 6.) Is the distribution skewed? Justify your 41 0.193359375 answer. 42 0.22558593 Distribution is not skewed . It is 43 0.193359375 symmetrical becasuse p=0.5. For it to be 44 .120849609 skewed p would be p > 0.5 if left skewed 45 0.053710938 or p