Question: HOW CAN I CONVERT THIS ALGORITHM TO A FORMULA IN EXCEL? BETS PLACED ON HEADS AND TAILS FOLL BELOW ALGORITHM. THE ALGORITHM IS 1, WIN

HOW CAN I CONVERT THIS ALGORITHM TO A FORMULA IN EXCEL?

BETS PLACED ON HEADS AND TAILS FOLL BELOW ALGORITHM.

THE ALGORITHM IS 1, WIN BET 3(LOSE, BET 1), WIN BET 7(LOSE BET 3), WIN, BET 4 (LOSE, REPEAT BET OF 4 , IF THE REPEAT IS LOST , BET 1)

IF 4 WINS, BET 6 (LOSE BET 4, IF WON BET 7, IF BET OF 4 IS LOST , BET 1), WIN BET 7 (LOSE , BET 4, IF WON BET 7, IF BET OF 4 IS LOST , BET 1).

IF 7 WIN , BET 8 (LOSE , BET 4, IF WON BET 7, IF BET OF 4 IS LOST , BET 1), CONTINUE THE ALGORITHM UNTIL 2 LOSSES IN A ROW THEN START BETTING 1 AGAIN.

EXAMPLE BETS ON HEADS AND TAILS
IF FOLL SEQUENCE OF BETTING BELOW WILLUNDERSTAND THE ALGORITHIM BETTER THAN THE EXPLANATION ABOVE.
HEADS TAILS
H 1 -1
T -3 1
T -1 3
T -1 7
H 1 -4
H 3 -4
H 7 -1
T -4 1
H 4 -3
H 7 -1
T -5 1
H 5 -3
T -1 1
T -1 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!