If we place the number of events in cell B3, the probability parameter in E3, th

Question

If we place the number of events in cell B3, the probability parameter in E3, the outcomes starting in G5, and we want relative frequency to appear in column H, what would the relative frequency formula look like in cell H9? The probability mass function for the binomial is:

which of these

=(FACT($B$3)*$E$3^G9*(1-$E$3)^$B$3-$E$3)/(FACT(G9)*FACT($B$3-G9))

=(FACT($B$3)*$E$3^G9*(1-$E$3)^($B$3-$E$3))/(FACT(G9)*FACT($B$3-G9))

=(FACT($B$3)*$E$3^G9*(1-$E$3)^($B$3-$E$3))/FACT(G9)*FACT($B$3-G9)

=FACT($B$3)*$E$3^G9*(1-$E$3)^($B$3-$E$3)/(FACT(G9)*FACT($B$3-G9))

=(FACT($B$3)*$E$3^G9*(1-$E$3)^$B$3-$E$3)/(FACT(G9)*FACT($B$3-G9))

Explanation / Answer

=(FACT($B$3)*$E$3^G9*(1-$E$3)^($B$3-$E$3))/(FACT(G9)*FACT($B$3-G9))

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.