Question

1:57 Expert Q&A Done Whe os die he e danes the new being forcavevo and wonderfu l w dru Sumo dice rolls X) Polity ) What is the probability that sum of dice rolls is What is the probability that sum of dice rolls is more than 5 What is the ball that of dice rolls is less than 3 What is the probably the modice rolls will be no more than What is the ability that sum of die we will b e What is the standard deviation of this probably

i want answer for assignment in ms excel

Answer 1

Solutin: The table show the probability distribution of sum of rolls two dice. Sum of dice(x) P(X) X*P(x) ((x-mean)^2)*P(x) 2 0.027778 0.055556 0.694444444 c) The probability of sum of dice rolls 4; 3 0.055556 0.166667 0.888888889 d) The probability of sum of dice rolls more than 5; 4 0.083333 0.333333 0.75 e) The probability of sum of dice rolls less than 3; 5 0.111111 0.555556 0.444444444 f) The probability of sum of dice rolls no more than 5; 6 0.138889 0.833333 0.138888889 g) The probability of sum of dice rolls more than 11; 7 0.166667 1.166667 1.31477E-31 h) The expected value is; 8 0.138889 1.111111 0.138888889 i) The standard deviaiton is; 9 0.111111 0.444444444 10 0.083333 0.833333 0.75 11 0.055556 0.611111 0.888888889 12 0.027778 0.333333 0.694444444 Total 7 5.833333333 0.083333 0.722222 0.027778 0.277778 0.027778 2.415229

Solutin: The table show the probability distribution of sum of rolls two dice. Sum of dice(x) P(X) X*P(x) (ex-mean)^2)*P(X) =1/36 =B5*C5 =((B5-$D$16)^2) *C5 |=2/36 =B6*C6 =((B6-$D$16)^2) *C6 1 =3/36 =B7*C7 1=((B7-$D$16)^2) *C7 -4/36 =B8*C8 =((B8-$D$16)^2) *C8 1=5/36 =B9*C9 = (B9-$D$16)^2) *C9 =6/36 =B10*C10 =((B10-$D$16)^2) *C10 1-5/36 =B11*011 =((B11-$D$16)^2) *C11 1-4/36 =B12*C12 =((B12-$D$16)^2) *C12 1-3/36 =B13*C13 =((B13-$D$16)^2) *C13 1=2/36 =B14*C14 =((B14-$D$16)^2) *C14 =B15*C15 =((B15-$D$16)^2)*C15 =SUM(C5:C15) =SUM(D5:D15) =SUM(E5:E15) c) The probability of sum of dice rolls 4; d) The probability of sum of dice rolls more than 5; e)The probability of sum of dice rolls less than 3; f) The probability of sum of dice rolls no more than 5; g) The probability of sum of dice rolls more than 11; h) The expected value is; i) The standard deviaiton is; =C7 =SUM(C9:C15) =SUM(C5) =1-M6 =C15 =D16 =SQRT(E16) =1/36