Which formula should be put in cell F2?(A,B,C or D) A) = IF(D2<E2, 0, 1) Ben and

Question

Which formula should be put in cell F2?(A,B,C or D)

A) = IF(D2<E2, 0, 1) Ben and Frank are runners competing against each other in a 10km race. Ben will finish the race in 40 minutes, unless his knee starts hurting in which case it will take him 75 minutes. The chance that Ben's knee hurts is 30%. Frank will run the race in 50 minutes, unless his shins start hurting and in that case it will take him 80 minutes. The chance that Frank's shins hurt is 20%. It is your job to construct a simulation to estimate whether Ben or Frank will win the race The following spreadsheet is used to simulate several replications of this 10km race. Columns Band C should yield random numbers uniformly drawn from the interval I0, 1]. Columns D and E should compute the time (in minutes) that the runners take to complete the race. Column F should indicate whether Ben or Frank won the race (use 1 to indicate that Ben won the race and 0 to indicate that Frank won the race). 1 Replication UI0,1] Random Number Ul0,1] Random Number Ben's Time Frank's Time Winner (1-Ben, 0-Frank

Explanation / Answer

Answer:

Which formula should be put in cell F2?(A,B,C or D)

A) = IF(D2<E2, 0, 1)

Answer;

B)= IF(D2<E2, 1, 0)

C)= MIN(D2,E2)

D)= MAX(D2,E2)

We are selecting the person with minimum time as winner.

A) = IF(D2<E2, 0, 1)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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