To flip a coin on a spreadsheet, you would use the Excel formula: =IF(a + (b-a)*RAND()...

 

Transcribed Image Text:

To flip a coin on a spreadsheet, you would use the Excel formula: =IF(a + (b-a)*RAND()< 0.5, "Heads", "Tails"), where a = 1 and b = 0 =IF(RAND()<0.5,"Heads","Tails") =IF(NORM.INV(RAND(),0,1)<0.5, "Heads", "Tails") None of these formulas are correct To flip a coin on a spreadsheet, you would use the Excel formula: =IF(a + (b-a)*RAND()< 0.5, "Heads", "Tails"), where a = 1 and b = 0 =IF(RAND()<0.5,"Heads","Tails") =IF(NORM.INV(RAND(),0,1)<0.5, "Heads", "Tails") None of these formulas are correct

Answer rating: 100% (QA)

THE CORRECT ANSWER IS IFRAND 05HeadsTails because i IFa b aRAND 05 Heads Tails where ... View the full answer