Week 11 2020 Practice Questions PDF

Preview

Summary

Suggested time: 45mins~ 1 hour Solutions will be posted on 4pm today (March 17. 2020)Question 1. 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 forwar...

Description

Suggested time: 45mins~ 1 hour Solutions will be posted on 4pm today (March 17. 2020) Question 1. 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, 60% he doesn’t move, 30% 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, and who is ahead. You may use other columns and cells as you wish. At the top of the worksheet give the simulated race result – who is the winner (or possibly it’s a tie, then show “Tie” as the result). b) Create a chart that has minutes along the X axis and position in feet from the starting line along the Y axis. You are free to choose chart type, as long as the chart is able to clearly demonstrate the positions of the tortoise and the hare during the race. Press F9 to simulate a new race should cause the chart to be updated automatically. c) Let the hare and tortoise do the running race 10 times, each time for 1 hour. Show the outcomes of these 10 races (i.e., the winner of each race). Hint: you need to use a DataTable to show the outcomes of the 10 races.

Question 2. Farmer Leary grows wheat and corn on his 45-acre farm. He can sell at most 140 bushels of wheat and 120 bushels of corn. Each planted acre yields either 5 bushels of wheat or 4 bushels of corn. Wheat sells for $30 per bushel, and corn sells for $50 per bushel. Six hours of labor are needed to harvest an acre of wheat, and 10 hours of labor are needed to harvest an acre of corn. Up to 350 hours of labor can be purchased at $10 per hour. How should he design his farm?...