AutoSave OFF Chapter 5 - Pr Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 AA 35 Wrap Text v Gener Paste B avA Merge & Center Q12 X V I W # of Correct Total # of Theoretical Probability of Group Member Guesses Guesses one correct guess Overall 1 2.) Let X represent the number of correct guesses out of all the attempts for members in your group. What kind of distribution does X have? 12 Justify your response, indicating values for any of the variables that describe the distribution. (Answer here) 19 3.)Use an appropriate distribution function built into excel to answer the following questions: 20 a.) What is the probability that your group would have guessed all of them correctly? b.) What is the probability that another group, guessing the same amount as you, would have more correct responses that your group? c.) What is the expected number of correct guesses, give or take how much? +or - 4.) Create a probability distribution table showing each possible value of X: 5.) Using the SUMPRODUCT formula, calculate P(X