Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each of the situations described below, generate 100 repeated simulation runs in Excel, using pseudorandom numbers. To do this, use the built-in RAND() function:
For each of the situations described below, generate 100 repeated simulation runs in Excel, using pseudorandom numbers. To do this, use the built-in RAND() function: in this case, everyone's results should be a bit different, and each simulation run leads to a different result. 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. (Note for completeness that one point is awarded for each made free throw: these points are not considered here.) 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, record the empirical count for each outcome; then create a scatterplot of the basketball throw simulation results. 1.2 A traffic light at a street crossing 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 at this crossing by a randomly arriving car. Based on the generated sample, record the empirical count for each outcome. Based on your simulation results, create a pie chart of the empirical distribution of the recorded traffic light colors
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started