Question: Question 1 (10+10 = 20 points) For the situations described below, generate 100 simulation runs (repetitions) in Excel, using uniform random numbers. 1.1 A three-point

Question 1 (10+10 = 20 points) For the situations

Question 1 (10+10 = 20 points) For the situations described below, generate 100 simulation runs (repetitions) in Excel, using uniform random numbers. 1.1 A three-point field goal is a field goal in a basketball game made from beyond the three-point line (a designated arc surrounding the basket). A successful attempt is worth three points, in contrast to the two points awarded for field goals made within the three-point line and the one point for each made free throw). Simulate the performance of a basketball player who scores a three-point field goal 30 percent of the time, a two-point field goal 50 percent of the time, but misses to score 20 percent of the time. Based on the generated sample, calculate the empirical average for each outcome. 1.2 A traffic light is set green 50 percent of the time, yellow 10 percent of the time, and red 40 percent of the time. Simulate the color of the traffic light found by a randomly arriving car. Based on the generated sample, calculate the empirical average for each outcome

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 General Management Questions!