## (solution) requesting for complete solutions. linear programming using excel

requesting for complete solutions. linear programming using excel

of the year

days 2009 . remaining in the year. Question 4 The tortoise and the hare are having a race. Whoever can travel the most distance in an hour wins. For the tortoise, each minute the probabilities are 25% he rests and doesn't move, 30% he travels forward 1 foot, 35% he travels forward 2 feet, 10% he travels forward 3 feet. For the hare, each minute the probabilities are 10% he moves backward one foot, 65% he doesn't move, 25% he moves forward 5 feet. a) Create a worksheet to simulate the race. You should have a row for each minute. You should have columns at least for: minute number, tortoise position, hare position, who is ahead. You may use other columns and cells as you wish. At the top of the worksheet give the winner for the simulation (or possibly it's a tie). Also at the top please give the number of minutes during which the hare is behind where he started. b) Create a chart that has minutes along the X axis and position in feet from the starting line along the Y axis. The chart should show the positions of the tortoise and the hare during the race. Pressing F9 to simulate a new race should cause the chart to be updated automatically.

Solution details:

STATUS

QUALITY

Approved

Sep 13, 2020

EXPERT

Tutor